tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 859517d1707896113-meter-reading-problem-meter-reading-problem
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | previous reading | current reading
 |  |  | No. | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | Final Reading
 |  |  | Meter A | 510773 | 516718 | 532814 | 547899 | 569236 | 575878 | 586945 | 587640 | 806230 |  |  | 806230
 |  |  | [NAME] | 703714 | 734689 | 770209 | 792476 | 810780 | 840263 | 865963 | 905216 | 368000 |  |  | 1368000
 |  |  | [NAME] | 878387 | 960102 | 967478.2 | 1047493 | 1107716 | 1245351.1 | 1630566.6 | 1918741 | 486000 |  |  | 2404741
 |  |  | Case background:
 |  | 1 | Actual meter reading is only max 6 digital.
 |  | 2 | Check the max month & year
 |  | 3 | If the current reading (Jan 24) is bigger than the reading (Dec-23)
 |  | 4 | Final reading is the same as the current reading
 |  | 5 | If the current reading (Jan 24) is small than the reading (Dec-23)
 |  | 6 | Final reading is cumulative reading, i.e. sum of the current reading and the previous reading
 |  | 7 | The formula can search automatically the current reading & previous reading when I input a new current reading in the table monthly.
Spreadsheet: 215921d1361541678-sum-of-sum-tableau-entrep-ts
Sheet: A6

Local A6
Nom: | [NAME]
Numéro de téléphone: | [PHONE]
[NAME]: | 0
Paiement dû le: | 2013-03-15 00:00:00
[NAME]: | 13
Réservé:
Prix: | 125
Payé: | OUI
Mois réservés
Novembre 2011
Décembre 2011
Janvier 2012
Février 2012
Mars 2012
Avril 2012
Mai 2012
[NAME] 2012
Juillet 2012
Août 2012
Septembre 2012
Octobre 2012
Novembre 2012
Décembre 2012
Spreadsheet: 864799d1711948868-from-static-to-dynamic-cell-reference-via-indirect-function-raw-materials-record
Sheet: SBC

