tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: bh

Biggins. Sue |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 566593d1521593747-convert-time-series-ohlc-data-frequency-book2-2-
Sheet: Sheet1

Date | Open | High | Low | Last | Change | Settle | Volume | Previous Day Open Interest | Week | Month
2018-03-19 00:00:00 | 2755 | 2755 | 2739.5 | 2739.5 | 33.75 | 2739.75 | 4 | 47
2018-03-16 00:00:00 | 2772.5 | 2777.25 | 2766.5 | 2768.5 | 1.25 | 2768.5 | 14 | 24999
2018-03-15 00:00:00 | 2760.25 | 2775.5 | 2759.25 | 2767.75 | 0.75 | 2767.25 | 3 | 25000
2018-03-14 00:00:00 | 2784.5 | 2793 | 2763.5 | 2769 | 19 | 2766.5 | 107 | 24951
2018-03-13 00:00:00 | 2815 | 2818 | 2776.5 | 2782.25 | 16.5 | 2785.5 | 44 | 24925
2018-03-12 00:00:00 | 2805 | 2813 | 2799.5 | 2800.5 | 0.75 | 2802 | 53 | 24922
2018-03-09 00:00:00 | 2779.75 | 2801.25 | 2779.75 | 2801.25 | 45.75 | 2801.25 | 49 | 24918
2018-03-08 00:00:00 | 2750 | 2754.25 | 2742 | 2754.25 | 15.5 | 2755.5 | 1 | 24917
2018-03-07 00:00:00 | 2708.25 | 2745 | 2700 | 2739.25 | 0.5 | 2740 | 8 | 24916
2018-03-06 00:00:00 | 2736 | 2747.25 | 2731.5 | 2742.75 | 6 | 2740.5 | 31 | 24921
2018-03-05 00:00:00 | 2720.25 | 2743 | 2691 | 2737.5 | 27.25 | 2734.5 | 29 | 24917
2018-03-02 00:00:00 | 2699 | 2708.5 | 2666 | 2707 | 12.5 | 2707.25 | 16 | 24917
2018-03-01 00:00:00 | 2725 | 2747.5 | 2678.75 | 2695.5 | 37.75 | 2694.75 | 42 | 24939
2018-02-28 00:00:00 | 2760 | 2779 | 2732.5 | 2736.25 | 33.25 | 2732.5 | 73 | 24933
2018-02-27 00:00:00 | 2800.5 | 2804 | 2762 | 2764.25 | 36 | 2765.75 | 1057 | 24519
2018-02-26 00:00:00 | 2768.5 | 2804.25 | 2762 | 2804.25 | 36.5 | 2801.75 | 228 | 24317
Spreadsheet: 156194d1337208078-very-specific-sorting-issue-using-countif-sorting-sample
Sheet: Sheet1

[NAME] to Apply Number to Data | Raw Data |  | Pre-Typed Numbers | Re-Sorted Data Based on VLOOKUP |  | [NAME] to Apply Number to Data | Raw Data |  | Pre-Typed Numbers | Re-Sorted Data Based on VLOOKUP
 | B |  | 1 |  |  |  | C |  | 1
 | A |  | 2 |  |  |  | A |  | 2
 | D |  | 3 |  |  |  | C |  | 3
 | C |  | 4 |  |  |  | D |  | 4
 |  |  |  |  |  |  | B |  | 5
