tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102265d1300227372-random-item-number-equals-correct-price-new-job-template-1
Sheet: Cabinets Detail

ESTIMATE OF WORK
 |  |  |  |  |  |  | Date:
Contractor: | LaMorinda Tile and Stone |  |  | Job Name:
Address: | 2261 Commerce Ave., Suite B |  |  | Address:
City: | Concord, CA 94520 |  |  | City:
Phone: | [PHONE] |  |  | Phone:
Fax : | [PHONE] |  |  | Fax:
[NAME]: | [EMAIL] |  |  | [NAME]:
Detail of Work
Kitchen Cabinets Modular
 | [NAME] and doors
 | Solid maple plywood interiors
 | [NAME]-close slides
 | Pre-finished dovetail maple drawers
 | Standard Adjustable hinges
 | Adjustable shelves
 | Door type: Overlay
 |  | Door Style:
 |  | Drawer 5-piece to match door style
Item | Description of Job |  |  |  |  | Quantity | Price EA | Price
A7TK8 |  |  |  |  |  | 5
J5CM10 |  |  |  |  |  | 6
 |  |  |  |  |  |  | Discount
 |  |  |  |  |  |  | Sub Total
 |  |  |  |  |  |  | Tax
 |  |  |  |  |  |  | Total
Assembly |  |  |  |  |  |  | 15
Installation
 | Mounting all Cabinets
 | Installing all mouldings
 | Installing door pulls
NOTE: | Cabinets do not come with pulls
 |  |  |  |  |  |  | Total:
 | Accepted by:
 | Client |  |  |  |  |  | Date
Spreadsheet: 703626d1605090307-search-box-for-named-ranges-test-case-files
Sheet: CASE1

Issue | CASE1
current status | Resolved
summary | 1
 | 2
 | 3
note
case |  | note | audit week | Resolved date
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
ID NUMBERS |  | [NAME] | [NAME] | DATE
Spreadsheet: 680620d1591114004-identifying-combinations-example-v2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Combination | Combinationcode
 |  |  |  | Combination | Alternative Option |  |  |  | [NAME] | [NAME] | A
 |  | [NAME] | [NAME] | A | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | B
 |  | [NAME] | [NAME] | A | [NAME] | [NAME] |  |  |  | [NAME] | [NAME] | C
 |  | [NAME] | [NAME] | B | [NAME] | [NAME] |  |  |  | [NAME] | D
 |  | [NAME] | [NAME] | B | [NAME] | [NAME]
 |  | [NAME] | [NAME] | C | [NAME] | [NAME]
 |  | [NAME] | [NAME] | D | [NAME]
 |  | [NAME] | [NAME] | D | [NAME]
 |  | [NAME] | [NAME] | B | [NAME] | [NAME]
 |  | Name1 | [NAME] | Combination | CombinationCode
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | [NAME] | [NAME]
 |  | bob | [NAME]
Spreadsheet: 86213d1286236601-add-two-numbers-using-vlookup-careerdayschedule1
Sheet: D1Print

No.
Spreadsheet: 88251d1288121226-sums-with-special-rules-example
Sheet: Sheet1

2 | 0 | 0 | 1
1 | 3 | 3 | 2
2 | 1 | 0 | 1
3 | 3 | 3 | 2
2 | 1 | 1 | 1
2 | 0 | 0 | 1
3 | 1 | 1 | 2
0 | 2 | 1 | 2
2 | 2 | 2 | 1
2 | 3 | 2 | 1
2 | 0 | 0 | 2
2 | 0 | 0 | 2
Adding these columns so that rows 1, 5, 6, 11, and 12 follow the rules:  3=0, 2=1, 1=2, and 0=3.
Sums
18 | 29 | 26 | 19
Spreadsheet: 729320d1619021100-list-multiple-occurrences-and-then-move-one-repeat-name-as-many-times-as-it-exists-example
Sheet: Sheet1

 |  |  |  | Pull In Employees for Location A
 | Data Example |  |  | A |  |  |  | All Locations That Employees at A work at
 | Employee ID # | Location # |  | Employee # |  |  |  | Employee # | Location #
 | 123 | A |  |  |  |  |  | 123 | A
 | 123 | B |  |  |  |  |  | 123 | B
 | 150 | C |  |  |  |  |  | 170 | A
 | 160 | C |  |  |  |  |  | 170 | B
 | 170 | A |  |  |  |  |  | 170 | C
 | 170 | B
 | 170 | C
 | 180 | C
