tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 702702d1604493139-google-sheets-how-to-embed-a-condition-with-if-clause-in-given-formula-live-tracking-unique
Sheet: Solution - final report

 |  |  |  |  | PAISLEY |  | 3966 |  |  |  |  |  |  |  |  |  | BASKET |  |  |  |  |  |  |  |  |  |  |  | SOLITAIRE |  |  |  |  |  |  |  |  |  |  |  | PAISLEY
 |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 791944d1660664396-formula-for-counting-dates-as-one-with-multiple-entries-within-a-week-number-sameplebook
Sheet: Sheet2

Week number | Date | Hours worked
1 | 2022-08-16 00:00:00 | 4 |  | Week | No. |  |  |  |  |  |  | 2 |  |  |  |  | Column A represents the week number. Column B is a list of daily entries, to be counted as 1 day though it might contain 3-20 entries. Column C to represent hours worked. Cell H1 is my existing formula that will count the number of days, but I need it to include the week number as a condition to check (cell M1).
1 | 2022-08-16 00:00:00 | 5 |  | 1
2 | 2022-08-16 00:00:00 | 6
2 | 2022-08-16 00:00:00 | 7
2 | 2022-08-19 00:00:00 | 8
3 | 2022-08-17 00:00:00 | 9
3 | 2022-08-18 00:00:00 | 8
3 | 2022-08-17 00:00:00 | 7
3 | 2022-08-20 00:00:00 | 6
4 | 2022-08-16 00:00:00 | 5
4 | 2022-08-17 00:00:00 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Example: By checking how many day-entries in week 2, the desired value should be 2 since there are 2 different dates within week 2. If we were to check for week 1, then the desired value would be 1 since the work hours recorded were on the same day.
Spreadsheet: 88792d1288635347-mass-find-and-replace-sample
Sheet: Starts with 

Player ID | Player Name | Team
 | [NAME] | BOS | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | STL | 2 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
 | [NAME] | CLE | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Erick Threets | CHW | 11 | 0 | 12.1 | 9 | 1 | 0 | 3 | 6 | 0 | 0 | 0 | 0 | 0 | 0.97 | 0
 | [NAME] | BOS | 6 | 0 | 4 | 5 | 0 | 0 | 1 | 3 | 1 | 0 | 0 | 1 | 0 | 1.5 | 0
 | [NAME] | MIL | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | BAL | 1 | 0 | 0.2 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 3 | 0
Spreadsheet: 870678d1717147340-assign-group-name-to-a-list-of-values-within-another-column-ga-help
Sheet: Sheet1

Actual Status |  | Group Name | OUTPUT | Group Name | Actual Status | Ticket | Ticket Detail
Triage | > | Planned |  | Planned | Triage | 1 | [NAME]
Todo | > | In Progress |  | In Progress | In Progress | 3 | fdsjkfdj
Scope Review | > | Planned |  | Planned | Scope Review | 6 | dfjksldjflk
Ready for Development | > | In dev Q |  | Testing | Post-Deployment QA | 5 | dfjksldjflk
Post-Deployment QA | > | Testing |  | [NAME] | [NAME] | 7.5 | dfjksldjflk
Planned | > | Planned |  | Backlog | Backlog | 9 | dfjksldjflk
On Hold | > | On Hold |  | Cancelled | Cancelled | 10.5 | dfjksldjflk
In Review | > | Testing |  | Planned | Planned | 12 | dfjksldjflk
In Progress | > | In Progress
In Code Review | > | Testing
Done | > | Deployed
[NAME] | > | [NAME]
[NAME] | > | [NAME]
Deployed | > | Deployed
Canceled | > | Cancelled
Blocked | > | Blocked
Backlog | > | Backlog
Spreadsheet: 0578d60c-f994-4a03-bd06-3b1bd709b442
Sheet: Elecare

