tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 163635d1340383961-excel-2007-how-to-match-two-field-with-reference-field-stimulation_1
Sheet: Sheet2

Invoice# | DR | Invoice# | CR
a | 12 | f | 40
c | 12 | a | 12
b | 25 | d | 20
e | 25 | h | 15
d | 20 | e | 25
IF(NOT(ISERROR(VLOOKUP(B8,OrdersC,2,FALSE))), VLOOKUP(B8,OrdersC,2,FALSE),"Not Found"))))
INDEX($B$2:$D$4,MATCH(B7,$A$2:$A$4,0),MATCH(A7,$B$1:$D$1,0))
Spreadsheet: 45953d1244730230-how-to-link-names-to-a-table-score-card
Sheet: Sheet1

Antrobus & District Gun Club |  |  |  |  |  |  |  |  |  | Date:-       /      /
Name:-
Stand | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total
1
2
3
4
5
[NAME] for a Kill and 0 for a loss |  |  |  |  |  |  |  |  |  | Total:-
Antrobus & District Gun Club |  |  |  |  |  |  |  |  |  | Date:-       /      /
Name:-
Stand | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total
1
2
3
4
5
[NAME] for a Kill and 0 for a loss |  |  |  |  |  |  |  |  |  | Total:-
Antrobus & District Gun Club |  |  |  |  |  |  |  |  |  | Date:-       /      /
Name:-
Stand | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Total
1
2
3
4
5
[NAME] for a Kill and 0 for a loss |  |  |  |  |  |  |  |  |  | Total:-
Spreadsheet: 3723c030-50a2-4256-8b69-42b154b9256f
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
 | 8731.0 Building Approvals, Australia
 | TABLE 20. Number of Dwelling Units Approved in New Residential Buildings, Original - Australia
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Number of Dwelling Units ;  New ;  Total houses ; |  |  | Original | A418403T | 1956-01-01 00:00:00 | 2010-08-01 00:00:00 | 656 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Semi-detached, row or terrace house, townhouse with one storey and similar ; |  |  | Original | A415785F | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Semi-detached, row or terrace house, townhouse with two or more storeys ; |  |  | Original | A422926F | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total semi-detached, row or terrace houses, townhouses and similar ; |  |  | Original | A416421K | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of one or two storeys ; |  |  | Original | A423529V | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of three storeys ; |  |  | Original | A424174L | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Flat, unit or apartment in a building of four or more storeys ; |  |  | Original | A424726X | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total flats, units or apartments, excl. [NAME] flats and other/unknown ; |  |  | Original | A417063R | 1991-07-01 00:00:00 | 2010-08-01 00:00:00 | 230 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total other residential building ; |  |  | Original | A419138J | 1970-07-01 00:00:00 | 2010-08-01 00:00:00 | 482 | Number | FLOW | Month | 1
Number of Dwelling Units ;  New ;  Total residential building ; |  |  | Original | A419824J | 1956-01-01 00:00:00 | 2010-08-01 00:00:00 | 656 | Number | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 691290d1597620295-could-dmax-be-changed-to-a-pull-down-formula-help0817
Sheet: Sheet2

Client | Date | QTY |  |  |  | Client | DMAX | MAX
A |  | 10 |  |  |  | A
B |  | 20 |  |  |  | B
C |  | 30 |  |  |  | C
D |  | 40 |  |  |  | D
A |  | 50
C |  | 60 |  |  |  |  | Dmax only H2 cell Correct
A |  | 70 |  |  |  |  | How about H3:H5
B |  | 80 |  |  |  |  | Only H2 cell is correct, is there a way to drag down to get the correct answer (like yellow color)
A |  | 90
Spreadsheet: 842207d1694289801-adding-cells-and-columns-with-criteria-of-other-columns-formula-question-1-
Sheet: Sheet1

 |  |  | 5 |  | debit
 | 15 |  | 7 |  | credit
 | 30 |  | 3 |  | Credit
 | 25 |  | 6 |  | Debit
 | 96 |  | 9 |  | Debit
 | 83 |  | 1 |  | Debit
 | 12 |  | 18 |  | Credit
 |  |  | 5 |  | Credit
 |  |  | 6 |  | Debit
 |  |  | 7 |  | Credit
 |  |  | 6 |  | Credit
 |  |  | 8 |  | Debit
 |  |  |  | debit
 |  |  |  | credit
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-216,888

 |  |  |  |  |  |  |  | 9-216   9-888
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 845345d1696879535-conditional-format-color-scale-after-a-first-elimination-rule-alexxl-conditional-color-scale-after-rule
Sheet: Sheet1

