tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889969d1741051187-running-balance-using-power-query-pq-customers-ledger-sunboy-
Sheet: Customers Ledger USD

 | I kindly ask for Power Query Solution to transform the "Transactions Tables" to the desired solution. Please note that the running balance depends on I.D Number.
 | If possible, provide comments on M formula.
 | Desired Solution
 | Name | I.D Number | Date | Bank | Invoice | Reference | Debit | Credit | Balance |  |  | Name | I.D Number | Date | Bank | Invoice | Reference | Debit | Credit | Balance
 | [NAME] | CT 372 | 2025-01-01 00:00:00 |  |  | Balance B/D |  | 100 |  |  |  | [NAME] | CT 372 | 2025-01-01 00:00:00 |  |  | Balance B/D | 0 | 14214.99 | 14214.99
 | [NAME] | CT 372 | 2025-01-05 00:00:00 |  | First Term 003 |  | 11361.944 |  |  |  |  | [NAME] | CT 372 | 2025-01-05 00:00:00 |  | First Term 003 |  | 11361.94 | 0 | 2853.05
 | [NAME] | CT 372 | 2025-01-06 00:00:00 | Cash - US$ |  | 17432 |  | 2841.828 |  |  |  | [NAME] | CT 498 | 2025-01-06 00:00:00 | Cash - US$ |  | 17432 | 0 | 2841.83 | 5694.87
 | [NAME] | CT 372 | 2025-01-08 00:00:00 | Cash - US$ |  | 17437 |  | 8541.456 |  |  |  | [NAME] | CT 372 | 2025-01-08 00:00:00 | Cash - US$ |  | 17437 | 0 | 8541.46 | 14236.33
 | AMBER MEARES | CT 420 | 2025-01-01 00:00:00 |  |  | Balance B/D | 6167.525832670934 |  |  |  |  | AMBER MEARES | CT 420 | 2025-01-01 00:00:00 |  |  | Balance B/D | 6167.53 | 0 | -6167.53
 | AMBER MEARES | CT 420 | 2025-01-05 00:00:00 |  | First Term 004 |  | 11361.944 |  |  |  |  | AMBER MEARES | CT 420 | 2025-01-05 00:00:00 |  | First Term 004 |  | 11361.94 | 0 | -17529.47
 | AMBER MEARES | CT 420 | 2025-01-07 00:00:00 | Cash - US$ |  | 17433 |  | 8534.592 |  |  |  | AMBER MEARES | CT 420 | 2025-01-07 00:00:00 | Cash - US$ |  | 17433 | 0 | 8534.59 | -8994.88
 | AMBER MEARES | CT 420 | 2025-01-08 00:00:00 | Cash - US$ |  | 17438 |  | 8541.456 |  |  |  | AMBER MEARES | CT 420 | 2025-01-08 00:00:00 | Cash - US$ |  | 17438 | 0 | 8541.46 | -453.42
 | BADAR DON | CT 408 | 2025-01-01 00:00:00 |  |  | Balance B/D | 14067.2364226691 |  |  |  |  | BADAR DON | CT 408 | 2025-01-01 00:00:00 |  |  | Balance B/D | 100 | 0 | -100
 | BADAR DON | CT 408 | 2025-01-05 00:00:00 |  | First Term 001 |  | 11361.944 |  |  |  |  | BADAR DON | CT 408 | 2025-01-05 00:00:00 |  | First Term 001 |  | 11361.94 | 0 | -11461.94
 | BADAR DON | CT 408 | 2025-01-06 00:00:00 | Cash - US$ |  | 17431 |  | 8525.484 |  |  |  | BADAR DON | CT 408 | 2025-01-06 00:00:00 | Cash - US$ |  | 17431 | 0 | 8525.48 | -2936.46
 | BADAR DON | CT 408 | 2025-01-08 00:00:00 | Cash - US$ |  | 17436 |  | 5694.304 |  |  |  | BADAR DON | CT 408 | 2025-01-08 00:00:00 | Cash - US$ |  | 17436 | 0 | 5694.3 | 2757.84
Spreadsheet: lisa_gang__22296__ENA_PGE_MAY 15_2002
Sheet: JD-MAL OR CPTJK TRANS

