tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 472468d1469612901-productivity-depending-on-different-type-of-work-test-6-
Sheet: Raw Data

Name | Closed Date | Work Type | week number
Employee 1 | 2016-07-25 00:00:00 | Work Type 3
Employee 1 | 2016-07-25 00:00:00 | Work Type 1
Employee 2 | 2016-07-25 00:00:00 | Work Type 3
Employee 2 | 2016-07-25 00:00:00 | Work Type 1
Employee 2 | 2016-07-25 00:00:00 | Work Type 1
Employee 3 | 2016-07-25 00:00:00 | Work Type 2
Employee 4 | 2016-07-25 00:00:00 | Work Type 7
Employee 4 | 2016-07-25 00:00:00 | Work Type 2
Employee 4 | 2016-07-25 00:00:00 | Work Type 5
Employee 4 | 2016-07-25 00:00:00 | Work Type 5
Employee 4 | 2016-07-25 00:00:00 | Work Type 5
Employee 4 | 2016-07-25 00:00:00 | Work Type 5
Employee 5 | 2016-07-25 00:00:00 | Work Type 3
Employee 5 | 2016-07-25 00:00:00 | Work Type 3
Employee 5 | 2016-07-25 00:00:00 | Work Type 6
Employee 4 | 2016-07-25 00:00:00 | Work Type 1
Employee 1 | 2016-07-26 00:00:00 | Work Type 3
Employee 1 | 2016-07-26 00:00:00 | Work Type 1
Employee 2 | 2016-07-26 00:00:00 | Work Type 3
Employee 2 | 2016-07-26 00:00:00 | Work Type 1
Employee 2 | 2016-07-26 00:00:00 | Work Type 1
Employee 3 | 2016-07-26 00:00:00 | Work Type 2
Employee 4 | 2016-07-26 00:00:00 | Work Type 7
Employee 4 | 2016-07-26 00:00:00 | Work Type 2
Employee 4 | 2016-07-26 00:00:00 | Work Type 5
Employee 4 | 2016-07-26 00:00:00 | Work Type 5
Employee 4 | 2016-07-26 00:00:00 | Work Type 5
Employee 4 | 2016-07-26 00:00:00 | Work Type 5
Employee 5 | 2016-07-26 00:00:00 | Work Type 3
Employee 5 | 2016-07-26 00:00:00 | Work Type 3
Employee 5 | 2016-07-26 00:00:00 | Work Type 6
Employee 4 | 2016-07-26 00:00:00 | Work Type 1
fhhg | 2016-07-27 00:00:00 |  | 32
Spreadsheet: 770753d1646241289-match-employee-id-on-two-different-tabs-and-add-the-corresponding-name-to-column-example
Sheet: Sheet1

Data | User ID
info | ID 1
info | ID 1
info | ID 3
info | ID 8
info | ID 5
info | ID 6
info | ID 16
info | ID 16
info | ID 16
info | ID 16
info | ID 16
info | ID 12
info | ID 13
info | ID 14
info | ID 15
info | ID 16
info | ID 17
info | ID 18
Spreadsheet: 43097d1241697220-sumifs-with-multiple-values-for-one-criteria-range-sumifs
Sheet: Sheet1

Month | Day | Amount
Jan | Mon | 100
Jan | [NAME] | 50
Jan | Wednes | 75
Jan | Thurs | 80
Jan | Fri | 45
Feb | Mon | 60
Feb | [NAME] | 95
Feb | Wednes | 70
Feb | Thurs | 55
Feb | Fri | 100
Mar | Mon | 85
Mar | [NAME] | 90
Mar | Wednes | 100
Mar | Thurs | 60
Mar | Fri | 95
Spreadsheet: 721940d1614958620-find-top-5-with-criteria-and-sum-error-sample-1-
Sheet: Sheet2

