tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 84553d1284597876-excel-2007-find-unique-item-count-and-percentage-w-pivot-table-pivot_example
Sheet: Sheet1

 |  |  | M | T | W | T | F
NAME | ROLE | HOURS | 09/13 | 09/14 | 09/15 | 09/16 | 09/17
[NAME] | [NAME] | 8 | 1 | 1 | 1 | 1 | 1
[NAME] | [NAME] | 8 | 8 | 8 | 8 | 8 | 8
[NAME] | [NAME] | 8 | 4 | 4 | 4 | 4 | 4
[NAME] | AD | 8
[NAME] | AD | 8 | 4 | 4 | 4 | 4 | 4
[NAME] | AD | 8 | 4 |  |  | 8 | 8
[NAME] | Designer | 8
[NAME] | [NAME] | 8
[NAME] | Designer | 8 |  | 8 | 8
Sue | AD | 8 | 4 | 4 | 4 | 4 | 4
Spreadsheet: 474051d1470595815-ocean-tides-calculator-copy-of-tide-calculation_test-1
Sheet: Tide Calculation (2)

A Day of Tides
Location: |  |  | Input Tide data
Latitude Longitude:
 |  | Date | Military Time | Tide (High or Low) | Tide level (ft)
 |  | 2016-08-13 00:00:00 | 05:14:00 | High | 2.07 |  | 0
 |  | 2016-08-13 00:00:00 | 12:10:00 | Low | 0.41
 |  | 2016-08-13 00:00:00 | 18:06:00 | High | 2.18
 |  | 2016-08-14 00:00:00 | 1900-01-01 00:40:00 | Low | 0.75
 |  | Mean High Tide
 |  | Mean Low Tide
 |  | Mean Tide Level
Current Date and Time
High Tide Table |  |  |  | Low Tide Table
Spreadsheet: 856383d1705639454-require-formula-to-search-multiple-keywords-with-a-match-outputing-the-associated-category-banking-for-help-forum
Sheet: for help forum

Transactions | Category |  | Keywords | Keywords | Keywords | Keywords | Keywords | Keywords | Keywords | Keywords | Keywords | Keywords | Transaction Type
Direct Debit QBE Insurance |  |  | woolworths | coles |  |  |  |  |  |  |  |  | Groceries
BWS LIQUOR 5029 GLENELG AU AUS Card xx7405 Value Date: 06/04/2023 | Liquor |  | [NAME] | bws |  |  |  |  |  |  |  |  | Liquor
WOOLWORTHS 5798 BRIGHTON AU AUS Card xx7405 Value Date: 06/04/2023 | Groceries |  | dominos |  |  |  |  |  |  |  |  |  | Eat Out / takeaway
JUST THE THING PRE-L BEVERLEY SA AUS Card xx7405 Value Date: 06/04/2023 |  |  | wdl atm |  |  |  |  |  |  |  |  |  | Cash withdrawal
LEISURELY COFFEE ADELAIDE SA AUS Card xx7405 Value Date: 06/04/2023 |  |  | direct debit | giff gaff | zurich | APPLE.COM/BILL | netflix | alinta energy | gas | electric | water | more telecom | Utilities
Prince [NAME] Fulham Garden AU AUS Card xx7405 Value Date: 06/04/2023 | pub |  | Packham Property Management |  |  |  |  |  |  |  |  |  | Rent
5 STAR BARBER AND HA GLENELG SA AUS Card xx7405 Value Date: 06/04/2023 |  |  | upark | metrolink |  |  |  |  |  |  |  |  | Parking / travel
CARIFY VEHICLE HISTORY LIDCOMBE NS AUS Card xx7405 Value Date: 08/04/2023 |  |  | OTR | amphol | BP |  |  |  |  |  |  |  | Petrol
BOUNCE HOLDINGS AUSTRA GLEN IRIS AUS Card xx7405 Value Date: 09/04/2023 |  |  | super cheap | battery world | tyres | garage | car wash |  |  |  |  |  | Cars
BRIGHTON JETTY BAKER BRIGHTON SA AUS Card xx7306 Value Date: 10/04/2023 |  |  | [NAME] |  |  |  |  |  |  |  |  |  | pub
COLES 0458 OAKLANDS PARKAU | Groceries |  | [NAME] |  |  |  |  |  |  |  |  |  | salary
LEISURELY COFFEE ADELAIDE AU |  |  | target | cotton on | amazon | rebel | hair | nails | sportsgirl | bunnings | anaconda | kmart | shopping
ADELAIDE METRO ADELAIDE AUS Card xx7405 Value Date: 11/04/2023 |  |  | boxing room | body fit | f45 |  |  |  |  |  |  |  | gym
BWS LIQUOR 5029 GLENELG AU AUS Card xx7306 Value Date: 11/04/2023 | Liquor
WOOLWORTHS 5311 GLENELG AU AUS Card xx7306 Value Date: 11/04/2023 | Groceries
Dominos Estore Glenelg dominos.com.a AU AUS Card xx7306 Value Date: 11/04/2023 | Eat Out / takeaway
KMART 1005 KURRALTA PARK AU AUS Card xx7306 Value Date: 11/04/2023 | shopping
KMART 1151 OAKLANDS PARK AU AUS Card xx7306 Value Date: 11/04/2023 | shopping
Royal Copenhagen BRIGHTON AU
[NAME] | salary
WOOLWORTHS 5798 BRIGHTON AU AUS Card xx7306 Value Date: 12/04/2023 | Groceries
ZLR*Burgertec Torrensvi Torrensville AU
SQ *BLUE BIRD BAKERY Brighton AU
Spreadsheet: 62829d1263836345-is-this-type-of-copy-even-possible-test4-1-
Sheet: ADM

