tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 774497d1648502568-selecting-products-using-multiple-drop-down-menus-product-selector-table
Sheet: Source Data

 | Outdoor Applications
 | [NAME] | Travel Cover (trailerable) | Mooring Cover (non-trailerable) | Outdoor Cover (patio, grill, etc.) | Awning | Tarp | Icehouse | Boat Lift Canopy | Hunting Blind | Snowmobile/UTV/ATV/PWC | Marine Seating | Price
Product 1 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $
Product 2 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $$
Product 3 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$
Product 4 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | $$$$
Product 5 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $$
Product 6 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $
Product 7 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $$
Product 8 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$$
Product 9 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $$
Product 10 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$
Product 11 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $$
Product 12 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | $$$
Product 13 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $$
Product 14 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $$
Product 15 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | $
Product 16 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$
Product 17 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$
Product 18 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$
Product 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | $
Product 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | $
Product 21 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | $
Product 22 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$$
Product 23 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$
Product 24 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | $$$$
Product 25 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | $
Product 26 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | $
Product 27 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | $$
Product 28 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | $
Product 29 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | $
Product 30 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | $
Product 31 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | $$
Product 32 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | $$$$
Product 33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | $$$
Product 34 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 35 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 36 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$$
Product 37 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 39 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 41 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 42 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 43 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | $$$
Product 44 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | $$
Product 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | $$$
Spreadsheet: c62e7c53-0378-4850-8b98-64fe24d3398f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
265460 | 80762 | [NAME] | Pilbeam | AUS | 21 | 00:16:38 | 00:00:50 | 00:38:43 | [NAME] | 00:30:02 | 1 | 01:27:06
265460 | 74776 | Debbie | Wendt | AUS | 28 | 00:22:20 | 00:01:00 | 00:38:04 | [NAME] | 00:32:21 | 2 | 01:34:40
Spreadsheet: 47300d1246324142-conditionally-format-a-column-based-upon-another-column-sample-data
Sheet: sample

Name | Gender
[NAME] | Male
[NAME] | Female
Eddie | Male
[NAME] | Male
[NAME] | Female
[NAME] | Male
Jessica | Female
1- I know how to highlight duplicates in a column via conditional formatting.
2- But, I would like to highlight duplicates in column A for every unique item in column B
3- I worked out what the answer should be above.  The names highlighted are in red.
4- [NAME] is a male and female name.  It is highlighted.  [NAME] is a male and female name.  It is highlighted.
5- Does anyone know how to do this with a formula?
Spreadsheet: 455425d1460339301-how-can-this-spradsheet-be-improved-lunar-theme-park
Sheet: Running Costs

 |  | Staff | Maintenance |  | Total
Major Ride |  | 50 | 60
Minor Ride |  | 40 | 40
[NAME] |  | 30 | 20
Shop |  | 20 | 20
Toilet |  | 5 | 5
Spreadsheet: 6f0804b6-7fb8-479e-bd1c-8aa1b19c3d8a
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44331882 | 2014-12-06 20:29:12 | AXIS | 1 | 7 | 4 | 1036758 | player1036758 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44365868 | 2014-12-09 02:48:00 | AXIS | 0 | 5 | 7 | 1609999 | ArchNME | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44366151 | 2014-12-09 03:13:58 | ALLIES | 0 | 4 | 7 | 1609999 | ArchNME | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44366428 | 2014-12-09 03:36:24 | ALLIES | 0 | 2 | 6 | 192431 | Kain51 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44366655 | 2014-12-09 04:02:46 | AXIS | 1 | 6 | 5 | 192431 | Kain51 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
44426737 | 2014-12-13 18:01:04 | AXIS | 0 | 5 | 7 | 1620882 | diallo87 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44427036 | 2014-12-13 18:25:19 | ALLIES | 0 | 4 | 7 | 1620882 | diallo87 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44428963 | 2014-12-13 20:55:49 | AXIS | 1 | 5 | 0 | 1683746 | desb74 | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
44429234 | 2014-12-13 21:22:48 | AXIS | 1 | 7 | 4 | 969102 | player969102 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44429588 | 2014-12-13 21:39:53 | ALLIES | 0 | 4 | 7 | 969102 | player969102 | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
44433566 | 2014-12-14 03:34:42 | AXIS | 0 | 4 | 5 | 959603 | TommyGuts | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
44464214 | 2014-12-16 03:57:47 | ALLIES | 0 | 1 | 6 | 1074409 | ATTappman | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44464384 | 2014-12-16 04:12:17 | AXIS | 1 | 6 | 0 | 1074409 | ATTappman | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
44464558 | 2014-12-16 04:30:18 | AXIS | 1 | 6 | 4 | 1074409 | ATTappman | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
44464733 | 2014-12-16 04:45:05 | ALLIES | 0 | 2 | 6 | 1074409 | ATTappman | 9596 | western | 1944-06-06 | 1944-06-06 | Gold Beach | Gold Beach
44490945 | 2014-12-18 03:42:07 | AXIS | 0 | 3 | 5 | 1670968 | bkpfitzner | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
Spreadsheet: 790328d1659640728-12-month-rolling-calendar-for-occurences-example-attendance-tracker
Sheet: Instructions