Name | Workflow | Completed Cases |  |  |  |  | name | 1 | 2 | 3 | 4 | 5
[NAME] | workflow a | 56 |  |  |  |  | [NAME]
[NAME] | workflow a | 500 |  |  |  |  | [NAME]
[NAME] | workflow a | 5 |  |  |  |  | [NAME]
[NAME] | workflow a | 78 |  |  |  |  | [NAME]
[NAME] | workflow a | 21
[NAME] | workflow b | 200
[NAME] | workflow b | 34
[NAME] | workflow b | 55
[NAME] | workflow c | 100
[NAME] | workflow c | 5000
[NAME] | workflow d | 5000
Spreadsheet: 119337d1314327428-excel-2007-if-statement-help-stock
Sheet: Sheet1

# [NAME] | [NAME] | Stock | Warehouse
11 | 22 | 10 | 15 |  | Note: I want the calculation to work here and not show up red but I want to use the same formula for the entire column since I will be editing the numbers in each colum
27 | 50 | 40 | 50 |  | Note: I want this to be red and not show the calculation
10 | 15 | 11 | 17 |  | I changed this to and and or to show you what I would like to see. But if I use the same forumla for the other 2 rows above, it doesn’t work
 |  |  |  |  | If the is one yellow column in the row, I need it to show the calculation
 |  |  |  |  | And if  there is only one red or both are red, I don’t want the calculation to show up but it to say RED
Spreadsheet: 91986d1291667577-defining-a-column-for-use-in-another-sheet-2011-office-driver-call-sheet-input-practice
Sheet: Sheet3

 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
CHUCK | Hrs Total | 1 | 0 | 0 | 0
 | x rate | 18 |  | 18
 | TOTALS | 18 | 0 | 0 | 0 | 18
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
[NAME] | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 15 |  | 18
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
JERRY | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 15 |  | 18
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
PAUL | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 18
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
[NAME] | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 25
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
 | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 25
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
 | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 25
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
 | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 25
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
 | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 25
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
 | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 25
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
 | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 25
 | TOTALS | 0 | 0 | 0 | 0 | 0
 |  | Plow | Skid | Shovel | Sand Truck | TOTAL BILLING
 | Hrs Total | 0 | 0 | 0 | 0
 | x rate | 65 |  | 25
 | TOTALS | 0 | 0 | 0 | 0 | 0
Spreadsheet: 739048d1625482370-formula-to-determine-which-values-contra-each-other-formula-to-determine-contra-entries
Sheet: Sheet1

 |  |  |  |  | Debit | Credit | Balance |  |  |  |  | should Be
 |  |  |  |  | 4882.76 | 0
 |  |  |  |  | 6780.04 | 0
 |  |  |  |  | 6780.04 | 0 |  |  |  |  |  | False
 |  |  |  |  | 121.45 | 0
 |  |  |  |  | 1214.46 | 0
 |  |  |  |  | 1700.24 | 0
 |  |  |  |  | 1755.99 | 0
 |  |  |  |  | 2307.47 | 0
 |  |  |  |  | 290.26 | 0
 |  |  |  |  | 0 | 4882.76
 |  |  |  |  | 0 | 6780.04
 |  |  |  |  | 0 | 121.45
 |  |  |  |  | 0 | 1214.46
 |  |  |  |  | 0 | 1700.24
 |  |  |  |  | 0 | 1755.99
Spreadsheet: 855871d1705339576-list-by-highest-including-joint-highest-ranking
Sheet: Sheet1