Sub | SOP Name | Identifier | Responsible | Due Date | Authored | Approved | Submitted
ADM | Test | Test | [NAME] | 2010-01-20 00:00:00 | X
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA2 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA3 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA4 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA5 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA6 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA7 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA8 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA9 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA10 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA11 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA12 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA14 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA15 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA16 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA17 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA18 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA19 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA20 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA21 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA22 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA23 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA24 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA25 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA26 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA28 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA29 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA30 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA31 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA32 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
DATA34 | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
[NAME] | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH | SMTH
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 14-Pz-Po

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi lirimin nga pagesa e semestrit për [NAME] 2010/2011
 | [NAME] 2010/2011 lirohen nga pagesa e semestrit këta studentë nga
 | Fakulteti i Edukimit Prizren
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria
1 | [NAME] | Prizren | Asistencë sociale
2 | Frashër Dalip Behra | [NAME] | Prindi i vrarë
3 | [NAME] | [NAME] | Prindi i vrarë
VËREJTJE:
Studentët e liruar në bazë të këtij [NAME] të paraqiten në shërbimin financiar të fakultetit gjegjës për të bërë kërkesë për [NAME] e mjeteve të paguara për semester.
 |  | K O M I S I O N I:
 |  | Prof.Dr.[NAME],kryetar              ________________
 |  | [NAME], anëtar                           ________________
 |  | [NAME], anëtar                         ________________
 |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: 849734d1700140636-formula-to-count-personnel-rotations-schedule-test
Sheet: Sheet1

 | Base principle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expexted result
 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0
Manually counted |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | Nice to have
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expexted result
 | 0 | 0 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 4 | 4 | 3 | 3 | 0 | 0 | 1 | 0 | 0
Manually counted |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
Spreadsheet: 123689d1317810058-excel-2007-conditional-formatting-based-on-changing-benchmark-sample-conditional-format
Sheet: Sheet1

Number of Articles That Should Be Completed | [NAME] articles complete | [NAME] articles complete
0 | 1 | 0
2 | 2 | 2
4 | 3 | 4
6 | 5 | 7
8 | 6 | 7
10 | 8 | 9
 | (manually color coded)