Instructions for use of [NAME]
 | Set Up
1 | Enter the name, role and people leader of employees on the List of Employees tab.
 | Utilization - Attendance Tracker
1 | To document employee attendance activities and Occurances first select the Attendance Tracker tab
2 | Select the employee's name from the drop down menu
3 | Enter the date the attendance activity started
4 | Enter the last date of the attendance activity
5 | Select the type of leave from the drop down menu
6 | Days and hours taken will automatically calculate
7 | Decide if the activity is an occurrence based on the attendance policy guidelines and select "yes" or "no"
8 | Enter a comment for every line entered
 | Exceptions:
 | If unplanned PTO is taken for consecutive days, only enter unplanned for the first day. Remaining days should entered as planned PTO but make detailed comments
 | If a partial day of PTO is taken,manually type in the hours of PTO to override the automatic calculation
 | Days automatically calculates the number of weekdays minus any company holidays. If an occurance is on a Saturday, manually type in 1 day into the days column to override the automatic calculation.
 | Utilization - Attendance Calendar
1 | To view an employees attendance record, select their name from the drop down on the [NAME] tab
2 | Type in the year
3 | All attendance and PTO will populate on the calendar
Spreadsheet: 30459114-694e-4819-a618-885b1a8eaad5
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
 | 5609.0 Housing Finance, Australia
 | TABLE 12. HOUSING LOAN OUTSTANDINGS TO HOUSEHOLDS (OWNER OCCUPATION AND INVESTMENT HOUSING)
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
Owner-occupied housing ;  [NAME] ; |  |  | Original | A2435226X | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Permanent Building Societies ; |  |  | Original | A2435228C | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Credit Co-operatives ; |  |  | Original | A2435230R | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435232V | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
Investment housing ;  [NAME] ; |  |  | Original | A2435227A | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
Investment housing ;  Permanent Building Societies ; |  |  | Original | A2435229F | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
Investment housing ;  Credit Co-operatives ; |  |  | Original | A2435231T | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
Investment housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435233W | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
All residential housing ;  [NAME] ; |  |  | Original | A2435234X | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
All residential housing ;  Permanent Building Societies ; |  |  | Original | A2435235A | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
All residential housing ;  Credit Co-operatives ; |  |  | Original | A2435245F | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
All residential housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435246J | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
All residential housing ;  Securitisation Vehicles ; |  |  | Original | A2435238J | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
All residential housing ;  Other Lenders ; |  |  | Original | A2435241W | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
All residential housing ;  Total (Lender Housing) ; |  |  | Original | A2435244C | 2002-03-01 00:00:00 | 2010-11-01 00:00:00 | 105 | $ Millions | STOCK | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 98347d1297281087-i-have-a-drop-down-list-that-i-want-to-use-to-lookup-text-values-in-another-sheet-copy-of-example-1
Sheet: Sheet 1

Group leader | AJO - Are Johan Olsen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oppdragsledere
Oppdatert |  | M.O057C.6M.A.0009 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AJO - Are Johan Olsen
 |  | M.O057C.8M.1.0013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AK - Anders Kjøling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FD - Faisal Dahman
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GD - Geir Dahle
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GSL - Grethe Sem Larsen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HB - Hallstein Bringsvor
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JA - Jone Alsvik
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JL - Jørgen Lea
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JS - Jadhav Suryabhan
 | jan | feb | [NAME] | apr | mai | jun | jul | aug | sep | okt | Nov | Des |  |  |  |  |  |  |  |  |  |  |  |  |  | JSV - Jan Sverre Vea
