tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 147714d1332941894-count-cells-with-text-primjer-za-formulu2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 1. Make a copy of the table |  |  | 2. Remove duplicates using the excel function |  |  |  | 3. Copy the categorys to count |  |  | 4. Add Countif functions
 |  | Customers | Category |  |  |  |  |  |  | Customers | Category |  | Customers | Category |  |  | Category |  |  | Category | Counts
 |  | Customer 1 | LOCAL |  |  |  |  |  |  | Customer 1 | LOCAL |  | Customer 1 | LOCAL |  |  | LOCAL |  |  | LOCAL
 |  | Customer 2 | KEY |  |  |  |  |  |  | Customer 2 | KEY |  | Customer 2 | KEY |  |  | KEY |  |  | KEY
 |  | Customer 3 | CORPORATE |  |  |  |  |  |  | Customer 3 | CORPORATE |  | Customer 3 | CORPORATE |  |  | CORPORATE |  |  | CORPORATE
 |  | Customer 4 | CORPORATE |  |  |  |  |  |  | Customer 4 | CORPORATE |  | Customer 4 | CORPORATE
 |  | Customer 5 | CORPORATE |  |  |  |  |  |  | Customer 5 | CORPORATE |  | Customer 5 | CORPORATE |  |  |  |  |  | You Done!
 |  | Customer 6 | LOCAL |  |  |  |  |  |  | Customer 6 | LOCAL |  | Customer 6 | LOCAL
 |  | Customer 7 | LOCAL |  |  |  |  |  |  | Customer 7 | LOCAL |  | Customer 7 | LOCAL
 |  | Customer 8 | LOCAL |  |  |  |  |  |  | Customer 8 | LOCAL |  | Customer 8 | LOCAL
 |  | Customer 9 | KEY |  |  |  |  |  |  | Customer 9 | KEY |  | Customer 9 | KEY
 |  | Customer 10 | LOCAL |  |  |  |  |  |  | Customer 10 | LOCAL |  | Customer 10 | LOCAL
 |  | Customer 11 | KEY |  |  |  |  |  |  | Customer 11 | KEY |  | Customer 11 | KEY
 |  | Customer 12 | CORPORATE |  |  |  |  |  |  | Customer 12 | CORPORATE |  | Customer 12 | CORPORATE
 |  | Customer 13 | LOCAL |  |  |  |  |  |  | Customer 13 | LOCAL |  | Customer 13 | LOCAL
 |  | Customer 14 | LOCAL |  |  |  |  |  |  | Customer 14 | LOCAL |  | Customer 14 | LOCAL
 |  | Customer 1 | LOCAL |  |  |  |  |  |  | Customer 1 | LOCAL
 |  | Customer 2 | KEY |  |  |  |  |  |  | Customer 2 | KEY
 |  | Customer 3 | CORPORATE |  |  |  |  |  |  | Customer 3 | CORPORATE
 |  | Customer 11 | KEY |  |  | How many LOCAL Customers |  |  |  | Customer 11 | KEY
 |  | Customer 12 | CORPORATE |  |  | How many KEY Customers |  |  |  | Customer 12 | CORPORATE
 |  | Customer 13 | LOCAL |  |  | How many CORPORATE Customers |  |  |  | Customer 13 | LOCAL
 |  | Customer 3 | CORPORATE |  |  |  |  |  |  | Customer 3 | CORPORATE
 |  | Customer 4 | CORPORATE |  |  |  |  |  |  | Customer 4 | CORPORATE
 |  | Customer 5 | CORPORATE |  |  |  |  |  |  | Customer 5 | CORPORATE
Spreadsheet: 784523d1655807777-isnumber-and-find-in-finding-case-sensitive-values-based-on-the-criteria-book1
Sheet: Sheet1