Spreadsheet: 0c139202-03e2-4a8a-ba64-78b4a665daad
Sheet: Sheet1

Table 3--U.S. fiber supply | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Mar. | Apr. | May | May
Item | 2012 | 2012 | 2012 | 2011
 | 1,000 480-lb. [NAME]
Cotton:
Ginnings | 0 | 0 | 0 | 0
Imports since August 1 | 11.3 | 13.9 |  | 6.2
Stocks, beginning | 10633 | 8719 | 7201 | 6447
At mills |  |  |  | 143
Public storage |  |  |  | 4802
CCC stocks | 3016 | 2392 | 1872 | 2749
 | Million pounds
Manmade:
Production | 544.7 | 535.9 | 516.6 | 497.3
Noncellulosic | 544.7 | 544.7 | 531.2 | 497.3
Cellulosic
Total since January 1 | 1477.8 | 2013.7 | 2530.3 | 2607.5
 | Feb. | Mar. | Apr. | Apr.
 | 2012 | 2012 | 2012 | 2011
 | Million pounds
Raw fiber imports: | 140.1 | 161.9 | 163.5 | 165
Noncellulosic | 127.1 | 144.8 | 149.7 | 148.1
Cellulosic | 13 | 17.1 | 13.8 | 16.9
Total since January 1 | 288.6 | 450.5 | 514 | 580.8
 | 1,000 pounds
Wool and mohair:
Raw wool imports, clean | 968.1 | 1018.9 | 880.7 | 681.2
48s-and-finer | 462.1 | 333.5 | 499.8 | 281.6
Not-finer-than-46s | 506 | 685.4 | 380.9 | 399.3
Total since January 1 | 1679.7 | 2698.6 | 3579.3 | 2554
Wool top imports | 268.1 | 243.3 | 214 | 170.2
Total since January 1 | 644.3 | 887.6 | 1101.6 | 1218.3
Mohair imports, clean | 0 | 0 | 0 | 0
Total since January 1 | 0 | 0 | 0 | 2.3
NA = Not available.
Last update:  07/12/12.
Sources: USDA, National Agricultural Statistics Service; USDC,
U.S. Census Bureau; and [NAME].
Spreadsheet: 803758d1667666893-learn-chess-with-excel-how-to-detect-checkmate-learn-chess-with-excel-pw2
Sheet: Rules

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qw | 41
10 |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  | 10 |  |  |  |  | 51 |  |  | 21 |  |  |  |  |  | 1
20 |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  | 20 |  |  |  |  | 61 |  |  | -21 |  |  |  |  |  | 2
30 |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  | -10 |  |  |  |  | 31 |  |  | 19 |  |  |  |  |  | 11
40 |  |  |  |  |  | 44 |  |  |  |  |  |  |  |  | -20 |  |  |  |  | 21 |  |  | -19 |  |  |  |  |  | -9
50 |  |  |  |  |  | 55 |  |  |  |  |  |  |  |  | 1 |  |  |  |  | 42 |  |  | 12 |  |  |  |  |  | -1
60 |  |  |  |  |  | 66 |  |  |  |  |  |  |  |  | -1 |  |  |  |  |  |  |  | -12 |  |  |  |  |  | -2
70 |  |  |  |  |  | 77 |  |  |  |  |  |  |  |  | 11 |  |  |  |  | 52 |  |  | 8 |  |  |  |  |  | -11
-10 |  |  |  |  |  | -11 |  |  |  |  |  |  |  |  | -11 |  |  |  |  |  |  |  | -8 |  |  |  |  |  | 9
-20 |  |  |  |  |  | -22 |  |  |  |  |  |  |  |  | 9
-30 |  |  |  |  |  | -33 |  |  |  |  |  |  |  |  | -9 |  |  |  |  | 32
-40 |  |  |  |  |  | -44 |  |  |  |  |  |  |  |  | 0
-50 |  |  |  |  |  | -55 |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 0
-60 |  |  |  |  |  | -66
-70 |  |  |  |  |  | -77
1 |  |  |  |  |  | 9
2 |  |  |  |  |  | 18
3 |  |  |  |  |  | 27
4 |  |  |  |  |  | 36
5 |  |  |  |  |  | 45
6 |  |  |  |  |  | 54
7 |  |  |  |  |  | 63
-1 |  |  |  |  |  | -9
-2 |  |  |  |  |  | -18
-3 |  |  |  |  |  | -27
-4 |  |  |  |  |  | -36
-5 |  |  |  |  |  | -45
-6 |  |  |  |  |  | -54
-7 |  |  |  |  |  | -63
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52
-20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85
Spreadsheet: 49520d1248881081-number-format-this-prevents-me-from-summing-cells-transaction-samples
Sheet: Sheet1

 | 07/28/2009 | Debit Card Transaction | QT 421 PHOENIX AZ 952803 07/27QT 421 PH | 36.16
 | 07/27/2009 | Debit Card Transaction | ALBERTSONS #967 FLAGSTAF 07/24ALBERTSON | 8.71
 | 07/27/2009 | Debit Card Transaction | SAFEWAY STORE00015347 G 07/23SAFEWAY | 13.92
 | 07/27/2009 | Debit Card Transaction | SEARS AUTO CNTR 6398 MES 07/23SEARS AUT | 31.29
 | 07/23/2009 | Debit Card Transaction | CIRCLE K 09158 MESA AZ 07/20CIRCLE K | 37.92