Team | Rank | Name | Dec | Best | Cost
101 | 3 | [NAME] | 105 | 105 | 2.2
101 | 1 | [NAME] | 100 | 110 | 1.7
101 | 4 | [NAME] | 96 | 96 | 6.5 |  |  |  |  |  | Rank | Name | Dec | Best | Cost
101 | 1 | [NAME] | 92 | 109 | 3.3 |  |  |  |  | 101 | 3 | [NAME] | 105 | 105 | 2.2
102 | 1 | Vicky | 109 | 109 | 1.8 |  |  |  |  | 102 | 1 | Vicky | 109 | 109 | 1.8
102 | 3 | [NAME] | 109 | 109 | 5 |  |  |  |  | 102 | 3 | [NAME] | 109 | 109 | 5
102 | 2 | [NAME] | 107 | 107 | 1.5 |  |  |  |  | 103 | 1 | [NAME] | 90 | 95 | 1.75
102 | 4 | Ian | 106 | 108 | 6 |  |  |  |  | 104 | 1 | [NAME] | 116 | 116 | 1.8
103 | 1 | [NAME] | 90 | 95 | 1.75 |  |  |  |  | 105 | 4 | [NAME] | 123 | 123 | 2.5
103 | 2 | [NAME] | 89 | 89 | 2.3 |  |  |  |  | 106 | 1 | [NAME] | 121 | 121 | 1.4
103 | 4 | [NAME] | 80 | 86 | 2.2 |  |  |  |  | 106 | 2 | Asha | 121 | 122 | 2
103 | 3 | [NAME] | 78 | 78 | 4
104 | 1 | [NAME] | 116 | 116 | 1.8
104 | 2 | Moh | 114 | 114 | 1.5
104 | 4 | [NAME] | 114 | 121 | 3
104 | 3 | Asif | 110 | 110 | 4
105 | 4 | [NAME] | 123 | 123 | 2.5
105 | 3 | Berti | 106 | 106 | 4
105 | 1 | Chess | 104 | 104 | 2
105 | 2 | Gaby | 75 | 75 | 6.6
106 | 1 | [NAME] | 121 | 121 | 1.4
106 | 2 | Asha | 121 | 122 | 2
106 | 3 | Greta | 111 | 111 | 2.4
106 | 4 | Simone | 110 | 110 | 3
Sort by  Team (col A) then Dec (col D)
Show total Number of Team (col A)
Show total Number that highest number in Dec has Rank =1 ( rank is top position by customers)
There are 2 occasions where there is a joint top highest number in Dec column
In the above there are 3 times that the highest number in Dec has a Rank = 1 however
In Team 102  and also  Team  106 there are 2 Name(s) which have the joint highest Dec figure.
We also need to add the Cost number where the highest Dec person is also the no 1 Rank
 | In the example this Vicky 1.8 + Vicky 1.75 + [NAME] 1.8 + Pierre 1.4 = 6.75
The result we are looking for is 3 times where Rank = 1 from a total of 7  (because of 2 x jt top) in Dec column
Display all the occasions that this occurs in new columns
 | Col H = Team
 | Col I  = Rank
 | Col J = Name
 | Col K = Dec  (number)
 | Col L = Cost
Total summary below each column
This is how the result should look like
101 | 3 | [NAME] | 105 | 2.2
102 | 1 | Vicky | 109 | 1.8
102 | 3 | [NAME] | 109 | 5
103 | 1 | [NAME] | 90 | 1.75
104 | 1 | [NAME] | 116 | 1.8
105 | 4 | [NAME] | 123 | 2.5
106 | 1 | [NAME] | 121 | 1.4
106 | 2 | Asha | 121 | 2
Total | 4 |  | 8 | 6.75
Spreadsheet: 774995d1648755792-project-management-formula-help-for-prepopulating-dates-schedule-test
Sheet: Sheet1

xxxxxxxxx |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Flex Days/holiday
 |  |  |  |  |  |  |  |  |  |  |  | # of Xxxxx Technicians |  |  |  |  | X/X |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | # of xxxxx Technicians | 2 |  |  |  |  |  | Weekend
