tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 82410d1282473208-sum-type-between-2-dates-sumif-by-date
Sheet: Sheet1

Dates | Type | Amount |  | Summary Totals
2010-04-01 00:00:00 | Car | 10 |  | April | 2010-04-01 00:00:00 | 45
2010-04-04 00:00:00 | House | 23 |  | May | 2010-05-01 00:00:00 | 2
2010-04-27 00:00:00 | Car | 12 |  | June | 2010-06-01 00:00:00 | 333
2010-05-05 00:00:00 | Food | 2
2010-06-06 00:00:00 | House | 333
 |  |  |  | Summary by Month | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
 |  |  |  | Car
 |  |  |  | House
 |  |  |  | Food
Spreadsheet: 854568d1704389940-shift-work-sick-leave-and-hours-worked-calculator-sample-sheet-5-
Sheet: Sheet1

Hours Calculator V1.0 | Thursday XXth January to Wednesday XXst January
Day | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W |  |  |  | Overtime Shift
Month | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Hours | How many sick days? | How many OT hours? | RDO
[NAME] |  |  |  |  |  |  |  | Sick | Sick | OT | Nightshift | Nightshift | Training day 8 Hours |  |  |  |  | nightshift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | day shift
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Training day 8 Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sick
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WC
STAFF NUMBERS
Overtime Shift
roster day off
nightshift 7-7
day shift
leave with detail /alternative duties
nightshift 11-7
Spreadsheet: 867235d1714079862-extract-values-from-between-characters-text-extractor
Sheet: TextExtractor

Data | Sys | [NAME] | HR
0114: 113/79/87: note |  | 79 | 87
0115: 97/78/83 |  | 78 | 83
0116: 110/79/104 |  | 79 | 104
0117: 111/79/82 |  | 79 | 82
0118: 106/77/83: other note |  | 77 | 83
0119: 107/74/82 |  | 74 | 82
0120: 114/101/84 |  | 101 | 84
0121: 112/77/77 |  | 77 | 77
0122: 111/74/82 |  | 74 | 82
0123: 113/76/82 |  | 76 | 82
0124: 109/76/79 |  | 76 | 79
0125: 108/76/80 |  | 76 | 80
0126: 99/73/77: asdfasdf |  | 73 | 77
0127: 109/73/82 |  | 73 | 82
0128: 108/74/77 |  | 74 | 77
0129: 105/76/79 |  | 76 | 79
0130: 109/75/80 |  | 75 | 80
0131: 112/76/79 |  | 76 | 79
Spreadsheet: 055259bf-ed86-4490-9b06-df7e47452d96
Sheet: Sheet1

Table 8--Oilseed prices received by U.S. farmers | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybeans2 | Cottonseed3 | Sunflowerseed2 | Canola4 | Peanuts3 | Flaxseed4
year
 | $/bushel | $[NAME] | $/cwt. | $/cwt. | Cents/pound | $/bushel