No duplicates in the raw data, no issue |  |  |  |  |  | Duplicate in the raw data causes sorting formula to repeat "3", skip "4" (note the #N/A error), and number the next entry as "5"
 |  |  |  |  |  | My goal is to have "C" appear in the pre-typed "3" and "4" spots
Spreadsheet: 92076d1291745020-display-only-blank-cells-test
Sheet: Sheet1

Ticket # | Duplicate | Contact Made | When
1111112 | Yes
1111113 |  | Yes | 2010-12-06 00:00:00
1111114
1111115 | Yes
1111116
1111117 |  | Yes | 2010-12-01 00:00:00
111118 |  | Yes | 2010-12-03 00:00:00
1111119 | Yes
Spreadsheet: 270512d1381509679-how-to-count-blank-cells-in-data-range-count-blank-cells
Sheet: Sheet2

Frame a formulae to determine count of blank cells per agent wise. |  |  | Find No. of Blank cells for each name.
Name | Status
[NAME] | NO |  | [NAME] |  |  | Eg: Ashwini V | 2
[NAME] | YES |  | [NAME] |  |  | Manju Ediga | 2
[NAME] | NO |  | Manju Ediga
[NAME] | YES |  | [NAME]
[NAME] | NO |  | Samsung
[NAME] |  |  | [NAME]
[NAME] |  |  | Sujith
Manju Ediga | NO
Manju Ediga
Manju Ediga | NO |  | I need the formula
Manju Ediga
Manju Ediga | YES
Manju Ediga | NO
Manju Ediga | NO
[NAME] | YES
[NAME] | NO
[NAME] | YES
Samsung | NO
Samsung | NO
Samsung
[NAME] | NO
[NAME]
[NAME] | NO
[NAME] | NO
Sujith
Sujith
Sujith | NO
Sujith | N/A
Sujith
Sujith | N/A
Sujith
Spreadsheet: 776179d1649554414-excel-formula-to-amount-before-vat-supply-of-vat
Sheet: Sheet1

I'm kindly asking excel formula to calculate the amount excluding VAT in column [NAME] is 14.5%
 | Amount Including VAT | Amount excluding VAT
Trading Stock | 900000
Motor Vehicle | 105000
Machines | 458000
Desired Outcome
 | Amount Including VAT | Amount excluding VAT
Trading Stock | 900000 | 786026.2
Motor Vehicle | 105000 | 91703.06
Machines | 458000 | 400000
Spreadsheet: 122914d1317237680-copying-multiple-cells-based-on-drop-down-employee-ranking
Sheet: BP Input WK3

Location | Employee # | Employee | Apps | Approval | AS+ | Preapprov | [NAME] | ITA | ITA% | Existing | Existing %
Store 479 | 241087 | Roark, [NAME] | 67 | 0.4179 | 14 | 0 | 0 | 14 | 0 | 0 | 0
Store 479 | 10594 | [NAME], Stephen | 45 | 60 | 1 | 8 | 12.5 | 10 | 0 | 0 | 0
Spreadsheet: 811940d1672874388-index-match-w-2-column-sources-sample-twocolumnbasedlist
Sheet: Sheet2

 | Target 1: | CCCC |  |  |  | Date: | Code 1: | Used 1: | Code 2: | Used 2:
 | Target 2: | DDDD |  |  |  | 2023-01-01 00:00:00 | AAAA
 |  |  |  |  |  | 2023-01-02 00:00:00 | BBBB | 08:00:00
 | Date: | Times: | Hours: |  |  | 2023-01-03 00:00:00 | CCCC | 04:00:00 | AAAA | 04:00:00
 |  |  |  |  |  | 2023-01-04 00:00:00 | BBBB | 08:00:00
 |  |  |  |  |  | 2023-01-05 00:00:00 | DDDD | 04:00:00 | CCCC | 04:00:00
 |  |  |  |  |  | 2023-01-06 00:00:00 | BBBB | 08:00:00
 |  |  |  |  |  | 2023-01-07 00:00:00 | AAAA
 |  | [NAME] Should show results as: ↓
 | Date: | Times: | Hours:
 | 2023-01-03 00:00:00 | CCCC | 04:00:00
 | 2023-01-05 00:00:00 | DDDD | 04:00:00
 | 2023-01-05 00:00:00 | CCCC | 04:00:00
Spreadsheet: kim_ward__20933__RFP_Profile_CA_5_9_01
Sheet: Newell_Rubbermaid_T&C_Pg2

Newell Rubbermaid
City of Industry
Please submit your response to this RFP by completing and returning this sheet.
Volume: | 100% Full Requirements |  |  |  |  |  |  | Yes     or      No
 | See attached load profile based on historical usage.
 | Will pricing structure vary beyond a stated volume tolerance? |  |  |  |  |  |  | Yes     or      No
 | If yes, please indicate the pricing structure for incremental volumes.
Delivery Point: | Southern California Gas |  |  |  |  |  |  | Yes     or     No
Transportation: | Firm non recallable transportation |  |  |  |  |  |  | Yes     or     No
Nominations & | [NAME] will be responsible for nominations to LDC and for associated balancing.
Balancing | [NAME] will make nominations based on historical usage.  [NAME] will notify
 | Buyer of any periods of daily balancing and/or other operational flow orders,
 | which may cause penalties.  [NAME] will indemnify [NAME] against any
 | penalties that occur due to non-performance by [NAME]. |  |  |  |  |  |  | Yes     or     No
Credit: | All credit arrangements and contractual agreements will be between [NAME]
 | and [NAME]. |  |  |  |  |  |  | Yes     or     No
Other: | Is your company a certified, minority-owned business? |  |  |  |  |  |  | Yes     or     No
 | Please provide any additional information that may be applicable to your
 | company's plans to serve customers in this market (e.g., sample bill, brief
 | description of LDC operations, etc).