Area | Oct | Oct | Sep | Aug | Jul | Jun | May | Apr | Mar | Feb | Jan |  |  | Jun | May | Apr
 |  | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 0 | -1
Aloshop | 0.8 | 0 | 0.8630727762803234 | 0.8062959558823529 | 0.7357215967246673 | 0.8009122618728199 | 0.8123434297426554 | 0.79300725311512 | 0.8043265705206551 | 0.8052752954742001 | 0.7165763813651138 |  |  | 0.8009122618728199 | 0.8123434297426554 | 0.79300725311512
Spreadsheet: 162515d1339942666-tryin-to-get-a-red-amber-green-colour-scheme-to-appear-within-a-certain-range-of-a-numbr-rhrp-planner_reply
Sheet: Register

Name | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Contracted Hours
Spreadsheet: 1932f012-3841-4e6a-be97-523c1ca43c30
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Subfamily | Divisions | Genus
 | Reduviinae (Acanthaspidinae) | 1. Psopharia | Psophis
 |  |  | Euvonymus
 |  | 2. [NAME] | Centrocnemis
 |  |  | Epirodera
 |  |  | Marbodus
 |  | 3. Reduviaria | Alloeocranum
 |  |  | Reduvius
 |  |  | Gerbelius
 |  | 4. Acanthaspisaria | [NAME]
 |  |  | Pasiropsis
 |  |  | Acanthaspis
 |  |  | Inara
 |  |  | Edocla
 |  | 5. Lenaearia | Velitra
 |  |  | Lenaeus
 |  |  | Paralenaeus
 |  |  | Sminthocoris
 |  |  | [NAME]
 |  | 6. Conorhinaria | Durganda
 |  |  | Tiarodes
 |  |  | Conorhinus
 |  |  | Linshcosteus
 |  |  | Cerilocus