Beginning Date: |  | 2022-04-04 00:00:00 |  |  |  | End Date:
Begin | End | Bldg. | Area | Room | Panel | Panel Type | Device Count | xxxx Tasking Man Hrs. | xxxxx Total Man Hrs. | xxxxx [NAME]. | Days | xxxxxx Tasks | xxxxx Tasks
 |  |  |  |  |  |  |  | 1 |  | 4
 |  |  |  |  |  |  | 2 | 1 |  | 4
 |  |  |  |  |  |  |  | 4 |  | 4
 |  |  |  |  |  |  | 21 | 2 |  | 4
 |  |  |  |  |  |  | 5 | 1 |  | 4
 |  |  |  |  |  |  | 5 | 5 |  | 4
 |  |  |  |  |  |  | 7 | 2 |  | 4
 |  |  |  |  |  |  | 3 | 2 |  | 4
 |  |  |  |  |  |  | 4 | 2 |  | 4
 |  |  |  |  |  |  | 6 |  |  | 4
 |  |  |  |  |  |  | 3 | 2 |  | 4
 |  |  |  |  |  |  | 6 | 2 |  | 4
 |  |  |  |  |  |  | 12 | 2 |  | 4
 |  |  |  |  |  |  | 12 | 2 |  | 4
 |  |  |  |  |  |  | 0 |  |  | 4
 |  |  |  |  |  |  | 6 | 8 |  | 4
 |  |  |  |  |  |  | 4 | 8 |  | 4
 |  |  |  |  |  |  | 4 | 5 |  | 4
 |  |  |  |  |  |  | 4 | 5 |  | 4
 |  |  |  |  |  |  | 32 | 20 |  | 4
 |  |  |  |  |  |  | 15 | 10 |  | 4
 |  |  |  |  |  |  | 15 |  |  | 4
 |  |  |  |  |  |  | 13 | 4 |  | 4
 |  |  |  |  |  |  | 28 | 2 |  | 4
 |  |  |  |  |  |  | 62 | 40 |  | 4
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 2 |  | 4
 |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 1 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 0.5 |  | 4
 |  |  |  |  |  |  |  | 8 |  | 4
 |  |  |  |  |  |  |  | 8 |  | 4
 |  |  |  |  |  |  |  | 8 |  | 4
Spreadsheet: 887008d1737080472-index-match-and-return-closest-date-index-match-and-return-closest-date-1
Sheet: Sheet1

PO# | RECEIPT DATE | Estimated delivery DATE | Lookup in column F and return G |  | SHIP PO | Estimated DeliveryDate
1 | 2024-03-05 00:00:00 |  |  |  | 4 | 2024-01-03 00:00:00
2 | 2024-06-01 00:00:00 |  |  |  | 1 | 2024-01-04 00:00:00
3 | 2024-04-05 00:00:00 |  |  |  | 5 | 2024-01-06 00:00:00
4 | 2024-05-15 00:00:00 |  |  |  | 4 | 2024-01-10 00:00:00
5 | 2024-03-06 00:00:00 |  |  |  | 5 | 2024-02-10 00:00:00
 |  |  |  |  | 2 | 2024-02-15 00:00:00
 |  |  |  |  | 1 | 2024-03-01 00:00:00
 |  |  |  |  | 4 | 2024-03-03 00:00:00
 |  |  |  |  | 5 | 2024-03-09 00:00:00
 |  |  |  |  | 3 | 2024-04-02 00:00:00
 |  |  |  |  | 2 | 2024-05-29 00:00:00
 |  |  |  |  | 4 | 2024-06-12 00:00:00
Spreadsheet: errol_mclaughlin_jr__10299__NatSourceDealValuation
Sheet: July Summary

[NAME] Gas Daily Swap Valuation Comparison
 |  |  | TAGG Deal ID |  | Spreadsheet Value |  | ERMS Valuation
 |  |  | NO6629.1 |  | 1351600 |  | -99300.03100000005
 |  |  | NO8797.1 |  | -13539250 |  | 969750
 |  |  | NO8809.1 |  | -8123550.000000001 |  | 581850
 |  |  | NO8893.1 |  | -1353925 |  | 96975
 |  |  | NO8896.1 |  | -1353925 |  | 96975
 |  |  | NO8908.1 |  | -5425000 |  | 378600
 |  |  | [NAME] |  | 9299.999999999802 |  | 108600
 |  |  | NO9924.1 |  | 9299.999999999802 |  | 108600
 |  |  | NO9937.1 |  | 12400 |  | 111700
 |  |  | NP2012.1 |  | 3100.000000000209 |  | -96200
Spreadsheet: 69303d1269859762-getting-condition-based-start-and-end-dates-test_post
Sheet: Track