From: | EPMI
To: | PGE System Transactions
Date: | 2002-05-15 00:00:00
Total Transmission
HE
ENDING | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | PGE TRANNY | TOTAL
Pacific Prevailing
Time | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | NOT FOR TOM, ET AL | [NAME] USED
(PPT) |  |  |  |  |  |  | Total In To PGE Trans
0100 |  |  |  |  | 0 | 0
0200 | 0 | 0 | 0 | 0 | 0 | 0
0300 | 0 | 0 | 0 | 0 | 0 | 0
0400 | 0 | 0 | 0 | 0 | 0 | 0
0500 | 0 | 0 | 0 | 0 | 0 | 0
0600 | 0 | 0 | 0 | 0 | 0 | 0
0700 | 25 | 25 | 25 | 25 | 25 | 25
0800 | 25 | 25 | 25 | 25 | 25 | 25
0900 | 25 | 25 | 25 | 25 | 25 | 25
1000 | 25 | 25 | 25 | 25 | 25 | 25
1100 | 25 | 25 | 25 | 25 | 25 | 25
1200 | 25 | 25 | 25 | 25 | 25 | 25
1300 | 25 | 25 | 25 | 25 | 25 | 25
1400 | 25 | 25 | 25 | 25 | 25 | 25
1500 | 25 | 25 | 25 | 25 | 25 | 25
1600 | 25 | 25 | 25 | 25 | 25 | 25
1700 | 25 | 25 | 25 | 25 | 25 | 25
1800 | 25 | 25 | 25 | 25 | 25 | 25
1900 | 25 | 25 | 25 | 25 | 25 | 25
2000 | 25 | 25 | 25 | 25 | 25 | 25
2100 | 25 | 25 | 25 | 25 | 25 | 25
2200 | 25 | 25 | 25 | 25 | 25 | 25
2300 | 0 | 0 | 0 | 0 | 0 | 0
2400 | 0 | 0 | 0 | 0 | 0 | 0
 | BPA(G)24711 | BPA(G)24718 | BPA(G)24727 | BPA(G)24771 | BPA(G)24547 | BPA(G)24547
 | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD | BPA(T)SYS/JD
 | AEP | AEP | AEP | AEP | AEP | AEP
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5 | PGE(T)JD/MAL5
 | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE) | EPMI(PSE)
 | AEP | AEP | AEP | AEP | AEP | AEP
 | CDWR | CDWR | TID | MID | AVISTA | IDAC
 | ISO(T)MALIN/NP15 | ISO(T)MALIN/NP15 | TID(T)CPJK/TRACEY/WESLEY | MID(T)CPJK/TRACEY/WESLEY | TEMU | ISO(T)MALIN/NP15
 | CDWR(L,FS)NP15 (CA) | CDWR(L,FS)NP15 (CA) | TID | MID(L)WESLEY | PPM | IDAC(L,FS)NP15 (CA)
 |  |  | TID(L)WESLEY |  | MIRANT
 |  |  |  |  | DUKE
 |  |  |  |  | MORGAN
 |  |  |  |  | APX
 |  |  |  |  | ISO(T)MALIN/NP15
 |  |  |  |  | APX(L)NP15
Spreadsheet: 121859d1316459671-create-an-underline-equal-to-number-of-characters-in-cell-below-book1_maacmaac
Sheet: Sheet1

Example 1 | Example 2 |  | Desired Result
Annual Sales | Annual Sales |  | Annual Sales
20000 | 20000 |  | 20000
500 | 500 |  | 500
500 | 500 |  | 500
50 | 50 |  | 50
21050 | 21050 |  | 21050
Spreadsheet: 0b04ae08-f476-4353-a076-1b480aa4d90b
Sheet: SF3

protein description | UniProt | UniProtID | SignalP | paralog expressed in rodents?
Ig γ-2 chain C region | [NAME] | IGHG2_HUMAN | N
Ig γ-3 heavy chain | P01860 | IGHG3_HUMAN | N
Ig γ-4 chain C region | P01861 | IGHG4_HUMAN | N
Ig α-2 chain C region | P01877 | IGHA2_HUMAN | N
triosephosphate isomerase | [NAME] | TPIS_PANTR | N
[NAME], aortic smooth muscle | P62736 | ACTA_BOVIN | N
salivary proline-rich protein (clone CP7) | P02812 | [NAME] | Y | y
cysteine-rich secretory protein-3 | [NAME] | CRIS3_HUMAN | Y | y
complement C3 | P01024 | CO3_HUMAN | Y
α−2-HS-glycoprotein | P02765 | FETUA_HUMAN | Y
Ig λ light chain | Q6GMV7 | Q6GMV7_HUMAN | Y
mucin 5B | Q9HC84 | MUC5B_HUMAN | Y
Spreadsheet: richard_ring__31672__PJM_ICAP_Curves_20011015
Sheet: Current_Curves

 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019