Spreadsheet: 0ed08f36-b0bd-4c1a-9cfb-0f65a18b687b
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/05/2013 | Rifle | Ohio State | 12:00 AM | W, 4657-4648
10/13/2013 | Rifle | at Nebraska* | 12:00 AM | W, 4656-4650
10/26/2013 | Rifle | Army* | 12:00 AM | W, 4695-4669
11/02/2013 | Rifle | Mississippi* | 12:00 AM | W, 4681-4614
11/03/2013 | Rifle | Akron | 12:00 AM | W, 4690-4605
11/16/2013 | Rifle | at Navy* | 12:00 AM | W, 4678-4627
01/19/2014 | Rifle | [NAME]* | 12:00 AM | W, 4707-4604
01/24/2014 | Rifle | at Withrow Invitational (Murray, Ky.) | 12:00 AM | First Place, 4710
01/25/2014 | Rifle | at Memphis* | 12:00 AM | W, 4690-4655
02/06/2014 | Rifle | Alaska-Fairbanks | 12:00 AM | W, 4709-4680
02/08/2014 | Rifle | Kentucky* | 12:00 AM | W, 4702-4688
[NAME] | Rifle | [NAME] (Murray, Ky.) | 12:00 AM | 4691
03/01/2014 | Rifle | GARC Championships (Oxford, Miss.) | 12:00 AM | First, 2337
03/02/2014 | Rifle | GARC Championships (Oxford, Miss.) | 12:00 AM | First, 4700
03/14/2014 | Rifle | [NAME] (Murray, Ky.) | 12:00 AM | First Place (smallbore), 2338
03/15/2014 | Rifle | [NAME] (Murray, Ky.) | 12:00 AM | First Place, 4705
Spreadsheet: 1e4380dd-88ca-43b3-9efb-853a707e5f39
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | เดือน | ปี |  | รหัส | ชื่อสั้น | ชื่อเต็ม
ประจำเดือน | มกราคม | พ.ศ.2549 |  | A1 | บริการหญิงตั้งครรภ์ | รายงานผลการดำเนินงานโครงการส่งเสริมการจัดบริการดูแลหญิงมีครรภ์ก่อนคลอดคุณภาพ
 | กุมภาพันธ์ | พ.ศ.2550 |  | A2 | ก. 2 | สรุปรายงานการคลอดและการป่วย / การตายของมารดาและทารก
 | มีนาคม | พ.ศ.2551 |  | A3 | ธาลัสซีเมียในหญิงตั้งครรภ์ | แบบรายงานโครงการป้องกันและควบคุมโรคโลหิตจางธาลัสซีเมีย กลุ่มหญิงมีครรภ์
 | เมษายน | พ.ศ.2552 |  | A4 | พัฒนาการเด็ก 0-5  ปี | แบบรายงานผลการประเมินพัฒนาการในกลุ่มเด็กปฐมวัย (อายุ 0- 5 ปี)
 | พฤษภาคม | พ.ศ.2553 |  | A5 | ท/5 | ผลการปฏิบัติงานทันตสาธารณสุข
 | มิถุนายน | พ.ศ.2554 |  | A6 | การแปรงฟัน | แบบรายงานการแปรงฟัน จำนวนนักเรียนที่เข้าร่วมกิจกรรมการแปรงฟันเด็กก่อนวัยเรียน
 | กรกฎาคม | พ.ศ.2555 |  | A7 | เบาหวาน | แบบรายงานข้อมูลการคัดกรองเบาหวาน
 | สิงหาคม | พ.ศ.2556 |  | A8 | ความดัน | แบบรายงานข้อมูลการคัดกรองความดันโลหิตสูง
 | กันยายน | พ.ศ.2557 |  | A9 | สุขภาพจิต | รายงานบริการสุขภาพจิต
 | ตุลาคม | พ.ศ.2558 |  | A10 | HIV จากแม่สู่ลูก | [NAME] ไอ วี จากแม่สู่ลูก
 | พฤศจิกายน | พ.ศ.2559 |  | A11 | การให้บริการผู้พิการ | รายงานผู้มารับการฟื้นฟูสมรรถภาพคนพิการทางการแพทย์
 | ธันวาคม | พ.ศ.2560 |  | B1 | อนามัยแม่และเด็ก | แบบรายงานผลการดำเนินงานอนามัยแม่และเด็ก
 |  |  |  | B2 | วางแผนฯ ข้าราชการ ประกันสังคม | แบบรายงานวางแผนครอบครัว
 |  |  |  | B3 | มะเร็งปากมดลูก | สรุปผลงานการคัดกรองมะเร็งปากมดลูกสอ./PCU
 |  |  |  | B4 | มะเร็งเต้านม | สรุปผลงานการตรวจคัดกรองมะเร็งเต้านม
 |  |  |  | B5 | น้ำหนัก 0-72 เดือน | รายงานการติดตามภาวะโภชนาการเด็ก 0-72 เดือน
 |  |  |  | B6 | ชมรมสร้างสุขภาพ | แบบสรุปรายงานชมรมสร้างสุขภาพ
 |  |  |  | B7 | ครอบครัวอบอุ่น | แบบรายงานโครงการครอบครัวอบอุ่นสู่เมืองไทยแข็งแรง
 |  |  |  | C1 | ภ.301 | แบบรายงานการเฝ้าระวังโรคโลหิตจางจากการขาดธาตุเหล็ก
 |  |  |  | C2 | ภ.302 | แบบสรุปรายงานการเฝ้าระวังโรคโลหิตจางจากการขาดธาตุเหล็ก
 |  |  |  | D1 | รายงานการวัดรอบเอว | แบบรายผลการดำเนินกิจกรรมวัดรอบเอวสมาชิก  [NAME]
 |  |  |  | D2 | รายงานแผน  9 | แบบรายงานข้อมูลพื้นฐาน งานบริการอนามัยโรงเรียนปีงบประมาณ  2550
 |  |  |  | D3 | รายงาน  ทส.003 | [NAME]
 |  |  |  | D4 | พัฒนาการเด็กในศูนย์ | สรุปผลการประเมินพัฒนาการเด็กในศูนย์เด็ก
 |  |  |  | D5 | ตรวจสุขภาพผู้สูงอายุ | [NAME] รายหมู่บ้าน /ตำบล
 |  |  |  | D6 | อนามัยวัยทำงาน | รายงานเฝ้าระวัง / ส่งเสริมสุขภาพประชากรวัยทำงาน (อายุ 18 - 59  ปี)
 |  |  |  | D7 | สำรวจผู้พิการ | แบบสำรวจคนพิการ
 |  |  |  | E1 | ข้อมูลศูนย์เด็กเล็ก | รายงานผลการดำเนินงานโครงการศูนย์เด็กเล็กน่าอยู่
 |  |  |  | E2 | ข้อมูลโรงเรียน | ข้อมูลนักเรียน
 |  |  |  | E3 | [NAME] | รายงาน ผลการดำเนินงานวางแผนครอบครัว
 |  |  |  | E4 | ไอโอดีน | แบบสรุปภาวะการขาดสารไอโอดีนของเด็กนักเรียนชั้นประถมศึกษา                   ภ 203
 |  |  |  | E5 | วัดส่งเสริมสุขภาพ | รายงานผลการดำเนินงานวัดส่งเสริมสุขภาพ
 |  |  |  | E6 | ส้วม | รายงานผลการสำรวจส้วมสาธารณะ
