Test Data

RankNameRevenueProfitEmployeesHeadquarters
1Walmart$559,151$13,5102,300,000United States
2State Grid$386,617$5,580896,360China
3Amazon$386,064$21,3311,335,000United States
4China National Petroleum$283,958$4,5751,242,245China
5Sinopec Group$283,728$6,205553,833China
6Apple$274,515$57,411147,000United States
7CVS Health$268,706$7,179256,500United States
8UnitedHealth$257,141$15,403330,000United States
9Toyota$256,722$21,180366,283Japan
10Volkswagen$253,965$10,104662,575Germany
11Berkshire Hathaway$254,510$42,521360,000United States
12McKesson$238,228-$4,53967,500United States
13China State Construction$234,425$3,578356,864China
14Saudi Aramco$229,766$49,28779,800Saudi Arabia
15AmerisourceBergen$213,990$1,54040,000United States
16Samsung Electronics$200,734$22,116267,937South Korea
17Ping An Insurance$191,509$20,739362,035China
18BP$183,500-$20,30568,100United Kingdom
19Shell$183,195-$21,68087,000United Kingdom
20ICBC$182,794$45,783439,787China
21Alphabet$182,527$40,269144,056United States
22Foxconn$181,945$3,457878,429TaiwanTaiwan
23ExxonMobil$181,502-$22,44072,000United States
24Mercedes-Benz Group$175,827$4,133288,481Germany
25China Construction Bank$172,000$39,283373,814China
26AT&T$171,760-$5,176230,760United States
27Microsoft$168,090$61,270181,000United States
28Costco$166,761$4,002214,500United States
29Cigna$160,401$8,45872,963United States
30Agricultural Bank of China$153,885$31,293462,592China
31Cardinal Health$152,922-$3,69648,000United States
32Trafigura$146,994$1,6998,619Singapore
33China Life Insurance$144,589$4,648183,417China
34Glencore$142,338-$1,90387,822Switzerland
35China Railway Engineering Corporation$141,384$1,639308,483China
36Walgreens Boots Alliance$139,537$456450,000United States
37Exor$136,186-$34263,284Netherlands
38Allianz$136,173$7,756150,269Germany
39Bank of China$134,046$27,952309,084China
40Kroger$132,498$2,585465,000United States
41Home Depot$132,110$12,870504,800United States
42China Railway Construction$131,992$1,486364,632China
43JPMorgan Chase$129,503$29,131260,110United States
44Huawei$129,184$9,362197,000China
45Verizon$128,292$17,801135,500United States
46AXA$128,011$3,60596,595France
47Ford$127,144-$1,279186,000United States
48Honda$124,241$6,202211,374Japan
49General Motors$122,485$6,427155,000United States
50Anthem$121,867$4,57283,400United States

This is some test text

below is details of the advanced filter

TaskCell formulaExamples where true
Contains="=*Pea*"Peach, Pea, Appear
Does not contain="<>*Pea*"any text that does not contain Pea
Exact match="=Pea"Pea
Does not exactly match="<>Pea"Peach, Pear etc.
Starts with="=Pea*"Peach, Pear, Pea
Ends with="=*Pea"SweetPea, GreenPea
Use the ? symbol to represent any single character
="=Pea?"
Pear, Peas or any 4 letter word starting with "Pea"
Any of the symbols *?~
="=Pea~*"
Pea*, Pea?
Case sensitive(see section Using Formulas as Criteria)=EXACT(A7,"Peach")
Peach
Greater than
=">700"
701,702 etc.
Greater than or equals
=">=700"700, 701,702 etc.
Less than
="<700"
699,698 etc.
Less than or equals
="<=700"
700, 699, 698 etc.
Equals ="=700"
700
After date=">" & DATE(2023,4,30)01-May-2023
02-May-2023
Before date="<" & DATE(2023,4,30)29-April-2023
28-April-2023
Equal date="=" & DATE(2023,4,30)30-April-2023