tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 438076d1451734726-vlookup-to-return-certain-value-from-sheet-a-test2
Sheet: a

 | First Name: | Last Name | Card Number: | Department | Staff No.
 | Visitor | (Airport) | 7030881 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030882 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030883 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030884 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030885 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030886 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030887 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030888 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030889 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030890 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030891 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030892 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030893 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030894 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030895 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030896 | MUK OPERATIONS | Airport
 | Visitor | (Airport) | 7030897 | MUK OPERATIONS | Airport
 | Visitor | (W/D) 1 | 8189268 | MUK OPERATIONS | (W/D) 1
 | Visitor | (W/D) 2 | 8189267 | MUK OPERATIONS | (W/D) 2
 | Visiotr | (W/D) 3 | 8189269 | MUK OPERATIONS | (W/D) 3
 | [NAME] | , | 7965518 | MUK OPERATIONS | 0
 | Ashok | .A | 7031578 | FACILITIES | 0
 | vistor | 37 | 6413751 | MUK OPERATIONS | 122
 | Visitor: | 100 | 8188675 | MUK OPERATIONS | 100
 | VISITOR | 162 | 4269327 | MANAGEMENT | 0
 | [NAME] | A | 4250526 | MUK OPERATIONS | 0
 | Dayraj | A | 8040429 | MUK OPERATIONS | 0
 | Nejimudeen | A | 5449808 | MUK OPERATIONS | 8024
 | Ramesh | A | 6164481 | FACILITIES | 0
 | Thirunavukkarasu | A. | 5445529 | MUK OPERATIONS | 0
 | Dinesh | [NAME] | 6986763 | MUK OPERATIONS | 73833
 | AbdulRahman | A.S | 5665234 | SUPPLY CHAIN | 0
 | [NAME] | AAL AbdulSalam | 6505888 | SUPPLY CHAIN | 59280
 | Mahesh | Aanand J | 7031900 | MUK OPERATIONS | 0
 | Raju | [NAME] | 8728308 | MUK OPERATIONS | 0
Spreadsheet: louise_kitchen__23058__0111MarginRequirements
Sheet: Template

FUTURES MARGIN REQUIREMENTS
2001-11-26 00:00:00
2001-11-23 00:00:00
 | US $$$ |  |  |  |  |  |  |  |  |  |  |  | CANADIAN $$$
Broker | TE | Credit Facility Covering TE | TE Less CreditCoverage | Net Option Value | Initial Margin | Line of Credit Covering Initial Margin (except EDF [NAME] see calc below) | Initial Margin Less Line of Credit Covering Initial Margin |  | Daily Facility Movement Inc/(Dec) Line |  | Wire Day Cash In/(Out) |  | OTE | Initial Margin
ABN-Amro Inc |  |  |  | 0
ADM INVESTOR |  |  |  | 0
BANK ONE |  |  |  | 0
CARR FUTURES (NG) |  |  |  | 0
CARR FUTURES INC. |  |  |  | 0
CREDIT SUISSE FIRST BOSTON |  |  |  | 0
EDF MAN   (see note below)
FIMAT |  |  |  | 0 |  |  |  | 1
HSBC - US$ |  |  |  | 0
HSBC - Canadian | 0 |  |  | 0
JP Morgan |  |  |  | 0
[NAME] |  |  |  | 0
PARIBAS |  |  |  | 0
PRUDENTIAL SI |  |  |  | 0
REFCO, INC |  |  |  | 0
R J O'BRIEN |  |  |  | 0
SAUL STONE & COMPANY |  |  |  | 0
SMITH BARNEY, INC |  |  |  | 0
SMITH BARNEY, INC  (Financial) |  |  |  | 0
TOTAL EXCLUDING MID-DAY CALLS
MID-DAY CALLS: (based solely on Market Movement)
EDF Mann | 0
TOTAL INCLUDING MID-DAY CALLS
 |  | Used Line