Jan | 45 | 42.5 | 39.5 | 37.905 | 36.00974999999999 | 34.20926249999999 | 32.49879937499998 | 30.87385940624998 | 29.33016643593748 | 27.86365811414061 | 50 | 47 | 45 | 43 | 40 | 38 | 36 | 35
Feb | 45 | 42.5 | 39.5 | 49.81348749999999 | 47.32281312499998 | 44.95667246874998 | 42.70883884531248 | 40.57339690304685 | 38.54472705789451 | 36.61749070499978 | 50 | 47 | 45 | 43 | 40 | 38 | 36 | 35
Mar | 45 | 42.5 | 39.5 | 49.81348749999999 | 47.32281312499998 | 44.95667246874998 | 42.70883884531248 | 40.57339690304685 | 38.54472705789451 | 36.61749070499978 | 50 | 47 | 45 | 43 | 40 | 38 | 36 | 35
Apr | 45 | 42.5 | 39.5 | 49.81348749999999 | 47.32281312499998 | 44.95667246874998 | 42.70883884531248 | 40.57339690304685 | 38.54472705789451 | 36.61749070499978 | 50 | 47 | 45 | 43 | 40 | 38 | 36 | 35
May | 45 | 42.5 | 39.5 | 49.81348749999999 | 47.32281312499998 | 44.95667246874998 | 42.70883884531248 | 40.57339690304685 | 38.54472705789451 | 36.61749070499978 | 50 | 47 | 45 | 43 | 40 | 38 | 36 | 35
Jun | 65 | 60.5 | 57.5 | 49.81348749999999 | 47.32281312499998 | 44.95667246874998 | 42.70883884531248 | 40.57339690304685 | 38.54472705789451 | 36.61749070499978 | 61 | 57 | 55 | 52 | 49 | 47 | 44 | 42
Jul | 80 | 75.5 | 72.5 | 67.81836249999999 | 64.427444375 | 61.20607215624999 | 58.14576854843749 | 55.23848012101561 | 52.47655611496483 | 74 | 71 | 67 | 64 | 61 | 58 | 55 | 52 | 49
Aug | 80 | 75.5 | 72.5 | 79.22144999999998 | 75.26037749999998 | 71.49735862499998 | 67.92249069374998 | 64.52636615906248 | 61.30004785110935 | 74 | 71 | 67 | 64 | 61 | 58 | 55 | 52 | 49
Sep | 45 | 42.5 | 39.5 | 79.22144999999998 | 75.26037749999998 | 71.49735862499998 | 67.92249069374998 | 64.52636615906248 | 61.30004785110935 | 40 | 38 | 36 | 34 | 33 | 31 | 29 | 28 | 27
Oct | 45 | 42.5 | 39.5 | 36.00974999999999 | 34.20926249999999 | 32.49879937499998 | 30.87385940624998 | 29.33016643593748 | 27.86365811414061 | 40 | 38 | 36 | 34 | 33 | 31 | 29 | 28 | 27
Nov | 45 | 42.5 | 39.5 | 36.00974999999999 | 34.20926249999999 | 32.49879937499998 | 30.87385940624998 | 29.33016643593748 | 27.86365811414061 | 40 | 38 | 36 | 34 | 33 | 31 | 29 | 28 | 27
Dec | 45 | 42.5 | 39.5 | 36.00974999999999 | 34.20926249999999 | 32.49879937499998 | 30.87385940624998 | 29.33016643593748 | 27.86365811414061 | 40 | 38 | 36 | 34 | 33 | 31 | 29 | 28 | 27
Avg
Plan_Year
Spreadsheet: 730635d1619800321-match-to-3-criteria-the-return-results-30-day-sample
Sheet: 30 Day