Spreadsheet: 1d57bbee-8c2a-4122-ad7b-f0ada51a4499
Sheet: MSB Information

Money Services Business Information
Items with an * are critical. To the extent you have other items, please provide.
Please enter either entity name or individual name | Entity
 | Legal name *
 | Alternate name, e.g., DBA
 | Individual
 | Last name *
 | First name *
 | Middle name
 | Alternate name, e.g., AKA
 | Address *
 | City *
 | State *
 | ZIP/Postal Code *
 | Country *
 | TIN *
 | TIN type * | SSN/ITIN | EIN | Foreign
 | Telephone number
 | Extension
 | E-mail address
 | Website address (URL)
 | Letter reference number *
 | Date of most recent agent list *
Owner or Controlling Person Information
If same as above, please check here
Please enter either entity name or individual name | Entity
 | Name
 | Alternate name, e.g., DBA
 | Individual
 | Last name
 | First name
 | Middle name
 | Alternate name, e.g., AKA
 | Address
 | City
 | State
 | ZIP/Postal Code
 | Country
 | TIN
 | TIN type | SSN/ITIN | EIN | Foreign
 | Telephone number
 | Extension
 | E-mail address
 | Website address (URL)
Spreadsheet: 151406d1334895025-indexing-problem-using-multiple-arrays-and-conditions-indexing-problem
Sheet: Sheet1

 | Array 1 |  |  |  |  | [NAME] |  |  | Array 3 |  |  |  | [NAME]
 | 1 | x | a | 1 |  | b | 4 |  | 1 | a | 9 |  | 1 | 3a
 | 1 | x | b | 2 |  | c | 8 |  | 2 | a | 4 |  | 9 | 2
 | 1 | x | b | 3 |  |  |  |  | 4 | b | 8
 | 1 | 0 | b | 4 |  |  |  |  | 5 | b | 10
 | 0.5 | 0 | b | 5 |  |  |  |  | 6 | c | 3
 | 0 | x | a | 6 |  |  |  |  | 7 | c | 1
 | 0 | 0 | c | 7 |  |  |  |  | 3a | d | 2
 | 1 | 0 | c | 8 |  |  |  |  | 3b | b | 7
 | 1 | x | c | 9 |  |  |  |  | 8a | c | 6
 | 1 | x | c | 10 |  |  |  |  | 8b | d | 5
 | 1 | x | a | 11
 | 0 | x | d | 12
 | 0 | 0 | d | 13