Credit Lines: | Line | OTE | Initial Margin | Total Line Used | Total Line Unused
Smith Barney | 50000000 | 0
Smith Barney
1 Includes amounts withheld from payments due Enron.  Fimat's customer agreement states that excess margin including OTE due to Enron must first be used to pay down advances on the facility.
Spreadsheet: 121052d1315814251-auto-generating-entries-based-on-combined-entries-791862-auto-generating-entries-sample
Sheet: Sheet1

 |  |  |  |  |  |  | Each Department has a unique Schedule
Department | Subject Class Code |  | Schedule |  |  |  | Code No. is a dependent value of Subject
 | Subject | Code No. | Type | Period
Dept_A | Code_A | 002 |  |  |  |  | What needs to be done:
Dept_A | Code_A | 003 |  |  |  |  | If Department, [NAME] and Code No. are selected,
Dept_A | Code_B | 001 |  |  |  |  | the Schedule (Type and Period of the specific deparment)
Dept_A | Code_B | 002 |  |  |  |  | are auto-generated.
Entries
Department |  | Subject
Dept_A |  | Code_A
Dept_B |  | Code_B
Dept_C |  | Code_C
Dept_D |  | Code_D
Dept_E |  | Code_E
Subect Class Code |  | Dept_A |  | Dept_B |  | Dept_C |  | Dept_D |  | Dept_E
Subject | Code No. | Type | Period | Type | Period | Type | Period | Type | Period | Type | Period
Code_A | 001 | X | 1 | Y | 3 | Y | 2 | Z | - | Y | 1
Code_A | 002 | Z | - | Z | - | X | 2 | Z | - | Z | -
Code_A | 003 | X | 1 | X | 1 | X | 1 | X | 2 | Y | 1
Code_B | 001 | Y | 2 | Z | - | Z | - | Y | 2 | X | 1
Code_B | 002 | Z | - | X | 1 | X | 1 | Z | - | Z | -
Code_C | 001 | Z | - | X | 1 | X | 1 | Z | - | Z | -
Code_C | 002 | X | 1 | X | 1 | X | 1 | X | 2 | Y | 1
Code_C | 003 | Y | 2 | Z | - | Z | - | Y | 2 | X | 1
Code_C | 004 | Z | - | Z | - | X | 2 | Z | - | Z | -
Code_D | 001 | Z | - | Z | - | X | 2 | Z | - | Z | -
Code_D | 002 | X | 1 | X | 1 | X | 1 | X | 2 | Y | 1
Code_D | 003 | X | 1 | X | 1 | X | 1 | X | 2 | Y | 1
Code_D | 004 | Y | 2 | Z | - | Z | - | Y | 2 | X | 1
Code_E | 001 | X | 1 | X | 1 | X | 1 | X | 2 | Y | 1
Code_E | 002 | X | 1 | X | 1 | X | 1 | X | 2 | Y | 1
Spreadsheet: 72b74e29-7b4b-4fb8-9a39-e9db68e1f7e3
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME] dengan : | SE-27/PJ.22/1986
 |  |  |  |  |  |  |  |  |  | 14 Juni 1986
 | DAFTAR NOMINATIF BIAYA ENTERTAINMENT DAN SEJENISNYA
 | TAHUN PAJAK:
 | No. | Pemberian Entertainment & Sejenisnya |  |  |  |  | [NAME] Diberikan Entertainment & Sejenisnya |  |  |  | [NAME]
 |  | [NAME] | Tempat | Alamat | Jenis | [NAME] (Rp) | Nama | [NAME] | [NAME] | [NAME]
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | dst
 |  |  |  |  |  |  |  |  | …………………………., …………………………………20….
 |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 860886d1708900751-averageiif-for-values-between-a-set-range-50-100-report_etaf
Sheet: 50-100 Test.v2

