tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 50512d1249976739-need-help-get-random-of-range-values-from-database-sheet-quiz1
Sheet: Intro

What is your name? |  |  | Forum Member |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 74 105 68 40 36 161 165 91 172 128 51 131 158 170 140 | 172 | 172 | 7 | 73 | 44 | 16 | 119 | 176 | 6 | 20 | 68 | 74 | 183 | 54 | 4 | 182 | 76
How many questions do you want to answer? |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 119
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 176
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 183
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 182
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76
Spreadsheet: 21434d1208962695-removing-a-space-at-the-end-of-numerous-cells-removing-spaces-from-multiple-cells
Sheet: sheet1 (2)

Month | Value1 | Value2 | Value3 |  | Multiplied by 2
Dec 2004 | 2190.28 | 383.30 | 2,573.58 |  | #N/A
Jan 2005 | 3,068.72 | 537.03 | 3605.75 |  | 7211.5
Feb 2005 | 2,958.84 | 517.80 | 3,476.64
Mar 2005 | 4,195.21 | 734.16 | 4,929.37
Apr 2005 | 5,181.88 | 906.83 | 6,088.71
May 2005 | 2,640.58 | 462.10 | 3,102.68
Jun 2005 | 1,274.19 | 222.98 | 1,497.17
Jul 2005 | 2,421.72 | 423.80 | 2,845.52
Aug 2005 | 2,190.35 | 383.31 | 2,573.66
Sep 2005 | 2,711.93 | 474.59 | 3,186.52
Oct 2005 | 2,204.93 | 385.86 | 2,590.79
Nov 2005 | 4,353.11 | 761.79 | 5,114.90
Dec 2005 | 6,269.63 | 1,097.19 | 7,366.82
Jan 2006 | 3,421.03 | 598.68 | 4,019.71
Feb 2006 | 12,580.98 | 2,201.67 | 14,782.65
Mar 2006 | 15,509.63 | 2,714.19 | 18,223.82
Apr 2006 | 7,218.40 | 1,263.22 | 8,481.62
May 2006 | 6,234.87 | 1,091.10 | 7,325.97
Jun 2006 | 9,568.72 | 1,674.53 | 11,243.25
Jul 2006 | 7,127.53 | 1,247.32 | 8,374.85
Aug 2006 | 7,231.82 | 1,265.57 | 8,497.39
Sep 2006 | 7,799.17 | 1,364.85 | 9,164.02
Oct 2006 | 6,249.01 | 1,093.58 | 7,342.59
Nov 2006 | 7,830.60 | 1,370.36 | 9,200.96
Dec 2006 | 4,949.31 | 866.13 | 5,815.44
Jan 2007 | 3,594.51 | 629.04 | 4,223.55
Feb 2007 | 3,167.70 | 554.35 | 3,722.05
Mar 2007 | 6,825.10 | 1,194.39 | 8,019.49
Apr 2007 | 4,322.82 | 756.49 | 5,079.31
May 2007 | 7,772.39 | 1,360.17 | 9,132.56
Jun 2007 | 7,798.74 | 1,364.78 | 9,163.52
Jul 2007 | 7,381.00 | 1,291.68 | 8,672.68
Aug 2007 | 11,273.17 | 1,972.80 | 13,245.97
Sep 2007 | 8,315.09 | 1,455.14 | 9,770.23
Oct 2007 | 11,744.17 | 2,055.23 | 13,799.40
Nov 2007 | 16,915.23 | 2,960.17 | 19,875.40
Dec 2007 | 6,654.32 | 1,164.51 | 7,818.83
Jan 2008 | 4,205.23 | 735.92 | 4,941.15
Feb 2008 | 7,102.94 | 1,243.01 | 8,345.95
Spreadsheet: 859934d1708153173-sum-across-multiple-columns-meeting-3-criteria-v-month-on-month-balances-demo
Sheet: Summary

 |  | 2023-04-30 00:00:00 | 2024-01-31 00:00:00 | Total
 | Income