Company | Application |  | How many VALID applications?
Quad | REJECTED |  | Quad
QUAD | VALID |  | Aspen
quad | REJECTED |  | Carlton
Quad | REJECTED
Aspen | VALID
ASPEN | VALID
Aspen Ltd. | VALID
Quad LLC | REJECTED
Carlton LLC | VALID
Carlton | VALID
CARLTON | REJECTED
carlton | REJECTED
Carlton Intl | VALID
Quad | VALID
Quad | VALID
Carlton | REJECTED
Aspen | VALID
Aspen | REJECTED
Aspen | VALID
ASPEN Ltd | REJECTED
Carlton | VALID
Quad Ltd. | REJECTED
Carlton Intl | REJECTED
The Quad Ltd | VALID
Aspen Lite Intl | REJECTED
ASPEN Intl | REJECTED
CARLTON LLC | REJECTED
Quad LLC | VALID
QUAD | VALID
quad | REJECTED
Aspen | VALID
Quad | VALID
Carlton | VALID
CARLTON | VALID
carlton | REJECTED
quad | VALID
QUAD | REJECTED
Quad LLC | VALID
Quad | REJECTED
Quad Intl | REJECTED
Carlton | VALID
Aspen Intl | VALID
The Aspen Ltd | VALID
The Aspen | REJECTED
The Quad | VALID
Quad Intl | REJECTED
Quad LLC | VALID
Carlton Intl | VALID
Quad | REJECTED
Carlton | VALID
Spreadsheet: 836859d1689686751-custom-conditional-format-with-if-statement-lift_station_data_sheets-etaf
Sheet: Lift_Station_CC#1

Cross Creek Lift Station #1 Data
Date | Time | Name | Pump#1 ETM | Pump#1 Hours | Pump#2 ETM | Pump#2 Hours | Pump#1 Amps | Pump#2 Amps | Notes
2023-06-19 00:00:00 | 08:00:00 | Erick | 7340.51 |  | 5490.36 |  | 18 | 20.2 | Pump#2 VFD Overload
2023-07-06 00:00:00 | 07:20:00 | Erick | 7354.68 |  | 5503.02 |  | 18.4 | 16.7
2023-07-11 00:00:00 | 10:05:00 | Erick | 7358.92 |  | 5506.87 |  | 17.2 | 18
2023-07-14 00:00:00 | 07:15:00 | Erick | 7361.07 |  | 5508.81 |  | 17.4 | 18.6
2023-07-18 00:00:00 | 07:15:00 | Erick | 7364.41 |  | 5511.76 |  | 17.5 | 18.7
 |  |  |  | 1 |  | 5
Spreadsheet: 887ccf7a-e446-49fe-9ea2-9b8758a3face
Sheet: Sheet1

RED BALLOON OER AWARDEES
Course Developer | Academic Department | Course Number & Title | Average number
[NAME], Assistant Professor | Communication Studies | COMM 635 - Multimedia Production | 15
Dr. [NAME] | Sociology | SOC 140: Introduction to Sociology | 60
Dr. [NAME] | Advanced Education Programs | MIT 805 Instructional Technology Theory and Practice | 28
[NAME] | English | ENG | 25
[NAME] | English | ENG 101,  Composition I | 24
[NAME] | Biological Sciences | Biol 180 C Principles of Biology | 120
Skip Ward | Management and Marketing | BCOM 695 Corporate Communication | 15
[NAME] | Physics | PHYS 111 VA Physics 1 | 15
[NAME] | Psychology | PSY846 Program Evaluation | 10
[NAME] and [NAME] | Psychology | Advanced Abnormal Psychology PSY 800 | 10
[NAME] | Management and Marketing | MGT 611 - Human Resource Management | 125
[NAME] | Health and Human Performance | HHP 200 Personal Wellness | 630
[NAME] | Physics | PHYS 208 Elementary Meteorology | 100
[NAME] | Physics | Descriptive Astronomy PHYS 309 | 30
[NAME] | Physics | PHYS 309ca | 60
[NAME] | Physics | PHYS 212 Physics for Scientists and Engineers II | 35
[NAME] | Physics | Physics 102 | 275
 |  | TOTAL
Spreadsheet: 883158d1731647655-filter-function-to-display-result-next-to-each-row-person_list-no-vba
Sheet: person