Comments:
 | Proposals that do not reflect the specific terms above may not be included in the review.
 | All information and proposals will be held in confidence.  Thank you.
Spreadsheet: 44281d1242909794-lookup-book2
Sheet: Sheet1

Please only change what is in BLACK text - Please DO NOT change trhe RED text as these are formula driven.
KIWISAVER DEPOSIT
Salary | 40000 | 0.025 |  | 0.02 | 0.04 |  |  | 0.05
Date |  | [NAME] | Self Yearly | Government | Employer | Total | Accum Total | Total Savings
Age | 45
Spreadsheet: 126445d1319698691-excel-2007-percentage-book1sam
Sheet: Sheet1

2011-10-21 00:00:00
incoming | reviewed | applied | interview | unsuccessful
 |  |  |  | 12
 |  |  |  | 45
 |  |  |  | 57
1
 |  | 12
 |  |  |  | 1
 |  |  |  | 2
 |  |  |  | 3
1 | 0 | 12 | 0 | 120
0 | #N/A |  |  | #N/A
#N/A | #N/A | #N/A |  | #N/A
Spreadsheet: 847824d1698678362-retrieving-correct-zones-sample
Sheet: Zones

 |  |  | Area Code | [NAME] | Zone
 |  |  | EC1 | Clerkenwell, [NAME] | Zone 1
 |  |  | EC2 | Moorgate, Liverpool Street | Zone 1
 |  |  | EC3 | Monument, Tower Hill, Aldgate | Zone 1
 |  |  | EC4 | Fleet Street, St. Paul's | Zone 1
 |  |  | WC1 | [NAME], [NAME] | Zone 1
 |  |  | WC2 | Covent Garden, Holborn, Strand | Zone 1
 |  |  | W1 | Mayfair, Marylebone, Soho | Zone 1
 |  |  | SW1 | Westminster, Belgravia, [NAME] | Zone 1
 |  |  | E1 | Whitechapel, Stepney, [NAME] | Zone 2
 |  |  | E2 | Bethnal Green, Shoreditch | Zone 2
 |  |  | E3 | Bow, Bromley-by-Bow | Zone 2
Spreadsheet: 861775d1709620795-need-a-formula-to-generate-a-list-just-type-department-name-template-for-list-of-department-and-retired-aligw
Sheet: Department

 |  |  |  |  | Department of | Literature
Sr. | Campus | Faculty | Name of Faculty Member | Designation | Nature of Appointment | Gender | Date of Birth | Date of First Appointment at IUB | Date of Appointment in Curren Scale | Date of Retirement
 | Baghdad ul Jadeed | Arts & Languages | Dr. [NAME] | Professor | Regular | Male | 1963-11-02 00:00:00 | 1987-03-15 00:00:00 | 2020-07-04 00:00:00 | 2023-11-01 00:00:00