2001/02 | 4.38 | 90.5 | 9.62 | 8.77 | 23.4 | 4.29
2002/03 | 5.53 | 101 | 12.1 | 10.6 | 18.2 | 5.77
2003/04 | 7.34 | 117 | 12.1 | 10.6 | 19.3 | 5.88
2004/05 | 5.74 | 107 | 13.7 | 10.7 | 18.9 | 8.07
2005/06 | 5.66 | 96 | 12.1 | 9.62 | 17.3 | 5.94
2006/07 | 6.43 | 111 | 14.5 | 11.9 | 17.7 | 5.8
2007/08 | 10.1 | 162 | 21.7 | 18.3 | 20.5 | 13
2008/09 | 9.97 | 223 | 21.8 | 18.7 | 23 | 12.7
2009/10 | 9.59 | 158 | 15.1 | 16.2 | 21.7 | 8.15
2010/11 | 11.3 | 161 | 23.3 | 19.3 | 22.5 | 12.2
2011/121 | 12.45 | 259 | 28.9 | 24 | 31.7 | 14
2012/131 | 15.00-17.00 | 295-325 | 24.10-27.40 | 25.35-28.65 | 30.85-34.15 | 13.00-15.00
2010/11
September | 9.98 | 154 | 18.1 | 17.4 | 19.9 | 10.8
October | 10.2 | 158 | 19.9 | 18.2 | 21.4 | 11.8
November | 11.1 | 162 | 18.7 | 19.1 | 22.3 | 12.6
December | 11.6 | 163 | 20.6 | 19.5 | 24 | 13.1
January | 11.6 | 165 | 21.9 | 20.3 | 23 | 13.8
February | 12.7 | 172 | 27.4 | 20.4 | 23.5 | 15.3
March | 12.7 |  | 28.3 | 23.4 | 23.4 | 13.7
April | 13.1 |  | 28.8 | 24.8 | 23.1 | 13.5
May | 13.2 |  | 30 | 23.5 | 22.8 | 14.2
June | 13.2 |  | 29 | 25.1 | 23.3 | 15.4
July | 13.2 |  | 30.4 | 24.3 | 23.9 | 15.4
August | 13.4 | 213 | 32.2 | 23.1 | 23.2 | 14.3
2011/12
September | 12.2 | 245 | 32.9 | 23.2 | 23.2 | 13.5
October | 11.7 | 245 | 29.6 | 22.7 | 28.3 | 13.9
November | 11.7 | 269 | 29 | 23.3 | 33.1 | 14
December | 11.5 | 264 | 29.6 | 23 | 30.8 | 13.6
January | 11.9 | 281 | 28.7 | 23.3 | 33.6 | 13.6
February | 12.2 | 275 | 29.6 | 24.8 | 32.9 | 13.3
March | 13 |  | 28.5 | 27.1 | 34.8 | 13.8
April | 13.7 |  | 28.5 | 27.8 | 35.1 | 14.1
May | 14 |  | 29 | 27.7 | 33.8 | 14.9
June | 13.9 |  | 27.3 | 27.4 | 34.4 | 12.9
July1 | 15.6 |  | 25.5 | 26.5 | 35.3 | 13.2
1 Preliminary.  2 September-August.  3August-July. 4 July-June.
NA = Not available.
Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Last update: | 2012-08-13 23:25:55.220000
Spreadsheet: 03404072-139c-4a50-b6d2-45146e974018
Sheet: Sheet1

Make | Model | Rear Travel (mm) | Rear Sag (mm)
BMW | R100GS | 180 | 54.00000000000001
BMW | R1100GS | 200 | 60.00000000000001
BMW | R1150GS | 200 | 60.00000000000001
BMW | R1150GSA | 220 | 66.00000000000001
BMW | R1200GS | 200 | 60.00000000000001
BMW | R1200GSA | 220 | 66.00000000000001
BMW | R1200GS LOW | 170 | 51.00000000000001
BMW | F800GS | 215 | 64.50000000000001
BMW | F800GS-A | 215 | 64.50000000000001
BMW | F650GS Twin | 170 | 51.00000000000001
BMW | [NAME] | 210 | 63.00000000000001
BMW | G650GS | 160 | 48.00000000000001
BMW | [NAME] | 210 | 63.00000000000001
SUZUKI | DL1000 | 160 | 48.00000000000001
SUZUKI | DL650 | 160 | 48.00000000000001
TRIUMPH | Tiger 800XC | 215 | 64.50000000000001
TRIUMPH | 1200 Explorer | 194 | 58.20000000000001
YAMAHA | XT1200Z | 190 | 57.00000000000001
Spreadsheet: 709114d1608167437-countif-two-cells-with-same-content-does-not-work-in-this-case-questions-to-ask
Sheet: Store Inventory

 | SbSC
Helper column | Fruit | Number of fruit | [NAME] | Remaining fruit | [NAME] on TODAY | Ordering Alert
1 | Apple | 10 | 2021-03-03 00:00:00
 | Apple | 10 | 2021-03-03 00:00:00
 | Orange | 5
Spreadsheet: andy_zipper__264__Broker detail 5-11-01
Sheet: BROKER DEAL SUMMARY

EnronOnline | 2001-04-26 00:00:00
[NAME] for 5/11/2001
Completed Transactions:
LIFE TO DATE |  |  |  |  |  |  |  |  | TODAY
 |  |  |  |  |  |  |  |  | Date | 2001-05-11 00:00:00