PersonID | PersonName
P001 | [NAME]
P002 | [NAME]
P003 | [NAME]
P004 | [NAME]
P005 | [NAME]
P006 | [NAME]
P007 | Avery Campbell
P008 | [NAME]
P009 | Morgan Ellis
P010 | [NAME]
P011 | Dakota Jordan
P012 | [NAME]
P013 | [NAME]
P014 | [NAME]
Spreadsheet: 102599d1300546916-formulas-to-sort-data-and-fill-the-relevant-cells-benjamin2008_uk_contacts_list-1-
Sheet: Ledger

 | Sold To Country | Customer Name | Customer Number | Sold To Name Two | Billing Document Nbr | Manual invoices | Document Date | Due Date | Document Currency | Invoice Net Amt Local | Invoice Tax Amt Local | Total | Current | 1 to 30 | 31 to 60 | 61 to 90 | 91 to 120 | 121 to 150 | Call Log
 | UK | J Bloke | 123456 |  | 9620554645 | СЧЕТ № 1218 от 30.12.2010 | 2011-05-18 00:00:00 | 2011-01-29 00:00:00 | USD | 3115000 | 0 | 106802.4412 | 0 | 0 | 0 | 106802.4412 | 0 | 0 | 18/03/2011: To be called back
 | UK | J Bloke | 123456 |  | 9620554648 | СЧЕТ № 1218 от 30.12.2011 | 2011-05-19 00:00:00 | 2011-01-30 00:00:00 | USD | 295000 | 0 | 295000 | 0 | 0 | 0 | 0 | 295000 | 0 | 18/03/2011: To be called back
 | UK | [NAME]. | 2154685 |  | 9620554651 | СЧЕТ № 1218 от 30.12.2012 | 2011-05-20 00:00:00 | 2011-01-31 00:00:00 | USD | 895895 | 0 | 106802.4412 | 0 | 0 | 0 | 106802.4412 | 0 | 0 | 18/03/2011: To be called back
 | UK | [NAME]. | 2154685 |  | 9620554654 | СЧЕТ № 1218 от 30.12.2013 | 2011-05-21 00:00:00 | 2011-02-01 00:00:00 | USD | 125645 | 0 | 106802.4412 | 0 | 0 | 0 | 106802.4412 | 0 | 0 | 18/03/2011: To be called back
 | Grand Total |  |  |  |  |  |  |  |  | 5952946.92538 | 1815215.25005 | 1072924.91185 | 409825.48206 | 1570155.85869 | 900248.02 | 184577.40273
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: PK61 YXR

 |  |  |  |  | PK61 YXR
Registration number : | PK61 YXR |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Manufacturer : | MAN |  | 2011-12-13 00:00:00 | 12 Months | 2013-01-01 00:00:00 | £1255 (Includes £55 [NAME] fee)
Specification : | 6 x 2 A (3 Axle)
Type : | unkown
1st Registered : | unkown
Engine : | unkown
[NAME] : | 44,000kg
Back To Index
Spreadsheet: 86678d1286632408-eliminate-duplicates-in-worksheets-samplebook1
Sheet: Sheet2

Name | Address | City | Zip Code | [NAME] |  | Concatenated
[NAME] | 123 Elm | St. Louis | 65431 | [EMAIL] |  | [NAME]
[NAME] | 879 Oak | Los Angeles | 98888 | [EMAIL] |  | [NAME]
[NAME] | 576 Dogwood | Salt Lake City | 55555 | [EMAIL] |  | [NAME] 576 Dogwood Salt Lake City
[NAME] | 987 Jasper | Dallas | 87654 | [EMAIL] |  | [NAME] Jasper Dallas
Spreadsheet: 24995d1216061620-continue-searching-a-table-with-vlookup-despite-finding-one-match-calendar-help
Sheet: lookup