Spreadsheet: benjamin_rogers__944__PJMPosMgr
Sheet: Positions

Cash | Zone A | Zone G | Zone J | Nepool | PJM | Total | Total | Total |  |  |  |  | Price Summary
 | Position | Position | Position | Position | Position | NY | Nepool | PJM |  | Date | Prior Day |  |  | Current Day
 | Mw's |  |  |  |  |  |  |  |  |  | Zone A | Zone G | Zone J | Zone A | Zone G | Zone J
Term | Zone A | Zone G | Zone J | Nepool | PJM
 | Position | Position | Position | Position | Position
 | Mw's
Spreadsheet: 86786d1286760592-two-sheet-calculation-summary-poinsettiasale_forumhelp
Sheet: Summary

 |  |  |  |  |  |  |  |  |  | Poinsettia Sale
 |  |  |  |  |  |  |  |  |  |  | Sale Price | Cost | Profit | Student Profit | Band Profit
 |  |  |  |  |  |  |  |  |  | Small (R/W/P/J/M) | 12 | 6.15 | 5.85 | 4.387499999999999 | 1.4625
 |  |  |  |  |  |  |  |  |  | Medium (R/W) | 22 | 13.25 | 8.75 | 6.5625 | 2.1875
 |  |  |  |  |  |  |  |  |  | Large | 30 | 19.25 | 10.75 | 8.0625 | 2.6875
[NAME]
Name | Small |  |  |  |  | Med |  | Large | Total | Student Total Profit
 | R | W | P | J | M | R | W | R