Raw Material |  | SBC
Date | Description | Batch Processed Quantity |  | Quantity Stored ([NAME]'s) | Quantity Issued ([NAME]'s) | Total Quantity Remaining ([NAME]'s) | Bilty or Batch (Description)
 |  | Qty | [NAME]'s
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8
2023-09-30 00:00:00 |  |  |  |  |  | 64.611
Total
Spreadsheet: 698795d1602177896-oscilloscop-data-cleanup-for-bode-diagram-sample
Sheet: Sheet1

Second | V1 | V2 | cleaning duplicates | zero crossing | [NAME] | min
0 | -0.0012 | -0.68 |  |  |  |  | maximum should only evaluate cells one below 7 until the column that consist a number in row E, in this example a range from D8:D13
5e-07 | -0.0016 | 0.07
1e-06 | -0.0012 | 0.068
1.5e-06 | -0.0012 | 0.072
2e-06 | -0.0012 | 0.07
4e-06 | -0.002 | 0.072
4.5e-06 | -0.0016 | 0.07
5.5e-06 | -0.0012 | -0.072
6e-06 | -0.0016 | -0.07
8.5e-06 | -0.0012 | -0.072
Spreadsheet: 220794d1363267951-adding-rows-with-data-tandridge-test
Sheet: Ark1

 |  |  | Highlight yellow G3:M800. Can copy row 800 and paste 801 carry on down>> G4=Number K see B3:B7,  H4 & L4 type teams,  J4 & K4  match results,  I4 & L4 with * is penalty shootout if result stand draw after extra time. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Number K | Match Type | Index K |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Type teams name> | Westerham | JDG | Bromley | [NAME] | Orpington | Genesis | [NAME] | Oxted | Balgowan | Otford
1 | Friendly Matches | 20 |  | Rank: | Points: | Number K | Home Team: | * | H-Goals: | A-Goals: | * | Away Team: | Rank: | [NAME] | Goal-dif: | GD-fix: | Result: | Rank-dif: | Index K | Expected Result: | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
2 | All other tournaments | 30 |  |  |  | 1 | Westerham |  | 1 | 0 |  | JDG
3 | World cup and Continental qualifiers | 40 |  |  |  | 1 | Bromley |  | 1 | 4 |  | [NAME]
4 | Continental Championship and intercontinental | 50 |  |  |  | 1 | Orpington |  | 1 | 1 |  | semour villa
5 | World cup Finals | 60 |  |  |  | 1 | Genesis |  | 3 | 1 |  | Oxted
 |  |  |  |  |  | 1 | Balgowan |  | 1 | 5 |  | Otford
 |  |  |  |  |  | 1 | Westerham |  | 2 | 2 |  | glebe
Do not touch as this is automatic from U1 to BR1 |  |  |  |  |  | 1 | JDG |  | 3 | 1 |  | bromley
 |  |  |  |  |  | 1 | [NAME] |  | 2 | 6 |  | oxted
1 |  |  |  |  |  | 1 | Balgowan |  | 1 | 4 |  | genesis
2 |  |  |  |  |  | 1 | Bromley |  | 0 | 2 |  | westerham
3 |  |  |  |  |  | 1 | JDG |  | 4 | 4 |  | glebe
4 |  |  |  |  |  | 1 | Orpington |  | 2 | 7 |  | balgowan
5 |  |  |  |  |  | 1 | [NAME] |  | 1 | 8 |  | [NAME]
6 |  |  |  |  |  | 1 | Westerham |  | 9 | 5 |  | orpington
7 |  |  |  |  |  | 1 | Genesis |  | 10 | 0 |  | Oxted
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
Spreadsheet: 349378d1412289808-need-an-if-function-that-only-completes-a-formula-if-conditions-are-met-gradebook
Sheet: Sheet1

Project 1 | Project 2 | Project 3 | Project 4 | In-class [NAME] | Attendance | P1 | P2 | P3 | P4 | I | A | Current Grade |  |  | P1 Complete | P1 & P2 Complete | P1, P2 & P3 Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A+
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A-
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | B
 |  |  |  |  |  |  |  |  |  |  |  |  |  | B-
 |  |  |  |  |  |  |  |  |  |  |  |  |  | C+
 |  |  |  |  |  |  |  |  |  |  |  |  |  | C
 |  |  |  |  |  |  |  |  |  |  |  |  |  | C-
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  | D-
Spreadsheet: 213792d1360659474-enquiry-tracker-linked-sheets-sample_enquiry_tracker
Sheet: Q1

Quarter 1 : January -March 2012
Mode of Enquiry
 | Jan | Feb | Mar | Total
Website
Direct Enquiry
Word of Mouth
Trade Shows
Enquiries Assigned to Subteams
Technical Contact | Sub-Group | Jan | Feb | Mar | Total
Suresh | Ateam
Ramesh | Bteam
Girish | Cteam
Anna | Dteam
NCR
Mumbai
South
Rest of India
Not Known
Target Platform | Total
iPhone/iPad | #N/A
Mac | #N/A
iPhone/iPad/Mac | #N/A
iPhone/Mac | #N/A
iOS/Blackberry | #N/A
iOS/Blackberry/Android | #N/A
iPhone | #N/A
iPad | #N/A
Android | #N/A
Tablet | #N/A
Blackberry | #N/A
Playbook | #N/A
iPhone/Android | #N/A
iPhone/iPad/Android | #N/A
Windows Phone 7 | #N/A
Mobile Platforms | #N/A
[NAME] | #N/A
Symbian | #N/A
Others | #N/A
Spreadsheet: 769399d1645525291-if-and-function-gives-value-error-sample
Sheet: Sheet1

Client type | Ranking
B | 4
A | 7
A | 7
A | 10
A | 7
C | -1
A | 9
A | 9
A | 10
B | 8
B | 9
A | 8
B | -1
A | 10
D | 10
A | 8
E | -1
A | -1
F | 8
A | 8
 |  |  |  |  |  |  |  |  |  | "A"
 |  |  |  |  |  |  |  |  | >8
 |  |  |  |  |  |  |  |  | 7, 8
Spreadsheet: 748ac04f-0795-4036-b5d2-72e1513ac2b9
Sheet: Sheet1

link to the unit | Title | Level | Unit credit | GLH | Qualification/s the unit available within
The Register of Regulated Qualifications - View Unit : Do your job in a customer friendly way | Do your job in a customer friendly way | 1 | 5 | 33 | [NAME] in Cleaning and Support Services (QCF)
http://register.ofqual.gov.uk/Unit/Details/R_601_6071 | Apply legislation, regulation and organisational procedures for customer service | 1 | 3 | 24 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
[NAME] | Deal with queries and requests | 1 | 3 | 22 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
http://register.ofqual.gov.uk/Unit/Details/K_502_4005 | Creating business documents | 1 | 3 | 30 | [NAME] in Business Adminstration
http://register.ofqual.gov.uk/Unit/Details/F_502_4009 | Working in business & administration | 1 | 3 | 30 | [NAME] in Business Adminstration
http://register.ofqual.gov.uk/Unit/Details/A_502_4008 | Handling mail | 1 | 2 | 20 | [NAME] in Business Adminstration
http://register.ofqual.gov.uk/Unit/Details/A_601_6078 | Positive communication with customers | 1 | 2 | 20 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
http://register.ofqual.gov.uk/Unit/Details/A_601_6081 | Work in a customer-friendly way | 1 | 2 | 18 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
[NAME] | The customer service experience | 1 | 2 | 20 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
http://register.ofqual.gov.uk/Unit/Details/T_601_6077 | Answer telephone calls from customers | 1 | 2 | 18 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
http://register.ofqual.gov.uk/Unit/Details/T_502_4007 | Making and receiving calls | 1 | 2 | 20 | [NAME] in Business Adminstration
http://register.ofqual.gov.uk/Unit/Details/F_601_6079 | Contribute to effective customer service | 1 | 2 | 20 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
http://register.ofqual.gov.uk/Unit/Details/R_601_6068 | Create a good impression to customers | 1 | 2 | 18 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
http://register.ofqual.gov.uk/Unit/Details/M_601_6076 | Working in customer service | 1 | 2 | 18 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
http://register.ofqual.gov.uk/Unit/Details/M_502_4006 | Welcome visitors | 1 | 2 | 20 | [NAME] in Business Adminstration
http://register.ofqual.gov.uk/Unit/Details/K_601_6075 | Record and communicate customer problems | 1 | 2 | 18 | [NAME] 3 and Level 1 Awards and Certificates for Introduction to Customer Service
http://register.ofqual.gov.uk/Unit/Details/L_601_1614 | Follow the rules to deliver customer service | 2 | 4 | 30 | [NAME] in Cleaning and Support Services (QCF)
Spreadsheet: 49298d1248637035-excel-2007-filter-random-data-text-into-a-text-table-filter-data
Sheet: Sheet1

Random Data: |  |  | Filter 1: | Filter 2: |  |  | First | Second | Third | Fourth | Fifth | Sixth | Seventh | Eight | Nineth | Tenth | …
Is a: Dog |  | 1 | Dog eat | Dog eat |  | Dog | eat | sleep | sleep | eat | walk | walk | n/a | n/a | n/a | n/a | …
eat |  | 2 | [NAME] eat | Dog sleep |  | [NAME] | eat | run | sleep | walk | run | run | n/a | n/a | n/a | n/a | …
Is a: [NAME] |  | 3 | Dog sleep | Dog sleep
eat |  | 4 | [NAME] run | Dog eat
Is a: Dog |  | 5 | Dog sleep | Dog walk
sleep |  | 6 | Mouse sleep | Dog walk
Junk |  | 7 | Dog eat | [NAME] eat
Is a: [NAME] |  | 8 | Mouse walk | [NAME] run
run |  | 9 | [NAME] run | Mouse sleep
Is a: Dog |  | 10 | [NAME] run | Mouse walk
sleep |  | 11 | Dog walk | [NAME] run
Is a: [NAME] |  | 12 | Dog walk | [NAME] run
sleep |  |  | Junk
Is a: Dog |  |  | Junk 2
eat |  |  | Junk 3 …
Junk |  |  | (ignore all Junk)
Is a: [NAME]
walk
Is a: [NAME]
run
Junk
Is a: [NAME]
run
Is a: Dog
walk
Is a: Dog
walk
Junk
Junk 2
Junk 3 …
Spreadsheet: 802248d1666726441-series-on-different-columns-example-serie
Sheet: Sheet1

 | ElementA | ElementB | A |  |  |  |  | As should be
1 | TeamA | TeamB | 1 |  |  | 1 | Team A Series | 1
2 | TeamA | TeamB | 1 |  |  | 2 |  | 2
3 | TeamB | TeamA | 0 |  |  | 3 |  | 0
4 | TeamA | TeamB | 1 |  |  | 4 |  | 1
5 | TeamA | TeamB | 1 |  |  | 5 |  | 2
6 | TeamB | TeamA | 1 |  |  | 6 |  | 3
7 | TeamA | TeamB | 1 |  |  | 7 |  | 4
8 | TeamB | TeamA | 0 |  |  | 8 |  | 0
9 | TeamA | TeamB | 1 |  |  | 9 |  | 1
10 | TeamA | TeamB | 1 |  |  | 10 |  | 2
Spreadsheet: 96446d1295857545-curve-fitting-and-interpolation-curvft_1
Sheet: ورقة1

 | from scanned  curve manually |  |  | curve fit equation |  | LINEST
x | t=0 | t=30 |  | t=0 | t=30 | 0
0 | 0 | 0
1 | 0.2
2 | 0.4
3 | 0.62
4 | 0.85
5 | 1.1 | 1.3
6
7 | 1.5
8 | 1.7
9 | 1.95 | 2.3
10
11
12 | 2.55
13 | 2.8
14 | 3
15 | 3.2 | 3.7
16 | 3.42
17 |  | 4.2
18
19 | 4.1
20 | 4.3 | 4.9
21
22
23 |  | 5.6
24 | 5.2
25 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Using LINEST
26 |  |  |  |  |  |  |  | t | 0 |  |  |  |  | -0.01952380952380961 |  |  | t | 15
27 |  |  |  |  |  |  |  | x | 12 |  |  |  | 0.00488507375361225 | 0.01479029527991649 |  |  | x | 22
28 | 6.1 | 6.8 |  |  |  |  |  | y |  |  |  |  | 0.9980162578638581 | 0.02043572968159071 |  |  | y
29 |  | 7 |  |  |  |  |  |  |  |  |  |  | 2012.391106043331 | 4
30 | 6.5 |  |  |  |  |  |  |  |  |  |  |  | 0.8404128571428572 | 0.00167047619047619
Spreadsheet: andy_zipper__175__DYNEGY-ICE VOL Apr23
Sheet: Enron Activity-ICE

ICE
Transactions and Notional Volume
By Enron Entity, Commodity, and [NAME]
Enron North America - ICE |  |  |  |  |  | Enron Power Marketing - ICE |  |  |  |  |  | Enron Canada Corp - ICE
ICE GAS VOLUME: |  | ENRON PERCENTAGE: |  |  |  | ICE POWER VOLUME: |  |  | ENRON PERCENTAGE:
 |  |  | Data |  |  |  |  |  | Data |  |  | No Activity
Trader | Product | Qty Units | Transactions | Volume |  | Trader | Product | Qty Units | Transactions | Volume
[NAME], J | NG Fin, FP for LD1 | MMBtus | 1 | 912500 |  | Carson , M | Firm-LD Peak | MWhs | 5 | 7200
Mckay, B | NG Fin BS, LD1 for IF | MMBtus | 1 | 310000 |  | Dorland , C | Firm-LD Peak | MWhs | 16 | 87200
Quigley, D | NG [NAME], ID, GDD | MMBtus | 4 | 3720000 |  | Richter, J | Firm-LD Off-Peak | MWhs | 1 | 8200
Grand Total |  |  | 6 | 4942500 |  | Grand Total |  |  | 22 | 102600
Spreadsheet: e2fc1d68-f858-4af8-8f95-03859b3a9496
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
[NAME] | Test | [NAME] | ADAMTS13 Inhibitor Bethesda Titer | ADAMTS13 Inhibitor Bethesda Titer | ADMBU/61214 - not orderable only performed and charged as a reflex of profile ADM13/61212. |  |  |  |  |  | Only orderable as part of a profile. For further information see ADM13/61212 ADAMTS13 Activity and Bethesda Inhibitor [NAME]. | 2 mL | Hemolysis 	Mild OK; Gross reject Thawing	Warm reject; Cold reject Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | <0.4 BU |  |  |  | 1 | 85335 |  |  |  |  | Rochester
[NAME] | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 14 days
[NAME] | Result | 61214 | ADAMTS13 Inhibitor Bethesda Titer | ADAMTS13 Inhibitor Bethesda Titer | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 8d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Fixed-Float | 17598 | 4628 | 23598 | 2682
OTHER* | 2668 | 3572 | 88 | 1590
TOTAL | 20266 | 8200 | 23686 | 4272
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, FRA,  Inflation, OIS, and Swaption.
Spreadsheet: 273541d1382746206-grid-formula-ef514_lean-to-roofs
Sheet: Sheet1

LEAN TO ROOF |  |  |  | conservatory size |  | width | 4.15 | depth | 2.85
STANDARD OR LOW PITCH
WIDTH | 2750 | 3000 | 3250 | 3500 | 3750 | 4000 | 4250 | 4500 | 4750 | 5000
HEIGHT
2000 | 1674 | 1723 | 1795 | 1868 | 1948 | 2042 | 2114 | 2197 | 2267 | 2338
2250 | 1778 | 1841 | 1925 | 1995 | 2065 | 2174 | 2305 | 2314 | 2398 | 2470
2500 | 1901 | 1971 | 2042 | 2114 | 2197 | 2291 | 2363 | 2446 | 2516 | 2586
2750 | 2008 | 2091 | 2174 | 2244 | 2314 | 2421 | 2493 | 2530 | 2646 | 2718
3000 | 2152 | 2220 | 2291 | 2363 | 2446 | 2539 | 2610 | 2693 | 2765 | 2835
3250 | 2255 | 2338 | 2398 | 2471 | 2563 | 2648 | 2714 | 2812 | 2878 | 2944
3500 | 2303 | 2363 | 2431 | 2497 | 2576 | 2665 | 2742 | 2853 | 2895 | 2965
3750 | 2398 | 2476 | 2554 | 2620 | 2688 | 2789 | 2855 | 2922 | 3001 | 3067
Spreadsheet: 840236d1692599998-generating-pivot-table-using-indirect-function-or-others-in-excel-pt-using-indirect-aligw
Sheet: Report

Sky | >Pivot table using indirect function
 |  |  |  |  |  |  | Sum of Qty | Column Labels
 |  |  |  |  |  |  | Row Labels | Orange | Apple | Pears | (blank) | Grand Total
 |  |  |  |  |  |  | Jan | 84 | 36 | 99 |  | 219
 |  |  |  |  |  |  | Feb | 77 | 93 |  |  | 170
 |  |  |  |  |  |  | (blank)
 |  |  |  |  |  |  | Grand Total | 161 | 129 | 99 |  | 389
Spreadsheet: 217436d1362068050-complex-sorting-music-new
Sheet: Alternative

 | # | Genre • Alternative | Album # | Album Title | # Of Tracks | Total Album Time | Avg. Track Time | Release Year | Total Tracks | Total Time
 | 1 | All-American Rejects, The | 1 | Same Girls, New Songs | 6 | 00:20:34 | 00:03:26 | 2001 | 65 | 04:05:55
 |  |  | 2 | All-American Rejects, The | 13 | 00:49:55 | 00:03:50 | 2003
 |  |  | 3 | [NAME] | 15 | 00:54:27 | 00:03:38 | 2005
 |  |  | 4 | When The World Comes Down | 15 | 00:55:13 | 00:03:41 | 2008
 |  |  | 5 | Kids In The Street | 16 | 01:05:46 | 00:04:07 | 2012
 | 1 | Athenaeum | 1 | [NAME], The | 4 | 00:15:07 | 00:03:47 | 1995 | 38 | 02:25:55
 |  |  | 2 | Radiance | 12 | 00:45:06 | 00:03:46 | 1998
 |  |  | 3 | Blue Album, The | 10 | 00:40:30 | 00:04:03 | 2001
 |  |  | 4 | Hourglass | 12 | 00:45:12 | 00:03:46 | 2002
Spreadsheet: 816734d1675796423-nested-if-with-vlookup-based-on-a-yes-no-selection-test-for-vlookup-mr-excel-etaf-2
Sheet: Dining List

 | ser | Title | Surname | First Name | Payment Type
 |  |  | Black | [NAME] | BACS Confirmed
 |  | Mrs | [NAME] | [NAME] | BACS TBN
 |  | Mr | Jones | [NAME] | Card
 |  | Mr | Smith | [NAME] | BACS Confirmed
 |  | Ms | Ward | [NAME] | Card
 |  | Mrs | White | [NAME] | BACS Confirmed
Spreadsheet: 831916d1685988364-subtract-the-amount-from-remainders-based-on-criteria-subtract-the-figure-from-remainders-of-criteria-based-
Sheet: Sheet1

 |  | Products | price
 |  | PRODUCT 1 | 2
 |  | PRODUCT 2 | -1.8
 |  | PRODUCT 3 | 0.42
 |  | PRODUCT 1 | 3 |  | Respected  Sir / Mam
 |  | PRODUCT 2 | -1.8
 |  | PRODUCT 3 | 0.42 |  | I want Subtract the amount based on Product Criteria i.e. product 1
 |  | PRODUCT 1 | -2 |  | I want the calculation of Subtraction to be as follows based on Remainders
 |  | PRODUCT 2 | -1.8 |  | All Prices of product 1
 |  | PRODUCT 3 | 0.42 |  | D4 | 2
 |  | PRODUCT 1 | -1 |  | D7 | 3
 |  | PRODUCT 2 | -1.8 |  | D10 | -2
 |  | PRODUCT 3 | 0.43 |  | D13 | -1
 |  | PRODUCT 1 | 4 |  | D16 | 4
 |  | PRODUCT 2 | -1.84 |  | [NAME] | 5
 |  | PRODUCT 3 | 0.44 |  | D22 | -3
 |  | PRODUCT 1 | 5 |  | D25 | 4
 |  | PRODUCT 2 | -1.89 |  | D28 | 5
 |  | PRODUCT 3 | 0.45 |  | [NAME] | 6
 |  | PRODUCT 1 | -3 |  | D34 | 4
 |  | PRODUCT 2 | -1.89 |  |  | Balance
 |  | PRODUCT 3 | 0.45
 |  | PRODUCT 1 | 4
 |  | PRODUCT 2 | -1.89
 |  | PRODUCT 3 | 0.45
 |  | PRODUCT 1 | 5
 |  | PRODUCT 2 | -1.94
 |  | PRODUCT 3 | 0.45
 |  | PRODUCT 1 | 6
 |  | PRODUCT 2 | -1.94
 |  | PRODUCT 3 | 0.45
 |  | PRODUCT 1 | 4
 |  | PRODUCT 2 | -1.99
 |  | PRODUCT 3 | 0.47
Spreadsheet: 868096d1714812491-adding-an-extra-if-to-a-formular-stock-calculator-formular-creating-vlookup-0912
Sheet: Table

Code | Min | [NAME] | Diff
[NAME] | 1 | 8 |  |  | [NAME]
DS14C | 4 | 20
DS17C | 3 | 5
DS22C | 4 | 45
DS6
DS6L
DS14
DS17
DS22
DS14L
[NAME]
DS22L
DS1L
DS2
DS2L
DS2C
DSPS-B
[NAME]
DSPS-C
DSPL-B
DSPLL
DSPL-C
ALP12
DSR12
DSR16
DSR18
DSR12L
DSR16L
[NAME]
PP7
PP9
[NAME]
DS17P
DA204
DA205
3208
830420-108
3242
3234
830860-501
35.870
3260
3262
3269
3278
831710-101
365
365LID
J230
362
3282
850820-100
3286
830570-105
2820
2824
40C
2454
100F
WN-057
2463
2472
543RPL
104F | 2 | 3
2233
2258PLPF
2282
2364
511934-100
2014
2038
2050-02
2074
P73
3050
1236
F63
913CPL
2618
2650
2662
V375A
DN1300
DN1100
DN1200
DN1400
DN1500
DN1600
KR500
KR750
KRL
V500
V24B
V24BL
V32B
V32BL
V80B
V80BL
MWB812
MWB813
[NAME]
L8003
L9003
TEP120C
TEP180
TEP280
TEP375
TEP520
TEP565
TEP670
TEP800
TEP1000
TEP280RT
IP2.4
IP2.4L
IP2.4C
C400
No Sales Code See Below
No Sales Code See Below
[NAME]
No Sales Code See Below
No Sales Code See Below
CD121X
No Sales Code See Below
No Sales Code See Below
CD161X
T1000
T125
ESP125
PL125
PL2
PL4
T200C
CAKES1
MWB810
MWB813
[NAME]
MWB512S
MWB516S
MWB5LS
[NAME]
MWB700
[NAME]
C500
C650
C1000
2155-1D
RT12/40B
2187-1G
2200-1B
2200-1C
2227-1D
DOT35
J130
J160
J180
J140P
J180P
DOT140F1
?
SAND-QTR
ES004B-A
F97M
TR7
RB1
5201
5202
HS15/20
HS15/25
HS15/35
HS20/25
HS25/30
HS25/35
HS30/40
LSM
300/150LS
400-200LS
600-300LS
700-350LS
900-450LS
412SI
12RCK
CUPWRAP
[NAME]
ST7
DFR12-C
DFR16-C
70CPST
624
BBB35H
BBB7H
BBB14H
FF7
FF85
FF10
FF12
FF14
MGW5
MGW7
MGW10
MGW10-UNSTRUNG
MGW125
KPB150
HDVC1319
HDVC1117
PB810
PB1012
PB1215
PB1520
OWF-400
SILMB
GP1/4
131P
HB6
HB2
HB3
HB8/3
HB8
BT2
SPORKW
152W
5840W
5844W
4MKITWDK
HB1
KR8
KR8L
QSB1
QSB3
QSB4
QSB8
ECT05
ECT2
ECT3
ES004C-SUN
TS2K
AD0531
L Sealer M
B160D
MTPA
Mistral 350
830860-301
5215
5231
5251 (No. 1)
5254 (No.6a)
5256
5259
5261
830420-300 (N0.2)
830570-309
850820-300
7114W
7112B
Spreadsheet: 35397d1232997605-line-consolidation-example
Sheet: Sheet1

 | Apples / Oranges | Number | Curr | Description | Date | Sales code
 | Apples | 120 | GBP | Fruit | 2009-01-23 00:00:00 | GB0032785924
 | Apples | 150 | GBP | Fruit | 2009-01-23 00:00:00 | GB0032785924
 | Apples | 100 | GBP | Fruit | 2009-01-23 00:00:00 | GB0032785924
 | Oranges | 700 | GBP | Fruit | 2009-01-23 00:00:00 | GB0032785924
 | Oranges | 500 | GBP | Fruit | 2009-01-23 00:00:00 | GB0003042636
 | Oranges | 100 | GBP | Fruit | 2009-01-23 00:00:00 | GB0003042636
 | Oranges | 600 | GBP | Fruit | 2009-01-23 00:00:00 | GB0003042636
 | Oranges | 60 | GBP | Fruit | 2009-01-23 00:00:00 | GB0003042636
 | Apples | 300 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0330274
 | Apples | 200 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0330274
 | Apples | 900 | GBP | Fruit | 2009-01-24 00:00:00 | GB00B0330274
 | Apples | 800 | GBP | Fruit | 2009-01-23 00:00:00 | GB0008890161
 | Oranges | 200 | GBP | Fruit | 2009-01-23 00:00:00 | GB0008890161
 | Oranges | 300 | GBP | Fruit | 2009-01-23 00:00:00 | GB0008890161
 | Apples | 100 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0LNX641
 | Oranges | 330 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0LNX641
 | Apples | 250 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0LNX641
 | Oranges | 950 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0LNX641
 | Oranges | 15 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0LNX641
I am looking to compare in the columns in red, if red cells of row 2 = red cells of row 3, delete row 3 and add the column apples / oranges, it should thereafter look like this.
 | Apples | 370 | GBP | Fruit | 2009-01-23 00:00:00 | GB0032785924
 | Oranges | 1960 | GBP | Fruit | 2009-01-23 00:00:00 | GB0032785924
 | Apples | 1400 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0330274
 | Apples | 900 | GBP | Fruit | 2009-01-24 00:00:00 | GB00B0330274
 | Apples | 800 | GBP | Fruit | 2009-01-23 00:00:00 | GB0008890161
 | Oranges | 500 | GBP | Fruit | 2009-01-23 00:00:00 | GB0008890161
 | Apples | 700 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0LNX641
 | Oranges | 965 | GBP | Fruit | 2009-01-23 00:00:00 | GB00B0LNX641