Array | When Column B displays a value of >0.9 and Column C a value of 0 |  |  |  |  |  |  |  | Array | When Column B displays a value of "<0.1" and Column C a value of  "<>0"
1 & 2 | Then I want Column D and E to be displayed in Column G and H respectively |  |  |  |  |  |  |  | 1 & 3 | Then I want Array 4 to display  the data from Array 3 (based on the letters) in a horizontal fashion
 |  |  |  |  |  |  |  |  |  | (picking the first value of a,b,c or d it finds from top to bottom)
Spreadsheet: 835054d1688244264-sumifs-with-date-range-drop-down-list-sumifs-with-date-range-criteria-aligw
Sheet: Example

 |  |  | Start |  | End
 |  |  | 2023-06-02 00:00:00 |  | 2023-06-13 00:00:00
 |  |  |  |  |  |  |  | AliGW | date | value
 |  |  |  |  |  |  |  | 2023-06-13 00:00:00 | 06/13/2023 | 0.3927357402135936
 |  |  | [NAME] |  |  |  |  | 2023-06-12 00:00:00 | 06/12/2023 | 0.8159819874901322
 |  |  |  |  |  |  |  | 2023-06-11 00:00:00 | 06/11/2023 | 0.9316392825366333
 |  |  |  |  |  |  |  | 2023-06-10 00:00:00 | 06/10/2023 | 0.9952392035507514
 |  |  |  |  |  |  |  | 2023-06-09 00:00:00 | 06/09/2023 | 0.9557277344383106
 |  |  |  |  |  |  |  | 2023-06-08 00:00:00 | 06/08/2023 | 0.7718942622720579
 |  |  |  |  |  |  |  | 2023-06-07 00:00:00 | 06/07/2023 | 0.5392040973267698
 |  |  |  |  |  |  |  | 2023-06-06 00:00:00 | 06/06/2023 | 0.3171611685587548
 |  |  |  |  |  |  |  | 2023-06-05 00:00:00 | 06/05/2023 | 0.8651161701370582
 |  |  |  |  |  |  |  | 2023-06-04 00:00:00 | 06/04/2023 | 0.1749979155807708
 |  |  |  |  |  |  |  | 2023-06-03 00:00:00 | 06/03/2023 | 0.7924814688130499
 |  |  |  |  |  |  |  | 2023-06-02 00:00:00 | 06/02/2023 | 0.1091165453705072
Spreadsheet: 0f148e2c-0120-4b09-9c70-04628cdf7860
Sheet: Sheet1

Unnamed: 0 | UNITED STATES SENATOR - REPUBLICAN | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2002-09-10 00:00:00
Belknap County | Smith, r | Stremsky, r | [NAME], r | Shaheen, d | [NAME]
Alton | 433 | 13 | 530 | 1
Barnstead | 327 | 19 | 266 | 0
Belmont | 377 | 13 | 414 | 5
Center Harbor | 101 | 3 | 169 | 0
Gilford | 508 | 13 | 895 | 1
Gilmanton | 245 | 13 | 291 | 3
[NAME] | 180 | 10 | 416 | 0
[NAME] | 161 | 6 | 187 | 2
[NAME] 3 | 126 | 4 | 240 | 0
[NAME] | 138 | 2 | 185 | 0
[NAME] | 101 | 4 | 119 | 0
[NAME] 6 | 169 | 4 | 198 | 2
Meredith | 464 | 21 | 701 | 1
New Hampton | 177 | 6 | 157 | 1
Sanbornton | 245 | 7 | 207 | 0
[NAME] | 186 | 8 | 202 | 11
TOTALS | 3938 | 146 | 5177 | 27
 | UNITED STATES SENATOR - REPUBLICAN
Carroll County | Smith, r | Stremsky, r | [NAME], r | Shaheen, d | [NAME]
Albany | 45 | 1 | 49 | 0
[NAME] | 246 | 3 | 328 | 0
[NAME] | 74 | 0 | 97 | 1
Chatham | 24 | 1 | 22 | 0
Conway | 664 | 21 | 539 | 2
Eaton | 34 | 0 | 37 | 1
[NAME] | 90 | 8 | 101 | 0
Freedom | 140 | 8 | 210 | 0
Hale's Location | 39 | 0 | 26 | 0
Hart's Location | 7 | 0 | 6 | 0
[NAME] | 115 | 1 | 167 | 3
[NAME] | 209 | 12 | 171 | 0
Moultonborough | 445 | 17 | 812 | 2
Ossipee | 345 | 22 | 382 | 1
Sandwich | 118 | 10 | 176 | 0
Tamworth | 224 | 8 | 237 | 0
Tuftonboro | 265 | 8 | 420 | 1
Wakefield | 288 | 17 | 432 | 0
Wolfeboro | 586 | 21 | 1071 | 0
TOTALS | 3958 | 158 | 5283 | 11
Spreadsheet: 117286d1312622016-excel-2007-vlookup-last-data-entries-book1vlookup
Sheet: Data