[NAME] | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 3 | 5 | 35.1375
[NAME] | 4 | 2 | 0 | 9 | 5 | 2 | 0 | 6 | 28 | 149.25
[NAME] | 0 | 0 | 0 | 4 | 0 | 2 | 0 | 4 | 10 | 62.925
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: dfef0faf-0107-420e-ad15-e78958cb3e33
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6476 | 17364 | Sandra | Levenez | FRA | 3 | 00:35:01 | 00:00:19 | 00:59:57 | [NAME] | 00:17:25 | 1 | 01:53:02
6476 | 23496 | [NAME] | [NAME] | NED | 1 | 00:35:16 | 00:00:20 | 00:59:41 | [NAME] | 00:17:59 | 2 | 01:53:35
6476 | 29674 | [NAME] | Godard | FRA | 2 | 00:35:16 | [NAME] | 00:59:44 | 00:00:23 | 00:18:19 | 3 | 01:54:03
6476 | 13387 | [NAME] | Schulz | GER | 5 | 00:35:26 | [NAME] | 01:02:01 | 00:00:23 | 00:17:05 | 4 | 01:55:14
6476 | 6304 | Erika | Csomor | HUN | 4 | 00:35:47 | 00:00:21 | [NAME] | 00:00:21 | 00:18:25 | 5 | 01:56:34
Spreadsheet: 800446d1665670120-trying-to-conditionally-replace-data-in-a-cell-book3
Sheet: Sheet1

Input | Desired Output
LC-39A, Kennedy Space Center, Florida, USA | USA
Site 9401 (SLS-2), Jiuquan Satellite Launch Center, China | China
[NAME], Boca Chica, Texas, USA | USA
Site 200/39, Baikonur Cosmodrome, Kazakhstan | Kazakhstan
SLC-41, Cape Canaveral AFS, Florida, USA | USA
LC-9, Taiyuan Satellite Launch Center, China | China
Site 31/6, Baikonur Cosmodrome, Kazakhstan | Kazakhstan
LC-101, Wenchang Satellite Launch Center, China | China
SLC-40, Cape Canaveral AFS, Florida, USA | USA
LA-Y1, [NAME], Japan | Japan
LP-0B, Wallops Flight Facility, Virginia, USA | USA
Site 95, Jiuquan Satellite Launch Center, China | China
LC-3, Xichang Satellite Launch Center, China | China
Pad 1, Palmachim Airbase, Israel | Israel
Site 9401 (SLS-2), Jiuquan Satellite Launch Center, China | China
Rocket Lab LC-1A, M?Âhia Peninsula, New Zealand | New Zealand
LC-9, Taiyuan Satellite Launch Center, China | China
SLC-40, Cape Canaveral AFS, Florida, USA | USA
LC-2, Xichang Satellite Launch Center, China | China
Spreadsheet: 106519d1303792031-multiple-if-match-data-across-sheets-mis-format
Sheet: Asset Outstanding

UCC | Cust Id | Account Number | Client Name | FB Limit | FB OS | Total Limit | Total OS
4 | 2 | 46 | ABC Ltd
5 | 3 | 47 | XYZ Ltd
5 | 3 | 48 | XYZ Ltd
Spreadsheet: 786536d1657248599-problem-with-ifs-or-multiple-if-excel-forum
Sheet: Sheet1

 | XX_Account | YY_Account | ZZ_Account |  |  |  | No. | Code |  | SubCode | Result | Problem | When the criteria met is separated, the result comes out right
 | XX001 | YY001 | ZZ001 |  |  |  | 1 | IO | SubCode1 | XX001 |  | -
 | XX002 | YY002 | [NAME] |  |  |  |  |  | SubCode2 | [NAME]
 | [NAME] | [NAME] | ZZ003
 | XX004 | YY004 | ZZ004 |  |  |  | 2 | BT | SubCode1 | [NAME] |  | The condition meets criteria no. 3, but the result = Error.
 | XX005 | YY005 | ZZ005 |  |  |  |  |  | SubCode2 | ZZ005
 |  |  |  |  |  |  | 3 | JP | SubCode1 | XX004 |  | The condition meets criteria no. 4, but the result = Error.
 |  |  |  |  |  |  |  |  | SubCode2 | ZZ004
 | Criteria:
 | - IF Code = "", the result = ""
 | - IF Code = IO and SubCode1's match value > 0, the result = "Clear"
 | - IF Code = BT and SubCode1's match value > 0, the result = "Clear"
 | - IF Code = JP, SubCode1's match value > 0, SubCode2's match value > 0, the result = "Clear"
 | - IF there is no any criteria met, the result = "Error"
