tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 674540d1587903414-unique-value-count-based-of-multiple-criteria-kv
Sheet: NB

FLAG | TYPE | BRANCH | POL | SA | DOC1 | DOC2 | NAME | PREM | PLAN | MODE | DOB | AG | DO | GC
NB | O | 28 L001 | 344634736 | 970000 | 20190813 | 20190813 | XYZ | 97802 | 999 | V | 19940601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344634737 | 970000 | 20190813 | 20190813 | XYZ | 97802 | 999 | S | 19940601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344634733 | 970000 | 20190813 | 20190813 | XYZ | 98008 | 999 | K | 19800601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344634739 | 110000 | 20190813 | 20190813 | XYZ | 2942 | 999 | V | 19940601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344634796 | 911000 | 20190822 | 20190822 | XYZ | 8200 | 999 | S | 19710601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344634797 | 900000 | 20190822 | 20190822 | XYZ | 46900 | 999 | K | 19820101 | 0026628X | 8034 | N
NB | O | 28 L001 | 344634793 | 91000 | 20190822 | 20190822 | XYZ | 702240 | 999 | V | 19190601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344666926 | 60000 | 20120121 | 20120121 | XYZ | 4400202 | 999 | S | 19710601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344666927 | 60000 | 20120121 | 20120121 | XYZ | 44268 | 999 | K | 19710601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344744244 | 900000 | 20120331 | 20120331 | XYZ | 900202 | 999 | V | 19710601 | 0026628X | 8034 | Y
NB | O | 28 L001 | 344744261 | 100000 | 20120331 | 20120331 | XYZ | 4044 | 999 | S | 19710601 | 0026628X | 8034 | Y
NB | O | 28 L001 | 344744264 | 900000 | 20120331 | 20120331 | XYZ | 90207 | 999 | K | 19721228 | 0026628X | 8034 | Y
NB | O | 28 L001 | 344744263 | 100000 | 20120331 | 20120331 | XYZ | 4789 | 999 | V | 19820601 | 0026628X | 8034 | Y
NB | O | 28 L001 | 344744272 | 100000 | 20120331 | 20120331 | XYZ | 46202 | 999 | S | 19870201 | 0026628X | 8034 | Y
NB | O | 28 L001 | 344744439 | 100000 | 20120331 | 20120331 | XYZ | 20000 | 999 | K | 19940601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344744490 | 100000 | 20120331 | 20120331 | XYZ | 20809 | 999 | V | 19960601 | 0026628X | 8034 | N
NB | O | 28 L001 | 344627334 | 110000 | 20190130 | 20190130 | XYZ | 78666 | 999 | S | 19810601 | 271811 | 8034 | N
NB | O | 28 L001 | 344643301 | 130000 | 20190923 | 20190923 | XYZ | 90077 | 999 | K | 19780311 | 271811 | 8034 | N
NB | O | 28 L001 | 344643302 | 900000 | 20110923 | 20190923 | XYZ | 7268 | 999 | V | 19780311 | 271811 | 8034 | N
NB | O | 28 L001 | 344643301 | 130000 | 2010901 | 20200123 | XYZ | 90077 | 999 | K | 19810311 | 271811 | 8034 | N
NB | O | 28 L001 | 344643302 | 900000 | 20190923 | 20191023 | XYZ | 7268 | 999 | V | 19800311 | 271811 | 8034 | N
Spreadsheet: 746747d1631001247-count-the-number-of-books-i-need-based-on-all-the-classes-that-need-this-book-book1
Sheet: Sheet1

3Aec 3Antw 3Amt 3Alat 3Antwsp 3Kabv 3Kdans
3Tsport 3Tmawe 3Tet
4a 4t 4k
5/6K+5/6TEI+5losp+5stw+ 5/6A behalve [NAME] lawe + 5/6 sport wet
6losp 6stw
6stw 6losp 6Tet
3T sport | 17
3T mawe | 10
3T et | 2
TOTAAL=
3Aec | 15
3Antw | 13
3Amt | 5
3Alat | 2
3Antwsp | 0
TOTAAL=
Spreadsheet: john_arnold__15457__prc
Sheet: BO J&K052501