Elecare
Desired kcal | 280
Scoops of Powder |  | scoops
Water |  | ounces |  | mL
Yield |  | ounces |  | mL
Protein |  | grams
Elecare Jr
Desired kcal | 1800
Scoops of Powder |  | scoops
Water |  | ounces |  | mL
Yield |  | ounces |  | mL
Protein |  | grams
[NAME]
Presbyterian St. Lukes Medical Center/Rocky Mountain Hospital For Children
[EMAIL]
Spreadsheet: 681686d1591701430-add-2-cell-results-together-sales-2020
Sheet: Sheet3

Code | Merchant |  |  |  | Boxes | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WT | [NAME]
WC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC | [NAME]
Vessel | Species | Presentation | Grade | Number of Boxes | [NAME] | Unit Price | Total Value |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HD | [NAME]
 |  |  |  |  |  |  |  |  | Result 1 (wc) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JPL | JPL Shellfish
 |  |  |  |  |  |  |  |  | Code | Merchant |  |  |  | Boxes | Date |  |  |  |  |  |  |  |  | BL | Bells Seafood
 |  |  |  |  |  |  |  |  | WC | [NAME] |  |  |  | 31 |  |  |  |  |  |  |  |  |  | PWELL | Pierowall Fish
 |  |  |  |  |  |  |  |  | Vessel | Species | Presentation | Grade | Number of Boxes | [NAME] | Unit Price | Total Value |  |  |  |  |  |  |  | ICEW | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WL | Whitelink Seafoods
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CS | Caithness Smoke House
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OT | Fish In Crieff
 |  |  |  |  |  |  |  |  | BCK35 | COD | GH | 2 | 6 | 35 | 106 | 636 |  |  |  |  |  |  |  | CPM | Campbells Prime Meat
 |  |  |  |  |  |  |  |  | BCK35 | COD | GH | 3 | 2 | 35 | 84 | 168 |  |  |  |  |  |  |  | [NAME] | Captains Galley
 |  |  |  |  |  |  |  |  | BCK35 | HAD | GH | 2 | 2 | 35 | 89 | 178 |  |  |  |  |  |  |  | NS | Norscot Seafoods
 |  |  |  |  |  |  |  |  | BCK35 | HAD | GH | 3 | 2.75 | 35 | 50 | 137.5 |  |  |  |  |  |  |  | KB | Kirkwall Bay Shellfish
 |  |  |  |  |  |  |  |  | BCK35 | WHG | WF | 4 | 6.25 | 35 | 35 | 218.75
 |  |  |  |  |  |  |  |  | BF61 | COD | GH | 3 | 9.75 | 35 | 86 | 838.5
 |  |  |  |  |  |  |  |  | BF61 | HAD | GH | 3 | 1 | 29 | 40 | 40
Spreadsheet: 150300d1334407834-countifs-countifs
Sheet: Summary

 |  | 2012-01-30 00:00:00 | 2012-01-31 00:00:00 | 2012-02-01 00:00:00 | 2012-02-02 00:00:00 | 2012-02-03 00:00:00 | 2012-02-04 00:00:00 | 2012-02-05 00:00:00 | 2012-02-06 00:00:00 | 2012-02-07 00:00:00 | 2012-02-08 00:00:00 | 2012-02-09 00:00:00 | 2012-02-10 00:00:00
 | Total Completed | 13 | 0 | 0 | 0 | 0 | 0 | 12 | 27 | 0 | 0 | 0 | 0