Spreadsheet: 785060d1656103000-formula-for-finding-unique-data-in-a-cell-and-returning-answer-to-another-cell-finding-unique-data-from-cells
Sheet: Sheet1

CONTAINER SIZE | [NAME] to return Data from Column A |  | Desired Data returned by formula
4 x 4 x 2.25 oz / cs |  |  | oz
4  x  2 lb / cs |  |  | lb
4 x 30 ea bg / cs |  |  | ea
5 x 4 x 30 grm / bx |  |  | grm
1 x 25 lb / bg |  |  | lb
40 x 30 grm / cs |  |  | grm
1 x 20 lb / bg |  |  | lb
6 x 120 grm / cn |  |  | grm
6 x 16 oz /cs |  |  | oz
4 x 250 / slv / cs |  |  | slv
12 x 2 pk / cs |  |  | pk
16 x 400 ml  / cs |  |  | ml
6 x 1 qt / cs |  |  | qt
12 x 8 oz cn / cs |  |  | cn
12 x 2 lb / cs |  |  | lb
Spreadsheet: 803971d1667826817-extracting-data-from-excel-tables-sales-control
Sheet: Sales Ledger

 | I'm kindly asking for excel formula to produce sales ledger using data from bank 1, bank 2, bank 3, Cash, Sales journal and Opening balance sheets
 | Sales Ledger
 | Name | I.D Number | Date | Bank | Invoice | Reference | Debit | Credit | Balance
 | Abi | A002 | 44562 |  | 198 |  |  |  | -500
 |  |  | 44866 |  | 1 |  | 3500
 |  |  | 44870 | Bank 1 |  | 23 |  | 3000
 |  |  | 44870 |  | 4 |  | 5000
 |  |  | 44870 | Cash |  | 70 |  | 250
 |  |  | 44871 | Bank 2 |  | 25 |  | 3500
 |  |  | 44872 | Bank 3 |  | 40 |  | 1000
 |  |  | 44872 | Cash |  | 80 |  | 250
 | Bigboy | A003 | 44562 |  | 220 |  |  |  | 130
 |  |  | 44866 |  | 3 |  | 3500
 |  |  | 44870 | Bank 1 |  | 24 |  | 2000
 |  |  | 44870 | Bank 3 |  | 37 |  | 4000
 |  |  | 44870 |  | 5 |  | 5000
 |  |  | 44871 | Cash |  | 71 |  | 2000
 | Rose | A001 | 44866 |  | 2 |  | 3500
 |  |  | 44871 | Cash |  | 72 |  | 3500
 |  |  | 44870 |  | 5 |  | 5000
 |  |  | 44872 | Cash |  | 30 |  | 5000
Spreadsheet: 28948d1223547062-checking-cell-values-find
Sheet: Sheet1

Column 1 | Column 2
11111113 | 11111110 | 1
222222223 | 222222220 | 1
4444444443 | 4444444440 | 1
666666663 | 555555552 | 1
777777772 | 222222220 | 1
3333331 | 999999993 | 0
555555551
Spreadsheet: 752302d1634699082-looking-for-formula-to-cumulatively-count-number-of-unique-customers-over-time-cumulative-count-using-power-query-and-a-pivot-table-walrus_22-
Sheet: Sheet1