ISSUE DATE | CHECK NO. | Last Name | UNIT # | Last 3 SSN | [NAME]
2021-03-01 00:00:00 | 01-573551 | BARRAZA DIAZ | 307 | 958 | [EMAIL]
2021-03-01 00:00:00 | 01-573540 | BELLIS | 245 | 491
2021-03-01 00:00:00 | 01-573537 | BOEHM | 183 | 672
2021-03-10 00:00:00 | 01-602347 | CAMPOS | 228 | 432
2021-03-10 00:00:00 | 01-602444 | CAMPOS LEDEZMA | 500 | 339
2021-03-10 00:00:00 | 01-602410 | DURANT | 325 | 227
2021-03-10 00:00:00 | 01-602333 | FROELICH | 152 | 597
2021-03-01 00:00:00 | 01-569733 | GATES | 212 | 025
2021-03-23 00:00:00 | 01-620743 | GIANNETTA | 223 | 566
2021-03-10 00:00:00 | 01-602448 | GODINEZ | 502 | 338
Spreadsheet: 270461d1381494013-index-match-issue-free-spacev2
Sheet: Sheet1

Chassis |  |  |  |  | Chassis | Body | Free Space |  | Options
Body |  |  |  |  | [NAME] | OL10 | 1500 |  | 30
 |  |  |  |  | [NAME] | OL14 | 2000 |  | 50
Free Space |  |  |  |  | 6x2 | OL21 | 3000 |  | 40
 |  |  |  |  | 6x4 | OL23 | 4000 |  | 50
 |  |  |  |  |  |  |  |  | 70
Spreadsheet: 691651d1597814564-dynamic-range-dropdown-list-on-different-sheet-dropdown-for-excel-forum-sample-file
Sheet: DATA

Computer | Furniture_Fixures | Electrical
Acid Battery 12V*100AH Lead | Bank Sign Board | Air Condition Machine
Acid Batteries 150 AH Lead Maintains | Chairs | ATM (Automated Teller Machine)
CAT 6 D Link | Direcor Name Board | Camera Hikvision Bullet IR
Computers Shifted | [NAME] | Cash Counting Machine
Connectors & Consumabels | Fire Extinguishers | CCTV Camera
Desktop | Wooden Furniture for branch | Connectors & Consumabels
Face Plate | Lockers | Display Board Moving
Installation Charges |  | DVR Hikvision
Installation Charges Rack CAT6 |  | Electricity Fittings
Monitor LENOVO 19" |  | Fans
[NAME] (1 Mtr)
[NAME] (3 Mtrs)
Spreadsheet: 84584d1284635840-print-based-on-what-value-we-need-raw-data
Sheet: FilteredData

 |  |  |  |  |  |  | Okt - Jan 2011
 |  |  | 2010-09-16 17:29:16
 |  |  | Vera Aprilia | 19190 | Itm 2 |  | 820000 | 80000 | 40000 |  | 940000 |  | 1838
 |  |  | Mayco Molitanady | 19191 | B 3 C |  | 820000 | 80000 | 45000 |  | 945000 |  | 1817
 |  |  | Rayhan | 19192 | Test | 50000 |  |  |  |  | 50000
 |  |  | Detriyanti | 19193 | B 5 B |  | 57000 |  | 40000 |  | 97000 | pdmk / Sisa 843.000
 |  |  | Felnando | 19194 | B 3 A | 250000 | 820000 | 80000 | 60000 |  | 1210000 | NS
 |  |  | Alvin | 19195 | B 2 B |  | 820000 | 80000 | 45000 |  | 945000 |  | 2516
 |  |  | [NAME] | 19196 | [NAME] 1 |  | 820000 | 80000 |  |  | 900000 |  | 2037
 |  |  | [NAME] Y | 19197 | B 5 B |  | 420000 | 80000 | 40000 |  | 540000 |  | 1834
 |  |  |  | 19198 |  |  |  |  |  |  | 0 | CANCEL
 |  |  | [NAME] | 19200 | Pre intr 1 |  | 730000 | 80000 | 100000 |  | 910000 |  | 2036
 |  |  | Kiki | 18901 | B 2 A |  | 730000 | 80000 | 60000 |  | 870000 |  | 1800
 |  |  | [NAME] | 18902 | Itm 3 |  | 730000 | 80000 | 40000 |  | 850000 |  | 1929
 |  |  | [NAME] | 18903 | B 4 A | 50000 |  |  |  |  | 50000 | NS
 |  |  | [NAME] | 18904 | B 1 A | 500000 |  |  |  |  | 500000 | NS
 |  |  | [NAME] | 18905 | B 1 A | 500000 |  |  |  |  | 500000 | NS
 |  |  | [NAME] | 18906 | [NAME] 3 | 50000 |  |  |  |  | 50000 | NS
 |  |  | [NAME] | 18908 | Pre intr 3 |  | 820000 | 80000 | 100000 |  | 1000000 |  | 2374
 |  |  | Xecilia Mediana | 18910 | B 3 B |  | 820000 | 80000 | 40000 |  | 940000 |  | 1899
 |  |  | [NAME] | 18911 | B 1 A |  | 420000 | 80000 | 60000 |  | 560000 | KT / Anak Guru
 |  |  | [NAME] | 18912 | test | 50000 |  |  |  |  | 50000
 |  |  |  |  |  | 1450000 | 8827000 | 960000 | 670000 | 0 | 11907000