2 | Baghdad ul Jadeed | Arts & Languages | Dr. [NAME] [NAME] | Professor | Regular | Male | 1966-01-01 00:00:00 | 2001-09-01 00:00:00 | 2023-07-15 00:00:00 | 2025-12-31 00:00:00
3 | Baghdad ul Jadeed | Arts & Languages | Mr. [NAME] Shair | Assistant Professor | Regular | Male | 1969-08-24 00:00:00 | 2001-03-12 00:00:00 | 2008-06-28 00:00:00 | 2029-08-23 00:00:00
Spreadsheet: 67455d1268082460-sumproduct-2-variables-in-2-columns-is-it-possible-copy-of-sum-with-2-conditions-rows-and-columns
Sheet: Sheet1

 | FY10 - 6 | FY10 - 6 | FY10 - 7 | FY10 - 7 | FY10 - 8 | FY10 - 8 | FY10 - 9 | FY10 - 9 | FY10 - 10 | FY10 - 10 | FY10 - 11
 | 2009-10-31 00:00:00 | 2009-11-14 00:00:00 | 2009-11-28 00:00:00 | 2009-12-12 00:00:00 | 2009-12-26 00:00:00 | 2010-01-09 00:00:00 | 2010-01-23 00:00:00 | 2010-02-06 00:00:00 | 2010-02-20 00:00:00 | 2010-03-06 00:00:00 | 2010-03-20 00:00:00
XY | 5 | 37.5 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75 | 18.75
XY | 5 | 16 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
XY | 5 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80
JA | 5 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80
XY | 5 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80 | 80
JA | 10 |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8
JA | 10 | 32 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
XY | 10 | 80 | 80 | 80 | 80 | 80
 |  | FY10 - 6 |  | If C15 = any cell between columns B2 and L2, then add the hours in those columns where the data in Row A = XY
 |  |  |  | So, for FY10 - 6, I would expect an answer of
 |  | FY10
 |  | FY10 - 8 |  | FY10 - 8 should result in
Spreadsheet: 726064d1617032164-convert-data-from-skills-matrix-into-analyzable-data-model-by-employees-skills-in-rows-ange-27-nov-2020-for-excel-help-ans
Sheet: Desired result

Team | Employee | Background | Country | Skill | Level
Spreadsheet: 775596d1649214596-conditional-formatting-weekends-and-public-holidays-condisional-formatting-weekends-and-public-holidays
Sheet: Sheet1

 |  |  |  |  |  |  |  | Public Hollidays
 |  |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  | 2022-03-21 00:00:00
Date |  |  |  |  |  |  |  | 2022-04-15 00:00:00
2022-03-01 00:00:00 |  |  |  |  |  |  |  | 2022-04-16 00:00:00
2022-03-02 00:00:00 |  |  |  |  |  |  |  | 2022-04-17 00:00:00
2022-03-03 00:00:00 |  |  |  |  |  |  |  | 2022-04-27 00:00:00
2022-03-04 00:00:00 |  |  |  |  |  |  |  | 2022-05-01 00:00:00
2022-03-05 00:00:00 |  |  |  |  |  |  |  | 2022-05-02 00:00:00
2022-03-06 00:00:00 |  |  |  |  |  |  |  | 2022-05-08 00:00:00
2022-03-07 00:00:00 |  |  |  |  |  |  |  | 2022-06-06 00:00:00
2022-03-08 00:00:00 |  |  |  |  |  |  |  | 2022-06-19 00:00:00
2022-03-09 00:00:00 |  |  |  |  |  |  |  | 2022-08-09 00:00:00
2022-03-10 00:00:00 |  |  |  |  |  |  |  | 2022-09-24 00:00:00
2022-03-11 00:00:00 |  |  |  |  |  |  |  | 2022-12-16 00:00:00
2022-03-12 00:00:00 |  |  |  |  |  |  |  | 2022-12-24 00:00:00
2022-03-13 00:00:00 |  |  |  |  |  |  |  | 2022-12-25 00:00:00
2022-03-14 00:00:00 |  |  |  |  |  |  |  | 2022-12-26 00:00:00
2022-03-15 00:00:00
2022-03-16 00:00:00
2022-03-17 00:00:00
2022-03-18 00:00:00
2022-03-19 00:00:00
2022-03-20 00:00:00
2022-03-21 00:00:00
2022-03-22 00:00:00
2022-03-23 00:00:00
2022-03-24 00:00:00
2022-03-25 00:00:00
2022-03-26 00:00:00
2022-03-27 00:00:00
2022-03-28 00:00:00
2022-03-29 00:00:00
2022-03-30 00:00:00
2022-03-31 00:00:00
Spreadsheet: jason_wolfe__13349__Matrix032701
Sheet: TEXAS REGION