DAILY DEAL COUNT | Commodity |  |  |  |  |  |  |  | DAILY DEAL COUNT | Commodity
Broker | Natural Gas | Power | Grand Total |  |  |  |  |  | Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 35 | 82 | 117 |  |  |  |  |  | APB Energy, Inc. | 2 | 12 | 14
Natsource LLC | 28 | 159 | 187 |  |  |  |  |  | Natsource LLC |  | 8 | 8
Power Merchants Group, LLC | 6 |  | 6 |  |  |  |  |  | Grand Total | 2 | 20 | 22
Grand Total | 69 | 241 | 310
Failed Transactions:
LIFE TO DATE |  |  |  |  |  |  |  |  | TODAY
 |  |  |  |  |  |  |  |  | Date | 2001-05-11 00:00:00
FAILED TRANSACTION COUNT | Commodity |  |  |  |  |  |  |  | FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total |  |  |  |  |  | Broker | Power | Grand Total
APB Energy, Inc. | 9 | 17 | 26 |  |  |  |  |  | APB Energy, Inc. | 3 | 3
Natsource LLC | 4 | 28 | 32 |  |  |  |  |  | Grand Total | 3 | 3
Power Merchants Group, LLC | 16 |  | 16
Grand Total | 29 | 45 | 74
Spreadsheet: 121925d1316513289-excel-2007-solved-how-to-group-and-sort-data-forumxl
Sheet: Sheet1

Chassis | Network Element Name | Slot No | Product ID | SNMP Name | Current Termination Milestone
jr1 | PN1 | Chassis | JP1 | CS1 | 1 Yr to Termination
jr1 | PN1 | 1 | JP2 | CS2 | 6 months to Termination
jr1 | PN1 | 1 | JP3 | CS3
jr1 | PN1 | 2 | [NAME] | CS4 | Terminated
jr1 | PN1 | 3 | JP5 | CS5 | Terminated
jr1 | PN1 | 3 | JP6 | CS6 | 1 Yr to Termination
jr1 | PN1 | 4 | JP7 | CS7
jr1 | PN1 | 6 | JP8 | CS8
jr1 | PN1 | 7 | JP9 | CS9
jr1 | PN1 | 8 | JP10 | CS10 | Terminated
jr1 | PN1 | 8 | JP11 | CS11 | 1 Yr to Termination
jr1 | PN1 | 9 | [NAME] | CS12 | Terminated
jr1 | PN1 | 9 | [NAME] | CS13 | 1 Yr to Termination
jr2 | PN2 | Chassis | [NAME] | CS14 | 1 Yr to Termination
jr2 | PN2 | 1 | JP15 | CS15 | 6 months to Termination
jr2 | PN2 | 1 | JP16 | CS16
jr2 | PN2 | 2 | JP17 | CS17 | Terminated
jr2 | PN2 | 3 | JP18 | CS18 | Terminated
jr2 | PN2 | 6 | JP19 | CS19 | Terminated
jr2 | PN2 | 6 | [NAME] | CS20 | 1 Yr to Termination
jr2 | PN2 | 7 | JP21 | CS21 | Terminated
jr2 | PN2 | 7 | JP22 | CS22 | 1 Yr to Termination
jr2 | PN2 | 8 | JP23 | CS23 | Terminated
jr2 | PN2 | 8 | [NAME] | CS24 | 1 Yr to Termination
jr2 | PN2 | 9 | JP25 | CS25 | Terminated
jr2 | PN2 | 9 | JP26 | CS26 | 1 Yr to Termination
[NAME] | PN3 | Chassis | JP27 | CS27
[NAME] | PN3 | 1 | JP28 | CS28
[NAME] | PN3 | 2 | [NAME] | CS29
[NAME] | PN3 | 3 | JP30 | CS30
[NAME] | PN3 | 4 | JP31 | CS31
[NAME] | PN3 | 5 | JP32 | CS32
[NAME] | PN3 | 5 | JP33 | CS33
[NAME] | PN3 | 5 | JP34 | CS34
[NAME] | PN3 | 7 | [NAME] | CS35
[NAME] | PN3 | 7 | [NAME] | CS36
[NAME] | PN3 | 8 | JP37 | CS37
[NAME] | PN3 | 8 | JP38 | CS38
[NAME] | PN3 | 9 | JP39 | CS39
[NAME] | PN3 | 9 | [NAME] | CS40
Spreadsheet: 46ecb3e3-b993-4ee7-88c5-03e96c9f6288
Sheet: Sheet1

 | Credit  Headcount At Census
 | MSJC SJC Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