Project | EP | 1
leave/off/absent | output | start date | end date | latest Status | Name | Task | Number | 2010-03-29 00:00:00 | 2010-03-30 00:00:00 | 2010-03-31 00:00:00 | 2010-04-01 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-05 00:00:00 | 2010-04-06 00:00:00 | 2010-04-07 00:00:00 | 2010-04-08 00:00:00 | 2010-04-09 00:00:00 | 2010-04-10 00:00:00 | 2010-04-12 00:00:00 | 2010-04-13 00:00:00 | 2010-04-14 00:00:00 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | 2010-04-19 00:00:00 | 2010-04-20 00:00:00 | 2010-04-21 00:00:00 | 2010-04-22 00:00:00 | 2010-04-23 00:00:00 | 2010-04-24 00:00:00 | 2010-04-26 00:00:00 | 2010-04-27 00:00:00 | 2010-04-28 00:00:00 | 2010-04-29 00:00:00 | 2010-04-30 00:00:00
1 | #N/A | #N/A | #N/A | ok | A | 1 | 102 | start | wip | a | fr | ok
1 | #N/A | #N/A | #N/A | ok | B | 2 | 64 |  | start | wip | a | fr | ok
2 | #N/A | #N/A | #N/A | add arc | C | 3 | 44 |  |  | start | a | a | add arc
1 | #N/A | #N/A | #N/A | ok | B | 4 | 42 | start | a | pls speed up | ok
1 | #N/A | #N/A | #N/A | ok | C | 5 | 50 |  |  | start | a | pls speed up | ok
1 | #N/A | #N/A | #N/A | pls speed up | C | 6 | 32 |  | start | a | pls speed up
Here I am looking for a solution which gives me start date from range (I2:AK2) when it find "start" in corresponding range (I3:AK3) and same for end date if it finds "ok"
Spreadsheet: 737707d1624550033-top-10-values-including-all-duplicates-book4
Sheet: Sheet1

26
8 |  | 1
27 |  | 2
18 |  | 3
15 |  | 4
16 |  | 5
17 |  | 6
29 |  | 7
5 |  | 8
5 |  | 9
28 |  | 10
9
27
21
22
6
20
20
28
1
9
7
22
28
24
24
8
8
27
11
14
28
18
21
5
10
4
24
29
9
22
15
19
7
16
4
12
4
7
23
21
30
11
6
14
14
25
21
25
22
20
27
8
14
21
1
15
28
19
20
18
29
6
16
22
9
26
2
25
19
18
20
1
5
28
24
9
4
11
16
20
27
26
5
5
10
2
6
10
22
Spreadsheet: 139142d1328101699-n-a-error-na
Sheet: Sheet1

blue | #N/A | [NAME]: Ballarat Turf Club Thursday 02, February 2012
red | [NAME] | Meeting Type: Country (TAB MEETING) |  |  |  | Ballarat
green | #N/A | Rail Position: True Position (Inner Track) |  |  |  | Ballarat
 |  | Track Condition: Dead 4 |  |  |  | Ballarat
 |  | Track Type: Turf |  |  |  | Ballarat
 |  | Weather: Fine |  |  |  | Ballarat
 |  | Penetrometer: |  |  |  | Ballarat
 |  | FinalFields Last Published: Tue 31-Jan-12 12:05PM AEDT |  |  |  | Ballarat
 |  | Total Number of starters for this meeting (including emergencies) 94 |  |  |  | Ballarat
 |  | Race 1 - 2:45PM Porter Plant F&M Maiden Plate (1400 METRES) |  |  | Race 1 | Ballarat
 |  | Of $15,000.1st $8,775, 2nd $2,700, 3rd $1,350, 4th $675, 5th $250, 6th $250, 7th $250, 8th $250, 9th $250, 10th $250 |  |  |  | Ballarat
 |  | Maiden, Set Weights, Three-Years-Old and Upwards, Fillies and Mares, Apprentices can claim. |  |  |  | Ballarat
 |  |  |  |  |  | Ballarat
 |  | Field Limit: 16 + 4 EM |  |  |  | Ballarat
 |  |  |  |  |  | Ballarat