Pipeline | Logistics/Primary | Ext. | Deal Validation/Primary | Ext. | Deal Validation/Telephonic | Ext. | Volume Control/Primary | Ext.
Amaco Pipeline | [NAME] | 35251 | [NAME] | 37911 | [NAME] | 33048 | N/A
Black Marlin  (Blue Dolphin)                                                                                                                                             offshore | [NAME] | 36673 | [NAME] | 37911 | [NAME] | 33048 | N/A
Channel Pipeline | Sabrae Zajac | 36381 | [NAME] | 37911 | [NAME] | 33048 | N/A
Dow Pipeline | [NAME] | 39497 | [NAME] | 37911 | [NAME] | 33048 | N/A
East Texas Gas (ETXC) | [NAME] | 36673 | [NAME] | 37911 | [NAME] | 33048 | N/A
EasTrans Pipeline | [NAME] | 36673 | [NAME] | 37911 | [NAME] | 33048 | N/A
[NAME] | [NAME] | 35251 | [NAME] | 37911 | [NAME] | 33048 | N/A
Lone Star | [NAME] | 33396 | [NAME] | 37911 | [NAME] | 33048 | N/A
Moss Bluff Storage (MOSS) | Sabrae Zajac | 36381 | [NAME] | 37911 | [NAME] | 33048 | [NAME] | 34707
[NAME] (formally Black Marlin) | [NAME] | 36673 | [NAME] | 37911 | [NAME] | 33048 | [NAME] | 34780
Oasis Pipeline (OPLC) | [NAME] | 33396 | [NAME] | 37911 | [NAME] | 33048 | N/A
PGE | [NAME] | 35251 | [NAME] | 37911 | [NAME] | 33048 | N/A
PowerTex (LG&E Nat) | [NAME] | 36101 | [NAME] | 37911 | [NAME] | 33048 | N/A
Sea Hawk-Seagull Shoreline | Sabrae Zajac | 36381 | [NAME] | 37911 | [NAME] | 33048 | [NAME] | 34780
TUFCO | [NAME] | 36673 | [NAME] | 37911 | [NAME] | 33048 | N/A
[NAME] (Centana) | [NAME] | 36673 | [NAME] | 37911 | [NAME] | 33048 | N/A
Spreadsheet: 78072d1278515504-if-statements-in-excel-with-and-seeea
Sheet: .xlsx)Sheet1