ARCHIVE
Date | Qty | Ref
2011-08-05 00:00:00 | 110000 | B1
 |  | A
 |  | B2
 |  | A
 |  | B3
 |  | A
 |  | B4
 |  | A
 |  | B5
 |  | A
 |  | B6
 |  | A
 |  | B7
 |  | A
 |  | B8
 |  | A
 |  | B9
 |  | A
 |  | B10
 |  | A
 |  | B11
 |  | A
 |  | B12
 |  | A
 |  | B1
 |  | A
 |  | B2
 |  | A
 |  | B3
 |  | A
Spreadsheet: michelle_lokay__26699__imball0112
Sheet: Citizens

Citizens Communications
 | Measured | Scheduled | Imbalance
56659 |  | -378
500046 | -566 | -210 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500086 |  |  |  |  |  |  |  |  |  |  | lunch | 7.6
500134 | -2339 | -1950
500528
500529
500619
INDEX
2001-11-30 00:00:00 |  |  | -511336.62
2001-12-03 00:00:00
CBS Volume
 |  |  | -25128
Spreadsheet: 2ddc18c7-0e6d-443d-85e7-7f257ec28fec
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259958 | 50772 | [NAME] | Hopkins | CAN | 210 | 00:16:13 | 00:03:00 | 00:43:22 | 00:02:15 | 00:18:24 | 1 | 01:23:13
259958 | 75881 | Eleni | [NAME] | GBR | 208 | 00:09:59 | 00:02:21 | 00:43:27 | 00:02:18 | [NAME] | 2 | 01:24:06
259958 | 25144 | [NAME] | Price | USA | 207 | 00:18:39 | 00:04:25 | 00:47:07 | 00:03:04 | 00:31:50 | 3 | 01:45:04
259958 | 74776 | Debbie | Wendt | AUS | 209 | 00:21:44 | 00:03:53 | 00:50:19 | 00:02:54 | 00:28:43 | 4 | [NAME]
Spreadsheet: 852369d1702426570-oldest-and-newest-date-base-on-criteria-min-and-max-date-based-on-criteria
Sheet: Sheet1

Data |  |  |  |  |  | Looking for
Date | Company | Open/Closed |  |  | Company | Oldest Date of Company that is Open | Most Recent Date of Company that is Closed |  | Reference
 | D | Open |  |  |  |  |  |  | Open
 | A | Closed |  |  | A |  |  |  | Closed
 | B | Open |  |  | B
 | B | Closed |  |  | C
 | C | Open
 | C | Closed
 | D | Open
 | D | Closed
 | A | Open
 | A | Closed
 | B | Open
 | B | Closed
 | C | Open
 | C | Closed
 | D | Open
 | D | Closed
 | A | Open
 | A | Closed
 | B | Open
 | B | Closed
 | C | Open
 | C | Closed
 | D | Open
 | D | Closed
 | A | Open
 | A | Closed
 | B | Open
 | B | Closed
 | C | Open
 | C | Closed
Spreadsheet: 810501d1671812077-looking-for-a-better-way-than-vlookup-when-same-value-is-shown-twice-2022-12-23-better-way-to-match-vendors-with-invoices-that-are-the-same-for-both-vendors
Sheet: Sheet1