Estiminert cost, periodic | 0 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KN - Kjetil Nådland
Accumulated, actual cost | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KR - [NAME]
Accumulated, actual profit | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | KRF - Kjell Rune Framvik
[NAME] omsetning, akkum | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MA - Morten Andreassen
EBITDA mål | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MH - Mike Hooker
EBITDA faktisk | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MM - Mansi Mantri
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NB - Neelima Bhaduri
EBITDA margin mål % | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | RHA - [NAME]
EBITDA margin faktisk % | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  | SH - Stein Haugland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAK - [NAME] Kleveland
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WS - [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AA - Anita Albriktsen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ÅS - Åge Sjøveian
Spreadsheet: 126207d1319565974-counting-instances-of-a-string-in-non-contiguous-columns-example
Sheet: Sheet1

[NAME] | # of Interactions | # of Clicks | 72711 Opens | 72711 Clicks | 72711(2) Opens | 72711(2) Clicks
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
[EMAIL]
Spreadsheet: 805523d1668737223-return-multiple-certifications-completed-and-sum-of-certifications-in-separate-columns-need-formula-vijavad-
Sheet: Trained

EMP ID | First Name | Course attended | Course Certified | Certified Date
20291 | Vijay V | SC-900
20291 | Vijay V | SC-200
20291 | Vijay V | SC-300
20291 | Vijay V | SC-400
20291 | Vijay V | SC-100
20291 | Vijay V | AZ-900
20292 | Kiran Kumar | AZ-900
20292 | Kiran Kumar | SC-900
20293 | Madhu | MS-500
20293 | Madhu | SC-900
21534 | Hemanth | SC-300
21534 | Hemanth | SC-400
21534 | Hemanth | SC-100
21534 | Hemanth | AZ-900
21534 | Hemanth | MS-500
Spreadsheet: 164781d1340890583-referencing-row-or-column-numbers-from-cell-values-average
Sheet: Sheet1

Row  Start | 3
Row  End | 20
Average |  |  |  | 11
 |  |  |  | 12
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  |  | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  |  | 25
 |  |  |  | 26
 |  |  |  | 27
Spreadsheet: 11c5e348-fa4f-4322-8deb-80b9693a858a
Sheet: E-STAX

[NAME] 2014
 | Online Book Views | Books Downloaded | Total Book Use
August | 3 | 11
September | 7 | 26
October | 6 | 9
November | 2 | 4
December
Total
Notes:
Live to Public on August 1, 2014.
Books can either be viewed online or downloaded.
Spreadsheet: 789817d1659377688-return-data-based-on-two-indicators-including-max-date-2022-08-01-oeldere-hammcfly-excelforum1
Sheet: Sheet1

PROJECT ID | DATE | BUDGET | INDICATOR | HELPER | HELPER2 | BUDGET2 | BUDGET3
PROJ1 | 2022-07-01 00:00:00 | 1000000 | 1
PROJ2 | 2022-07-01 00:00:00 | 1000000 | 2
PROJ3 | 2022-07-01 00:00:00 | 1000000 | 3
PROJ4 | 2022-07-01 00:00:00 | 1000000 | 4
PROJ1 | 2022-07-15 00:00:00 | 2000000 | 1
PROJ2 | 2022-07-15 00:00:00 | 2000000 | 2
PROJ1 | 2022-07-31 00:00:00 | 3000000 | 1
Spreadsheet: 731857d1620647925-using-sumproduct-no-sumifs-to-summarize-mapped-data-sumproduct
Sheet: Sheet1

 | 1) Available Information
 |  | 2021
 | A | 23.09771358297671 | 99.23469731260295 | 5.118624664849913 | 9.721795783920417 | 41.86933798989963
 | B | 14.03335175143512 | 3.731501867538511 | 64.5995006038213 | 99.79986346985423 | 18.50497596222567
 | C | 59.44276967744027 | 51.71394198662003 | 65.963556956002 | 0.7336172743449332 | 50.3640465811927
 | D | 95.99776126461296 | 27.94356805555854 | 99.00236481709985 | 32.27675344467922 | 12.91211970144241
 | E | 43.35331800585405 | 98.63346867825854 | 49.17204281212088 | 48.23115425687165 | 16.59581441003798
 | F | 17.5666610731332 | 42.00756651723383 | 5.880398978700296 | 88.30023235012034 | 0.5455865262733783
 | G | 92.38102793753362 | 51.65267145021414 | 31.0351934956848 | 77.17785636183031 | 93.67873545443655
 | H | 76.10931521200247 | 69.58601301375542 | 75.16696971442003 | 64.67973543514728 | 73.57143256839159
 | I | 94.0309064124232 | 96.84580341983448 | 37.89838830395457 | 67.9562128871874 | 77.70633823955278
 | 2) Mapping
 | Product | Type
 | A | Alpha
 | B | Alpha
 | C | Alpha
 | D | Beta
 | E | Beta
 | F | Beta
 | G | Gamma
 | H | Gamma
 | I | Gamma
 | 3) Final Product
 |  | 2021
 | Alpha
 | Beta
 | Gamma
 | ...