period | months |  |  |  |  |  |  |  | rental charge | due | amt paid | cost pool
Jan-may | 5 |  | Jan | Feb | Mar | Apr | May | 500 | 2500 | 15000 | 17500 | [NAME] | 34213.58499999999
feb | 1 | feb | Feb |  |  |  |  | 25362 | 25362 | 25362 | 50724 | [NAME]
Jan-apr | 4 |  | Jan | Feb | Mar | Apr |  | 834 | 3336 | 3336 | 6672 | [NAME]
Jan-apr | 4 |  | Jan | Feb | Mar | Apr |  | 6340.5 | 25362 | 25362 | 50724 | dbn
apr | 1 | Apr | Apr |  |  |  |  | 3336 | 3336 | 3336 | 6672 | dbn
[NAME] | 1 | [NAME] | Mar |  |  |  |  | 3336 | 3336 | 3336 | 6672 | [NAME]
jan-mar | 3 |  | Jan | Feb | Mar |  |  | 8454 | 25362 | 25362 | 50724 | [NAME]
jan-mar | 3 |  | Jan | Feb | Mar |  |  | 1112 | 3336 | 3336 | 6672 | [NAME]
jan-mar | 3 |  | Jan | Feb | Mar |  |  | 8454 | 25362 | 25362 | 50724 | [NAME]
Jan | 1 | jan | Jan |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | dbn
Jan | 1 | jan | Jan |  |  |  |  | 2653 | 2653 | 2653 | 5306 | dbn
Jan | 1 | jan | Jan |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | dbn
Jan | 1 | jan | Jan |  |  |  |  | 2653 | 2653 | 2653 | 5306 | dbn
feb | 1 | feb | Feb |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
Jan | 1 | jan | Jan |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
Jan | 1 | jan | Jan |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
[NAME] | 2 |  | Feb | Mar |  |  |  | 12681 | 25362 | 25362 | 50724 | [NAME]
[NAME] | 2 |  | Feb | Mar |  |  |  | 378.01 | 756.02 | 756.02 | 1512.04 | dbn
[NAME] | 2 |  | Feb | Mar |  |  |  | 1326.5 | 2653 | 2653 | 5306 | dbn
[NAME] | 2 |  | Feb | Mar |  |  |  | 378.01 | 756.02 | 756.02 | 1512.04 | dbn
feb-Apr | 3 |  | Feb | Mar | Apr |  |  | 884.3333333333334 | 2653 | 2653 | 5306 | dbn
[NAME] | 2 |  | Feb | Mar |  |  |  | 1668 | 3336 | 3336 | 6672 | [NAME]
[NAME] | 2 |  | Feb | Mar |  |  |  | 12681 | 25362 | 25362 | 50724 | [NAME]
[NAME] | 2 |  | Feb | Mar |  |  |  | 1668 | 3336 | 3336 | 6672 | [NAME]
apr | 1 | Apr | Apr |  |  |  |  | 25362 | 25362 | 25362 | 50724 | [NAME]
apr | 1 | Apr | Apr |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | dbn
[NAME] | 2 |  | Feb | Mar |  |  |  | 1326.5 | 2653 | 2653 | 5306 | dbn
march | 1 |  | Mar |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
march | 1 |  | Mar |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
march | 1 |  | Mar |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
feb | 1 | feb | Feb |  |  |  |  | 25362 | 25362 | 25362 | 50724 | [NAME]
jan-apr | 4 |  | Jan | Feb | Mar | Apr |  | 189.005 | 756.02 | 756.02 | 1512.04 | dbn
apr | 1 | Apr | Apr |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | dbn
apr | 1 | Apr | Apr |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
apr | 1 | Apr | Apr |  |  |  |  | 25362 | 25362 | 25362 | 50724 | psf
apr | 1 | Apr | Apr |  |  |  |  | 756.02 | 756.02 | 756.02 | 1512.04 | psf
apr | 1 | Apr | Apr |  |  |  |  | 2653 | 2653 | 2653 | 5306 | [NAME]
Spreadsheet: 113966d1309855892-vlookup-alternative-to-sum-rows-excel-help
Sheet: Total Orders