DATA I am tracking |  |  |  |  |  |  | DATA from AP
Vendor | INV | Amt | Pmt Status
BURGER KING | 13936 | 3053.18 |  |  |  |  | BURGER KING | 13936 | 3053.18
BURGER KING | 13960 | 537.5 | 537.5 |  |  |  | BURGER KING | 13960 | 537.5
BURGER KING | 14191 | 7110.85 | 7110.85 |  |  |  | BURGER KING | 14191 | 7110.85
BURGER KING | 14385 | 3598.58 | 3598.58 |  |  |  | BURGER KING | 14385 | 3598.58
BURGER KING | 14459 | 1550 | 1550 |  |  |  | BURGER KING | 14459 | 1550
BURGER KING | 15068 | 7830.05 | Not Paid |  |  |  | DQ | 15068 | 7830.05
BURGER KING | 15118 | 1905 | Not Paid |  |  |  | DQ | 15118 | 1905
BURGER KING | 15132 | 1942.04 | Not Paid |  |  |  | DQ | 15132 | 1942.04
BURGER KING | 15144 | 2038.75 | Not Paid |  |  |  | DQ | 15144 | 2038.75
BURGER KING | 15257 | 4301 | Not Paid |  |  |  | DQ | 15257 | 4301
BURGER KING | 15260 | 2965 | Not Paid |  |  |  | DQ | 15260 | 2965
BURGER KING | 15262 | 4839.03 | Not Paid |  |  |  | DQ | 15262 | 4839.03
TACO BELL | 15118 | 1905 | 1905 |  |  |  | TACO BELL | 15118 | 1905
TACO BELL | 15132 | 1942.04 | 1942.04 |  |  |  | TACO BELL | 15132 | 1942.04
TACO BELL | 15144 | 2038.75 | 2038.75 |  |  |  | TACO BELL | 15144 | 2038.75
TACO BELL | 15257 | 4301 | 4301 |  |  |  | TACO BELL | 15257 | 4301
TACO BELL | 15260 | 2965 | 2965 |  |  |  | TACO BELL | 15260 | 2965
TACO BELL | 15262 | 4839.03 | Not Paid |  |  |  | SHONEYS | 15262 | 4839.03
TACO BELL | 15740 | 20107 | Not Paid |  |  |  | SHONEYS | 15740 | 20107
TACO BELL | 15743 | 12929 | Not Paid |  |  |  | SHONEYS | 15743 | 12929
TACO BELL | 15886 | 859.58 | Not Paid |  |  |  | SHONEYS | 15886 | 859.58
Spreadsheet: 791441d1660338314-xlookup-find-sub-categories-and-label-with-main-category-in-new-column-2022-08-12-oeldere-capxsaicin-excel-forum-example-2-
Sheet: Sheet1

Date | Description | Institution | Account | Category | Main Category | Is Hidden | Is Pending | Amount
2022-07-19 00:00:00 | APLPAY |  |  |  |  | No | No | -10
2022-07-19 00:00:00 | DELTA AIR LINES ATLANTA |  |  |  |  | No | No | -11.2
2022-07-19 00:00:00 | [NAME] |  |  |  |  | No | No | -74.03
2022-07-19 00:00:00 | SPEEDWAY |  |  |  |  | No | No | -38.66
2022-07-19 00:00:00 | UBER TRIP SAN FRANCISCO CA |  |  |  |  | No | No | -33.56
2022-07-19 00:00:00 | GREENLIGHT DES APP ID GREENLIGHT LONG CO WEB |  |  |  |  | No | No | -10
2022-07-18 00:00:00 | VENMO DES PAYMENT LONG CO WEB |  |  |  |  | No | No | -100
2022-07-18 00:00:00 | CHECKCARD APPLE.COM BILL CA RECURRING |  |  |  |  | No | No | -0.99
2022-07-18 00:00:00 | MICROSOFT XBOX MSBILL.INFO |  |  |  |  | No | No | -1.08
2022-07-17 00:00:00 | STAGE HOUSE TAVERN SCOTCH PLAIN |  |  |  |  | No | No | -171.6
2022-07-17 00:00:00 | STAGE HOUSE TAVERN SCOTCH PLANT |  |  |  |  | No | No | -171.6
2022-07-17 00:00:00 | STAGE HOUSE PUB SCOTCH PLAIN |  |  |  |  | No | No | -1
2022-07-17 00:00:00 | STAGE HOUSE TAVERN SCOTCH PLAIN |  |  |  |  | No | No | -2
2022-07-17 00:00:00 | STAGE HOUSE TAVERN SCOTCH PLAIN |  |  |  |  | No | No | -3
2022-07-17 00:00:00 | STAGE HOUSE TAVERN SCOTCH PLAIN |  |  |  |  | No | No | -4
2022-07-17 00:00:00 | STAGE HOUSE TAVERN SCOTCH PLAIN |  |  |  |  | No | No | -5
Spreadsheet: 839603d1692108815-how-to-concatenate-and-show-ranking-formulas-ranking-example
Sheet: Sheet1