Trainer |  | No |  |  |  | Ballarat | Horse | Trainer
[NAME] | #N/A | 1 |  |  |  | Ballarat | ALWAYS IN DA’NILE | [NAME] | #N/A
[NAME] | #N/A | 2 |  |  |  | Ballarat | LA SKALATO | [NAME] | #N/A
[NAME] | #N/A | 3 |  |  |  | Ballarat | PROFIT MARGIN | [NAME] | #N/A
[NAME] | #N/A | 4 |  |  |  | Ballarat | VIXEN HUSTLER | [NAME] | #N/A
[NAME] | #N/A | 5 |  |  |  | Ballarat | ALLY THE GREAT | [NAME] | #N/A
Michael, Wayne & [NAME] | Flemington | 6 |  |  |  | Ballarat | GIRL GONE ROCKIN | Michael, Wayne & [NAME] | Flemington
[NAME] | #N/A | 7 |  |  |  | Ballarat | GREY CHLOE | [NAME] | #N/A
[NAME] | #N/A | 8 |  |  |  | Ballarat | HOURGLASS | [NAME] | #N/A
[NAME] | #N/A | 9 |  |  |  | Ballarat | [NAME] LADY | [NAME] | #N/A
[NAME] | #N/A | 10 |  |  |  | Ballarat | KIMIKO | [NAME] | #N/A
[NAME] | #N/A | 11 |  |  |  | Ballarat | LA REILLY (NZ) | [NAME] | #N/A
[NAME] | #N/A | 12 |  |  |  | Ballarat | MIASHEENY RUBY | [NAME] | #N/A
[NAME] | #N/A | 13 |  |  |  | Ballarat | ORACLE | [NAME] | #N/A
[NAME] | #N/A | 14 |  |  |  | Ballarat | SISELY | [NAME] | #N/A
[NAME] | #N/A | 15 |  |  |  | Ballarat | TIGER TROUBLES | [NAME] | #N/A
Spreadsheet: 188932d1351025973-help-with-a-2013-marketing-calendar-2013-marketing-calender-template
Sheet: January

 |  |  |  |  |  |  |  | 2013-01-01 00:00:00
 |  | Sunday |  |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  |  | Mediums
 |  |  |  |  |  |  |  |  | 1
 |  | 1 | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost |  | Total Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Internal |  | Radio
 |  |  |  |  |  |  |  |  |  |  |  |  |  | External |  | Internal Print
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | External Print
Spreadsheet: 145522d1331634186-about-column-chart-818613c
Sheet: 2

data | [NAME] | frquency | %
0.4747765192177438 | 0.1
0.2368296949413358 | 0.2 | 3
0.8029807100895727 | 0.3 | 1
0.4586084257227299 | 0.4 | 0
0.5260953931122121 | 0.5 | 7
0.122167220516036 | 0.6 | 2
0.4701451170543325 | 0.7 | 1
0.940842112000909 | 0.8 | 2
0.4702137045887462 | 0.9 | 3
0.4752698020103026 | 1 | 1
0.1661522285227299
0.728783673306717
0.4087543367812358
0.8115954071871174
0.8594223761163091
0.6519699014015607
0.4002621682814311
0.7215366767367675
0.5939157954989271
0.1741168973511673
Spreadsheet: 823286d1679874481-vlookup-type-function-return-a-value-based-on-multiple-criteria-road-lookup-example
Sheet: Roads

Road Name | Section | Start Location | End Location
Road 1 | Section 1 | 0 | 100
Road 1 | Section 2 | 100 | 200
Road 1 | Section 3 | 200 | 300
Road 1 | Section 4 | 300 | 400
Road 2 | Section 1 | 0 | 100
Road 2 | Section 2 | 100 | 200
Road 2 | Section 3 | 200 | 300
Road 2 | Section 4 | 300 | 400
Road 2 | Section 5 | 400 | 500
Road 2 | Section 6 | 500 | 600
Road 3 | Section 1 | 0 | 100
Road 3 | Section 2 | 100 | 200
Road 3 | Section 3 | 200 | 300
Road 3 | Section 4 | 300 | 400
Road 3 | Section 5 | 400 | 500
Road | Location | Section |  | Query Steps |  | Result
Road 2 | 234 | ? |  | Step 1 | Find Road 2 (A25) in Table1 | Cells A6:A9
Road 3 | 310 | ? |  | Step 2 | Find what Section (Column B) location 234 (B25) is located between [NAME] (C6:D9) | Row 8 - 200 < 234 <300
 |  |  |  | Step 3 | Return Section (Column B) for Row 8 | Section 3
Spreadsheet: 22005d1210333991-pull-numbers-only-from-a-column-containing-both-numbers-and-text-number-pull-sample
Sheet: Sample Sheet 2