All orders |  |  |  | Total by Code
Code | Qty |  |  | Code | Total Qty
M1260NP | 12 |  |  | M1260NP |  | I'd like to lookup the code in column E against the codes in column A, and return the total Quantity for that code in column F.    i.e. It should return 48 for the M1260NP. Vlookup just returns 12.
M1260NP | 24 |  |  | W1260PS
M1260NP | 12 |  |  | MR993GL
W1260PS | 24 |  |  | M860RS2
W1260PS | 12 |  |  | M860SB2
MR993GL | 12 |  |  | M860GG2
M860RS2 | 12 |  |  | W860SB2
M860SB2 | 24 |  |  | W860KMM2
M860SB2 | 24 |  |  | M660GR1
M860GG2 | 12 |  |  | M660TB
W860SB2 | 12 |  |  | W660SB1
W860KMM2 | 12 |  |  | W660PB
M660GR1 | 12 |  |  | [NAME]
M660TB | 24 |  |  | M560NV2
M660TB | 24 |  |  | W560PK2
W660SB1 | 12
W660PB | 12
W660PB | 12
[NAME] | 12
[NAME] | 36
M560NV2 | 12
W560PK2 | 12
Spreadsheet: 740608d1626423708-return-text-if-text-found-in-column-or-sum-column-if-just-numerical-values-module-lifting-risk-chart
Sheet: Lift Risk

 |  |  |  | High | Design requires positive mechanical attachment
 |  |  |  | Medium | Further Review Required - Possible requirement for positive mechanical attachment
 |  |  |  | Low | Low risk, ok to proceed without positive mechanical attachment. Robust lifting plan required by AP.
 | Module / Stack Configuration | Item | Risk Score
 | Module Construction
 |  | Full Unistrut
 |  | Hot Rolled Steel
 | Module Type
 |  | [NAME]
 |  | Riser
 |  | Plant Skid
 | Module Tiers |  |  |  | Still need to determine break between High, Medium, Low
 |  | Single Tier
 |  | 2 Tier
 |  | 3 Tier
 | Weight Distribution
 |  | Near Central
 |  | Mostly Offset
 | [NAME]
 |  | 0-250kg
 |  | 250-500kg
 |  | 500+kg
 | Stack Height
 |  | 0-1500mm
 |  | 1500-2000mm
 |  | 2000mm+
 | Stack Quantity
 |  | 1-5
 |  | 5+
 | Stack Weignt
 |  | 0-2000kg
 |  | 2000kg+
 | Stack Weight Distribution
 |  | Near Central
 |  | Mostly Offset
 |  | Risk Score
Spreadsheet: 847109d1698188866-adjusting-a-unique-let-formula-to-add-an-additional-column-value-unique-values-test-03
Sheet: Sheet1

NAME | Number | DATE | AMOUNT
JOE | 123 | 2023-10-01 00:00:00 | 10
JOE | 123 | 2023-11-02 00:00:00 | 15
SUE | 456 | 2023-10-04 00:00:00 | 30
MARK | 789 | 2023-10-06 00:00:00 | 5
LISA | 12 | 2023-10-15 00:00:00 | 20
SUE | 456 | 2023-10-16 00:00:00 | 60
JOE | 123 | 2023-10-23 00:00:00 | 80
JOE | 123 | 2023-10-24 00:00:00 | 15
Spreadsheet: 122014d1316551995-indirect-erep_1gb-tigrovi_bkp
Sheet: Pizuh