Customer | Jan-21 | Feb-21 | Mar-21 | Apr-21 | May-21 | [NAME] | [NAME] | Aug-21 | Sep-21 | Oct-21 | Nov-21 | Dec-21
Customer 1 | 1 |  | 1 |  |  |  |  |  | 1
Customer 2 |  | 1 |  |  | 1
Customer 3 |  |  |  | 1 |  |  |  |  | 1
Customer 4
Customer 5 |  | 1 |  |  |  |  |  |  |  |  | 1
Customer | Date | Cumulative |  | Date | 2021-03-21 00:00:00
Customer 1 | 2021-01-21 00:00:00
Customer 2 | 2021-02-21 00:00:00 |  |  | Cumulative Customers
Customer 5 | 2021-02-21 00:00:00 |  |  | 3
Customer 1 | 2021-03-21 00:00:00
Customer 3 | 2021-04-21 00:00:00
Customer 2 | 2021-05-21 00:00:00
Customer 1 | 2021-09-21 00:00:00
Customer 3 | 2021-09-21 00:00:00
Customer 5 | 2021-11-21 00:00:00
Spreadsheet: 206401d1358179126-darts-scoreboard-darts1
Sheet: MAIN

 | PLAYER 1 | PLAYER 2
 |  |  |  |  | [NAME]
 | [NAME] | Niall |  |  | 501 |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  | #N/A | 501 | 501 |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  | Games
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Player 1 | Player 2
 |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3DA
 |  |  |  | 3DA | #N/A |  |  |  |  |  |  |  |  |  | Player 1 | Player 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Number of Games | 0
 |  |  |  |  | Niall |  |  |  |  |  |  |  |  |  | P1 | P2
 |  |  |  |  | 501 |  |  |  |  | #N/A |  |  |  | Won | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  | #N/A |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  | 3DA | #N/A
 | Games
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 3DA | 3DA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
Spreadsheet: 485861d1477117179-find-trends-in-employee-data-example
Sheet: page 21

Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
U 1 | 22:00     6:00 | 22:00     6:00 |  |  |  | 6:00     15:00 | 7:00     16:00
 | 4:00     11:00 | 5:00     13:00 | 22:00     6:00 | 23:00     7:00
 |  |  | 14:00    24:00 | 22:00     6:00 | 22:00     6:00 |  | 14:00    24:00
 | 14:00    23:00 | 22:00     6:00 | 22:00     6:00
 |  | 6:00     15:00 | 4:00     11:00 | 6:00     15:00 |  | 7:00     17:00 | 22:00     6:00
 | 22:00     6:00 |  |  | 5:00     14:00 | 6:00     15:00
Tur | Mandag | Tirsdag | Onsdag | Torsdag | Fredag | Lørdag | Søndag
U 2 | 22:00     6:00 | 23:00     7:00 |  |  |  | 8:00     17:00 | 8:00     17:00
 | 14:00    23:00 | 14:00    24:00 | 22:00     6:00 | 23:00     7:00
 | 6:00     15:00 | 5:00     14:00 |  |  | 14:00    24:00 | 22:00     6:00 | 23:00     7:00
 |  | 15:00    22:00 | 14:00    23:00 | 15:00     1:00
 |  |  | 14:00    22:24 | 14:00    23:00 | 23:00     7:00 |  | 22:00     6:00
 | 22:00     6:00 |  |  | 5:00     13:00 | 4:00     11:00
Spreadsheet: 08120971-55a1-44e3-a016-b58c6ec4ebe3
Sheet: 2000-2012-Cash Receipts

GAVI Alliance
Cash received 2000-2012
as of 31 December 2012
millions US$
 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | Total