Spreadsheet: 834796d1688081205-locate-and-copy-tables-tms-v1
Sheet: Sheet3 Compare

 | 4 | 0 | Arsenal | 1 | 1 | 0 | 0 | 2 | 1 | 1 | 3 | W--- | 1 | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 15 | 0 | Leicester City | 1 | 0 | 0 | 1 | 1 | 2 | -1 | 0 | L--- | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 1 | 2 | 0
 | 17 | 0 | Newcastle United | 1 | 0 | 0 | 1 | 0 | 1 | -1 | 0 | L--- | 1 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 8 | 0 | [NAME] | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 3 | W--- | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0
 | 6 | 10 | [NAME] | 2 | 1 | 0 | 1 | 3 | 2 | 1 | 3 | WL-- | 1 | 1 | 0 | 0 | 3 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 0 |  |  | 19 | -2 | Newcastle United | 2 | 0 | 0 | 2 | 1 | 4 | -3 | 0 | LL-- | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 3 | 0
 | 15 | -3 | Derby County | 2 | 0 | 1 | 1 | 1 | 2 | -1 | 1 | LO-- | 1 | 0 | 0 | 1 | 1 | 2 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |  |  | 2 | 2 | Arsenal | 2 | 2 | 0 | 0 | 4 | 2 | 2 | 6 | WW-- | 1 | 1 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 0 | 2 | 1 | 0
 | 10 | -2 | Bradford City | 2 | 1 | 1 | 0 | 2 | 1 | 1 | 4 | XW-- | 1 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 |  |  | 19 | 1 | Sheffield Wednesday | 3 | 0 | 1 | 2 | 2 | 7 | -5 | 1 | XLL- | 1 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 1 | 1 | 1 | 5 | 0
 | 13 | = | Sunderland | 3 | 1 | 1 | 1 | 2 | 4 | -2 | 4 | OWL- | 2 | 1 | 1 | 0 | 2 | 0 | 1 | 0 | 0 | 1 | 0 | 4 | 0 |  |  | 3 | -1 | Arsenal | 3 | 2 | 1 | 0 | 4 | 2 | 2 | 7 | OWW- | 1 | 1 | 0 | 0 | 2 | 1 | 2 | 1 | 1 | 0 | 2 | 1 | 0
Spreadsheet: 83667d1283673073-find-which-row-best-matches-the-criteria-book1
Sheet: Sheet1

 | Item1 | Item2 | Item3 | Item4
Row1 | A | B | C | D
Row2 | B | B | A | C | 1
Row3 | A | C | B | B | 1
Row4 | A | B | C | A | 3
Row5 | C | D | B | C | 0
Row6 | B | C | C | C | 1
Row7 | A | D | D | D | 2
Row8 | A | A | A | C | 1
Row9 | D | B | B | B | 1
Row10 | D | B | C | D | 3
Row11 | D | C | C | C | 1
Row12 | D | B | C | B | 2
Row13 | C | C | B | A | 0
[NAME] | B | C | D | A | 0
Row15 | B | C | D | D | 1
Row16 | D | A | C | A | 1
Row17 | B | D | D | C | 0
Spreadsheet: 810186d1671591520-need-formula-to-categorize-shift-from-start-and-end-date-and-time-shift_trax
Sheet: Sheet1

Emp | Start Time | End Time | Expected Result
Zohib Islam Amiri | 2022-12-14 10:00:00 | 2022-12-14 23:00:00 | AfterN Shift
[NAME] | 2022-12-12 11:00:00 | 2022-12-12 15:00:00 | -
[NAME] | 2022-12-10 11:00:00 | 2022-12-10 14:00:00 | -
Ovays Azizi | 2022-01-11 22:00:00 | 2022-02-11 06:00:00 | Night Shift
[NAME] | 2022-01-11 22:00:00 | 2022-02-11 06:00:00 | Night Shift
Omid Popalzay | 2022-01-11 22:00:00 | 2022-02-11 06:00:00 | Night Shift
Zubayr Amiri | 2022-08-12 10:00:00 | 2022-08-12 23:00:00 | AfterN Shift
Norlla Amiri | 2022-12-17 22:00:00 | 2022-12-17 17:00:00 | [NAME]
[NAME] | 2022-12-17 22:00:00 | 2022-12-17 17:00:00 | [NAME]
[NAME] | 2022-12-19 11:30:00 | 2022-12-19 22:00:00 | -
Lucas Neill | 2022-12-19 10:00:00 | 2022-12-19 21:00:00 | AfterN Shift
[NAME] | 2022-12-21 10:00:00 | 2022-12-21 22:00:00 | AfterN Shift
Spreadsheet: 701420d1603748876-formula-to-compare-tables-and-flag-rows-that-have-been-updated-customer-list-abell-
Sheet: Old Table