Full Name | Peer Group | Position Description | [NAME] | 2001 Mid-Year Pre-Ranking
Quigley, [NAME] | C | Associate | Mr. [NAME] | 3
Maggi, [NAME] | C | Dir Trading | Mr. [NAME] | 3
May, [NAME] | C | Dir Trading | Mr. [NAME] | 1
Disturnal, [NAME] | C | Dir Trading | Mr. [NAME] | 2
Griffith, [NAME] | C | Mgr Trading | Mr. [NAME] | 3
[NAME], Ina  R | CS | [NAME] | Mr. [NAME] | 2
Spreadsheet: mary_fischer__25609__32C-2001
Sheet: E-6.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032C
COMPANY NAME   Enron Building Services Inc. Hldg Co.
ANALYSIS OF PROPERTY, PLANT AND EQUIPMENT
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY: [NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
 |  | 12-31-2000 Balance |  |  |  |  |  | CHARGED TO I/S
 |  | DR/(CR.) |  |  |  | SALES AND OTHER |  |  |  |  |  |  |  | DETAIL OF |  | ENDING
[NAME] |  | BEGINNING |  | ADDITIONS |  | RETIREMENTS |  | DEPR |  | DEPL |  | OTHER |  | OTHER CHANGES |  | BALANCE
 |  | BALANCE |  | DR/(CR) |  | DR/(CR) |  | 1415 |  | 1416 |  | (List Below-A) |  | (List Below-B) |  | DR/(CR)
Natural Gas Transmission
Electric Generation & Distribution
Construction In Process
O & G Properties
Other
Gross PP & E
Accumulated DD & A
Net PP & E |  |  | * |  | ** |  | ** |  |  |  |  |  |  |  |  |  | *
 |  |  |  |  | ** Pertains to amounts related to normal |  |  |  |  |  |  | (A) |  | (B) | * | [NAME] TO
 |  |  |  |  | operations.  Unusual amounts should be shown |  |  |  |  |  |  |  |  |  |  | HYPERION LINE
 |  |  |  |  | under "Other Changes" with appropriate explanations. |  |  |  |  |  |  |  |  |  |  | NET_TOT_PPE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Asset/Exp  DR/(CR)
 |  |  |  |  |  |  | DETAIL OF OTHER CHANGES     (B)
 |  |  |  |  |  |  |  |  |  |  |  | PP & E |  | ACCUM |  | NET
CHARGED TO OTHER I/S ACCTS     (A) |  |  |  |  |  |  | KEY: |  |  |  |  | DR/(CR) |  | DR/(CR) |  | DR/(CR)
[NAME] |  | HYP ACCT CHGD |  | DR/(CR) |  |  | (PROVIDE DETAIL OF INDIVIDUAL ITEMS
 |  |  |  |  |  |  | IN EXCESS OF $200,000.)
 |  |  |  |  |  |  | (1) Reclassification between property
 |  |  |  |  |  |  | accounts (should net to -0-)
 |  |  |  |  |  |  | (2) Intercompany transfer
 |  |  |  |  |  |  | (list companies):
 |  | TOTAL
 |  |  |  |  |  |  | (3) Acquisition (disposition)
 |  |  |  |  |  |  | of business
 |  |  |  |  |  |  | (4) Foreign currency
 |  |  |  |  |  |  | translation adjustment
 |  |  |  |  |  |  | (5) Lease impairments -
 |  |  |  |  |  |  | Oil & Gas
 |  |  |  |  |  |  | (6) Other (detail):
 |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-6
Spreadsheet: 8d3485eb-d07a-44c5-8ced-738f445781c3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Transmission Fluid Drain/Refill |  |  |  | Total ATF Capacity - Mazda Millenia
 | Replacement Ratio Calculator |  |  |  |  | 2.5L [KL] | 2.3L [KJ]
 |  |  |  |  | US Quarts | 8.5 | 7.8
 | Total ATF Capacity: | 7.8 |  |  | Imperial Quarts | 7 | 6.5
 | Amount Replaced: | 4 |  |  | Liters | 8 | 7.4
 | Change #1 | 0.5128205128205129
 | Old ATF Remaining | 0.4871794871794871
 | Change #2 | 0.762656147271532
 | Old ATF Remaining | 0.237343852728468
 | Change #3 | 0.8843709435425412
 | Old ATF Remaining | 0.1156290564574588
 | Change #4 | 0.9436678955720073
 | Old ATF Remaining | 0.05633210442799275
 | Change #5 | 0.9725561542530292
 | Old ATF Remaining | 0.02744384574697079
 | Change #6 | 0.9866299213027578
 | Old ATF Remaining | 0.01337007869724216
 | Change #7 | 0.9934863719167282
 | Old ATF Remaining | 0.006513628083271827
 | Change #8 | 0.9968266940107138
 | Old ATF Remaining | 0.003173305989286224
 | Change #9 | 0.998454030415476
 | Old ATF Remaining | 0.001545969584524021
 | Change #10 | 0.9992468353306165
 | Old ATF Remaining | 0.0007531646693834659
Spreadsheet: 712044d1610029807-sum-if-cell-reference-question-project-cash-flow-test-document
Sheet: Sub Contract Labour

 | Sub Contract Labour
 | PO No. | Purchase Date | Terms | Due Date | Value
 | ME Engineering | 2020-04-21 00:00:00 | 30 |  | 15000
 | ME Engineering | 2020-05-21 00:00:00 | 30 |  | 11200
 | ME Engineering | 2020-06-21 00:00:00 | 30 |  | 1200
 | ME Engineering | 2020-07-21 00:00:00 | 30 |  | 1200
 | ME Engineering | 2020-08-21 00:00:00 | 30 |  | 1200
 | ME Engineering | 2020-09-21 00:00:00 | 30 |  | 1200
 | ME Engineering | 2020-10-21 00:00:00 | 30 |  | 1200
 | ME Engineering | 2020-11-21 00:00:00 | 30 |  | 1200
 | ME Engineering | 2020-12-21 00:00:00 | 30 |  | 1200
 | ME Engineering | 2021-01-21 00:00:00 | 30 |  | 1200
 | ME Engineering | 2021-02-21 00:00:00 | 30 |  | 1200
 | Maitland QS | 2020-04-21 00:00:00 | 30 |  | 1500
 | Maitland QS | 2020-05-21 00:00:00 | 30 |  | 2750
 | Maitland QS | 2020-06-21 00:00:00 | 30 |  | 2750
 | Maitland QS | 2020-07-21 00:00:00 | 30 |  | 2750
 | Maitland QS | 2020-08-21 00:00:00 | 30 |  | 2750
 | Maitland QS | 2020-09-21 00:00:00 | 30 |  | 2750
 | Maitland QS | 2020-10-21 00:00:00 | 30 |  | 2750
 | Maitland QS | 2020-11-21 00:00:00 | 30 |  | 2750
 | Maitland QS | 2020-12-21 00:00:00 | 30 |  | 2750
 | Maitland QS | 2021-01-21 00:00:00 | 30 |  | 1500
 | Axflow | 2020-07-21 00:00:00 | 30 |  | 38974.31
 | [NAME] | 2020-08-21 00:00:00 | 45 |  | 33000
 | [NAME] | 2020-12-21 00:00:00 | 45 |  | 2000
 | D and M | 2020-06-21 00:00:00 | 60 |  | 30000
 | D and M | 2020-07-21 00:00:00 | 60 |  | 70000
 | D and M | 2020-08-21 00:00:00 | 60 |  | 80000
 | D and M | 2020-09-21 00:00:00 | 60 |  | 70000
 | D and M | 2020-10-21 00:00:00 | 60 |  | 1100
 | Chimflue | 2020-09-21 00:00:00 | 45 |  | 7152
 | Crabtree | 2020-07-21 00:00:00 | 60 |  | 30000
 | Crabtree | 2020-08-21 00:00:00 | 60 |  | 30000
 | Crabtree | 2020-09-21 00:00:00 | 60 |  | 17888
 | Hasman | 2020-10-21 00:00:00 | 45 |  | 8400
 | [NAME] | 2020-11-21 00:00:00 | 60 |  | 13775
 | PH Water | 2020-10-21 00:00:00 | 45 |  | 15000
Spreadsheet: 71620d1272380964-looking-up-a-value-copy-of-xls-problem
Sheet: datasheet

A/P | Area |  | column B should
ATL | [NAME] |  | give the output based on sheet: LIST with a/p
[NAME] | [NAME] |  | ATL=AREA 1
LUX | #N/A |  | LUX=AREA 2
ACC | AREA2 |  | ACC=AREA 2
SIN | AREA3 |  | SIN=AREA 3
HKG | AREA3
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: 2019

 |  |  |  |  |  |  | 2019
 |  |  |  |  |  |  |  | Number   of       Walks | Total   Miles | Total Height | Total   Hours  Walked | Average Speed
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Will
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Sophie
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | [NAME]
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: PNM

PNM imbalance
 | Measured | Scheduled | Imbalance
9236 |  | -40275
9238 |  | -20000
56422 |  | -1499052
58710 | -4946 | -31877
60921 |  | -1401360
78026 |  | 11000
500084 |  | -60000
500085 | -3596
500097 |  | -82961
INDEX
2002-01-31 00:00:00 |  |  | 835344.24
2002-02-20 00:00:00
CBS Volume
 |  |  | 340221
Spreadsheet: 733826d1621848628-filtering-with-merged-cells-whilst-displaying-all-data-210524_db_dummy-database
Sheet: Old

 | Category |  | Country |  | Language |  | Subtitles |  | Industry |  | Function |  | Use Case
 | Customer Made Videos |  | Denmark |  | Danish |  | Danish |  | Agriculture |  | Aftersales |  | Change Communication
 | Energy |  | Finland |  | Dutch |  | Dutch |  | Banking |  | Communication |  | Citizen Services
 | Entertainment |  | Germany |  | English |  | English |  | Bio Energy |  | Education |  | Communication
 | Finance |  | Netherlands |  | Finnish |  | Finnish |  | Chain |  | Health and Safety Operations |  | Competence Development
 | Government |  | Norway |  | German |  | German |  | Chemicals |  | HR |  | Culture
 | Industries |  | Sweden |  | Norwegian |  | None |  | Communications and Power |  | IT |  | Customer Communication
 | Insurance |  |  |  | Swedish |  | Norwegian |  | Consulting |  | Management |  | Customer Service
 | IT, Consulting |  |  |  |  |  | Swedish |  | Education |  | Marketing |  | [NAME]
 | Law |  |  |  |  |  |  |  | Entertainment |  | Sales |  | Distributed Workforce
 | Manufacturing |  |  |  |  |  |  |  | Finance |  | Support |  | Education
 | Municipalities |  |  |  |  |  |  |  | Food Products |  | Town Planning |  | External Communication
 | Retail & Trade |  |  |  |  |  |  |  | Food Service |  | Training |  | Guidelines
 | Services |  |  |  |  |  |  |  | Government |  |  |  | Instructions
 | Telecommunications |  |  |  |  |  |  |  | Healthcare |  |  |  | Internal Communication
 | Video as a management tool |  |  |  |  |  |  |  | Infrastructure Networks |  |  |  | IT Instructions
 | Video as a sales tool |  |  |  |  |  |  |  | Installation |  |  |  | Leadership Communication
 | Video in change management |  |  |  |  |  |  |  | Insurance |  |  |  | Mobile Videos
 | Video in learning |  |  |  |  |  |  |  | IT |  |  |  | News
 | Video in marketing |  |  |  |  |  |  |  | Law |  |  |  | Onboarding
 |  |  |  |  |  |  |  |  | Life Sciences |  |  |  | Online Course Material
 |  |  |  |  |  |  |  |  | Machinery |  |  |  | Process Documentation
 |  |  |  |  |  |  |  |  | Manufacturing |  |  |  | Product Marketing
 |  |  |  |  |  |  |  |  | Metal |  |  |  | Production Instructions
 |  |  |  |  |  |  |  |  | Municipality |  |  |  | Recruitment
 |  |  |  |  |  |  |  |  | Pharmaceutical |  |  |  | Safety Guidelines
 |  |  |  |  |  |  |  |  | Public Sector |  |  |  | Scattered Workforce
 |  |  |  |  |  |  |  |  | Real Estate |  |  |  | Screen Recording
 |  |  |  |  |  |  |  |  | Restaurant |  |  |  | System Instruction
 |  |  |  |  |  |  |  |  | Retail |  |  |  | Training
 |  |  |  |  |  |  |  |  | Services
 |  |  |  |  |  |  |  |  | Telecommunications
 |  |  |  |  |  |  |  |  | Trade
 |  |  |  |  |  |  |  |  | Transportation
 |  |  |  |  |  |  |  |  | Ventilation Systems
Spreadsheet: 86518d1286477913-countif-based-on-multiple-criteria-repeat-calls
Sheet: Sheet1

TIME_STAMP | Phone | Agent | Queue | 7 days
2010-09-09 10:43:00 | 5551234567 | agent 1 | queue 1
2010-09-09 11:38:00 | 5551234567 | agent 2 | queue 2
2010-09-12 11:25:00 | 5551234567 | agent 3 | queue 3
2010-09-14 10:19:00 | 5551234567 | agent 4 | queue 4
2010-09-14 11:21:00 | 5551234567 | agent 5 | queue 2
2010-09-14 11:36:00 | 5551234567 | agent 6 | queue 4
2010-09-15 20:12:00 | 5551234567 | agent 7 | queue 2
2010-10-02 17:53:00 | 5551234567 | agent 8 | queue 1
2010-10-04 12:31:00 | 5551234567 | agent 9 | queue 1
2010-10-06 15:36:00 | 5551234567 | agent 10 | queue 2
2010-10-06 17:20:00 | 5551234567 | agent 11 | queue 4
2010-10-06 22:02:00 | 5551234567 | agent 12 | queue 2
Spreadsheet: 827156d1682515650-filter-function-breaks-the-formula-sample-workbook
Sheet: Sheet1

 |  |  |  |  | This works |  |  | This works |  | doesn't work
 | value1 | value2 |  |  | Value | Count |  | Value |  | Value
 | 123 | a
 | 123 | a |  |  | 456 |  |  | 123
 | 456 | a |  |  | 789 |  |  | 456
 | 456 | b |  |  |  |  |  | 789
 | 123 | b
 | 123 | b
 | 789 | a
Spreadsheet: 39cf4942-727d-4a27-8d92-b8b3db190bbc
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
 | 6302.0 Average Weekly Earnings, Australia
 | TABLE 11B. Average Weekly Earnings, Victoria (Dollars) - Trend
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
Earnings; [NAME]; Full Time; Adult; Ordinary time earnings ;  Victoria ; |  |  | Trend | A2828146J | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Full Time; Adult; Total earnings ;  Victoria ; |  |  | Trend | A2828149R | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
Earnings; [NAME]; Total earnings ;  Victoria ; |  |  | Trend | A2828155K | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Ordinary time earnings ;  Victoria ; |  |  | Trend | [NAME] | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
Earnings; Females; Full Time; Adult; Total earnings ;  Victoria ; |  |  | Trend | A2828150X | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
Earnings; Females; Total earnings ;  Victoria ; |  |  | Trend | A2828156L | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Ordinary time earnings ;  Victoria ; |  |  | Trend | A2828148L | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
Earnings; Persons; Full Time; Adult; Total earnings ;  Victoria ; |  |  | Trend | A2828151A | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
Earnings; Persons; Total earnings ;  Victoria ; |  |  | Trend | A2828157R | 1994-08-15 00:00:00 | 2011-11-15 00:00:00 | 70 | $ | RATIO | Quarter | 2
© Commonwealth of Australia  2012
Spreadsheet: 859434d1707828828-if-function-not-working-itworkspart2
Sheet: Sheet1

 |  |  |  |  |  |  |  | IF | IF
 |  |  |  |  |  | 1 | 4
 |  |  |  |  |  | 2
 |  |  |  |  |  | 4
 |  |  |  |  |  | 23
 |  |  |  |  |  | 12 | 2
 |  |  |  |  |  |  | 1
 |  |  |  |  |  | 4 | 3
 |  |  |  |  |  | 56 | 5
 |  |  |  |  |  | 1
 |  |  |  |  |  | 1 | 6
Spreadsheet: 84011d1284018673-cell-function-detecting-color-format-returncolourindex
Sheet: Sheet1

 |  | 6 |  | RichardSchollar
6 |  | 23 |  | View Profile
 |  | 44 |  | View Forum Posts
Yellow 6 |  | 0
 |  | 10 |  | Banned
1 | Yellow | 0 | < N.B.doesn't recognise Conditional Formatting
 |  | 29 |  | Join Date
 |  | 3 |  | 18th September 2005
 |  | 43 |  | Location
 |  | 42 |  | Hampshire, UK
 |  |  |  | Posts:= 1278
 |  |  |  | Re: Use Cell Colour In Formula Without Vba
 |  |  |  | There is a way to do it that uses the XLM4 Macro function GET.CELL (it is a little bit limited though):
 |  |  |  | 1. Go Insert>Name>Define and name this formula that you are about to create "color"
 |  |  |  | 2. In the Refers To box type:
 |  |  |  | 3.Back in the sheet, in the immediately adjacent cell below the one where you want to determine the fill colour type (so yellow cell in A1, then you enter the following in A2):
 |  |  |  | N.B:= I've used "colour" and "InteriorColour"  on this sheet ….Marcol
 |  |  |  | This will return the colorindex of the cell interior (6 is bright yellow in a default installation).
 |  |  |  | So you can use this in a formula to do as you wish eg:
 |  |  |  | Best regards
 |  |  |  | [NAME]
Spreadsheet: 139545d1328291007-extract-data-from-a-simple-table-searchtable
Sheet: Sheet1

 |  | Column | c
 |  | Row | 14
 | a | b | c
1 | 163 | 178 | 216
2 | 216 | 253 | 330
3 | 232 | 247 | 294
4 | 290 | 334 | 431
5 | 161 | 176 | 214
6 | 214 | 251 | 328
7 | 251 | 266 | 314
8 | 322 | 359 | 452
9 | 348 | 363 | 426
10 | 327 | 364 | 459
11 | 264 | 279 | 335
12 | 308 | 323 | 364
13 | 284 | 299 | 355
14 | 390 | 449 | 583
 |  | result | 583
Spreadsheet: df4dec1b-9897-4d9d-9960-3689291b0d8f
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
PERS | Test | PERS | Persimmon, IgE | Persimmon, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel	 [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PERS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PERS | Result | PERS | Persimmon, IgE | Persimmon, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 10947-0
Spreadsheet: 731998d1620739959-extract-data-based-on-a-drop-down-list-selection-version-10
Sheet: Lists

Merchant Code | Merchant |  | Species Code | Species Name | MSC |  | Presentation |  | Grade |  | Part |  | PLN | Vessel |  | Area
WT | [NAME] |  | ANF | MONKFISH |  |  | GH |  | 1 |  | 0.25 |  | BCK35 | CALEDONIA BCK35 |  | 4a
WC | [NAME] |  | BLL | BRILL |  |  | WF |  | 2 |  | 0.5 |  | [NAME] | LIBERTY BF120 |  | 6a
HD | [NAME] |  | CAT | CATFISH |  |  | ROE |  | 3 |  | 0.75 |  | [NAME] | VISION BF191 |  | Other
JPL | JPL Shellfish |  | COD | COD |  |  |  |  | 4 |  |  |  | BF29 | JOLANNA M BF29 |  | 4a, 6
BL | Bells Seafood |  | HAD | HADDOCK | MSC |  |  |  | 5 |  |  |  | BF505 | GENESIS BF505 |  | 4a, Other
PWELL | Pierowall Fish |  | HBT | HALIBUT |  |  |  |  | 6 |  |  |  | BF61 | TRANSCEND BF61 |  | 6, Other
ICEW | [NAME] |  | HKE | HAKE | MSC |  |  |  | U |  |  |  | BF800 | RELIANCE BF800 |  | 4a, 6 & Other
WL | Whitelink Seafoods |  | JOD | JOHN DORY |  |  |  |  | B |  |  |  | INS155 | SHEKINAH INS155
CS | Caithness Smoke House |  | LEM | LEMONSOLE |  |  |  |  |  |  |  |  | INS240 | RADIANCE INS240
OT | Fish In Crieff |  | LEZ | MEGRIM |  |  |  |  |  |  |  |  | K121 | KEILA K121
CPM | Campbells Prime Meat |  | LIN | LING |  |  |  |  |  |  |  |  | PD174 | [NAME]
[NAME] | Captains Galley |  | MAC | MACKEREL |  |  |  |  |  |  |  |  | PD352 | CEOL NA MARA PD352
NS | Norscot Seafoods |  | NEP | NEPHROPS |  |  |  |  |  |  |  |  | UL44 | LOCH INCHARD UL44
KB | Kirkwall Bay Shellfish |  | OCT | OCTOPUS |  |  |  |  |  |  |  |  | [NAME] | BOY [NAME]
PS | Pentland Seafoods |  | PLE | PLAICE
L15 | [NAME] |  | POK | SAITHE | MSC
 |  |  | POL | LYTHE
 |  |  | RJC | SKATE THORNY
 |  |  | RJM | SKATE ROKER
 |  |  | [NAME] | SKATE CUCKOO
 |  |  | SQU | SQUID
 |  |  | SYC | LESSER SPOTTED DOGS
 |  |  | TBT | TURBOT
 |  |  | USK | TUSK
 |  |  | WHG | WHITING
 |  |  | WIT | WITCH
 |  |  | GUR | RED GURNARD
Spreadsheet: 92837d1292365449-vl-lookup-example
Sheet: Melb Stock 14th Dec 10

Stock_prod | Product_na | Stock_pal2 | Stock_quan | Cubic
239525 | TURBO SELECT 6B REAR TRIM KIT | 0.03 | 1
239525 | TURBO SELECT 6B REAR TRIM KIT | 0.03 | 1
ABLBEAN | AMBIENT LOUNGE MESH BAG & BOX | 0.25 | 1
ABLBEAN | AMBIENT LOUNGE MESH BAG & BOX | 1 | 4
ABLBEAN | AMBIENT LOUNGE MESH BAG & BOX | 1 | 4
Spreadsheet: 764826d1643026120-rank-not-correct-working-testing_rank-1-
Sheet: Sheet1

Car-NR | Driver | Co-Driver | START | Finish | Time | Point | Penalty | What it should be
1 | A | K | 09:15:00 | 10:18:00 | 01:03:00 | 63.00000000000001 | 3 | 5
2 | B | L | 09:16:00 | 10:19:00 | 01:03:00 | 62.99999999999994 | 3 | 5
3 | C | M | 09:17:00 | 10:18:00 | 01:01:00 | 61.00000000000002 | 1 | 3
4 | D | N | 09:18:00 | 10:19:00 | 01:01:00 | 60.99999999999994 | 1 | 3
5 | E | O | 09:19:00 | 10:16:00 | 00:57:00 | 57.00000000000004 | 6 | 7
6 | F | P | 09:20:00 | 10:17:00 | 00:57:00 | 56.99999999999996 | 6 | 7
7 | G | Q | 09:21:00 | 10:16:00 | 00:55:00 | 55.00000000000004 | 10 | 9
8 | H | R | 09:22:00 | 10:17:00 | 00:55:00 | 54.99999999999996 | 10 | 9
9 | I | S | 09:23:00 | 10:23:00 | 01:00:00 | 59.99999999999994 | 0 | 1
10 | J | T | 09:24:00 | 10:24:00 | 01:00:00 | 60.00000000000003 | 0 | 1