List of values to search for |  | New search criteria:
041-12
075-02
413-01
416-01
418-07
418-09 |  | I03B
437-01
470-02
655-06
692-07
735-04
738-04 |  |  |  |  |  |  |  |  | I07B
739-04 |  |  |  |  |  |  |  |  | I07B
822-01 |  |  |  |  |  |  |  | I07B | I07B
824-01
828-04 |  |  |  |  |  |  |  |  | I07B
833-01
833-02
834-04 |  |  |  |  |  |  |  | I07B | I07B
839-01 |  |  |  |  |  |  |  |  | I07B
861-01 |  |  |  |  |  |  |  |  | I07B
863-01 |  |  |  |  |  |  |  | I07B
864-01
865-01
881-03
888-07
942-06
951-01
952-01
962-01 |  |  |  |  |  |  |  | I07B
962-02
976-01
977-01
991-01
997-01
Spreadsheet: 71969d1272643137-return-a-name-from-dated-column-1-criterion-big
Sheet: Sheet2

 |  | Choose a month |  | SEPTEMBER | How to make the data in the table change as I choose a different month because I don`t want very long table here for whole year
 |  |  | 2010-04-01 00:00:00 | 2010-04-02 00:00:00 | 2010-04-03 00:00:00 | 2010-04-04 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-11 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-18 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-25 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 | 2010-05-01 00:00:00
 |  | PETRAS |  |  |  | H
 |  | ANTANS |  |  |  |  | H
 |  | name3
 |  | JURGIS |  |  |  | H
 |  | name5
 |  | name6 |  |  |  | S
 |  | name7 |  |  |  |  | S
 |  | name8
 |  | name9 |  |  |  | H | H
 |  | name10
 |  | name11 |  |  |  | S
 |  | name12
 |  | name13
 |  | name14 |  |  |  |  | H
 |  | [NAME]
 |  | TOTAL | 15 | 15 | 15 | 10 | 11 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
 |  |  |  | JANUARY
 |  |  |  | FEBRUARY
 |  |  |  | [NAME]
 |  |  |  | APRIL
 |  |  |  | MAY
 |  |  |  | [NAME]
 |  |  |  | JULY
 |  |  |  | AUGUST
 |  |  |  | SEPTEMBER
 |  |  |  | OCTOBER
 |  |  |  | NOVEMBER
 |  |  |  | DECEMBER
Spreadsheet: 156232d1337237074-question-about-forms-linked-to-spreadsheets-and-pivot-tables-offset-and-table
Sheet: Table

Revenue | Jan-12 | Dec-11 | [NAME] |  | Total Variance | 60092
A1 | 50322 | 54670 | -4348
A2 | 94457 | 97783 | -3326
A3 | 95590 | 88351 | 7239
A4 | 59628 | 63023 | -3395
A5 | 70523 | 56757 | 13766
A6 | 68052 | 24374 | 43678
A7 | 95368 | 77037 | 18331
A8 | 18717 | 34230 | -15513
A9 | 25955 | 59983 | -34028
A10 | 15269 | 20675 | -5406
A11 | 64082 | 19448 | 44634
A12 | 20324 | 21864 | -1540
Spreadsheet: 106520d1303792212-summing-the-number-of-ma-crosses-tally-crosses
Sheet: Sheet1

 |  |  | average temp. readings |  |  |  | crosses
2010-04-15 00:00:00 | 21.7 | 13 | 18 | 10 | 8 | 15
2010-04-16 00:00:00 | 23 | 15 | 21 | 15 | 9 | 13
2010-04-17 00:00:00 | 25 | 18 | 24 | 20 | 10 | 9
15 to 16
Slope | 1.300000000000001 | 2 | 3 | 5 | 1 | -2
Start | 21.7 | 13 | 18 | 10 | 8 | 15
0.1 | 21.83 | 13.2 | 18.3 | 10.5 | 8.1 | 14.8
0.2 | 21.96 | 13.4 | 18.6 | 11 | 8.2 | 14.6
0.3 | 22.09 | 13.6 | 18.9 | 11.5 | 8.3 | 14.4
0.4 | 22.22 | 13.8 | 19.2 | 12 | 8.4 | 14.2 |  | we can see on the 15th there where 2 crosses, the 16th 3 crosses and the 17th none, so I am interested in the 16th the total would be
0.5 | 22.35 | 14 | 19.5 | 12.5 | 8.5 | 14 |  | 5 crosses. A day either side of the 16th plus the 16th would give me a great number.
0.6 | 22.48 | 14.2 | 19.8 | 13 | 8.6 | 13.8
0.7 | 22.61 | 14.4 | 20.1 | 13.5 | 8.7 | 13.6
0.8 | 22.74 | 14.6 | 20.4 | 14 | 8.8 | 13.4
0.9 | 22.87 | 14.8 | 20.7 | 14.5 | 8.9 | 13.2
1 | 23 | 15 | 21 | 15 | 9 | 13
Spreadsheet: 121558d1316149818-finding-the-lowest-value-based-on-multiple-text-criteria-book2
Sheet: Sheet1

2000 |  |  |  |  | Min Data
Name1 | P01
 | P02
 | P03
[NAME] | P01
 | P02
 | P03
 | P04
2001 |  |  |  |  | Min Data
Name1 | P01
 | P02
 | P03
 | P04
 | P05
[NAME] | P01
 | P02
2002 |  |  |  |  | Min Data
Name1 | P01
 | P02
Spreadsheet: 809367d1671045606-vlookup-help-test-2023
Sheet: Feb

Last 2 Months | Current Month
Dec/ Jan | Feb | Store 1 | Store 2 | Store 3 | Store 4 | Store 5 | Totals
 | Dr. [NAME] | 10 | 5 |  | 5
Coke |  | 5 |  | 5 |  | 5
Spreadsheet: 0f0635b5-d5d0-4647-bde1-18ab8a0c8082
Sheet: Sheet1

DAFTAR PESERTA PLPG RAYON 112 UNIVERSITAS NEGERI SEMARANG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
TAHAP VI GUGUS BADAN DIKLAT PROPINSI JAWA TENGAH GEDUNG MERAPI
[NAME] Tanggal 2 s/d 11 Agustus 2011
Kelas | : Penjas SD
No | No Peserta | Nama | [NAME] | Kab/Kota
1 | 11032922010055 | AJI DWIYANTO | SD N KALIWLINGI 01 | Kab. Brebes
2 | 11032522010573 | AMAT YAHRI | SD N SURJO 01 | Kab. [NAME]
3 | 11032522010332 | BUKHORI | SD N BANDAR 01 | Kab. [NAME]
4 | 11032522010497 | BUSRO | SD N KRANGGAN 02 | Kab. [NAME]
5 | 11032522010500 | CASYANTO | SD N SUMURBANGER 02 | Kab. [NAME]
6 | 11032622010587 | [NAME], A.Ma. | SDN 1 KERTIJAYAN | Kab. Pekalongan
7 | 11032522010488 | HERLINA KOMARA LESTARI | SD N CEPAGAN 02 | Kab. [NAME]
8 | 11032702710093 | KISNOTO | SDN 4 WIDODAREN | Kab. Pemalang
9 | 11032902710464 | KUSWO | SDN SALEM 04 | Kab. Brebes
10 | 11032522010518 | MAKHMUDI | SD N BOJA 01 | Kab. [NAME]
11 | 11032522010587 | MUHAMAD NAIBAN | SD N SURJO 03 | Kab. [NAME]
12 | 11032522010582 | NANANG JAKA PURWANTA | SD N GETAS 01 | Kab. [NAME]
13 | 11032522010583 | NURUDIN MAKSUS | SD N PURBO 01 | Kab. [NAME]
14 | 11032522010303 | PRIYONO | SD N BULU 01 | Kab. [NAME]
15 | 11032522010127 | RAJA''I | SD N SUBAH 01 | Kab. [NAME]
16 | 11032522010146 | RUDDY MAFRONI | SD N KALIMANGGIS | Kab. [NAME]
17 | 11032902710463 | RUSMANA | SDN BENTARSARI | Kab. Brebes
18 | 11032522010150 | SALAMAH | SD N KALIBOYO 02 | Kab. [NAME]
19 | 11032522010369 | SANTOSO | SD N KAMBANGAN 01 | Kab. [NAME]
20 | 11032522010092 | SITI KUTSIYAH | SD N KARANGANOM 02 | Kab. [NAME]
21 | 11032522010213 | SRI SULISTYONO | SD N AMONGROGO 01 | Kab. [NAME] |  |  |  | 26.25
22 | 11032202710390 | SRI WALUYO, [NAME]. | SDN PANJANG 03 | Kab. Semarang
23 | 11032522010493 | SUBIYANTO | SD N GONDO 02 | Kab. [NAME] |  |  | 252
24 | 11032522010229 | SUKAMTO | SD N LEBO 02 | Kab. [NAME]
25 | 11032522010313 | [NAME] | SD N BINANGUN 01 | Kab. [NAME]
26 | 11032522010365 | SUNARTO | SD N KETELENG 01 | Kab. [NAME]
27 | 11032522010309 | SUPRIHATIN | SD N BANDAR 03 | Kab. [NAME]
28 | 11032522010267 | SUTRISNO | SD N SIDOREJO 01 | Kab. [NAME]
29 | 11032902710821 | TARWIN | SDN SIGEMPOL | Kab. Brebes
30 | 11032522010520 | TARYADI | SD N HARJOWINANGUN 02 | Kab. [NAME]
31 | 11032522010402 | TRI ANTOROHADI | SD N KLIDANG WETAN | Kab. [NAME]
32 | 11032522010188 | TRIYANI | SD N KENCONOREJO 01 | Kab. [NAME]
33 | 11032522010541 | TUTIATI | SD N TAMBAKBOYO 02 | Kab. [NAME]
34 | 11032522010498 | WAHYUDI | SD N PUJUT 02 | Kab. [NAME]
35 | 11032522010551 | WIYONO | SD N WONOSOBO 01 | Kab. [NAME]
36 | 11032522010080 | ZUBAIKHUN | SD N UJUNGNEGORO 02 | Kab. [NAME]
Spreadsheet: 60142d1260677478-solved-vlookup-adambudget2009-1-
Sheet: CurrentPayCheck

Pay Check | Date | Finger Print | Item Name | Categories | Tags | Tag Amount | Bank Amount | Comments | Expense Categories | Tags
 |  |  |  |  |  |  |  |  | Blank | Blank
1301
Left Over |  |  |  | Gifts |  | 5
 |  |  |  | Gifts |  | 20
 |  |  |  |  |  |  |  |  | Total Category Amount | Total Tag Amount
 |  |  |  |  |  |  |  |  | Total Budgeted Amount | Filter
 |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Left Over
Spreadsheet: michelle_lokay__26792__imball0203
Sheet: Duke

Duke Energy Field Services
Contract  24268
2002-02-28 00:00:00 |  | 1494053.52
 |  |  |  |  |  |  |  | Duke Energy Trading and Marketing, L.L.C.
2002-03-06 00:00:00 |  |  |  |  |  |  |  | OBA Balances as of 11/30/01
50895
60874 | 612
78169 |  |  |  |  |  |  |  | Contract# | Amount | Description/Points
500235 |  |  |  |  |  |  |  | 24361 |  | Pyote points - fuel is still being delivered causing amount to grow each month
500248 |  |  |  |  |  |  |  | 24693 | 275313.72 | [NAME] plant - hasn't had activity since 12/2000
500251 |  |  |  |  |  |  |  | 21665 | 73449.16 | no activity since 11/98
500254 |  |  |  |  |  |  |  | 22664 | 23612.35 | Grand Valley plant - last activity 4/96
500255
500262 | -1
500267
Duke Energy Trading and Marketing
Contract  24693
2002-02-28 00:00:00 |  | 275313.72
2002-02-28 00:00:00
9164
9167
Duke Energy Trading and Marketing |  |  |  | CBS Volume | 24268 | 24693 | 24361
Contract  24361 |  |  |  |  | 360991 | 117857 | 197167
2002-02-28 00:00:00 |  | 863787.94
2002-03-06 00:00:00
500241
500391
500392 | 538
Duke Energy Trading and Marketing
21665 | oba | 73445.08 | POI 9109 Mobil Waha Plant |  |  |  | 21665 | 36401
22664 | oba | 23612.35 | POI 59918 Grand Valley Plant |  |  |  | 22664 | 18932
24268
24693
24361
21665
22664
23995
22051
20379
26357
21544
24532
Spreadsheet: 216235d1361651828-counting-only-specific-values-problem-2-
Sheet: Logbook

DATE | AIRCRAFT |  | PILOT IN COMMAND | CO-PILOT, STUDENT OR PASSENGER | REMARKS | ROUTE | SINGLE ENGINE AIRCRAFT |  |  |  | MULTI-ENGINE AIRCRAFT |  |  |  |  |  | CROSS COUNTRY |  |  |  | TAKE-OFFS & LANDINGS |  | INSTRUMENT
 | MAKE/MODEL | REGISTRATION |  |  |  |  | DAY |  | NIGHT |  | DAY |  |  | NIGHT |  |  | DAY |  | NIGHT
 |  |  |  |  |  |  | DUAL | PIC | DUAL | PIC | DUAL | PIC | CO-PILOT | DUAL | PIC | CO-PILOT | DUAL | PIC | DUAL | PIC | DAY | NIGHT | ACTUAL | HOOD | SIM | # IFR Approaches
2012-09-06 00:00:00 | C152 | C-GGGG | Self |  |  |  |  | 5 |  |  |  |  |  |  |  | 9.9 |  | 4 |  |  | 1
2012-09-07 00:00:00 | C152 | C-GGGG | Self |  |  |  |  | 3.7 |  |  |  |  |  |  |  |  |  | 1 |  |  | 1
2012-10-08 00:00:00 | C152 | C-GGGG | Self |  |  |  |  | 3.1 |  |  |  |  |  |  |  |  |  | 1.2 |  |  | 1
2012-10-08 00:00:00 | C152 | C-GGGG | Self |  |  |  |  | 0.8 |  |  |  |  |  |  |  |  |  | 0.6 |  |  | 1
2012-10-09 00:00:00 | C152 | C-GGGG | Self |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 1.6 |  |  | 1
2012-10-10 00:00:00 | C152 | C-GGGG | Self |  |  |  |  | 1.5 |  |  |  |  |  |  |  |  |  | 1.5 |  |  | 1
2012-12-30 00:00:00 | SW5 | C-XXXX | [NAME] | Self |  |  |  |  |  |  |  |  | 1.6 |  |  |  | 1.2 |  |  |  | 3 |  |  |  |  | 1
2013-01-03 00:00:00 | SW5 | C-XXXX | [NAME] | Self |  |  |  |  |  |  |  |  |  |  |  | 3.4 |  |  | 3.4 |  |  | 2
2013-01-07 00:00:00 | SW5 | C-YYYY | [NAME] | Self |  |  |  |  |  |  |  |  |  |  |  | 1.8 |  |  | 1.8 |  |  | 2 | 0.3
2013-01-10 00:00:00 | SW5 | C-XXXX | [NAME] | Self |  |  |  |  |  |  |  |  | 0.9 |  |  | 3.6 | 0.9 |  | 3.6 |  | 0.5 | 2.5 | 3 |  |  | 2
2013-01-11 00:00:00 | SW5 | C-YYYY | [NAME] | Self |  |  |  |  |  |  |  |  |  |  |  | 1.8 |  |  | 1.8 |  |  | 2 | 0.6 |  |  | 1
2013-01-16 00:00:00 | SW5 | C-YYYY | [NAME] | Self |  |  |  |  |  |  |  |  |  |  |  | 1.8 |  |  | 1.8 |  |  | 2 | 0.4
2013-01-18 00:00:00 | SW5 | C-XXXX | [NAME] | Self |  |  |  |  |  |  |  |  |  |  |  | 3.6 |  |  | 3.6 |  |  | 2 | 0.9
2013-01-21 00:00:00 | SW5 | C-XXXX | [NAME] | Self |  |  |  |  |  |  |  |  |  |  |  | 3.6 |  |  | 3.6 |  |  | 2 | 1.5
2013-01-22 00:00:00 | SW5 | C-ZZZZ | [NAME] | Self |  |  |  |  |  |  |  |  |  |  |  | 3.8 |  |  | 3.8 |  |  | 2 | 1.6 |  |  | 1
2013-01-23 00:00:00 | SW5 | C-ZZZZ | [NAME] | Self |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 2 |  |  | 2 | 1.3 |  |  | 2
 |  |  |  |  |  | TOTAL
 |  |  |  | TOTAL FLIGHT TIME
Spreadsheet: 161837d1339648016-sumproduct-multiple-criteria-sample
Sheet: Sheet1

 | Name | Defect | Fatal | Non Fatal | Error | Quality
 | ABC | 3 | 2 | 1 | 30 | 70
 | DEF | 1 | 1 | 0 | 10 | 90
 | GHI | 1 | 0 | 1 | 3.3 | 96.7
 | JKL | 2 | 1 | 1 | 20 | 80
 | MNO | 5 | 5 | 0 | 36.7 | 63.3
 | PQR | 3 | 3 | 0 | 23.3 | 76.7
 | STU | 1 | 1 | 0 | 3.4 | 96.6
 | VW | 1 | 1 | 0 | 10 | 90
 | XYZ | 1 | 1 | 0 | 10 | 90
 | ABC | 2 | 1 | 1 | 13.3 | 86.7
 | DEF | 1 | 1 | 0 | 10 | 90
 | GHI | 3 | 3 | 0 | 23.4 | 76.6
 | JKL | 0 | 0 | 0 | 0 | 100
 | MNO | 2 | 2 | 0 | 20 | 80
 | PQR | 1 | 1 | 0 | 10 | 90
 | STU | 0 | 0 | 0 | 0 | 100
 | VW | 1 | 1 | 0 | 5 | 95
 | XYZ | 2 | 2 | 0 | 20 | 80
 | ABC | 2 | 1 | 1 | 13.3 | 86.7
 | DEF | 2 | 2 | 0 | 13.4 | 86.6
 | GHI | 1 | 1 | 0 | 10 | 90
 | JKL | 1 | 1 | 0 | 10 | 90
 | MNO | 0 | 0 | 0 | 0 | 100
 | PQR | 0 | 0 | 0 | 0 | 100
 | STU | 1 | 1 | 0 | 10 | 90
 | VW | 4 | 4 | 0 | 28.4 | 71.6
 | XYZ | 5 | 5 | 0 | 36.7 | 63.3
Spreadsheet: 720893d1614351889-lookup-values-and-if-a-match-is-made-do-a-conditional-formatting-match-and-shade
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friends |  |  |  |  |  |  |  |  |  | Enemy |  |  |  |  |  |  |  | Neutral
 |  |  | P | 2 |  | NN | 9 |  |  | E | ANTI |  |  |  |  |  |  |  | 1 | 9 | 2 | 5 | 3 | 6 | 1 |  |  | 1 | 8 |  |  |  |  |  |  | 1 | 4 | 7
 |  |  | P | 2 |  | FN |  |  |  | E | ANTI |  |  |  |  |  |  |  | 2 | 1 | 5 | 3 | 2 |  |  |  |  | 2 | 8 | 4 | 9 |  |  |  |  | 2 | 6 | 7
 |  |  | L | 7 |  | NN |  |  |  | F | OK |  |  |  |  |  |  |  | 3 | 1 | 5 | 6 | 2 |  |  |  |  | 6 |  |  |  |  |  |  |  | 3 | 4 | 8 | 9
 |  |  | L | 7 |  | FN |  |  |  | F | OK |  |  |  |  |  |  |  | 4 | 7 | 1 | 5 | 6 | 4 |  |  |  | 2 | 8 | 2 | 9 |  |  |  |  | 4 | 3
 |  |  | P1 | 2 |  | L2 | 8 |  |  | E | ANTI |  |  |  |  |  |  |  | 5 | 1 | 2 | 3 | 6 | 5 |  |  |  | 5 |  |  |  |  |  |  |  | 5 | 7 | 8 | 9 | 4
 |  |  | P2 | 9 |  | L1 | 3 |  |  | F | OK |  |  |  |  |  |  |  | 6 | 1 | 5 | 7 | 6 | 4 |  |  |  | 6 | 3 |  |  |  |  |  |  | 6 | 8 | 9 | 2
 |  |  | L2 | 6 |  | NN | 6 |  |  | N | NETRAL |  |  |  |  |  |  |  | 7 | 4 | 6 | 1 | 5 | 3 |  |  |  | 7 |  |  |  |  |  |  |  | 7 | 8 | 9 | 2 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | 3 | 6 | 7 |  |  |  |  | 8 | 1 | 2 | 8 |  |  |  |  | 8 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1 | 5 | 3 |  |  |  |  |  | 9 | 4 | 2 |  |  |  |  |  | 9 | 9 | 7 | 6 | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F | Friends
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E |  | Enemy
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N |  | Neutral
 |  |  |  |  | need help with a looup formula that will firstly check E3 and H3
 |  |  |  |  | THE VALUE OF e3 IS 2 AND THE VALUE OF h3 IS 9
 |  |  |  |  | We check the tables  and if E3 and H3 matches under the table and we find that it matches in the secon d table
 |  |  |  |  | 2 and 9 which is found in the Enemy table so a match
 |  |  |  |  | we therafter indicate I K3 that a match is found and the letter "E" will be indicated and shaded red
 |  |  |  |  | the match is an enemy so we say that they are anti to each other
 |  |  |  |  | trust makes a little better sense to what I have in mind
Spreadsheet: 0343878c-ffda-4d0d-94fe-75d7131d7099
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
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 27. Output of the Other services industries, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  9533 Parking services ; |  |  | Original | A2314112L | 1998-09-01 00:00:00 | 2012-12-01 00:00:00 | 58 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2013
Spreadsheet: 153731d1336032009-vlookup-with-more-than-1-condition-example
Sheet: Sheet1

Client name | ID | Type | Location
a | 1 | a
b | 2 | b
c | 3 | a
d | 4 | b
Spreadsheet: 765869d1643646751-weeks-conditional-formatting-berna-example-week-aligw
Sheet: Foglio1

2022
[NAME] | fine | START | N. of week | END |  | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
2021-12-13 00:00:00 |  |  | 5
2022-07-13 00:00:00 |  |  | 4
2022-12-13 00:00:00 |  |  | 7
2022-02-13 00:00:00 |  |  | 6
2022-04-13 00:00:00 |  |  | 7
2022-12-08 00:00:00 |  |  | 3
Spreadsheet: richard_shapiro__32201__BudReductions
Sheet: Sheet1

Proposed Budget Reductions
Atlantic Seaboard Region
Description | State | Original | Reduction | Revised
 |  | Budget/RCR |  | Budget/RCR
Tabors TCC Review - RCR | NY | 75000 | 35000
Legislative Activity | Massachusetts | 50000 | 25000
Legislative Activity | New Jersey | 240000 | 20000
Legislative Activity | New York | 75000 | 25000
[NAME] / IPPNY | New York | 101000 | 25000
Legislative Activity | Pennsylvania | 72000 | 22000
Legislative Activity | Virginia | 36000 | 6000
Travel & Entertainment | all | 708000 | 10000
Total Proposed Reduction