Main Heading | - Auctions
Sub Heading | Auction
Sub Heading | AutoKart
 | =SUM(FILTER(T!F2:I20,(T!D2:D20=Summary!A5)*(T!E2:E20=Summary!A6)*(T!A2:A20=Summary!B3)*(T!F3:I3=Summary!A7)))
 | =SUM(FILTER(T!F2:I20,(T!D2:D20=Summary!A5)*(T!E2:E20=Summary!A6)*(T!A2:A20=Summary!C3)*(T!F3:I3=Summary!A7)))
 | Auction | -6006.172172661868 | -59239.85271942443
 | AutoKart | -53.52517985611511 | -779.5125572978906
 | Could you pls. help me pull the data from (Sum from all the column meeting conditions) from "T" worksheet based on following 3 criteria
 | 1 | Main Heading
 | 2 | Sub Heading
 | 3 | Month Criteria
Spreadsheet: 14ba60b2-2966-4a47-a4b9-5662945f3151
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | State owned and managed Indigenous housing 2008–09
 | General notes
 | Summary data items
 | Performance indicators
 | P1 Amenity/location |  |  |  |  | [NAME] satisfaction
 | [NAME] |  |  |  |  | P8 Net recurrent cost per dwelling
 | [NAME] of dwelling to household size |  |  |  |  | P9 Occupancy rate
 | P4 Low income |  |  |  |  | P10 Turnaround time
 | P5 Special needs |  |  |  |  | P11 Rent collection rate
 | P6 Priority access to those in greatest need
 | Any enquiries about or comments on this data should be directed to:
 | Housing Unit
 | Australian Institute of Health and Welfare
 | GPO Box 570
 | Canberra ACT 2601
 | Phone: (02) 6244 1267
 | [NAME]: [EMAIL]
 | © Australian Institute of Health and Welfare 2009
 | Suggested citation
 | Australian Institute of Health and Welfare 2009. State owned and managed Indigenous housing 2008–09. Canberra: AIHW. <www.aihw.gov.au/housing/assistance>.
Spreadsheet: daren_farmer__5962__SMI128reveff061200
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/12/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-12 00:00:00 | SMI 128 | 1745 | 0 |  |  | 1156
1st of month DBQ = 1156/d
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.
Spreadsheet: 731539d1620395754-highlight-date-range-on-calendar-data
Sheet: 309 Issue

 |  |  |  |  |  | 309 - HIRE ISSUE LOG