Name 1 | [NAME] | Address | Phone No | Visits
Elvis | Presley | 2 West Street | 55987 | 23
[NAME] | [NAME] | 15 West Street | 16579 | 18 |  |  | Rank 2 = [NAME]
Clint | Eastwood | 2 North Row | 78945 | 4 |  |  | Rank 3 = [NAME] 55
[NAME] | Wayne | 54 East Avenue | 22265 | 66 |  |  | Rank 4 = [NAME] 23
Elvis | Presley | 2 West Street | 55987 | 15 |  |  | Rank 5 = [NAME] 18
[NAME] | [NAME] | 15 West Street | 16579 | 9 |  |  | Rank 6 = [NAME] 15
Clint | Eastwood | 2 North Row | 78945 | 1 |  |  | Rank 7 = [NAME] 13
[NAME] | Wayne | 54 East Avenue | 22265 | 77 |  |  | Rank 8 = Elton John 9
Elvis | Presley | 2 West Street | 55987 | 8 |  |  | Rank 9 = Elvis  Presley 8
[NAME] | [NAME] | 15 West Street | 16579 | 1 |  |  | Rank 10 = [NAME]
Clint | Eastwood | 2 North Row | 78945 | 13 |  |  | Rank 11 = [NAME]
[NAME] | Wayne | 54 East Avenue | 22265 | 55 |  |  | Rank 11 = [NAME] John 1
Spreadsheet: 52899d1252732033-help-with-spreadsheet-design-if-then-or-vlookup-with-mulitple-scenarios-qty-pricing
Sheet: Sheet1

Item# | SKU 1 | SKU 2 | Description | Color | Size | Price Level | Qty Reqd | Price
1 | 1-1 | 1-1 | Widget | Red | Large | 1 | 1 | 100
1 | 1-2 | 1-10 | Widget | Red | Large | 2 | 10 | 95
1 | 1-3 | 1-25 | Widget | Red | Large | 3 | 25 | 90
1 | 1-4 | 1-50 | Widget | Red | Large | 4 | 50 | 80
1 | 1-5 | 1-100 | Widget | Red | Large | 5 | 100 | 75
1 | 1-6 | 1-200 | Widget | Red | Large | 6 | 200 | 60
2 | 2-1 | 2-1 | Whatsit | Blue | Small | 1 | 1 | 80
2 | 2-2 | 2-10 | Whatsit | Blue | Small | 2 | 10 | 78
2 | 2-3 | 2-25 | Whatsit | Blue | Small | 3 | 25 | 72
2 | 2-4 | 2-50 | Whatsit | Blue | Small | 4 | 50 | 64
2 | 2-5 | 2-100 | Whatsit | Blue | Small | 5 | 100 | 60
2 | 2-6 | 2-200 | Whatsit | Blue | Small | 6 | 200 | 48
 |  |  |  | Type Item # | Type Qty | Excel Returns Price
 |  |  |  | 1-100 | 105 | 75
 |  |  | Color Code |  | user eters
 |  |  |  |  | excel retuned answer
Spreadsheet: 813312d1673656476-bring-multiple-cells-into-one-based-on-a-match-names-and-model-numbers
Sheet: Sheet1