Ambient on/off
eRepublik – Online Strategy Game
Sep20 Day 1,400 of the New World
Home
My Land
Wars
Market
Marketplace
Job market
Monetary market
Companies for sale
Community
World Map
News
My Party
Elections
Military Unit
Country administration
Invite friends
Badges
Get Gold & Extras
[NAME]
[NAME]
27
60
Eat food
Gold2.24 Gold
BAM411 BAM
HRK1625 HRK
Missions
X
You don't have enough Gold to complete the task Get Gold
Completed!
2011-10-03 00:00:00
2011-10-03 00:00:00
2011-10-03 00:00:00
Reward
Ok
Congratulations, your rank is now
Rank Bonus on attack +5%
Energy bar
Ok
Strength
Experience points
Health
Rank points
Gold
Energy bar
[NAME]
Free Lands
Scope
Bazooka
Weapons
Weapons
Weapons
Food units
Food units
Food units
Grain Farms
0 0
Logout
Experience level: 27
Experience points: 10027
Next level at: 15000
• Working, training and fighting decreases health
[NAME], health boxes, food, hospitals restore health.
This action restores as much health as possible by eating Food from your Storage.
You can recover up to: 450 / 450 Health
100 more recoverable Health in: 00:59:59
Food limit reached
You have reached your food consumption limit.
You can recover 100 health every hour.
100 more recoverable Health in: [NAME]
Buy health kit Close
[NAME]
offlinePizuh
Add as a friend Send message Donate
Experience level 31
33,505 / 35,000
Location: PolandPoland, Lower Saxony and Bremen Citizenship: CroatiaCroatia
eRepublik birthday
Jul 20, 2009
National rank: 78
Party Member
[NAME] eHrvatskeSavez Komunista eHrvatske Far-left Wing
HV 1.GB Tigrovi HV 1.GB Tigrovi
Press director
Konoba news.....
Friends(177)
teXew
[NAME]
PeeKaBooh
[NAME]
Hajduk
[NAME]
[NAME]
Vejita
webstartm
view all
Land of Pizuh: 29 buildings
Visit
Achievements
hard worker
24
Hard Worker
Worked 30 days in a row
congressman
1
Congress Member
Won the Congress elections
president
Country President
Win the Presidential elections
media mogul
1
Media Mogul
Reached 1000 subscribers to your newspaper
battle hero
7
Battle Hero
Reach the highest war influence in a battle
campaign hero
Campaign hero
Reach the highest war influence in a campaign
resistance hero
Resistance Hero
Start a resistance war and liberate that region
super soldier
24
Super Soldier
Advance 250 strength points
society builder
Society Builder
Invite 10 people to eRepublik and help them reach level 10
mercenary
Mercenary
Defeat 25 enemies for 50 different countries
Coming soon
Coming soon
Military Skills
Strength
6,048.01
Super soldier:6,048 / 6,250
Rank
National Force National Force
Rank points:
5,256,943 / 5,800,000
Forum   |   [NAME]   |   Blog   |   Press   |   Contact   |   [NAME]   |   Terms of Service   |   Privacy  |   Affiliates  |   [NAME]
Follow us: FacebookFacebook TwitterTwitter
Copyright © 2007-2011 eRepublik
Spreadsheet: 473853d1470433983-how-to-search-filter-data-by-from-other-sheets-ef949_syllabus-book
Sheet: Sheet2

Department | Level | Term | Subject | Subject Code | [NAME] | Credit Hour | Contact Hour | Course Content
CE | 1 | 1 | Mathematics | MATH 101 | Mathematics-1 | 3 | 3 | Aaa
CE | 1 | 2 | Physics | PHY 103 | Physics-1 | 2 | 2 | Bbb
CE | 2 | 1 | Chemistry | CHEM 201 | Chemistry-1 | 3 | 3 | [NAME]
CE | 2 | 2 | Economics | ECO 203 | Economics-1 | 2 | 2 | [NAME]
ME | 1 | 1 | Mathematics | MATH 111 | Mathematics-2 | 3 | 3 | Eee
ME | 1 | 2 | Physics | PHY 113 | Physics-2 | 2 | 2 | Fff
ME | 2 | 1 | Chemistry | CHEM 211 | Chemistry-2 | 3 | 3 | Ggg
ME | 2 | 2 | Economics | ECO 213 | Economics-2 | 2 | 2 | Hhh
CSE | 1 | 1 | Mathematics | MATH 123 | Mathematics-3 | 3 | 3 | Mmm
CSE | 1 | 2 | Physics | PHY 123 | Physics-3 | 2 | 2 | [NAME]
CSE | 2 | 1 | Chemistry | CHEM 221 | Chemistry-3 | 3 | 3 | Ooo
CSE | 2 | 2 | Economics | ECO 223 | Economics-3 | 2 | 2 | Ppp
Spreadsheet: jonathan_mckay__17262__6th Floorplan-newco
Sheet: Sheet1

East Gas Trading & Orig - c
 | [NAME] |  |  | Ops #1 | Ops #2
 |  |  |  | 483 | 483
 |  |  |  |  | 477
 | Admin. | Ops #3 | Ops #4 | Ops #5 | Ops#6
 | S.Loving | Ops #7 | Ops #8 | Ops #9 | Ops #10 | Ops #11
 |  |  |  |  |  | 470
 |  |  |  |  |  | 463
 | F.Vickers | J.Kaiser | C.Ames | J.Townsend | P.Keavey | S.Brawner
 | D.Jones | [NAME]* | A.Ring | S.Neal | [NAME] | B.McKay
 | 461 |  |  |  |  | 456