Date | Customer | Site | Issue | Who attended | Engine hrs | Comments | Summary
2020-02-21 00:00:00 | S-LL | [NAME] | Ad blue fault | OFF |  | Requires topping up only
2020-02-23 00:00:00 | S-LL | [NAME] | Regen issue fault, couldn't manually | CF |  | Restarted shredder next day.  All okay CAT not req'd
2020-03-13 00:00:00 | S-LL | [NAME] | Low fuel warning/faulty gauge | OFF |  | Miscommunication onsite. Shredder running okay all morning.  Just needed topped up  - not empty & not faulty gauge
2020-03-15 00:00:00 | S-LL | [NAME] | CAT issue.  Replaced ARD head | CF |  | Enginer derating.  CAT attended site 15/03/20.
2020-03-25 00:00:00 | S-LL | [NAME] | Air intake fault | OFF |  | Check & clean air filter
2020-03-29 00:00:00 | S-LL | [NAME] | Fault 40 | OFF |  | Unplug from valve block & plug back in.  Fault cleared
2020-03-30 00:00:00 | S-LL | [NAME] | Burst hydraulic hose | OFF |  | Pick up hose from HPS & fill tank w/ oil approx 110L
2020-06-17 00:00:00 | Seat | Lanark | Belt seized | OFF |  | New belt ordered & fit new side skirts.  (Vulcan 29-30/06) 1w delivery for belt
2020-07-17 00:00:00 | S-BB | Bredbury | Overheating radiator | OFF |  | Blow out RAD - MD
2021-07-16 00:00:00 | S-BB | Bredbury | [NAME] | GB |  | [NAME] attended
2020-07-19 00:00:00 | S-BB | Bredbury | Motor issue | OFF |  | Supply & fit new conv drive motor - CS
2021-07-29 00:00:00 | S-BB | Bredbury | [NAME] | GB |  | [NAME] attended
2020-08-03 00:00:00 | S-BB | Bredbury | Oil leak | CF |  | MD + CAT onsite - parts
2020-08-04 00:00:00 | S-BB | Bredbury | Track pump | OFF |  | Offhire due to issues running  Reliability
2020-09-21 00:00:00 | HH | Keny | PVG valve, thermostats | CF | 10682 | CAT attend, part next day del fr Metso, MD on site for days
2020-09-30 00:00:00 | ABC | London | Rubbish not going up conveyor | OFF |  | Height issue with other mahinery on site and how it's loaded
2020-10-13 00:00:00 | ABC | London | Sensor on grease distribution block | OFF |  | Replaced with new sensor
2020-10-03 00:00:00 | ABC | London | Greasing issue | OFF |  | MD attended - all ok
2020-10-05 00:00:00 | ABC | London | Greasing issue | OFF |  | MD
2020-11-11 00:00:00 | ABC | London | Accumulator issue | OFF |  | MD - 1211 - take 4ltr acc to site (acc not used, returned to Core)
2020-11-17 00:00:00 | ABC | London | AA3 controller issue | OFF |  | MD - attend site - OFF HIRED
2020-12-31 00:00:00 | Cash | Hull | ARD head fitted new, gauge in feed fuel line, regen | CF | 10997 | CAT onsite 311220
2021-03-29 00:00:00 | Cash | Hull | DPF injector/ARD issue | CF | 11137 | CAT attended
2021-03-30 00:00:00 | Cash | Hull | ARD head (AGAIN) - Replaced | CF | 11137 | CAT attended
2021-04-26 00:00:00 | Cash | Hull | Regen  - manual regen issue | CF |  | Onsite 260421
Spreadsheet: 3986105e-6c02-4b4f-b5bf-b746c769a1b0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-01-06 09:35:39.290000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.181 | 101.181 | 101.056 | 100.556 |  | and are added to price quote
5.125 | 100.602 | 100.602 | 100.477 | 99.97699999999999
5 | 100.234 | 100.234 | 100.109 | 99.609 |  | Note: | Refer To Price [NAME]
4.875 | 99.38799999999999 | 99.38799999999999 | 99.26299999999999 | 98.76299999999999 |  |  | For all Price Adjs
4.75 | 98.875 | 98.875 | 98.75
4.625 | 97.762 | 97.762 | 97.637
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.625 | 100.545 | 100.545 | 100.42 | 99.92
4.5 | 100.359 | 100.359 | 100.234 | 99.734
4.375 | 100.087 | 100.087 | 99.96199999999999 | 99.46199999999999
4.25 | 99.61399999999999 | 99.61399999999999 | 99.48899999999999 | 98.98899999999999
4.125 | 98.329 | 98.329 | 98.204
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-01-06 09:35:39.290000
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-01-20 09:35:39.290000
30 DAY | 2011-02-04 09:35:39.290000
45 DAY | 2011-02-19 09:35:39.290000
60 DAY | 2011-03-06 09:35:39.290000
90 DAY | 2011-04-05 09:35:39.290000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 695359d1600173734-solved-sumif-through-two-drop-down-list-test
Sheet: Data

 | Week1 |  |  |  |  |  |  | Week2 |  |  |  |  |  |  | Week3 |  |  |  |  |  |  | Week4
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
apple
orange
banana
peach
Week1 | Sunday
Week2 | Monday
Week3 | Tuesday
Week4 | Wednesday
 | Thursday
 | Friday
 | Saturday
Spreadsheet: 99238d1297945284-index-and-match-a-list-excel-example
Sheet: Sheet1

A | B | C | D | E | F
 |  |  |  |  | Top 3
[NAME] | Region | Value |  | Scotland | 12.5
A | Scotland | 10.1 |  |  | 11.9
b | England | 8.2 |  |  | 11
c | Wales | 6.3
d | Ireland | 5.4
e | Scotland | 10.3
f | England | 9
g | Wales | 8
h | Ireland | 7.2
i | Scotland | 4
j | England | 3
k | Wales | 2
l | Ireland | 1
m | Scotland | 12.5
n | England | 11.9
o | Wales | 3 |  |  | Sum of Value
p | Ireland | 6.2 |  |  | Region | [NAME] | Total
q | Scotland | 2 |  |  | England | n | 11.9
r | England | 10 |  |  |  | r | 10
s | Wales | 11 |  |  |  | f | 9
t | Ireland | 10.4 |  |  |  | b | 8.2
 |  |  |  |  |  | j | 3
 |  |  |  |  | England Total |  | 42.1
 |  |  |  |  | Ireland | t | 10.4
 |  |  |  |  |  | h | 7.2
 |  |  |  |  |  | p | 6.2
 |  |  |  |  |  | d | 5.4
 |  |  |  |  |  | l | 1
 |  |  |  |  | Ireland Total |  | 30.2
 |  |  |  |  | Scotland | m | 12.5
 |  |  |  |  |  | e | 10.3
 |  |  |  |  |  | A | 10.1
 |  |  |  |  |  | i | 4
 |  |  |  |  |  | q | 2
 |  |  |  |  | Scotland  Total |  | 38.9
 |  |  |  |  | Wales | s | 11
 |  |  |  |  |  | g | 8
 |  |  |  |  |  | c | 6.3
 |  |  |  |  |  | o | 3
 |  |  |  |  |  | k | 2
 |  |  |  |  | Wales Total |  | 30.3
 |  |  |  |  | Grand Total |  | 141.5