Spreadsheet: 58306d1258575531-create-a-matrix-book6
Sheet: Sheet1

ID | Score 1-5 | Value (H, M, L)
6.1 | 1 | H
6.2 | 1 | M
6.3 | 1 | L
6.4 | 2 | H
6.5 | 2 | M
6.6 | 2 | L
6.7 | 3 | H
6.8 | 3 | M
6.9 | 3 | L
6.11 | 4 | H
6.12 | 4 | M
6.13 | 4 | L
6.14 | 5 | H
6.15 | 5 | M
6.16 | 5 | L
Spreadsheet: 859750d1708009158-identify-knock-off-orders-test
Sheet: Sheet1

INVOICE | AMOUNT | RESULT
ORDER 1 | -31
ORDER 1 | -20
ORDER 1 | -20
ORDER 1 | 20
ORDER 2 | -27.45
ORDER 2 | -27.45
ORDER 2 | 27.45
ORDER 3 | -87.5
ORDER 3 | -87.5
ORDER 3 | 87.5
ORDER 4 | -20
ORDER 4 | -20
ORDER 4 | 20
Spreadsheet: 775042d1648794786-return-value-if-company-name-doesnt-exactly-match-book11
Sheet: Matix Production

 | Online Travel Agent
RAW REPORT | Revenue |  |  |  | Channel | Returned value
Booking.com (OTA) | 194067717.85 |  |  |  | Agoda
Ctrip (BAR) |  |  |  |  | Booking.com
Ctrip (WHO) |  |  |  |  | Cleartrip
Direct Reservation |  |  |  |  | Ctrip
Expedia Lodging Partner Service (OTA) | 33491831.96 |  |  |  | Expedia
[NAME] (LEI) |  |  |  |  | Goibibo
[NAME] (BAR) |  |  |  |  | Hotelscombined
Hotelbeds (WHO) |  |  |  |  | Makemytrip
[NAME] (GMG) |  |  |  |  | MyTour
Long Stay (PKG) |  |  |  |  | PegiPegi
[NAME] Hotel Reservation (WHO) |  |  |  |  | Tiket.com
PT. [NAME] (BAR) |  |  |  |  | Travelguru
PT. [NAME] (WHO) |  |  |  |  | Traveloka
Tiket.Com (OTA) | 76423939.64 |  |  |  | VnTrip
Travel Tripper (OTD)
Traveloka (OTA) | 25368504.22
Grand Total | 329351993.67
From
01/03/2022 00:00:00
To
31/03/2022 [NAME]
Row by
Company-Agent
Column by
Booking Source
Included Dummy Room
False
Included Comp / House Used
False
Spreadsheet: 876088d1722750367-sorting-between-brackets-rafael1024-detect-characters-in-name-aligw
Sheet: Final Result

Similar to AliGW's method
in column A, it would organize by the first pair of brackets [Area] | Ideally, could expand so it then extracts from the second set of brackets [Zone] | Sorting of names is not important |  | Sorting of names is not important | Sorting of names is not important
Area Sorted | Zone Sorted | Name (Ideal Option) without [Area] and [Zones] |  | Name (2nd Ideal Option) with [Zones] | Name (3rd Ideal Option) with [Area] and [Zones]
Area 1 | DA.1 | C OT - Nurse |  | C OT - Nurse - [DA.1] | [Area 1] - C OT - Nurse - [DA.1]
 |  | C OT - Nurse 1 |  | C OT - Nurse 1 - [DA.1] | [Area 1] - C OT - Nurse 1 - [DA.1]
 | DA.2 | Nurse - Wing |  | Nurse - Wing - [DA.2] | [Area 1] - Nurse - Wing - [DA.2]
 | DA.15 | CB OT - Nurse - Core |  | CB OT - Nurse - Core - [DA.15] | [Area 1] - CB OT - Nurse - Core - [DA.15]
Area 2 | FA.2 | C Partial  Nurse - Core |  | C Partial  Nurse - Core - [FA.2] | [Area 2] - C Partial  Nurse - Core - [FA.2]
 | FA.11 | B Partial - Nurse |  | B Partial - Nurse - [FA.11] | [Area 2] - B Partial - Nurse - [FA.11]