Greater Than | Up To | [NAME] | Avg -Sht / +Lng | [NAME] From Pin | Avg. Shot Gain | Avg Score | [NAME] from Pin
50 | 55 | -1.2
55 | 60
60 | 65 |  |  |  |  |  |  |  |  |  | In the attached spreadsheet I am looking to solve for the average left/right for a particular golf shot given a target distance. For example, row 14 has a golf shot target that is 52 yards (A14). Column B indicates the left or right variance of the shot. There are a series of shots within the cohort from =>50 yards to <55 yards. If I average their variance it comes out to 1.2 yards. (But, I had to do that manually.
65 | 70
70 | 75
75 | 80
80 | 85
85 | 90
90 | 95
95 | 100
Yards | -Lft / +Rgt | -Sht / +Lng | yrds from Pin
52 | -2 | 5 |  |  | Include
51 | 2 | -5 |  |  | Include
81 | 4 | -2.3
62 | -4 | -6.3
91 | 1 | 3
50 | 0 | 3.6 |  |  | Include
56 | 3 | 1,6
98 | 6 | 5
86 | 5 | -5
56 | -2 | -2.3
56 | 3 | -6.3
95 | -2 | 3
84 | -6 | 3.6
51 | -8 | 1,6 |  |  | Include
52 | 2 | 5 |  |  | Include
83 | 3 | -5
86 | -4 | -2.3
91 | -2 | -6.3
89 | 0 | 3
77 | 0 | 3.6
Spreadsheet: 117907d1313207131-automated-calculation-of-percentages-of-the-row-trend-analysis
Sheet: Sheet1

 | All Accounts |  |  | 100100
 | 2008 | 2009 | 2010 | 2008 | 2009 | 2010
January
February
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 1cc418a4-fc23-4af5-9927-d774f192f3b2
Sheet: Area 6

Location | Title | Name | Mobile | CRCs | CRC Mobile
Area 6 | Area Manager | [NAME] | 07703 469 372
[NAME] | RDO | [NAME] | 07764 960 396 | [NAME] | 07718 706548
 |  |  |  | [NAME] | 07718 706558
 |  |  |  | [NAME] | 07715 856802
East Yorkshire | RDO | [NAME] | 07764 960 401 | [NAME] | 07718 706554
 |  |  |  | [NAME] | 07718 706555
[NAME] | RDO | [NAME] | 07764 960 376 | [NAME] | 07718 706556
 |  |  |  | Richie Young | 07718 706557
 |  |  |  | [NAME] | 07715 856700
West Yorkshire | RDO | [NAME] | 07764 336 702 | [NAME] | 07718 706559
 |  |  |  | [NAME] | 07718 706560
 |  |  |  | [NAME] | 07718 706561
South Yorkshire | RDO | [NAME] | 07764 960 400 | [NAME] | 07718 706565
 |  |  |  | [NAME] | 07718 706566
 |  |  |  | Olly [NAME] | 07718 706567
[NAME] | RDO | [NAME] | 07711 185 219 | [NAME] | 07718 706551
 |  |  |  | [NAME] | 07894 489095
 |  |  |  | [NAME] | 07718 706552
Northumberland | RDO | [NAME] | 07736 517 728 | [NAME] | 07718 706562
 |  |  |  | [NAME] | 07718 706563
 |  |  |  | [NAME] | 07718 706564
Cumbria | RDO | [NAME] | 07711 901 374 | [NAME] | 07718 706 568
 |  |  |  | [NAME] | 07545 921 474
 |  |  |  | [NAME] | 07545 921 473
Area 6 | URDO | [NAME] | 07894 489 755
Area 6 | WRDO | [NAME] | 07841 367 391
Spreadsheet: 226666d1365468590-help-how-to-automatic-reference-and-update-in-master-copy-book1
Sheet: Master Doc

 | Master [NAME]
File type
File | file 1
 | file 2
 | file 3
 | file 4
 | file 5
 | file 6
 | file 7
 | file 8
 | file 9
 | file 10
 | file 11
 | file 12
 | file 13
 | file 14
File A | fileA 1
 | fileA 2
 | fileA 3
 | fileA 4
 | fileA 5
 | fileA 6
 | fileA 7
 | fileA 8
 | fileA 9
 | fileA 10
 | fileA 11
 | fileA 12
 | fileA 13
 | fileA 14
Spreadsheet: 647093d1572275374-weighted-median-for-large-dataset-with-many-varying-weights-weighted-median
Sheet: Sheet1

Fam_Inc | Weight | [NAME]
5149 | 33.67798233
5106 | 188.9760132
5072 | 3.108463287
4994 | 611.1603394
4982 | 48.08955765
4975 | 51.73936081
4940 | 51.73936081
4893 | 699.7153931
4877 | 500.3041077
4864 | 51.73936081
4783 | 47.6829071
4694 | 51.73936081
4612 | 9.833632469
4604 | 1.244086146
4543 | 85.56001282
4519 | 47.6829071
4499 | 58.2733078
4429 | 44.60183716
4420 | 51.73936081
Spreadsheet: 526199d1499182497-need-copy-data-according-to-other-value-in-other-cell-trial
Sheet: Sheet1

Pppp | GERY
Date | 2017-07-04 00:00:00
No. | 111111
Shift | SH#2
RUN time | 1St
Status | XED |  |  |  |  |  |  |  | Date
me | Pppp | No. | Date | Shift | Run Time | Status |  |  | 2017-07-04 00:00:00 | 2017-07-05 00:00:00 | 2017-07-06 00:00:00
 |  |  |  |  |  |  |  | AAA1 | Present
 |  |  |  |  |  |  |  | AAA2 | Present
 |  |  |  |  |  |  |  | AAA3 | Absent
 |  |  |  |  |  |  |  | AAA4 | Present
 |  |  |  |  |  |  |  | AAA5 | Present
 |  |  |  |  |  |  |  | AAA6 | Present
 |  |  |  |  |  |  |  | AAA7 | Present
 |  |  |  |  |  |  |  | AAA8 | Present
 |  |  |  |  |  |  |  | AAA9 | Present
 |  |  |  |  |  |  |  | AAA10 | Present
 |  |  |  |  |  |  |  | AAA11 | Present
 |  |  |  |  |  |  |  | AAA12 | Present
 |  |  |  |  |  |  |  | AAA13 | Present
Result needed no AAA3 because its absent
me | Pppp | No. | Date | Shift | Run Time | Status
AAA1 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA2 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA4 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA5 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA6 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA7 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA8 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA9 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA10 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA11 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA12 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
AAA13 | GERY | 111111 | 2017-07-04 00:00:00 | SH#2 | 1st | XED
Spreadsheet: 863744d1711128615-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22
Sheet: Summary

Season Counts
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
 |  |  | P | C | 1B | 2B | 3B | SS | LF | LCF | RF | RCF | X
Spreadsheet: 786006d1656925309-count-specific-cells-with-multiple-criteria-duplicated-content-must-only-be-counted-once-test-project-tracker-work-in-progress
Sheet: Calculations

 | Property Status | Property Status Count
Spreadsheet: 58345d1258617647-extracting-data-from-multiple-sheets-help-needed-vehicle-fleet-dashboard
Sheet: Jun_08

 | 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 | TOTAL
[NAME]
[NAME]
BNE-003
BNE-004
BNE-005
BNE-006
BNE-007
BNE-008
BNE-009
[NAME]
BNE-011
BNE-012
BNE-013
BNE-014
BNE-015
BNE-016
BNE-017
BNE-018
BNE-019
BNE-020
BNE-021
BNE-022
BNE-023
BNE-024
BNE-025
BNE-026
BNE-027
BNE-028
BNE-029
BNE-030
[NAME]
BNE-032
BNE-033
BNE-034
BNE-035
BNE-036
BNE-037
BNE-038
BNE-039
[NAME]
BNE-041
BNE-042
BNE-043
BNE-044
BNE-045
BNE-046
BNE-047
BNE-048
[NAME]
BNE-050
BNE-051
BNE-052
BNE-053
BNE-054
BNE-055
BNE-056
BNE-057
BNE-058
BNE-059
BNE-060
BNE-061
BNE-062
BNE-063
BNE-064
BNE-065
BNE-066
BNE-067
BNE-068
BNE-069
BNE-070
BNE-071
BNE-072
BNE-073
BNE-074
BNE-075
BNE-076
[NAME]
BNE-078
[NAME]
BNE-080
BNE-081
BNE-082
BNE-083
BNE-084
BNE-085
BNE-086
BNE-087
BNE-088
[NAME]
BNE-090
BNE-091
BNE-092
BNE-093
BNE-094
BNE-095
BNE-096
BNE-097
BNE-098
[NAME]
[NAME]
BNE-101
BNE-102
BNE-103
BNE-104
BNE-105
BNE-106
BNE-107
BNE-108
BNE-109
BNE-110
BNE-111
BNE-112
BNE-113
BNE-114
BNE-115
BNE-116
BNE-117
BNE-118
BNE-119
BNE-120
BNE-121
BNE-122
BNE-123
BNE-124
BNE-125
BNE-126
BNE-127
BNE-128
BNE-129
BNE-130
BNE-131
BNE-132
BNE-133
BNE-134
[NAME]
BNE-136
[NAME]
[NAME]
BNE-139
BNE-140
BNE-141
BNE-142
BNE-143
BNE-144
BNE-145
[NAME]
[NAME]
BNE-148
BNE-149
BNE-150
BNE-151
BNE-152
BNE-153
BNE-154
BNE-155
BNE-156
BNE-157
BNE-158
BNE-159
BNE-160
BNE-161
[NAME]
BNE-163
BNE-164
BNE-165
[NAME]
BNE-167
BNE-168
BNE-169
BNE-170
BNE-171
BNE-172
BNE-173
BNE-174
BNE-175
BNE-176
BNE-177
BNE-178
BNE-179
BNE-180
BNE-181
BNE-182
BNE-183
BNE-184
BNE-185
BNE-186
BNE-187
BNE-188
BNE-189
BNE-190
BNE-191
BNE-192
BNE-193
BNE-194
BNE-195
[NAME]
BNE-197
BNE-198
BNE-199
BNE-200
BNE-201
BNE-202
BNE-203
BNE-204
BNE-205
BNE-206
BNE-207
BNE-208
BNE-209
BNE-210
BNE-211
BNE-212
BNE-213
BNE-214
BNE-215
BNE-216
[NAME]
BNE-218
BNE-219
BNE-220
BNE-221
BNE-222
BNE-223
BNE-224
BNE-225
BNE-226
BNE-227
BNE-228
BNE-229
BNE-230
BNE-231
BNE-232
BNE-233
[NAME]
BNE-235
BNE-236
BNE-237
BNE-238
BNE-239
BNE-240
BNE-241
BNE-242
BNE-243
BNE-244
BNE-245
BNE-246
BNE-247
BNE-248
BNE-249
BNE-250
BNE-251
BNE-252
BNE-253
[NAME]
BNE-255
[NAME]
BNE-257
BNE-258
[NAME]
[NAME]
[NAME]
BNE-262
BNE-263
BNE-264
BNE-265
BNE-266
[NAME]
BNE-268
BNE-269
BNE-270
BNE-271
BNE-272
BNE-273
BNE-274
BNE-275
Spreadsheet: formulachallenge
Sheet: one to populate

Table 1
ESI Shortcode | Sector | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00
INDU.DE.10.5.BS.M | Manufacture of food products
 |  |  |  | These figures are right ^^^ and coming from the lookup sheet, but if someone adds a column, for example, in $BC on the lookup sheet, it
 |  |  |  | will drag the figures from the wrong column and I wouldn't know. What I'm trying to do is modify the formula that seems to work in the cells (K5)
(Lookup Table 2 on tab 'lookup sheet') |  |  |  | from =INDEX('lookup sheet'!$BC:$BC,MATCH(EOMONTH(K$4,0),'lookup sheet'!$A:$A,0))
 |  |  |  | to something that will lookup the column header first 'INDU.DE.10.5.BS.M' (which is in A5 in this sheet for example),
 |  |  |  | so that it continues to grab the right value if anyone inserts/deletes a column in the 'lookup sheet'
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Sussex

Sussex To: | [NAME]
Amherst, NS | 88
Anagance, NB | 18
Atholville, NB | 254
Bathurst, NB | 185
[NAME], NB | 88
Bridgewater, NS | 272
Centreville, NB | 160
Charlottetown, PE | 151
Chatham, NB | 138
Dartmouth, NS | 206
Debert, NS | 148
Edmundston, NB | 242
Florenceville, NB | 160
Fredericton, NB | 78
Grand Bay, NB | 58
[NAME], NB | 203
Hampton, NB | 25
Hartland, NB | 151
Havelock, NB | 39
Kedgwick, NB | 264
Kentville, NS | 262
Lake Utopia, NB | 89
Mcadam, NB | 124
[NAME], NB | 37
Millidgeville, NB | 48
Minto, NB | 65
Nackawic, NB | 113
Nashwaaksis, NB | 78
NB / QC Border | 252
New Glasgow, NS | 188
Newcastle, NB | 144
North Sydney, NS | 344
[NAME], NB | 68
Pennfield, NB | 85
Perth Andover, NB | 181
Petitcodiac, NB | 26
Plaster Rock, NB | 205
[NAME], NB | 100
Quispamsis, NB | 30
[NAME], NB | 29
Rothesay, NB | 39
[NAME], NB | 44
Scoudouc, NB | 63
[NAME], NB | 53
[NAME], NB | 108
[NAME], NB | 278
[NAME], NB | 89
[NAME], NB | 247
[NAME], NB | 216
[NAME], NB | 253
[NAME], NB | 114
Summerside, PE | 136
Tracadie, NB | 187
Truro, NS | 156
Valley Station, NS | 159
[NAME], PE | 153
Woodstock, NB | 137
[NAME], NB | 30
Spreadsheet: michelle_lokay__26750__imball0112
Sheet: NGPL

 | 52862 |  | 6828
 | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 19565 | 19737
2 | 19701 | 19737
3 | 19719 | 19737
4 | 19712 | 19737 |  | -10000 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 19700 | 19737 |  | -50
6 | 19696 | 19737 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 22849 | 22895
8 | 19738 | 19737 |  |  |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 | 19291 | 19737 | -10996 | -25000 |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 | 19791 | 19737 | -1056 | -9593 |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 |  |  |  |  |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13
14 |  |  |  |  |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15
16 |  |  |  |  |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  |  |  | 159450
2001-12-10 00:00:00
CBS Dollars
 |  |  | 416892
Spreadsheet: 757681d1638394179-filter-the-top-12-highest-number-with-duplicates-then-lookup-to-its-reference-criteria-simple-intermediate-step-to-get-sort-answer
Sheet: Sheet1

No. | Qty |  | No. | Qty
1 | 4 |  | 3 | 10 |  | If your data was appended into a single column like the left column A-B,
2 | 2 |  | 6 | 9 |  | Then you sort by the Quantity column from large to small - see columns D-E. by column E.
3 | 10 |  | 23 | 8 |  | Talking your top 6 and next 6 rows gives you an easy answer.
4 | 6 |  | 8 | 7
5 | 6 |  | 11 | 7 |  | No. | Qty |  | No. | Qty
6 | 9 |  | 20 | 7
7 | 3 |  | 32 | 7
8 | 7 |  | 34 | 7
9 | 4 |  | 4 | 6
10 | 3 |  | 5 | 6
11 | 7 |  | 12 | 6
12 | 6 |  | 13 | 5
13 | 5 |  | 15 | 5 |  | If I had to do your problem, I'd make a simpler one by combining/appending the two tables into a single one
14 | 3 |  | 16 | 5
15 | 5 |  | 18 | 5
16 | 5 |  | 21 | 5
17 | 3 |  | 22 | 5
18 | 5 |  | 24 | 5
19 | 4 |  | 27 | 5
20 | 7 |  | 35 | 5
21 | 5 |  | 1 | 4
22 | 5 |  | 9 | 4
23 | 8 |  | 19 | 4
24 | 5 |  | 26 | 4
25 | 3 |  | 29 | 4
26 | 4 |  | 33 | 4
27 | 5 |  | 36 | 4
28 | 2 |  | 37 | 4
29 | 4 |  | 38 | 4
30 | 3 |  | 7 | 3
31 | 3 |  | 10 | 3
32 | 7 |  | 14 | 3
33 | 4 |  | 17 | 3
34 | 7 |  | 25 | 3
35 | 5 |  | 30 | 3
36 | 4 |  | 31 | 3
37 | 4 |  | 2 | 2
38 | 4 |  | 28 | 2
Spreadsheet: 148905d1333611249-formulas-no-longer-working-with-date-format-excel-example_change-in-date-format
Sheet: Lists 

Incident Categories |  | CIs
Customer Error |  | UKAPARISBLC3
AIX |  | UKAPBMCP1BLC3
Windows |  | UKAPBWPREBLC3
SAN |  | UKAPMSSCMBLC3
Administration |  | UKAPQTPBLC3
File System |  | UKAPSAVMBLC3
Backup Failure |  | UKAPSPARE1BLC3
Compliance |  | UKAPWWIBLC3
VCS |  | ukapx117
 |  | ukapx118
 |  | ukapx119
 |  | ukapx120
 |  | ukapx121
 |  | ukapx122
 |  | ukapx123
 |  | ukapx124
 |  | ukapx125
 |  | ukapx128
 |  | ukapx129
 |  | ukapx130
 |  | ukapx131
 |  | ukapx132
 |  | UKBLARISBLC2
 |  | UKBLBMCP1BLC2
 |  | UKBLBWPREBLC3
 |  | UKBLGENIFIXBLC2
 |  | UKBLGENIFIXBLC3
 |  | UKBLHPCONTBLC2
 |  | UKBLHPINJ1BLC3
 |  | UKBLHPINJ2BLC3
 |  | UKBLHPINJ3BLC3
 |  | UKBLHPPERFCBLC2
 |  | UKBLIODEVBLC2
 |  | UKBLIOTESTBLC3
 |  | UKBLMSSCMBLC2
 |  | UKBLQTPBLC2
 |  | UKBLSPARE1BLC2
 |  | UKBLSPARE1BLC3
 |  | UKBLSYAVBLC3
 |  | UKBLVERIBLC2
 |  | UKBLVERIBLC3
 |  | [NAME]
 |  | ukblx330
 |  | ukblx331
 |  | [NAME]
 |  | ukblx333
 |  | ukblx334
 |  | ukblx335
 |  | ukblx336
 |  | ukblx337
 |  | ukblx338
 |  | ukblx339
 |  | ukblx340
 |  | ukblx341
 |  | ukblx342
 |  | ukblx343
 |  | ukblx344
 |  | ukblx345
 |  | ukblx350
 |  | ukblx351
 |  | ukblx352
 |  | ukblx353
 |  | ukblx354
 |  | All servers
Spreadsheet: 233051d1367599421-format-cells-font-underline-accounting-can-you-set-the-color-underline-example
Sheet: Sheet1

 |  | Oranges |  |  | Apples
 | Revenue | 16 | 12.1 | 310 | 4213 | 315 | 3251
 | Expense | 14 | 31 | 290 | 1132 | 210 | 3341
 | Profit
 |  | Oranges |  |  | Apples
 | Revenue | 16 | 12.1 | 310 | 4213 | 315 | 3251
 | Expense | 14 | 31 | 290 | 1132 | 210 | 3341
 | Profit
Spreadsheet: 563e58d9-196a-4669-add8-d761a3484608
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-06-03 09:57:46.150000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 101.837 | 101.712 | 101.587 | 101.212 |  | and are added to price quote
4.625 | 100.995 | 100.87 | 100.745 | 100.37
4.5 | 100.506 | 100.381 | 100.256 | 99.881 |  | Note: | Refer To Price [NAME]
4.375 | 99.945 | 99.82 | 99.695 | 99.32 |  |  | For all Price Adjs
4.25 | 98.881 | 98.756 | 98.631
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.85 | 101.725 | 101.6 | 101.225
4 | 101.505 | 101.38 | 101.255 | 100.88
3.875 | 101.116 | 100.991 | 100.866 | 100.491
3.75 | 100.582 | 100.457 | 100.332 | 99.957
3.625 | 99.432 | 99.307 | 99.182
 |  |  |  |  |  | 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:
 |  |  |  |  |  | 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-06-17 09:57:46.150000
30 DAY | 2011-07-02 09:57:46.150000
45 DAY | 2011-07-17 09:57:46.150000
60 DAY | 2011-08-01 09:57:46.150000
90 DAY | 2011-08-31 09:57:46.150000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.