Spreadsheet: 796339d1663229781-any-function-that-can-replace-countifs-sample-sheet
Sheet: Sheet 1

Product name | Currency type
Apple | USD
Apple | HKD
Apple | USD
Orange | HKD
Orange | HKD
Watermelon | USD
Watermelon | HKD
Apple | USD
Watermelon | HKD
Orange | USD
Apple | MOP
Spreadsheet: 127940d1320693275-macro-that-will-insert-rows-with-condition-data
Sheet: 4 HDMA

Loan                     Application ID | HMDA                      Status ID | Loan                Type ID | HMDA Application                   Method | Applicant                  Type ID | Ethnicity Desc | Race Type ID | Race Description | HMDA Status ID
109035011 | 0 | 0 | 0 | 1 | Not Hispanic or Latino | 5 | White | 0
109035011 | 0 | 0 | 0 | 1 | Not Hispanic or Latino | 5 | White | 0
109131612 | 0 | 0 | 0 | 1 | NA | 0 | NA | 0
109162613 | 0 | 0 | 0 | 1 | NA | 0 | NA | 0
109225114 | 0 | 0 | 0 | 1 | Hispanic or Latino | 5 | White | 0
109225114 | 0 | 0 | 0 | 1 | Hispanic or Latino | 5 | White | 0
109255215 | 0 | 0 | 0 | 1 | Hispanic or Latino | 5 | White | 0
109033016 | 0 | 0 | 0 | 1 | Hispanic or Latino | 5 | White | 0
109033016 | 0 | 0 | 0 | 1 | Hispanic or Latino | 5 | White | 0
109039617 | 0 | 0 | 0 | 1 | Not Hispanic or Latino | 5 | White | 0
Spreadsheet: 820999d1678379755-replace-maiden-name-with-married-name-aka
Sheet: Sheet1

Name |  | Sales |  |  |  | Reference List: |  | Maiden Name | Married Name
[NAME] |  | 2000 |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  | 1500 |  |  |  |  |  | [NAME] | [NAME]
[NAME] |  | 900
[NAME] |  | 1200
[NAME] |  | 3500
[NAME] |  | 1400
[NAME] |  | 1000
I would like excel to use reference list to either replace maiden names with married name outright:
Name |  | Sales
 |  | 2000
 |  | 1500
 |  | 900
 |  | 1200
 |  | 3500
 |  | 1400
 |  | 1000