Area 4 | QA.21 | A PM - Nurse |  | A PM - Nurse - [QA.21] | [Area 4] - A PM - Nurse - [QA.21]
Area 5 | DA.1 | Z OT - Nurse |  | Z OT - Nurse - [DA.1] | [Area 5] - Z OT - Nurse - [DA.1]
 | DA.2 | CZ OT - Nurse 1 |  | CZ OT - Nurse 1 - [DA.2] | [Area 5] - CZ OT - Nurse 1 - [DA.2]
 |  | CZ OT - Nurse 2 |  | CZ OT - Nurse 2 - [DA.2] | [Area 5] - CZ OT - Nurse 1 - [DA.2]
 |  | CZ OT - Nurse 3 |  | CZ OT - Nurse 3 - [DA.2] | [Area 5] - CZ OT - Nurse 3 - [DA.2]
 | RA.1 | A Full - Nurse |  | A Full - Nurse - [RA.1] | [Area 5] - A Full - Nurse - [RA.1]
 | ZA.1 | B DTM - Nurse |  | B DTM - Nurse - [ZA.1] | [Area 5] - B DTM - Nurse - [ZA.1]
 |  | [NAME] |  | DTM - Nurse - [ZA.1] | [Area 5] - DTM - Nurse - [ZA.1]
Area 55 |  | A DTM - Nurse |  | A DTM - Nurse - [ZA.1] | [Area 5] - A DTM - Nurse - [ZA.1]
Final Result by hand
Note: I realized during some testing that I can sort the zones more accurately if I convert .1, .2, .3 to .01, .02. 03
Spreadsheet: 266248d1379546109-finding-multiple-values-in-a-data-range-excel_noob_
Sheet: Sheet1