01448-942918635 | Widget #1 | ABC123 | 1448
00429-943228928 | Widget #2 | ABC234 | Aldrich
00158-943219073 | Widget #3 | ABC345 | [NAME]
00284-943292235 | Widget #4 | ABC456 | Anglin
01320-923546889 | Widget #5 | ABC567 | 1320
Spreadsheet: 726585d1617303768-sumifs-issue-template-etaf
Sheet: APR

 | Company 1
 | Date | Payment Type | Name | Description | Ref |  | AMOUNT | TOTAL |  | Comment
EX | 2021-04-01 00:00:00 | Cash | Wawa | Auto Gas | Receipt |  | 30
Spreadsheet: 285449d1387619200-percentage-problem-conny-price-list-mark-3
Sheet: Sheet1

CONSERVATORY
CUSTOMER NAME |  |  |  |  |  |  | JOB NO |  |  |  |  |  |  |  | COST
CONSERVATORY TYPE |  |  | EDWARDIAN |  |  |  | WIDTH | 4 | DEPTH | 4
PLANNING REQUIRED |  |  |  | Y
DIFFICULT ACCESS |  |  |  | Y
REMOME EXISTING STRUCTURE |  |  |  | GLASS/TIMBER/ALI
BREAK UP EXISTING BASE |  |  |  | Y
HOUSE WALL / RECESS PIPE |  |  |  | Y
REMOVE CLADDING / TILES ETC |  |  |  | Y |  |  | WIDTH | 5 | DEPTH | 2.5
PLASTER HOUSE WALL |  |  |  | Y |  |  | WIDTH | 5 |  |  | EXTRA
FOOTINGS STANDARD |  |  |  | Y | DEPTH | 1000 | SQUARE BASED
FACET BASED |  | 5 FACET VICTORIAN CENTRE WIDER |  |  | DEPTH | 1000 | FACETS |  | CORNER |  | CENTRE | 1.863 | SIDE
 |  |  |  |  |  |  |  |  | TOTAL FACET LENGHTS
BASE AND SCREED |  |  |  | Y |  | SQUARE METRES
BASE BUILD UP |  |  |  | 1
RAFT |  |  |  | Y |  | LINEAL METRES
SCREED ONLY |  |  |  | Y
DWARF WALLS |  |  |  | 600 BRICK ON PLASTER |  |  | LINEAL METRES |  | 10.4
[NAME] |  |  |  | DWARF WALL 3 FACET
FLANK WALLS |  |  |  | HEIGHT | 2.1 | DEPTH | 2.05 | FINISH | RENDER / PLASTER
BRICK PIERS |  |  |  | QTY | 1 | MAX 330 X 330mm
RETAINING WALL PLUS FOOTINGS |  |  |  |  | Y |  | WIDTH | 3.2 | DEPTH | 1.356
CIRCLE IN BRICKWORK |  |  |  |  | 1
BRICKWORK REMOVAL |  |  |  | Y | WIDTH | 0.9 | HEIGHT | 0.69 | SQUARE METRES
BRICKWORK BUILD UP |  |  |  | Y | WIDTH | 1.25 | HEIGHT | 2.15 | SQUARE METRES
LINTOL REQUIRED |  |  |  | OVER ONE METRE UP TO TWO METRES
KNOCK OUTS THAT REQUIRE A LINTOL |  |  |  | OVER ONE METRE UP TO TWO METRES |  |  |  | INCLUDES CALCS & REGS
REMOVE EXCESS SOIL |  |  |  | Y |  |  |  |  | [NAME] METRES |  | 2.36
STEPS STANDARD |  |  |  | SEMI CIRCLE OVER 1800 [NAME]
FRAMES |  |  |  | FULL HEIGHT 7 |  | QTY | 6
 |  |  |  | DWARF WALL 1 |  | QTY | 3
 |  |  |  | FULL HEIGHT 3 |  | QTY | 2
 |  |  |  | DWARF WALL 5 |  | QTY | 7
 |  |  |  | ABOVE FLANK 2 |  | QTY | 3