or I could add a column for married name which excel would automatically fill:
Name | Married Name | Sales
[NAME] |  | 2000
[NAME] |  | 1500
[NAME] |  | 900
[NAME] |  | 1200
[NAME] |  | 3500
[NAME] |  | 1400
[NAME] |  | 1000
Spreadsheet: 156540d1337342496-pivot-chart-formatting-831905
Sheet: Performance Summary

 | Summary by Week |  |  |  |  |  |  |  | Summary by [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reader | 1 | 4 |  |  | Columns |  |  |  | Lines
 | Week Commencing | Impressions. | Clicks. | CTR | [NAME] | Total Client Cost | [NAME] |  | [NAME] | Impressions. | Clicks. | CTR | [NAME] | Total Client Cost | [NAME] |  |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
 | 2012-03-05 00:00:00 | 144252 | 567 | 0.003930621412528076 | 0.3769841269841273 | 231.08085 | 2.068941297174389 |  | Brand | 555231 | 1363 | 0.002454834114089451 | 0.6540498899486431 | 963.7503875999995 | 1.96530364839139 |  |  |  |  |  |  | Impressions.
 | 2012-03-12 00:00:00 | 230441 | 1001 | 0.004343845062293602 | 0.4268131868131868 | 461.8806192000008 | 1.831401313134381 |  | Brand + Product | 30548 | 975 | 0.03191698310855048 | 0.1258564102564103 | 132.6593267999999 | 1.00098042425036 |  |  |  |  |  |  | Clicks.
 | 2012-03-19 00:00:00 | 211086 | 770 | 0.003647802317538823 | 0.4846623376623375 | 403.4482452000008 | 1.90110471561354 |  | Grand Total | 585779 | 2338 | 0.003991266330817595 | 0.433781009409753 | 1096.409714399999 | 1.915014809339358 |  |  |  |  |  |  | CTR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ave CPC
Spreadsheet: 28a68d1d-e5c4-49b4-b3e8-1af23c1bcdc8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 | Fig. 13.2.26 - Distribution of farmers market per province. Veneto. Year 2010
 | Source: [NAME] indagine diretta data (2009)
 | Distribution of farmers market per province. Veneto. Year 2010
 | Belluno | 0
 | Treviso | 8
 | Padova | 6
 | Rovigo | 3
 | Venezia | 15
 | [NAME] | 3
 | [NAME] | 11
 | Source: [NAME] indagine diretta data (2009)
Spreadsheet: 45560d1244312254-inefficient-data-compilation-compilelist
Sheet: Sheet1

Assessed Object | Value on Day 1
Car | 52000
Boat | 70000
House | 500000
dog | 10
monkey | 90
road | 300
chicken | 40
shoes | 80
computer | 1000
plant | 70
slot machine | 600
table | 300
chair | 50
T.V. | 8000
apple | 5
mattress | 50
fountain | 350
soccerbal | 20
pots | 100
tiles | 700
football | 20
parrot | 90
zebra | 400
lion | 2000
Spreadsheet: 1fe98130-b1a4-471d-85f9-88d59326acaf
Sheet: 11c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency Basis | 14 | 16 | 54 | 79 | 149 | 126 | 124 | 13 | 575
Cross-Currency Fixed-Fixed | 21 | 0 | 6 | 2 | 14 | 20 | 9 | 0 | 72
Cross-Currency Fixed-Float | 32 | 0 | 94 | 117 | 173 | 60 | 6 | 0 | 482
TOTAL
Spreadsheet: 124550d1318455106-excel-2007-invoice-data-lookup-order-template-wip
Sheet: MaryKayCheek

[NAME]
Facial Highlighting Pen | Shade 1 | 18 | Facial Highlighting Pen
Mineral Highlighting Powder | [NAME]
Mineral [NAME] | Shade 3
Mineral Cheek Color | Shade 4
Cream Blush | Pink Porcelain | 12 | Mineral Highlighting Powder
 | [NAME]
 | [NAME] |  | Mineral [NAME]
 | [NAME]
 | [NAME]
 | Sandstone
 | [NAME] | 10 | Mineral Cheek Color
 | [NAME]
 | [NAME]
 | [NAME]
 | Citrus Bloom
 | Golden Copper
 | [NAME]
 | Sparkling Cider
 | [NAME]
 | Sunny Spice
 | [NAME] | 13 | Cream Blush
 | [NAME]
Spreadsheet: 824676d1680767100-dynamic-sumif-dynamtic-sumif
Sheet: Sheet1

Type | Amount |  |  |  |  |  | Amount
Car | 100 |  |  |  |  | Car | 1100
Car | 200 |  |  |  |  | Boat | 411
Car | 300 |  |  |  |  | House | 11
Boat | 400 |  |  |  |  | Plane | 222
Car | 500
House | 11
Boat | 11
Plane | 222
Spreadsheet: 770827d1646294961-calculate-birthdays-via-hours-old-book-4
Sheet: Sheet1

Name | Hours Old | [NAME] |  | Reference date | 2022-03-03 00:00:00
Name1 | 105918
[NAME] | 128224
Name3 | 137466
Name4 | 81784
Name5 | 143955
Name6 | 143954
Name7 | 131461
Name8 | 87134
Name9 | 29117
Name10 | 145709
Spreadsheet: 851234d1701452427-vlookup-formula-or-let-sample-data-for-lookup-2-
Sheet: Data2

Load # | SHPG_LOC_CD | EXTL_CD2
1005451507 | 3007535 | VENDOR-Z002
1005451507 | 3008555 | VENDOR-Z003
1007006478 | 3013754 | VENDOR-Z002
1007006478 | 3015153 | VENDOR-Z003
1007056747 | 3409486 | VENDOR-Z002
1007056747 | 3410590 | VENDOR-Z006
1007081479 | 3409486 | VENDOR-Z006
1007081479 | 3008555 | VENDOR-Z009
1007269620 | 3017222 | VENDOR-Z006
1007269620 | 3405088 | VENDOR-Z005
1007324559 | 3001386 | VENDOR-Z002
1007324559 | 3014643 | VENDOR-Z003
1004777041 | 3002333 | VENDOR-Z002
1004793253 | 3403248 | VENDOR-Z003
1004802420 | 3002333 | VENDOR-Z002
1004804390 | 3009210 | VENDOR-Z006
1004810152 | 3405882 | VENDOR-Z006
1004816909 | 3002333 | VENDOR-Z009
Spreadsheet: 710331d1608847257-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: June

Employee Absence Schedule
June | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 699243d1602500157-add-cell-reference-at-the-end-of-existing-formulas-add-formula
Sheet: Sheet1

 | 0.001 | Multiplier
 |  |  |  |  | An example of forumals where I want to add a reference to: =Sheet1!$B$3 |  |  |  |  |  |  | Data spread across 30 sheets, all with different formulas
 |  |  |  |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar
 |  |  |  |  |  |  |  |  |  |  |  | Value 1 | 1000000 | 2000000 | 3000000
 |  |  |  |  |  |  |  |  |  |  |  | Value 2 | 2000000 | 3000000 | 4000000
 |  |  |  |  |  |  |  |  |  |  |  | Value 3 | 3500000 | 4500000 | 5500000
 |  |  |  |  | What I have today |  |  | What I want to achieve:
 |  |  |  |  | Formula 1 |  |  | Formula 1
 |  |  |  |  | Formula 2 |  |  | Formula 2
 |  |  |  |  | Formula 3 |  |  | Formula 3
 |  |  |  |  | Formula 4 |  |  | Formula 4
 |  |  |  |  | [NAME] n |  |  | [NAME] n
Spreadsheet: 657727d1-4e93-4b1d-87a1-441e1d38a150
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
AMPHB | Test | AMPHB | Amphotericin B, HPLC | Amphotericin B | High Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Draw blood in a plain, red-top tube(s). (Serum gel tube is not  acceptable.) Spin down and send 2 mL of serum frozen in  amber vial (Mayo Supply T192) to protect specimen from light. | 0.5 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | Amphotericin B steady-state peak levels after intravenous administration:    Mean adult peak level (3 mg/kg as sulfate): 2.6 mcg/mL  Mean adult peak level (4 mg/kg as sulfate): 2.9 mcg/mL  Mean adult peak level (1 mg/kg as lipid): 12.2 mcg/mL  Mean adult peak level (2.5 mg/kg as lipid): 31.4 mcg/mL  Mean adult peak level (5 mg/kg as lipid): 83.0 mcg/mL  Test Performed By:  Focus Diagnostics, Inc.                                        5785 Corporate Ave.                                        Cypress, CA 90630-4750 | Monday, Thursday | 5-6 days | 7-14 days | 1 | 80299 |  |  |  |  | Focus Diagnositics, Inc.
AMPHB | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
AMPHB | Result | Z0580 | Amphotericin B | Amphotericin B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 78043d1278501873-copying-rows-and-cells-of-qualified-information-workbook-to-martin
Sheet: Key Sheet

 |  | [NAME] : I think I have duplicated what you sent over before to create this "Key" worksheet. However, please review it for acuracy.
Spreadsheet: 715048d1611519657-finding-the-duplicate-occurrences-and-displaying-their-frequency-in-descending-order-desired-solution-example-1-
Sheet: DESIRED SOLUTION

16 | 12 |  |  |  |  |  |  |  |  |  | 3 | 5 | 3
14 | 1 |  |  |  |  |  |  |  |  |  | 14 | 1 | 2
5 | 3
16 | 43
1 | 14
3 | 5
5 | 3
Spreadsheet: 63734d1264611050-solved-vlookup-or-index-function-book1-pe
Sheet: Ref Table

TAX ID | Billing Area | Practice Name | CITY | STATE | Facility ID | TAXONOMY | LINKED GROUP | MEDICARE #
121212 | 24 | AUSTIN OFFICE | AUSTIN | TX | 2222 | single | NO | 55
232323 | 37 | DALLAS OFFICE | DALLAS | TX | 3333 | single | YES | 66