(part #'s | item descriptions | dates | prices | sf | dd | f | sf | sdf | df | sf | sdf | sd | fs | df | sdf | sf | sdf | s | fds | Cust Cont Req | Ship Date | Due Date
1 |  | 2013-08-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
2 |  | 2013-09-19 00:00:00
3 |  | 2013-09-20 00:00:00
4 |  | 2013-09-21 00:00:00
Spreadsheet: 675244d1588210338-problem-using-index-match-with-merged-cells-sample-report
Sheet: Sheet2

YTD March 2020 Actual to Budget Comparison
 | Product 1 |  |  |  |  |  | Product 2
 | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff. | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff.
Total Revenue
Total Expenses
***I WANT THE NUMBERS TO TOTAL SO IT SHOULD LOOK LIKE THIS:
 | Product 1 |  |  |  |  |  | Product 2
 | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff. | Actual | Budget | % of Rev. Act. | % of Rev. [NAME] | $ [NAME]. | % Diff.
Total Revenue
Total Expenses
Spreadsheet: 777039d1650093110-how-to-vlookup-table-array-with-wildcard-condition-lookup
Sheet: Sheet1

Sample Lookup Value | Expected Lookup Value |  |  | Table Array for lookup
 |  |  |  |  | desired |  | Standard | Forcing in the wildcard for at least 1 character
F1-0911_Singapore_HongKong_Bond | 911111.1001 |  |  | F1-0911_*Ho* | [PHONE]
F1-0911_HongKong_Thailand_SubBond | 911111.1002 |  |  | F1-0911_*Th* | [PHONE]
F1-0911_HongKong_Singapore_SubBond | 911111.1003 |  |  | F1-0911_*Si* | [PHONE] | (Not HongKong or Thailand)
F1-0911_Singapore_Cambodia_SubBond | 911111.1004 |  |  | F1-0921_*Ho* | [PHONE]
F1-0921_Singapore_HongKong_Bond | 921111.1005 |  |  | F1-0921_*Th* | [PHONE]
F1-0921_HongKong_Thailand_SubBond | 921111.1006 |  |  | F1-0921_*Si* | [PHONE] | (Not HongKong or Thailand)
F1-0921_Cambodia_Singapore_SubBond | 921111.1007
 |  |  |  | based on the limited sample dataset, the method in column I allows to use 2 letters |  |  | gets previous match due to not forcing in the extra chars | this still requires 2 letters because S on its own will also match SubBond and therefore return the first match
Spreadsheet: 268330d1380567734-how-do-i-calculate-a-sum-in-horizontal-cells-and-display-the-results-vertically-in-a-table-book1
Sheet: Sheet1

Week | Date | Branch1 |  |  | Branch2 |  |  | Branch3 |  |  | Branch4 |  |  | Branch5 |  |  | Branch6 |  |  | Branch7 |  |  | Branch8 |  |  | Branch9 |  |  | Branch10 |  |  | Branch11 |  |  | [NAME] |  |  | Branch13 |  |  | Branch14
Week 1 | 2013-09-02 00:00:00 |  |  | 36 |  |  | 6 |  |  | 5 |  |  | 3 |  |  | 2 |  |  | 1 |  |  | 6 |  |  | 6 |  |  | 8 |  |  | 8 |  |  | 5 |  |  | 13 |  |  | 1 |  |  | 14
Week 2 | 2013-09-09 00:00:00 |  |  | 24 |  |  | 7 |  |  | 15 |  |  | 13 |  |  | 7 |  |  | 0 |  |  | 3 |  |  | 6 |  |  | 0 |  |  | 6 |  |  | 12 |  |  | 3 |  |  | 15 |  |  | 2
Week 3 | 2013-09-16 00:00:00 |  |  | 10 |  |  | 13 |  |  | 4 |  |  | 6 |  |  | 14 |  |  | 12 |  |  | 8 |  |  | 4 |  |  | 1 |  |  | 9 |  |  | 5 |  |  | 15 |  |  | 9 |  |  | 11
Week 4 | 2013-09-23 00:00:00 |  |  | 14 |  |  | 13 |  |  | 4 |  |  | 12 |  |  | 10 |  |  | 1 |  |  | 4 |  |  | 0 |  |  | 5 |  |  | 15 |  |  | 8 |  |  | 9 |  |  | 9 |  |  | 5
Week 5 | 2013-09-30 00:00:00 |  |  | 10 |  |  | 13 |  |  | 11 |  |  | 15 |  |  | 10 |  |  | 5 |  |  | 12 |  |  | 10 |  |  | 12 |  |  | 17 |  |  | 11 |  |  | 11 |  |  | 12 |  |  | 7
 | Total |  |  | 94 | 0 | 0 | 52 | 0 | 0 | 39 | 0 | 0 | 49 | 0 | 0 | 43 | 0 | 0 | 19 | 0 | 0 | 33 | 0 | 0 | 26 | 0 | 0 | 26 | 0 | 0 | 55 | 0 | 0 | 41 | 0 | 0 | 51 | 0 | 0 | 46 | 0 | 0 | 39
Week/Date | 9
Rank | Order | Sales | Total
1 | Branch 1 | 24 ▼ | 94
3 | Branch 2 |  | 52
9 | Branch 3 |  | 39
5 | Branch 4 |  | 49
7 | Branch 5 |  | 43
14 | Branch 6 |  | 19
11 | Branch 7 |  | 33
12 | Branch 8 |  | 26
12 | Branch 9 |  | 26
2 | Branch 10 |  | 55
8 | Branch 11 |  | 41
4 | Branch 12 |  | 51
6 | Branch 13 |  | 46
9 | Branch 14 |  | 39
Spreadsheet: 233747d1367920649-formula-for-advace-filter-data-new
Sheet: Required

 |  |  |  |  | Company | TITLE
 |  |  |  |  | PPL | B
S.No | Cost Centre | GL Code | Amount
 | 22 | 6520 | 20000
 | 22 | 66 | 5000
 | 22 | 77 | 5000
 | 22 | 88 | 5000
Spreadsheet: 93262d1292870856-calculating-sums-in-a-2d-chart-from-a-separate-list-that-has-the-variables-excelforumsample1
Sheet: CF

ISOweek | 2011-Wk1 | 2011-Wk2 | 2011-Wk3 | 2011-Wk4 | 2011-Wk5 | 2011-Wk6 | 2011-Wk7 | 2011-Wk8
Expenses
Rent | 0
Taxes
Gasoline
Office supplies
Parking
Food
Internet
Cell phones
FedEx
Spreadsheet: 750101d1633268437-help-with-formulas-that-will-populate-a-quick-view-of-household-bills-and-payments-rent
Sheet: Monthly Family Budget

 | 2021 Monthly Rent/Utilities
 | Summary | Total Monthly  Cost | Total Actually Paid | Total Remaining Balance
 |  | 505
 | Housing
 | Housing | Rent | Utilities | Total | Payments | Balance |  | Monthly Charges
 | Jan |  |  |  |  |  |  | Lot Rent | 295
 |  |  |  |  |  |  |  | Electric | 135
 | Feb |  |  |  |  |  |  | Gas | 75
 |  |  |  |  |  |  |  | Total monthly
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | [NAME]
 | December
 | Total
 | Payments
 | Month | Date | Cash/Check No. | Amount | Total Amount
 | Jan
 | Feb
 | March
 | April
 | may
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 |  |  | TOTAL
Spreadsheet: 207644d1358522372-want-to-identify-lineup-combinations-and-pick-out-which-lineups-do-the-best-lineup-combination-
Sheet: Sheet1

Starting 5 |  | For | Against |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  | [NAME] |  |  |  |  | Madanly
Madanly |  |  |  |  | Madanly |  |  |  |  | Perkins
Wei |  |  |  |  | Perkins |  |  |  |  | [NAME]
Randolph |  |  |  |  | Randolph |  |  |  |  | Song
Song |  |  |  |  | Song |  |  |  |  | Randolph
9 Min |  | 28 | 23 |  | 28 Min |  | 70 | 55 |  | Kobe
[NAME] |  |  |  |  | [NAME] |  |  |  |  | [NAME]
Madanly |  |  |  |  | Perkins |  |  |  |  | Wei
Wei |  |  |  |  | Madanly |  |  |  |  | Sweet
Randolph |  |  |  |  | Wei |  |  |  |  | Blake
[NAME] |  |  |  |  | Randolph |  |  |  |  | [NAME]
12 Min |  | 36 | 30 |  | 34 Min |  | 91 | 73 |  | Maiwoo
Perkins |  |  |  |  | Perkins
Madanly |  |  |  |  | [NAME]
[NAME] |  |  |  |  | Wei |  |  |  |  | Big Men Combinations
[NAME] |  |  |  |  | Randolph
Song |  |  |  |  | Song |  |  |  |  | [NAME] |  | [NAME] |  | Wei |  | Wei
17 Min |  | 43 | 32 |  | 40 Min |  | 100 | 83 |  | Song |  | Randolph |  | Randolph |  | Song
[NAME] |  |  |  |  | [NAME]
Perkins |  |  |  |  | Perkins |  |  |  |  | Starting 5
[NAME] |  |  |  |  | [NAME]
[NAME] |  |  |  |  | Randolph
Song |  |  |  |  | Song
18 Min |  | 46 | 36 |  | 41 Min |  | 102 | 85
[NAME] |  |  |  |  | [NAME]
Perkins |  |  |  |  | Madanly
[NAME] |  |  |  |  | [NAME] |  |  |  |  | Double Foreiners
Wei |  |  |  |  | Randolph |  |  |  |  | McCants
[NAME] |  |  |  |  | Song |  |  |  |  | Randolph
22 Min |  | 63 | 44 |  | 42 Min |  | 105 | 94
[NAME] |  |  |  |  | [NAME] |  |  |  |  | Three Foreiners
[NAME] |  |  |  |  | Madanly |  |  |  |  | McCants
Perkins |  |  |  |  | Perkins |  |  |  |  | Madanly
Wei |  |  |  |  | Wei |  |  |  |  | Randolph
Song |  |  |  |  | Randolph
 |  |  |  |  | 45 Min |  | 112 | 104
 |  |  |  |  | [NAME]
 |  |  |  |  | Perkins
 |  |  |  |  | Wei
 |  |  |  |  | Randolph
 |  |  |  |  | Song
[NAME] |  | 64 | 48 |  | Final |  | 118 | 110
Spreadsheet: 545945d1509737708-rota-and-date-problems-rota2017
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 2017-01-01 00:00:00
 |  |  |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4
 | Clinician |  | Usual Location |  | Session
 | Rachel |  | SRMC |  | Am |  | Day off | Annual Leave | Annual Leave | Annual Leave | srmc
 |  |  |  |  | Pm
 | [NAME] |  | SRMC |  | Am |  | DAY OFF | SRMC | SRMC
 |  |  |  |  | Pm |  |  | SRMC | BMC
 | Sue |  | SRMC |  | Am
 |  |  |  |  | Pm
 | Nick |  | SRMC |  | Am
 |  |  |  |  | Pm
 | Stuart |  | BMC |  | Am
 |  |  |  |  | Pm
 | Claudia |  | WMC |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm
 |  |  |  |  | Am
 |  |  |  |  | Pm