DOORS |  |  |  | SINGLE DOOR |  |  |  | QTY | 1
 |  |  |  | PATIO DOOR 3 PANE |  |  |  | QTY | 1
DOORS WIDTH |  | 1.6 |  | FRENCH DOORS WITH MIDRAILS |  |  |  | QTY | 1
MOULDED PANELS |  |  |  | Y |  |  |  | QTY | 5
GLASS OPTIONS |  |  |  | K GLASS
GEORGIAN ARCHES |  |  |  | Y | QTY | 10
LEADS |  |  |  | Y
GEORGIAN GRILL |  |  |  | Y
FANLIGHT OPTIONS |  |  |  | COLOURED FANLIGHTS |  |  | 10
ROOF |  |  |  | LEAN TOO
Spreadsheet: 219277d1362696416-conditional-format-not-working-conformat
Sheet: Sheet1

 |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb
 |  | 8.3 | 10 | 7 | 10 | 8.1 | 4 | 9 | 7 | 8.3 | 6 | 8.4 | 8.3 | 8.2 | 8.1 | 8
Spreadsheet: 750089d1633240526-find-a-text-in-a-sentence-column-search-text_gw-ans
Sheet: Cases

OP's test case -Row-2 A&B both appear in row-4 |  |  | Expected | Flame-1 | Flame-2 | GW | [NAME] | kvsrinivasamurthy | Test case
RESI_ADDR | EMP_DEMO | SELECT A.SAL, A.ADDR FROM EMP_DSI A GROUP BY 1,2 | True | True | True | True | True |  | OP's original test case
COUNTY | EMP_QUAL | SELECT A.BAL, B.HLTH FROM EMP_FI A, EMP_SE B WHERE A.ID = B.ID | False | False | False | False | False
EDUCATION | EMP_BIO | SELECT A.RESI_ADDR, A.LOC FROM EMP_DEMO A GROUP BY 1,2 | False | False | False | False | False
Row-8:  A in one row, B in a different row  expected row-8: TRUE
RESI_ADDR | EMP_DEMO | SELECT A.SAL, A.ADDR FROM EMP_DSI A GROUP BY 1,2 | True | True | True | True | True |  | col-A in one row, col-B in a different row
COUNTY | EMP_QUAL | SELECT A.BAL, B.HLTH FROM EMP_QUALEMP_FI A, EMP_SE B WHERE A.ID = B.ID | True | True | True | False | True
EDUCATION | EMP_BIO | SELECT A.RESI_ADDR, A.LOC FROM EMP_DEMO A COUNTYGROUP BY 1,2 | False | False | False | False | False
Row-12: Only A is found, not B - expected result: FALSE
RESI_ADDR | EMP_DEMO | SELECT A.SAL, A.ADDR FROM EMP_DSI A GROUP BY 1,2 | False | True | True | False | True |  | Only col-A is found, not col-B
COUNTY | EMP_QUAL | SELECT A.BAL, B.HLTH FROM EMP_FI A, EMP_SE B WHERE A.ID = B.ID | False | False | False | False | False
EDUCATION | EMP_BIO | SELECT A.RESI_ADDR, A.LOC FROM EMP_DEMX A GROUP BY 1,2 | False | False | False | False | False
Row-18: Multiple matches of RESI_ADDR
RESI_ADDR | EMP_DEMO | SELECT A.SAL, A.ADDR FROM EMP_DSI A GROUP BY 1,2 | True | True | True | True | True |  | Multiple matches of RESI_ADDR
COUNTY | EMP_QUAL | SELECT A.BAL, B.HLTH FROM RESI_ADDR EMP_FI A, EMP_SE B WHERE A.ID = B.ID | False | False | False | False | False
EDUCATION | EMP_BIO | SELECT A.RESI_ADDR, A.LOC FROM EMP_DEMO A GROUP BY 1,2 | False | False | False | False | False
RED fill means a change from the OP's original test case.
Spreadsheet: 10b50a0d-7589-4dc5-b33f-a2166e0c2be0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: New Home Sales
 |  | New Single-family [NAME]: United States
 |  | Seasonally Adjusted All Houses [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: May 21, 2013 (2:28 pm)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
2008
2009
2010
2011
2012