ADDRESS_NO | Account_ID | ADDRESS_TYPE | CUSTOMER | [NAME] | ADDRESS_2 | CITY | PROVINCE | POST_CODE | [NAME] | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | _REP_NAME | AIAC01 | AIAC05 | AIAC08 | ABAC04/L01 | DRDL01 | [NAME]
1 | End | End | Customer 1 | 1212 second street |  | Toronto | ON | L1L 1L1 | 2892222222 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | 20 | 20 | 20 | 20 | 20 | 20
2 | End | End | Customer 2 | 1225 third street |  | Toronto | ON | L1L 1L1 | 2892222222 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | Rep 1 | 20 | 20 | 20 | 20 | 20 | 20
Spreadsheet: 63d237ab-4613-4d6e-8b43-263ac942a26d
Sheet: Sheet1

Release: Construction Spending | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=229
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-09-01 1:32 PM CDT
 | Real-Time | Period
Name: | Start | End
Construction Spending | 2011-07-01 00:00:00 | Current
Link:
http://www.census.gov/construction/c30/c30index.html | 2011-07-01 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2011-07-01 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2011-07-01 00:00:00
2011-08-01 00:00:00
2011-09-01 00:00:00
2011-10-03 00:00:00
2011-11-01 00:00:00
2011-12-01 00:00:00
2012-01-03 00:00:00
2012-02-01 00:00:00
2012-03-01 00:00:00
2012-04-02 00:00:00
2012-05-01 00:00:00
2012-06-01 00:00:00
2012-07-02 00:00:00
2012-08-01 00:00:00
2012-09-04 00:00:00
2012-10-01 00:00:00
2012-11-01 00:00:00
2012-12-03 00:00:00
2013-01-02 00:00:00
2013-02-01 00:00:00
2013-03-01 00:00:00
2013-04-01 00:00:00
2013-05-01 00:00:00
2013-06-03 00:00:00
2013-07-01 00:00:00
2013-08-01 00:00:00
2013-09-03 00:00:00
2013-10-22 00:00:00
2013-12-02 00:00:00
2014-01-02 00:00:00
2014-02-03 00:00:00
2014-03-03 00:00:00
2014-04-01 00:00:00
2014-05-01 00:00:00
2014-06-02 00:00:00
2014-07-01 00:00:00
2014-08-01 00:00:00
Spreadsheet: 181763d1348146770-horizontal-search-horizontal-search-almost
Sheet: Blad1

 |  | 1000 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
last value, row 6 from C6 till W6 and 0 don't count so the number i want to get is 950
Spreadsheet: 155953d1337113323-formula-for-counting-filtered-matrixed-data-please-matrixed-data-sample
Sheet: Sheet1

ITEM | QTY | COLOR | BOX A | BOX B | BOX C | BOX D
BOLT 1 | 1 | GREEN | X
BOLT 2 | 2 | YELLOW | X
BOLT 3 | 3 | WHITE |  |  |  | X
BOLT 4 | 1 | WHITE | X
BOLT 5 | 0 | GREEN |  | X
BOLT 6 | 2 | GREEN |  |  |  | X
BOLT 7 | 3 | YELLOW |  |  | X
NUT 1 | 3 | WHITE |  | X
NUT 2 | 0 | GREEN |  |  | X
NUT 3 | 1 | GREEN |  |  | X
NUT 4 | 1 | YELLOW |  |  |  | X
NUT 5 | 2 | GREEN |  |  | X
NUT 6 | 3 | WHITE |  |  |  | X
NUT 7 | 2 | GREEN |  | X
 |  |  |  |  |  |  | output
 |  |  |  |  |  |  |  | GREEN | YELLOW | WHITE
 |  |  |  |  |  |  | BOX A | 1 | 1 | 1
 |  |  |  |  |  |  | BOX B | 2 | 0 | 2
 |  |  |  |  |  |  | BOX C | 3 | 1 | 0
 |  |  |  |  |  |  | BOX D | 1 | 1 | 2
Spreadsheet: 1ae9522e-5b40-4f6a-99cc-143589004ff8
Sheet: Sheet1