Spreadsheet: 723371d1615653333-conditional-formatting-and-color-cells-with-formula-testname-6-1-
Sheet: Blad1

project | datum | nr vlist | nr defensie | vertrek | tijd | aankomst | aantal | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
5154 | 2021-03-18 00:00:00 |  |  |  | 22:00:00 |  |  | nl |  |  |  |  |  |  | uren inkoop |  |  | km inkoop
5154 | 2021-03-18 00:00:00 |  |  |  | 22:00:00 |  |  |  | nl |  |  |  |  |  | [NAME] |  |  | km verkoop
5155 | 2021-03-18 00:00:00 |  |  |  | 20:00:00 |  |  | ik | ics |  |  |  |  |  | [NAME] |  |  | [NAME]
5155 | 2021-03-18 00:00:00 |  |  |  | 20:00:00 |  |  | nl | ics
5155 | 2021-03-18 00:00:00 |  |  |  | 20:00:00 |  |  |  | ics |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5156 | 2021-03-18 00:00:00 |  |  |  | 22:30:00 |  |  |  | ast |  |  |  |  |  | [NAME] |  |  | Verkoop D
5156 | 2021-03-18 00:00:00 |  |  |  | 22:30:00 |  |  |  | ast |  |  |  |  |  | [NAME] |  |  | Verschil D
5156 | 2021-03-18 00:00:00 |  |  |  | 22:30:00 |  |  |  | ast
5157 | 2021-03-18 00:00:00 |  |  |  | 22:45:00 |  |  |  | nl |  |  |  |  |  | Totaal inkoop |  |  | proj nl in
5157 | 2021-03-18 00:00:00 |  |  |  | 22:45:00 |  |  |  | nl |  |  |  |  |  | Totaal verkoop |  |  | proj nl ver
5158 | 2021-03-18 00:00:00 |  |  |  | 23:30:00 |  |  |  | nl |  |  |  |  |  | totaal [NAME] |  |  | [NAME] in
5158 | 2021-03-18 00:00:00 |  |  |  | 23:30:00 |  |  |  | nl |  |  |  |  |  |  |  |  | [NAME] ver
5159 | 2021-03-19 00:00:00 |  |  |  | 00:00:00 |  |  | rene | rene
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | projrct [NAME] |  | project [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | search code | aantal beg | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | customer | amount
Spreadsheet: 152730d1335490760-select-cell-based-upon-hlookup-result-test
Sheet: Sheet1

 | 2011-01-01 00:00:00 |  | 2011-02-01 00:00:00 |  | 2011-03-01 00:00:00 |  | 2011-04-01 00:00:00 |  | 2011-05-01 00:00:00 |  | 2011-06-01 00:00:00 |  |  | 2011-05-01 00:00:00
 | 1 | 9 | 1 | 9 | 1 | 9 | 1 | 9 | 34 | 87 | 1 | 9
 | 2 | 8 | 2 | 8 | 2 | 8 | 2 | 8 | 56 | 12 | 2 | 8 |  |  | This HLOOKUP returns cell J11. (Shaded yellow)
 | 3 | 7 | 3 | 7 | 3 | 7 | 3 | 7 | 76 | 76 | 3 | 7 |  |  | I want it to return cell K11. (Shaded green)
 | 4 | 6 | 4 | 6 | 4 | 6 | 4 | 6 | 83 | 34 | 4 | 6 |  |  | I understand that the merged header cell is the problem.
 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 45 | 49 | 5 | 5
 | 6 | 4 | 6 | 4 | 6 | 4 | 6 | 4 | 12 | 62 | 6 | 4
 | 7 | 3 | 7 | 3 | 7 | 3 | 7 | 3 | 34 | 32 | 7 | 3
 | 8 | 2 | 8 | 2 | 8 | 2 | 8 | 2 | 65 | 71 | 8 | 2
 | 9 | 1 | 9 | 1 | 9 | 1 | 9 | 1 | 23 | 27 | 9 | 1
Spreadsheet: 678684d1590006358-slicer-which-can-list-by-specific-periods-2020-05-20-oeldere2-zanshin777-678478d1589909386-slicer-which-can-list-by-specific-periods-ex
Sheet: PT

Som van Duration | Kolomlabels
Rijlabels | Month < 3 | Month > 3 | Month > 6 | Year > 2 | Eindtotaal
AEU | 15 | 60 |  | 1221 | 1296
Ear_Training |  |  | 10 |  | 10
Guitar | 20 | 10 |  |  | 30
Intellectual |  | 70 | 39 |  | 109
Keyboard |  | 50 |  |  | 50
Songwriting | 30 |  |  |  | 30
Eindtotaal | 65 | 190 | 49 | 1221 | 1525
Spreadsheet: 805338d1668628921-need-help-setting-up-formula-that-updates-using-dates-excel-help-formula
Sheet: Sheet1

Go Live Date | Annual Bundle Fee | Annual Management First Year | Annual Recurring Management & Bundle Fee | Original Monthly Management Fee | Annual Management Fee 2023 | January | February | March | April | May | June | July | August | September | October | November | December
2020-11-01 00:00:00 | 1600 | 28800 | 30400 | 2400
2020-12-01 00:00:00 | 4000 | 60000 | 64000 | 5000
2021-02-01 00:00:00 | 3500 | 48000 | 51500 | 4000
Spreadsheet: 10ef95d3-6bcf-4d59-a656-ea9ea6cc1919
Sheet: Sheet1

Votre recherche : ATHENA, [NAME] tês Hellados (EBE), 2202 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Folios | Auteur | Oeuvre | Commentaire | Siècle | Date | Source
001-57* | LITVRGICA | LITVRGIAE | Inc. mut. | 17 |  | R(III)0434
057-76* | LITVRGICA | VARIA | Apostoloevangelia | 17 | 1639 | R(III)0434
076-91v* | LITVRGICA | EVCHOLOGIVM |  | 17 | 1639 | R(III)0434
Spreadsheet: 220710d1363244293-adding-rows-automatically-in-two-separate-worksheets-examplev17
Sheet: Assets

Assets
Non-current assets
Land | 100000 | 80000 | 160000 | 130000 | 80000 | 60000
Buildings | 251651 | 226154
Goodwill | 10000 | 8000 | 6000 | 4000 | 2000 | 1000
Other tangable assets | 500 | 500 | 500 | 500 | 500 | 500
Current assets
Inventory | 165990
Cash | 59659 | 59659 | 59659 | 59659 | 59659 | 59659
Other goods | 8592 | 8592 | 8592 | 8592 | 8592 | 8592
Spreadsheet: 144974d1331230400-auto-fill-data-from-multiple-sheets-ex-schedual_mahju
Sheet: EMP2

Monthy Days to work |  |  |  | emp2
 | Cashier | [NAME] | [NAME]
2012-03-08 00:00:00
2012-03-09 00:00:00
2012-03-10 00:00:00
2012-03-11 00:00:00
2012-03-12 00:00:00
2012-03-13 00:00:00
2012-03-14 00:00:00
2012-03-15 00:00:00
Spreadsheet: 193315d1352800708-associating-a-list-with-positve-and-negative-numbers-formula-divisionexample
Sheet: Sheet1

 | (vs Damian B)
 | (vs [NAME])
 | (vs [NAME])
 | (vs [NAME]) |  |  | week 1 | week 2 | week 3 | week 4 | week 5
 | (vs [NAME] E)
 | (vs [NAME])
 | (vs [NAME]) |  |  | VERSUS
 | (vs [NAME] D)
 | (vs [NAME]) |  |  | (vs Damian B) | (vs [NAME]) | (vs [NAME] D) | (vs [NAME]) | (vs [NAME] E)
 | (vs Brett B)
 |  |  |  | RESULT (Positve number = win   Negative number = loss)
 | MIKE N |  |  | -31.2 | 22.5 | 14.3 | 6.6 | 0
 |  | W-L-T
 |  | 1-1-1 |  | Loss |  |  | Win | Tie
Spreadsheet: 153381d1335888780-excel-2007-dropdown-list-test-2-
Sheet: Do Not Delete or Ammend

Monday |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  | Thursday |  |  |  |  |  |  | Friday
MonMorning |  |  | MonAfternoon |  |  | MonLates | TueMorning |  |  | TueAfternoon |  |  | TuesLates | WedMorning |  |  | WedAfternoon |  |  | WedLates | ThurMorning |  |  | ThurAfternoon |  |  | ThurLates | FriMorning |  |  | FriAfternoon |  |  | FriLates