Male
Female
Undeclared
Term Total
Academic Year
% of Total | Credit Headcount % of Total
 | MSJC SJC Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
Male
Female
Undeclared
Success Rate | Success Rate
 | MSJC SJC Total by Gender
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Gender | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
Male
Female
Undeclared
Term Average
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Note: district totals exclude dual enrollment data
Spreadsheet: 97497d1296660374-matching-and-conditional-referncing-calculation-excel-help
Sheet: CS-Sheet3

NORTHGATE |  |  | LTGM | LTBH | LTBR | LTCA | LTOE | LTMF | LTAA | LTPI | [NAME] | LTGR
Scheme ID | Property Reference | Full Address | Grounds Maintenance | [NAME] | Bulk Refuse | Estate Communal Maintenance | Other Estate Services | Management Fees | Audit and Accountancy | Property Insurance | External Agent Costs | Ground Rent
PENTSO/WHITSO | MOS05290001012 | FMO | 0.2307692307692307 |  |  |  | 0 | 1.23 | 5 |  |  | 14.62
PENTSO/WHITSO | MOS05290002012 |  | 0.2307692307692307 |  |  |  | 0 | 1.07 | 4.33 |  |  | 12.67
PENTSO/WHITSO | MOS05290006012 | 0 | 0.2307692307692307 |  |  |  | 0 | 1.23 | 5 |  |  | 14.62
PENTSO/WHITSO | MOS05290007012 | 15 | 0.2307692307692307 |  |  |  | 0 | 1.07 | 4.33 |  |  | 12.67
 |  |  |  |  |  |  |  |  | 4.33 |  |  | 12.67
 |  |  |  |  |  |  |  |  | 4.33 |  |  | 12.67
 |  |  |  |  |  |  |  |  | 4.33 |  |  | 12.67