Sex Offenses | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Incident, Offenses, Victims, and Known Offenders
by Offense Type, 2011
Offense Type | Incidents1 | Offenses | Victims2 | Known Offenders3, 4
Total | 69819 | 76121 | 76121 | 74283
Sex Offenses, Forcible: | 64382 | 69356 | 69356 | 67550
Forcible Rape | 26221 | 27023 | 27023 | 28455
Forcible Sodomy | 6574 | 7227 | 7227 | 7069
Sexual Assault with an Object | 2738 | 2951 | 2951 | 2855
Forcible Fondling | 28849 | 32155 | 32155 | 29171
Sex Offenses, Nonforcible: | 6377 | 6765 | 6765 | 6733
Incest | 1034 | 1152 | 1152 | 1071
Statutory Rape | 5343 | 5613 | 5613 | 5662
1The actual number of incidents is 69,819.  However, the column figures will not add to the total because incidents  may include more than one offense type, and each appropriate offense type is denoted in this table.
2The victim type for all sex offenses is Individual (person).
3The term [NAME] does not imply the identity of the suspect is known, but only that an attribute of the suspect has been identified, which distinguishes him/her from an unknown offender.
4The figures in the column Known Offenders do not include the 3,970 incidents with an unknown offender.
Spreadsheet: 453919d1459518269-data-validation-with-indirect-and-name-manager-created-with-index-or-offset-functions-data-validation-with-indirect-ans
Sheet: Sheet1

A | Sheet1!$A$1:$A$19 |  |  |  | Note:
D |  |  |  |  | I was Created A Name Manger by using [NAME] as
E | Sheet1!$A$1:$A$19
F |  |  |  |  | MyList1 - =Sheet1!$A$1:$A$8
H |  |  |  |  | MyList2 - =Sheet1!$A$1:INDEX(Sheet1!$A:$A,MATCH("zzz",Sheet1!$A:$A))
I | Sheet1!$A$1:$A$19
J |  |  |  |  | And Created Data Validation List By using formula - =INDIRECT(B1) in Cell C1
K
L |  |  |  |  | So when I used MyList1 in Cell B1 the List showing  well In Cell C1
M |  |  |  |  | But when I used MyList2 in Cell B1 the List not showing any thing why?
N
O
P
q
r
e
t
y
u
Spreadsheet: e3bcc62f-aa2f-463b-a991-840feecb1f8f
Sheet: FEBRUARY

SEATTLE UNIVERSITY
NON-EXEMPT EMPLOYEE TIME REPORT
NAME: |  |  |  |  | DEPT: |  |  | (Use 4 letter-code as shown on paystub under DEPT)
Datatel ID Number or SSN:
PE: |  | 2015-02-01 00:00:00 | TO | 2/29/2015 |  | MO. NO.: |  | 2
Holiday Pay |  |  |  | HP | 4
Sick Pay |  |  |  | SP
Vacation Pay |  |  |  | VP
[NAME] |  |  |  | BR |  | (up to 5 days of paid leave)
Jury Duty Leave |  |  |  | JL
[NAME] |  |  |  | DP
 |  |  |  |  |  |  |  |  | Employee Signature |  |  |  | Date
Regular Pay |  |  |  | RP
SUB-TOTAL |  |  |  |  | 80 |  |  |  | Supervisor Signature |  |  |  | Date
Overtime (1.0 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is between 37.50 and 40)
Overtime (1.5 rate) |  |  |  |  |  | (If total hours worked (Sunday-Saturday) is above 40)
TOTAL
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 8 |  | 9 |  | 10 |  | 11 |  | 12 | Time sheets due | 13 |  | 14
 |  | HP | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 15 |  | 16 |  | 17 |  | 18 |  | 19 |  | 20 |  | 21
 |  |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
 | 22 |  | 23 |  | 24 |  | 25 |  | 26 | Payday | 27 |  | 28
REMEMBER: Adjustment from Prior Month!! INCLUDE PRIOR MONTH ADJ HOURS IN THE ABOVE CALCULATION!
Spreadsheet: 882240d1730510360-copying-rows-with-retaining-data-recruiting-spreadsheet-challenge-sample-recruiting-sheet
Sheet: Recruiting Job 2