Australia |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 8.6 | 48.844 | 56.4855
Canada |  |  | 1.88035602 | 4.75542135 | 9.06273425 | 130.8686406 | 5.19031142 |  |  |  |  | 20.736 | 15.12859304
Denmark |  | 1.14740743 |  |  | 3.33887922 | 3.41610739 | 4.41126234 | 4.73754 |  | 9.098395589999999 | 1.807207 | 8.798 | 4.351625
European Commission (EC) |  |  |  | 1.26 |  |  |  | 4.84964 | 23.129114 | 28.63013 |  |  | 12.54732252
France |  |  |  |  | 6.02911392 |  | 12.63 |  |  |  |  | 34.5 | 20.10215
Germany |  |  |  |  |  |  | 5.2604 | 5.948 |  | 5.72138 | 5.13598 | 8.5 | 34.69248328
Ireland |  |  | 0.51075 | 0.62375 | 0.65 | 0.83146 | 7.902 | 8.3112 | 3.84132 | 3.54 | 3.630863 | 4.913 | 3.491585
Japan |  |  |  |  |  |  |  |  |  |  |  | 9.348 | 9.067392
Luxembourg |  |  |  |  |  | 0.64515 | 1.318775 | 0.81184 | 1.4229 | 1.19124 | 1.10044 | 1.186 | 1.0752701
Netherlands |  | 24.06033462 | 13.37517187 | 16.49264195 | 17.32986645 | 15.85941435 |  | 33.547469 | 38.885301 | 31.20579 | 25.1113845 | 26.3 | 14.2065
Norway |  | 17.89468975 | 21.32565609 | 21.79108674 | 40.92459264 | 39.53459411 | 67.37931370000001 | 86.156761 | 65.44948326 | 82.80032471 | 76.483608 | 79.2 | 106.8762334
Republic of Korea |  |  |  |  |  |  |  |  |  |  | 0.4 | 0.3 | 0.3
Spain |  |  |  |  |  |  |  |  | 40.5362 |  |  | 2.666 | 0
Sweden |  | 1.89213259 | 1.11479998 | 2.38518169 | 4.93142988 | 12.66340061 | 14.59397503 | 15.514976 | 19.151976 | 13.80099952 | 36.4874975 | 92.7 | 0
United Kingdom | 4.4634 |  | 15.04825 | 5.60595 | 18.491535 | 6.625149 | 23.214072 | 48.113952 |  |  | 15.883044 | 85.1 | 206.88
United States |  | 48.092 | 53 | 58 | 59.64 | 64.48 | 69.3 | 69.3 | 71.913 | 75 | 78 | 89.8 | 130
Donor Governments and EC
Anglo Amercian plc |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
Absolute Return for Kids (ARK) |  |  |  |  |  |  |  |  |  |  |  |  | 1.6104
Bill & Melinda Gates Foundation | 325 | 425 |  | 3.5 | 5 | 154.338 |  | 75 | 75 | 75 | 75 | 264.1 | 268.8
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 3.2
His Highness Sheikh [NAME] |  |  |  |  |  |  |  |  |  |  |  | 14.1 | 8.8254855
"la Caixa" Foundation |  |  |  |  |  |  |  |  | 5.8 | 5.9 | 4 | 3.1 | 2.841215
LDS Charities |  |  |  |  |  |  |  |  |  |  |  |  | 1.5
JP Morgan |  |  |  |  |  |  |  |  |  |  |  | 2.361 | 0
The Children’s Investment Fund Foundation (UK) |  |  |  |  |  |  |  |  |  |  |  |  | 4.3
Other private | 0.02 |  | 1.630361 | 2.580847 | 1.805051 | 0.47348 | 1.904352 | 1.1 | 0.8 | 1 | 1 | 0.8 | 0.7589999999999999
Private Contributions
Sub-total
IFFIm to GFA transfers |  |  |  |  |  |  | 524.749285 | 428.268866 | 272.638133 | 330.027 | 320 | 300 | 100
AMC funds |  |  |  |  |  |  |  |  |  |  | 42.87705 |  | 223.5
Total contributions
Donations recorded on a cash basis