Name | Model Number | Sub type | Type | Generate here
Adam | 855 | 1
[NAME] | 855 | 3
Yolanda | 855 | 6 | Primary | [NAME], [NAME], Yolanda | Is there a formula that can collect these names from column A based on a match in Column B?
[NAME] | 890 | 1
[NAME] | 891 | 4 | Primary | [NAME], Carety, Victoria | Model 891 is in Row 6, 7 and 8, but names go in Row 6, because of the 'Primary' designation
[NAME] | 891 | 55
Victoria | 891 | 70
Shane | 905 | 9
[NAME] | 907 | 10
Kimberly | 912 | 14
[NAME] | 934 | 2
[NAME] | 934 | 3
[NAME] | 934 | 7 | Primary | [NAME], [NAME], [NAME], [NAME], Mario
[NAME] | 934 | 8
Mario | 934 | 17
[NAME] | 987 | 21
[NAME] | 988 | 20
Zachary | 988 | 25 | Primary | Colin, [NAME]
Xavier | 989 | 29
Spreadsheet: 132573d1323821321-pdf-text-to-excel-spreadsheet-travelleisure
Sheet: Page_3

 |  |  |  | Media Outlet Results
Outlet Name | Outlet City | Outlet State | Outlet Type  Outlet Website |  |  | Outlet E-mail |  | Outlet Phone Number Outlet Circulation Keyword Outlet Source  AudienceRelevance
Pleasant Hawaii | Honolulu | HI | [NAME] |  | http://www.t | editor@this |  | (808) 843-6000 | 54,000 | 41 | S
Magazine |  |  | zine, |  | hisweekma | week.com
 |  |  | consu |  | gazines.co
 |  |  | [NAME] |  | m/staff.html
Lodging | Cleveland | OH | [NAME] |  | http://www.l |  |  | (216) 696-7000 | 52,154 | 49 | S
Hospitality |  |  | zine, |  | honline.com
 |  |  | trade/
 |  |  | indust
 |  |  | ry
Florida | Tallahassee | FL | [NAME] |  | http://restau | submit@flor |  | (850) 907-8244 | 51,000 | 50 | S
Restaurant and |  |  | zine, |  | rantandlodgi | idarestaurat
Lodging |  |  | trade/ |  | ng.com/ | uer.com
 |  |  | indust
 |  |  | ry
Spotlight's Big | Honolulu | HI | [NAME] |  | http://www.s | editor@spot |  | (808) 593-9404 | 50,000 | 54 | S
Island Gold |  |  | zine, |  | potlighthaw | lighthawaii.c
 |  |  | consu |  | aii.com/bigis | om
 |  |  | [NAME] |  | legold/index
 |  |  |  |  | .asp
Ocean Home | Andover | MA | [NAME] |  | [NAME] | ssmall@rms |  | (978) 623-8020 | 49,671 | 5 | S
 |  |  | zine, |  | ceanhomem | mediagroup
 |  |  | consu |  | ag.com | .com
 |  |  | [NAME]
Hotel | Cleveland | OH | [NAME] |  | http://www.h |  |  | (800) 669-1668 | 46,409 | 43 | S
Management |  |  | zine, |  | otelworldnet
 |  |  | trade/ |  | work.com
 |  |  | indust
 |  |  | ry
Hotel Business | East Setauket | NY | [NAME] |  | http://www.h | info@hotelb |  | (631) 246-9300 | 40,500 | 45 | S
 |  |  | zine, |  | otelbusines | usiness.co
 |  |  | trade/ |  | s.com | m
 |  |  | indust
 |  |  | ry
Page: 3 |  |  |  |  |  |  |  |  |  |  | 12/13/2011
Spreadsheet: 798553d1664551012-sumproduct-countif-hitting-divide-by-zero-error-due-to-empty-cells-sumproduct-divzero-example-1-
Sheet: Sheet1

STATUS | ID |  | TOTAL COMPLETE
DONE | 1
DONE | 2
DONE | 3
DONE | 2
DONE | 4
DONE | 6
IN PROGRESS | 1
DONE | 7
N/A | 1
DONE | 5
Spreadsheet: 723519d1615747869-o365-match-does-not-recognise-exact-matches-example-2-gk-
Sheet: Sheet1

 |  | Reference table - will remain static as a reference with no formulas
 |  | YJL | AC
 |  | IP, AC | NK, PS, IM
 |  | AM | AM
 |  | CD, BD, MA, IM | RPe (1-2pm), MA, IP (until 3pm)
 |  | NK | BD
 |  | CD
 |  | PS | RPe
 |  | US MSK - PS
 |  |  | JHi
 |  | NKa | NKa
 |  | NA, JMcC, RP, JB | JB
 |  |  |  |  |  |  | YJL