[NAME], Art |  |  |  | Harbers, [NAME] |  |  |  | Pickard, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Simpson, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Widger, [NAME] |  |  |  | Emadi, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Khademi, [NAME] |  |  |  | Mathur, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Peabody, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Whiting, Curtis |  |  |  | Abedini, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Gumm, Butch |  |  |  | Houghman, Deena |  |  |  | [NAME], [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Reschly, [NAME] |  |  |  | Roark, Partrick |  |  |  | [NAME], [NAME] |  |  |  | Whitmer, [NAME] |  |  |  | Young, Brandon |  |  |  | Zolyomi, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Fantz, Dane |  |  |  | [NAME], [NAME] |  |  |  | Nilssen, Tore
El-Ad, [NAME] |  |  |  | Bevis, [NAME] |  |  |  | Bonnofsky, [NAME] |  |  |  | Griswold, [NAME] |  |  |  | O'Neil, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Sheytelman, [NAME] |  |  |  | Stone, [NAME] |  |  |  | Courage, Sean |  |  |  | Crist, [NAME] |  |  |  | Simpson, [NAME] |  |  |  | Thompson, [NAME] |  |  |  | Winger, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Cha, [NAME] |  |  |  | Densmore, [NAME] |  |  |  | Navarro, Joel |  |  |  | Nee, [NAME] |  |  |  | Peck, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Brooks, [NAME] |  |  |  | Churchill, Brett |  |  |  | Herring, [NAME] |  |  |  | Ives, [NAME] |  |  |  | [NAME], [NAME] |  |  |  | Park-Epil, Christie |  |  |  | Rhodes, Holly |  |  |  | [NAME], [NAME] |  |  |  | Schaeperkoetter, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Americas | 2008-07-02 00:00:00 | 2008-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Americas | 2008-07-28 00:00:00 | 2008-07-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Americas | 2008-07-12 00:00:00 | 2008-07-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Europe | not booked | not booked
Spreadsheet: 139578d1328309982-if-statement-that-will-add-values-ost-absence-log-2012
Sheet: Names

Therapists
Amber Schindler
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Espie Castillo
Heather Huggins
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
LouAnn Moushey
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Tiffany Keller
Tiffany Sterry
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
LouAnn Moushey
[NAME]
[NAME]
Spreadsheet: 696712d1600954679-fee-increase-by-a-certain-over-every-certain-years-fee-increase-by-a-certain-over-every-certain-years
Sheet: Sheet1

 | Fee increase by a certain % over every certain years
 | Year | 1 |  |  |  |  |  |  |  |  |  |  |  | Checksum
 | Assessment fee | 100
 | Increase every ? years | 3
 | Increase % | 0.05
 | Require a formula in cell D5 that I can drag across to cell N5 all the way, to show increase in assessment fee every 3 years by 5%
 | Also require a formula in cell O5 to check that the cell N5 is computed correctly
Spreadsheet: 887091d1737214183-cadet-qualifcation-tracker-dates-updating-overall-status-progress-cdt-tracker-draft-1
Sheet: Basic

Surname | Initial | Cohort | Status | Welcome Brief | Log Book Issued | ATC | RAF | Security | Cyber | Climatic Injuries | History of Flight | Basic Drill | Updated on SMS
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 |  | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 |  | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00
 |  | 2025-01-01 00:00:00 |  | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00 | 2025-01-15 00:00:00
Spreadsheet: 881826d1730035238-formula-for-cell-each-cell-2hrs-highlight-by-color-based-on-total-hour-cf-example-eba
Sheet: Sheet1

SHUTDOWN | Activity Name | Duration
EPOXY REACTORS WITH ANY PLANNED MAINTENANCE
level-1 |  |  | 2 | 4 | 6 | 8 | 10 | 12 | 14 | 16 | 18 | 20 | 22 | 24 | 26 | 28 | 30 | 32 | 34 | 36 | 38 | 40 | 42 | 44 | 46 | 48 | 50 | 52 | 54 | 56 | 58 | 60 | 62 | 64 | 66 | 68 | 70 | 72 | 74 | 76 | 78 | 80 | 82 | 84 | 86 | 88 | 90 | 92 | 94 | 96
Tower |  |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
1 | Drain Purging | 24
2 | N2+Steam Purge | 24
3 | Ready For Maintenance Hand Over | 48
 | want to write formula to create cell highlight like shown here and dynamic one
Spreadsheet: 217302d1362039898-calculating-streaks-of-wins-and-losses-projecting-profits-version-1-dd-included
Sheet: Monthly 3

 | January | February | March | April | May | June | July | August | September | October | November | December | TOTAL
Year 1 | -0.1326520548790601 | -0.0168686468536243 | 0.08068424945580409 | -0.01329321531436859 | 0.06261971431249189 | 0.06261971431249165 | 0.02396000002580313 | 0.1214855935679107 | 0.1252439082213704 | 0.1027390300569432 | 0.04136732002624187 | 0.04136732002624147 | 0.6154194091678837 | Total (%)
P/L | -702.6979961285151 | -87.87596810738069 | 420.3186297911516 | -74.83740800414398 | 347.8467055002384 | 369.6287668232035 | 150.2862903696414 | 780.2617582145976 | 902.1232013421768 | 832.7053844439188 | 369.7311519382583 | 385.0259388241557 | 3692.516455007302 | Profit (£)
D/D | -0.1171163326880859 | -0.1376638608541694 | -0.1346622411992247 | -0.1168882264561195 | -0.07727435544818473 | -0.02000000000000002 | -0.03959999999999997 | -0.02000000000000002 | 0 | -0.02000000000000002 | -0.0428077360000001 | -0.06820728022410982 | -0.1376638608541694 | [NAME]
Year 2 | 0.1836124623324091 | 0.06261971431249173 | 0.08430583093111398 | -0.009986570459704075 | 0.1027390300569428 | -0.01658881597521856 | 0.08068424945580403 | 0.1064345213582796 | 0.08430583093111382 | 0.06261971431249193 | 0.1027390300569433 | 0.003480800025287278 | 1.232154141463155 | Total (%)
P/L | 1779.666812501284 | 718.3848387519356 | 1027.73597372063 | -132.0055250525256 | 1344.473620568939 | -239.3894239996334 | 1145.021066044654 | 1632.322799677437 | 1430.562597307642 | 1152.158234166636 | 2008.69674708815 | 75.0465504618769 | 11942.67429123702 | Profit (£)
D/D | 0.0169999999999999 | -0.02000000000000002 | -0.02000000000000002 | -0.05880800000000008 | -0.02978683905051016 | -0.08071254965439989 | -0.03625703965571414 | -0.00334000000000001 | -0.01999999999999991 | -0.02000000000000002 | -0.01999999999999991 | -0.02978683905050972 | -0.08071254965439989 | [NAME]
Year 3 | 0.02396000002580317 | 0.003480800025287102 | -0.01658881597521868 | 0.0413673200262418 | 0.05907056446668799 | 0.003480800025287156 | 0.02739148759436839 | 0.04136732002624199 | 0.102739030056943 | -0.03302735100808099 | 0.04485714288347279 | 0.006843657842481189 | 0.3421804555317781 | Total (%)
P/L | 518.3791708382705 | 77.1121467275807 | -368.7806937601417 | 904.3682703569939 | 1344.816398459665 | 83.92586889378799 | 662.7373685170169 | 1028.298469443856 | 2659.507437403128 | -942.7840707535979 | 1238.181447767416 | 197.3776111728184 | 7403.139425066795 | Profit (£)
D/D | -0.03960000000000008 | -0.07763184000000001 | -0.04600475816175997 | -0.04919110226949974 | -0.02653546751199998 | -0.06195158128 | -0.05236680398791949 | -0.06183040966984876 | -0.02000000000000002 | -0.0776318399999999 | -0.05553189886259968 | -0.03959999999999997 | -0.07763184000000001 | [NAME]
Year 1 |  |  |  |  |  |  |  |  | Profit (£) | Gain (%)
 |  |  |  |  |  |  |  | Account Balance | 9692.516455007302 | 0.6154194091678837
 |  |  |  |  |  |  |  | Peak Drawdown | -0.1376638608541694
 |  |  |  |  |  |  |  | Losing Streak
 |  |  |  |  |  |  |  | Winning Streak
Spreadsheet: 82007d1282079392-matching-rows-in-excel-and-finding-out-duplicate-rows-contacts_records-2-
Sheet: Company_Records

Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA1 | 123-456-567 | www.bigdesign.com
Big Design | Stephen | Gills | Director | 12 NY, USA | 123-456-568 | www.bigdesign.com
Big Design | [NAME] | McKay | CEO | 13 NY, USA | 432-455-354 | www.bigdesign.com
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
ABC LLC | [NAME] | Fard | Technician | 415 M Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 453-989-877 | www.abc.com
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000 | www.futureltd.com
Future Ltd | [NAME] | Farris | CFO | 34, New Zeland | 103-340-009 | www.futureltd.com
Digital Torch | Jet | [NAME] | Technician | 12, Australia | 124-009-007 | www.digital.com
Digital Torch | Johny | Mac | Designer | 12, Australia | 124-009-008 | www.digital.com
Digital Torch | [NAME] | Rid | [NAME] | 12, Australia | 124-009-009 | www.digital.com
In sheet1: I have these records: (Company Records)
In sheet 2: I have these records: (All Records)
In sheet 2 i have all the contacts that includes personal contacts, company contacts etc plus in few records there is no company name, address etc
(a)Now in sheet 3 i want those records (with complete row i.e. all fields) from sheet 2 that matches with records in sheet 1 (matching will be based on First Name, Last Name & CompanyName)
(b) In addition to that the records which are in sheet 2, i am not sure if they are correct or not,
so if any row (from sheet 2) matches with row(in sheet 1)[on bases of 3 fields that i mentioned above] i want Address, website and JobTitle (in resultant sheet 3) to be updated according to sheet 1
How to do that ? please guide me....as i have 10,000 records and manually doing each one is not possible....
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: 10

Name | lbs | oz | Oz (total) | Points
 | 14 | 0
 | 26 | 2
 | 15 | 0
 | 4 | 4
 | 3 | 12
 | 24 | 0
 | 13 | 0
 | 7 | 8
 | 3 | 14
 | 13 | 4
 | 9 | 0
 | 27 | 10
 | 0 | 6
 | 15 | 2
 | 28 | 0
 | 1 | 4
 | 9 | 8
 | 0 | 0
 | 10 | 14
 | 0 | 0
 | 2 | 3
 | 13 | 5
Spreadsheet: 789290d1659026543-formula-to-match-a-value-in-a-column-and-then-write-its-adjacent-cell-value-sample-file-7
Sheet: Sheet1

2022-05-01 00:00:00
 |  |  | 2022-05-02 00:00:00 | 1
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4 |  |  | Expected Results
 |  |  |  | 5 |  | 2022-05-03 00:00:00
 |  |  |  | 6
 |  |  | 2022-05-03 00:00:00 | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 11
 |  |  |  | 12
 |  |  | 2022-05-04 00:00:00 | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
 |  |  | 2022-05-05 00:00:00 | 19
 |  |  |  | 20
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  | 2022-05-06 00:00:00 | 25
Spreadsheet: 818147d1676622160-formula-to-categorize-transactions-based-off-description-test-1-
Sheet: List

Detailed Description | Category*
HOMESENSE 107 | Home Products
UBER CANADA/UBERTRIP | Transportation
Sobeys 750 | Food
SHOPPERS DRUG MART #08 | Health / Personal
Sobeys 52 | Food
HOMESENSE 1112 | Home Products
SHOPPERS DRUG MART #15 | Health / Personal
 | *These are the results I want from the formula
Detailed Description | Category
HOMESENSE 107 | Home Products
UBER CANADA/UBERTRIP | Transportation
Sobeys 750 | Food
SHOPPERS DRUG MART #08 | Health / Personal
Sobeys 52 | Food
HOMESENSE 1112 | Home Products
SHOPPERS DRUG MART #15 | Health / Personal
Spreadsheet: 181625d1348086505-total-of-x-by-looking-up-a-to-pull-total-from-b-c-whatimtryingtodo
Sheet: Sheet1

CAR TYPE | PRICE | delivery
CORSA | 100 | 150
CORSA | 100 | 150
ASTRA | 100 | 170
CORSA | 100 | 170
MEGANE | 100 | 200
CORSA TOTAL =
ASTRA TOTAL =
Spreadsheet: 235084d1368334116-populate-data-based-on-changing-criteria-book2
Sheet: Sheet1

 | Branch | Dallas | New York | New Jersey | Chicago
 | Address | J Street | F Street | Y Street | Q Street
 | No of Staff | 4 | 5 | 4 | 9
 | Production | 49000 | 76000 | 32000 | 65000
Spreadsheet: geir_solberg__11250__5_10act
Sheet: EPEData

 | 37117.88611111111
 | NEWMAN 1 ,UNAV,  0  , 68  , 39  , 83  ,  0  ,1
 | NEWMAN 2 ,MANL, 72  , 77  , 37  , 82  ,  0  ,1
 | NEWMAN 3 ,ECON, 90  , 98  , 35  ,103  ,  9  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,ECON,210  ,214  , 86  ,214  ,  4  ,1
 | NEWMAN   ,, 373 ,  389,  158, 399 ,  13 ,
 | COPPER   ,MANL, 65  , 69  , 15  , 69  ,  0  ,1
 | RIOGRAN 6,UNAV,  0  , 40  , 28  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 40  , 32  , 30  , 49  ,  0  ,1
 | RIOGRAN 8,MANL, 89  , 90  , 60  ,151  ,  0  ,1
 | RIOGRANDE,, 129 ,  122,   90, 200 ,   0 ,
 | PALOVERDE,MANL,390  ,390  ,390  ,600  ,  0  ,1
 | FOURCRNRS,[NAME]  ,101  ,101  ,104  ,  0  ,1
 | LAMBDA, 53.67,  727,  754,   73,    1,   27,29385,94
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1