Spreadsheet: a8589767-cec1-4e21-997b-f2f90099c7f4
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38748013 | 2013-11-28 20:24:08 | ALLIES | 0 | 3 | 7 | 778385 | Major [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
38748222 | 2013-11-28 20:38:20 | AXIS | 1 | 7 | 3 | 778385 | Major [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
38749380 | 2013-11-28 22:01:52 | AXIS | 1 | 7 | 4 | 29441 | w a r r i o r | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
38749610 | 2013-11-28 22:16:55 | ALLIES | 0 | 2 | 7 | 29441 | w a r r i o r | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
38852764 | 2013-12-06 05:06:00 | AXIS | 1 | 6 | 5 | 1216091 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
38853023 | 2013-12-06 05:35:16 | ALLIES | 0 | 5 | 6 | 1216091 | [NAME] | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
38865268 | 2013-12-07 03:34:17 | AXIS | 0 | 5 | 6 | 188507 | WiredNun | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
38865444 | 2013-12-07 03:51:11 | ALLIES | 0 | 3 | 6 | 188507 | WiredNun | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
38865592 | 2013-12-07 04:13:25 | AXIS | 0 | 3 | 6 | 188507 | WiredNun | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
38865807 | 2013-12-07 04:29:00 | ALLIES | 0 | 4 | 6 | 188507 | WiredNun | 6152 | western | 1944-12-20 | 1944-12-22 | [NAME] | St. Vith
38873751 | 2013-12-07 18:45:08 | AXIS | 0 | 4 | 6 | 418850 | SIR B LAW | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
38874049 | 2013-12-07 18:59:29 | ALLIES | 0 | 3 | 6 | 418850 | SIR B LAW | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
38888425 | 2013-12-08 17:44:42 | AXIS | 0 | 0 | 6 | 1077170 | [NAME] | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38888689 | 2013-12-08 18:02:21 | ALLIES | 1 | 6 | 5 | 1077170 | [NAME] | 8044 | eastern | 1942-01-26 | 1942-02-07 | Rzhev | Rzhev
38888995 | 2013-12-08 18:19:00 | AXIS | 0 | 3 | 6 | 1077170 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
38889230 | 2013-12-08 18:34:58 | ALLIES | 0 | 5 | 6 | 1077170 | [NAME] | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
38895802 | 2013-12-09 02:08:40 | AXIS | 1 | 6 | 1 | 1152035 | minderbinder | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
38895964 | 2013-12-09 02:24:06 | ALLIES | 0 | 2 | 6 | 1152035 | minderbinder | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
Spreadsheet: 797121d1663716925-dynamic-trend-formula-to-reflect-ytd-trend-1-
Sheet: Sheet1

 | 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
 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual
 | 2021-01 | 2021-02 | 2021-03 | 2021-04 | 2021-05 | 2021-06 | 2021-07 | 2021-08 | 2021-09 | 2021-10 | 2021-11 | 2021-12 | 2022-01 | 2022-02 | 2022-03 | 2022-04 | 2022-05 | 2022-06 | 2022-07 | 2022-08 | 2022-09 | 2022-10 | 2022-11 | 2022-12 | 2023-01 | 2023-02 | 2023-03 | 2023-04 | 2023-05 | 2023-06
Act | 9611 | 9911 | 10197 | 9108 | 9826 | 9982 | 9909 | 9119 | 9910 | 9106 | 9102 | 999 | 10151 | 10134 | 9899 | 9653 | 10135 | 11033 | 10535 | 9984
Plan 2 | 9611 | 9911 | 10197 | 9108 | 9826 | 9982 | 9909 | 9119 | 9910 | 9106 | 9102 | 999 | 10151 | 10134 | 9899 | 9653 | 10135 | 11033 | 10535 | 9984 | 10864 | 10710 | 10530 | 10100 | 10000 | 9760 | 10300 | 10289 | 9984 | 8827
Trend
HD
Spreadsheet: 699918d1602828388-highlight-highest-1st-2nd-and-3rd-values-in-multiple-columns-conditional-formatting-3-highest-value
Sheet: Sheet3 (2)

Product | Item 1 | Item 2 | Item 3 | Item 4 | Grand Total | [NAME] | Min | 1st | 2nd | 3rd
Product 1 | 11868 | 13603 | 10045 | 5513 | 41029
Product 2 | 11868 | 13603 | 10045 | 5513 | 41029
Product 3 | 11374 | 13036 | 9628 | 5283 | 39321
Product 4 | 9890 | 11336 | 8371 | 4594 | 34191
Product 5 | 7838 | 8984 | 6635 | 4028 | 27485
Product 6 | 7838 | 8984 | 6635 | 4028 | 27485
Product 7 | 7511 | 8610 | 6358 | 3860 | 26339
Product 8 | 6532 | 7487 | 5528 | 3356 | 22903
Product 9 | 5759 | 6601 | 4876 | 2955 | 20191
Product 10 | 5759 | 6601 | 4876 | 2955 | 20191
Product 11 | 5519 | 6327 | 4672 | 2831 | 19349
Product 12 | 4800 | 5502 | 4062 | 2463 | 16827
Product 13 | 4691 | 5377 | 3971 | 1946 | 15985
Product 14 | 4691 | 5377 | 3971 | 1946 | 15985
Product 15 | 4569 | 4408 | 3734 | 3156 | 15867
Product 16 | 4569 | 4408 | 3734 | 3156 | 15867
Product 17 | 4495 | 5153 | 3805 | 1865 | 15318
Product 18 | 4270 | 3968 | 3409 | 2968 | 14615
Product 19 | 4039 | 3758 | 3134 | 2531 | 13462
Product 20 | 4039 | 3758 | 3134 | 2531 | 13462
Product 21 | 3909 | 4481 | 3308 | 1623 | 13321
Product 22 | 3887 | 3696 | 3209 | 2901 | 13693
Product 23 | 3771 | 3696 | 3209 | 2901 | 13577
Product 24 | 3740 | 3318 | 2809 | 2343 | 12210
Product 25 | 3624 | 3696 | 3209 | 2901 | 13430
Product 26 | 3624 | 3696 | 3209 | 2901 | 13430
Product 27 | 3357 | 3046 | 2609 | 2276 | 11288
Product 28 | 3241 | 3046 | 2609 | 2276 | 11172
Product 29 | 3094 | 3046 | 2609 | 2276 | 11025
Product 30 | 3094 | 3046 | 2609 | 2276 | 11025
Product 31 | 2902 | 2170 | 2184 | 1035 | 8291
Product 32 | 2902 | 2170 | 2184 | 1035 | 8291
Product 33 | 2781 | 2079 | 2094 | 993 | 7947
Product 34 | 2419 | 1808 | 1820 | 863 | 6910
Product 35 | 2112 | 1989 | 1469 | 721 | 6291
Product 36 | 2112 | 1989 | 1469 | 721 | 6291
Product 37 | 2112 | 1989 | 3134 | 721 | 7956
Product 38 | 2112 | 1989 | 3134 | 721 | 7956
Product 39 | 1919 | 1808 | 1334 | 656 | 5717
Product 40 | 1919 | 1808 | 1334 | 656 | 5717
Product 41 | 1787 | 1937 | 1430 | 1453 | 6607
Product 42 | 1782 | 1504 | 1110 | 514 | 4910
Product 43 | 1782 | 1504 | 2809 | 514 | 6609
Product 44 | 1620 | 1368 | 1009 | 468 | 4465
Product 45 | 1361 | 1205 | 890 | 441 | 3897
Product 46 | 1361 | 1205 | 2609 | 441 | 5616
Product 47 | 1237 | 1096 | 809 | 401 | 3543
Product 48 | 1234 | 1205 | 890 | 441 | 3770
Product 49 | 1234 | 1205 | 2609 | 441 | 5489
Product 50 | 1121 | 1096 | 809 | 401 | 3427
Product 51 | 1072 | 1205 | 890 | 441 | 3608
Product 52 | 1072 | 1205 | 890 | 441 | 3608
Product 53 | 1072 | 1205 | 2609 | 441 | 5327
Product 54 | 974 | 1096 | 809 | 401 | 3280
Product 55 | 974 | 1096 | 809 | 401 | 3280
Product 56 | 770 | 1057 | 781 | 751 | 3359
Product 57 | 612 | 802 | 593 | 594 | 2601
Product 58 | 605 | 833 | 616 | 615 | 2669
Product 59 | 212220 | 223271 | 183139 | 109874 | 728504
Spreadsheet: 823492d1679992190-group-4-data-sets-into-one-book11
Sheet: Sheet1

ID | Surname | First Name | CODE | Value 1 |  | ID | Surname | First Name | CODE | Value 2 |  | ID | Surname | First Name | CODE | Value 3 |  | ID | Surname | First Name | CODE | Value 4 |  | ID | Surname | First Name | CODE | Value 1 | Value 2 | Value 3 | Value 4 |  |  | Surname | First Name | CODE | Value 1 | Value 2 | Value 3 | Value 4
111 | aaa | aaa | PPY | 70 |  | 111 | aaa | aaa | PPY | 1 |  | 111 | aaa | aaa | PPY | 1 |  | 111 | aaa | aaa | PPY | 1 |  | 111 | aaa | aaa | PPY | 70 | 1 | 1 | 1 |  | 111 | aaa | aaa | PPY | 70 | 1 | 1 | 1
222 | bbb | bbb | PPY | 48 |  | 222 | bbb | bbb | PPY | 2 |  | 222 | bbb | bbb | PPY | 2 |  | 222 | bbb | bbb | PPY | 2 |  | 111 | aaa | aaa | 17XY | 38 | 6 | 6 | 6 |  | 222 | bbb | bbb | PPY | 48 | 2 | 2 | 2
333 | [NAME] | [NAME] | PPY | 59 |  | 333 | [NAME] | [NAME] | PPY | 3 |  | 333 | [NAME] | [NAME] | PPY | 3 |  | 333 | [NAME] | [NAME] | PPY | 3 |  | 222 | bbb | bbb | PPY | 48 | 2 | 2 | 2 |  | 333 | [NAME] | [NAME] | PPY | 59 | 3 | 3 | 3
444 | ddd | eee | PPY | 84 |  | 444 | ddd | eee | PPY | 4 |  | 444 | ddd | eee | PPY | 4 |  | 444 | ddd | eee | PPY | 4 |  | 222 | bbb | bbb | 17XY | 91 | 7 | 7 | 7 |  | 444 | ddd | eee | PPY | 84 | 4 | 4 | 4
555 | eee | eee | PPY | 86 |  | 555 | eee | eee | PPY | 5 |  | 555 | eee | eee | PPY | 5 |  | 555 | eee | eee | PPY | 5 |  | 333 | [NAME] | [NAME] | PPY | 59 | 3 | 3 | 3 |  | 555 | eee | eee | PPY | 86 | 5 | 5 | 5
111 | aaa | aaa | 17XY | 38 |  | 111 | aaa | aaa | 17XY | 6 |  | 111 | aaa | aaa | 17XY | 6 |  | 111 | aaa | aaa | 17XY | 6 |  | 333 | [NAME] | [NAME] | 17XY | 64 | 8 | 8 | 8 |  | 111 | aaa | aaa | 17XY | 38 | 6 | 6 | 6
222 | bbb | bbb | 17XY | 91 |  | 222 | bbb | bbb | 17XY | 7 |  | 222 | bbb | bbb | 17XY | 7 |  | 222 | bbb | bbb | 17XY | 7 |  | 444 | ddd | eee | PPY | 84 | 4 | 4 | 4 |  | 222 | bbb | bbb | 17XY | 91 | 7 | 7 | 7
333 | [NAME] | [NAME] | 17XY | 64 |  | 333 | [NAME] | [NAME] | 17XY | 8 |  | 333 | [NAME] | [NAME] | 17XY | 8 |  | 333 | [NAME] | [NAME] | 17XY | 8 |  | 444 | ddd | ddd | 17XY | 40 | 9 | 9 | 9 |  | 333 | [NAME] | [NAME] | 17XY | 64 | 8 | 8 | 8
444 | ddd | ddd | 17XY | 40 |  | 444 | ddd | ddd | 17XY | 9 |  | 444 | ddd | ddd | 17XY | 9 |  | 444 | ddd | ddd | 17XY | 9 |  | 555 | eee | eee | PPY | 86 | 5 | 5 | 5 |  | 444 | ddd | ddd | 17XY | 40 | 9 | 9 | 9
555 | eee | eee | 17XY | 84 |  | 555 | eee | eee | 17XY | 10 |  | 555 | eee | eee | 17XY | 10 |  | 555 | eee | eee | 17XY | 10 |  | 555 | eee | eee | 17XY | 84 | 10 | 10 | 10 |  | 555 | eee | eee | 17XY | 84 | 10 | 10 | 10
RAW DATA 1 |  |  |  |  |  | RAW DATA 2 |  |  |  |  |  | RAW DATA 3 |  |  |  |  |  | RAW DATA 4 |  |  |  |  |  | DESIRED RESULT
Spreadsheet: 857166d1706206097-textjoin-with-delimited-for-same-name-textjoin-by-same-name
Sheet: Sheet1

Company Name | Amended Name |  |  | Amended Name | Result
ABC Ltd (Taiwan) | ABC Ltd (Taiwan) |  |  | ABC Ltd (Taiwan)
ABC Ltd (Taiwan) ([NAME]) | ABC Ltd (Taiwan) |  |  | Tiger Co
ABC Ltd (Taiwan) (XJH22222) | ABC Ltd (Taiwan) |  |  | Black Pte Ltd
Tiger Co (JZZ88888) | Tiger Co |  |  | Monbly (Pte) Ltd
Tiger Co (ABC77777) | Tiger Co
Tiger Co | Tiger Co
Black Pte Ltd | Black Pte Ltd
Black Pte Ltd (PKD76251) | Black Pte Ltd
Monbly (Pte) Ltd | Monbly (Pte) Ltd
Monbly (Pte) Ltd (HTT21212) | Monbly (Pte) Ltd |  |  | *How do i get Column E and Column F via a formula?
 |  |  |  | Row Labels | Result
 |  |  |  | ABC Ltd (Taiwan) | ABC Ltd (Taiwan), ABC Ltd (Taiwan) ([NAME]), ABC Ltd (Taiwan) (XJH22222)
 |  |  |  | Black Pte Ltd | Black Pte Ltd, Black Pte Ltd (PKD76251)
 |  |  |  | Monbly (Pte) Ltd | Monbly (Pte) Ltd, Monbly (Pte) Ltd (HTT21212)
 |  |  |  | Tiger Co | Tiger Co (JZZ88888), [NAME] (ABC77777), [NAME]
Spreadsheet: 163287d1340267004-excel-2008-i-need-formula-for-cumulative-frequency-for-two-coexisting-values-in-two-different-columns-book2
Sheet: Sheet1

 | A | B |  |  |  |  |  | plate -cup | plate -plate | cup-plate | plate -plate | plate -cup | cup-cup | plate -cup
 | plate | cup
 | plate | cup
 | plate | plate
 | cup | plate
 | plate | plate
 | plate | cup
 | cup | cup
 | plate | cup
 |  |  |  | YAHOOO | : sandeep