Date Entered | [NAME] | ID# | First Name | Last Name | Phone Number | [NAME] | Computer Assessment | Criminial BG | Date Updated | Education Verification | Adobe Pre-Hire Forms | Paperwork | Everify
2024-11-01 00:00:00 | 85058 DO | 20333030 | [NAME] | Padilla
2024-11-01 00:00:00 | 85058 DO | 20349118 | Yuvannia | [NAME]
2024-10-24 00:00:00 | 85058 JS | 20344884 | Kasheka | [NAME]
2024-10-31 00:00:00 | 85058 DO | 11349092 | Mariceli | Nuez
2024-11-01 00:00:00 | 85058 JS | 18710555 | Kalil | Tanco
Spreadsheet: 17d20ad7-f90d-4624-ac02-72dbe0905ea0
Sheet: Publish Phosphates

Phosphates
 |  |  |  | Q1 FY12 | Q2 FY12 | Q3 FY12 | Q4 FY12 | Q1 FY13 | Q2 FY13 | Q3 FY13 | Q4 FY13
 | Net Sales and Gross Margin (in millions, except per tonne)
 | Segment income statement
 |  | North America |  | 629.5 | 648.1 | 603.5 | 671.9000000000001 | 556.4 | 648.1 | 624 | 640
 |  | International |  | 1590.3 | 1530.7 | 1048.3 | 1116.9 | 1004.5 | 1114.3 | 878 | 1030
 |  |  | Net Sales | 2219.8 | 2178.8 | 1652 | 1789 | 1561 | 1762.4 | 1502
 |  | Cost of Goods Sold |  | 1810.2 | 1703.1 | 1392.6 | 1467 | 1273 | 1444.9 | 1236 | 1380
 |  | Gross Margin |  |  |  |  |  |  |  | 266
 |  |  | As % of Sales |  |  |  |  |  |  | 0.1769328094825864
 |  | PhosChem sales of other member |  | 233.3020329999999 | 130 | 125 | 156 | 47 | 8.912025 | 7.80291824 | 28
 |  | [NAME] (x PhosChem)(i) |  | 1987 | 2048.8 | 1527 |  |  |  | 1493.89708176
 |  | [NAME] (x PhosChem)(i) |  | 1576.897967 | 1573.1 | 1267.6 |  |  |  | 1228.19708176
 |  | Gross Margin (x PhosChem)(i) |  |  |  |  |  |  |  | 265.7
 |  |  | As % of Sales (x PhosChem)(h) |  |  |  |  |  |  | 0.1778569643411926
 |  | Segment Operating Earnings |  | 333.3 | 431.6 | 190.2 | 224 | 208 | 245.2 | 197.2 | 198.01
 |  |  | As % of Sales |  |  |  |  |  |  | 0.1313178397815809
 |  | DD&A |  | 64.6 | 64.1 | 66.8 | 68 | 69 | 72.3 | 71.10000000000001 | 74.89999999999998
 | Operating Data
 | Sales volumes ('000 tonnes)
 |  | Crop Nutrients
 |  |  | North America(d) | 863.866 | 893 | 931 | 1059 | 855 | 983 | 954 | 1011
 |  |  | International(d) | 1000 | 994 | 857 | 959 | 603 | 721 | 858 | 944
 |  | Crop Nutrient Blends(j) |  | 795 | 820 | 489 | 516 | 751 | 809 | 525 | 567
 |  | Feed Phosphates |  | 152 | 147 | 169 | 153 | 132 | 131 | 135 | 136
 |  | Other(k) |  | 347 | 342 | 145 | 203 | 321 | 319 | 170 | 281
 |  | Total(d) |  |  |  |  |  |  |  | 2642
 | Production [NAME] ('000 tonnes)
 |  | Total tonnes produced(l) |  | 2163 | 2083 | 1954 | 2079 | 1961 | 2075.385103873718 | 2111.540156391182 | 2054
 |  | Operating rate |  | 0.8919587628865979 | 0.8589690721649484 | 0.8057731958762887 | 0.86 | 0.81 |  | 0.8707382088211061
 | Realized prices ( $/tonne)
 |  | DAP (FOB plant)(e) |  | 576 | 611 | 536 | 494 | 529 | 544 | 496 | 483.15
 |  | Blends (FOB destination)(j) |  | 590 | 581 | 588 | 551 | 533 | 559 | 558 | 578.31
 | Realized costs  ($/tonne)
 |  | Ammonia (tonne)(m) |  | 551 | 579.21 | 589 | 417 | 449 | 561 | 540 | 540.38
 |  | Sulfur (long ton)(n) |  | 232 | 236.99 | 228 | 200 | 196 | 190 | 181 | 170.67
 | Average Market prices  ($/tonne)
 |  | Ammonia (tonne)(o) |  | 560.0833333333334 | 652.3333333333334 | 524.25 | 486 | 683 | 709.08 | 664.7666666666667 | 598.37
 |  | Sulfur (long ton)(p) |  | 220 | 220 | 204 | 175 | 176 | 165.33 | 156.6666666666667 | 151.67
 |  | Natural Gas(q) |  | 4.284286890645586 | 3.676904761904762 | 2.833078571428571 | 2.3 | 2.8 | 3.368 | 3.4 | 4
 | [NAME] ($ in millions) |  |  | 98 | 82 | 100 | 128 | 131 | 79 | 97 | 121
Spreadsheet: 262510d1378192115-match-identical-debit-and-credit-amounts-0a179
Sheet: Sheet1

Name | Amount | Testing column
[NAME] | 300
[NAME] | 200 |  |  | Putting the same formula that I use in CF, in column C, I hope to understand
[NAME] | 100 |  |  | the usage of the formula.
Stacy | 150
[NAME] | 250
[NAME] | 500
[NAME] | -300
[NAME] | -200
[NAME] | 50
[NAME] | 75
[NAME] | -100
In this example I have a lit of 12 persons.i want to match names (where they are identical) and amount  where the two are identical
irrespective of whether the amount is +ve or -ve.
In this case it should highlight |  |  | 1 | [NAME] | 300
 |  |  |  | [NAME] | -300
 |  |  | 2 | [NAME] | 200
 |  |  |  | [NAME] | -200
 |  |  | 3 | [NAME] | 100
 |  |  |  | [NAME] | -100
Spreadsheet: 755360d1636811537-reset-cell-increment-when-cell-value-changes-forum-help2
Sheet: Sheet1

Code | Should be Count |  |  |  |  | MOD(ROWS($1:1)-1,7)+1 | <---Formula that I have been using but isn't doing as I hoped :(
AA | 1 | <---Start increment again
AA | 2
AA | 3
AA | 4
AA | 5
AA | 6
BB | 1 | <---Start increment again
BB | 2
CC | 1 | <---Start increment again
CC | 2
AA | 1 | <---Start increment again
AA | 2
AA | 3
AA | 4
AA | 5
AA | 6
AA | 7 | <---Upto 7
AA | 1 | <---Start increment again
AA | 2
BB | 1 | <---Start increment again
BB | 2
BB | 3
BB | 4
Spreadsheet: 693400d1598957577-linking-two-excel-workbooks-job-database-sample-1-
Sheet: Sheet1

Date | Customer | Machine | Model | Serial Number | Hours Worked | KM Travelled | Code | Order Number | Expenses | Details of work carried out | Engineer | Report Number
2020-01-01 00:00:00 |  |  |  | 555 | 10 | 30 | CS | 1601-CS | 50 |  | AA | 345
2020-01-02 00:00:00 |  |  |  | 777 | 20 | 40 | WTY | 1601-W | 40 |  | AA | 346
Spreadsheet: 288e4882-eab3-434c-85b0-dd327942d908
Sheet: Team Todo List

 |  | TEAM TO DO LIST
 |  | No | Name | Completion
 |  | 1 | Todo!B2 |  | 1
 |  | 2 | 'Todo (2)'!B2 |  | 1
 |  | 3 | '[NAME] (3)'!B2 |  | 1
 |  | 4 | '[NAME] (4)'!B2 |  | 1
 |  | 5 | 'Todo (5)'!B2 |  | 1
 |  | 6 | '[NAME] (6)'!B2 |  | 1
 |  | 7 | '[NAME] (7)'!B2 |  | 1
 |  | 8 | 'Todo (8)'!B2 |  | 1
 |  | 9 | '[NAME] (9)'!B2 |  | 1
 |  | 10 | '[NAME] (10)'!B2 |  | 1
 |  | © 2011 exceltemplate.net |  |  |  | visit exceltemplate.net for more excel templates