tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862020d1709820750-counting-dates-and-times-ooh-sample
Sheet: Sheet2

01/02/2023 17:05:05 JOB CREATED
01/02/2023 17:15:12 JOB CREATED |  | 44958.71888888889
01/02/2023 18:32:47 JOB CREATED |  | 44958.77276620371
01/02/2023 18:38:34 JOB CREATED |  | 44958.77678240741
01/02/2023 19:01:54 JOB CREATED |  | 44958.79298611111
01/02/2023 20:25:36 JOB CREATED |  | 44958.85111111111
01/02/2023 22:18:49 JOB CREATED |  | 44958.9297337963
02/02/2023 17:34:27 JOB CREATED |  | 44959.73225694444
02/02/2023 18:21:22 JOB CREATED |  | 44959.76483796296
02/02/2023 18:24:55 JOB CREATED |  | 44959.76730324074
02/02/2023 18:37:22 JOB CREATED |  | 44959.77594907407
02/02/2023 19:05:12 JOB CREATED |  | 44959.79527777778
02/02/2023 23:20:48 JOB CREATED |  | 44959.97277777778
02/02/2023 23:23:08 JOB CREATED |  | 44959.97439814815
03/02/2023 [NAME] JOB CREATED |  | 44960.76438657408
03/02/2023 18:35:45 JOB CREATED |  | 44960.77482638889
03/02/2023 19:02:05 JOB CREATED |  | 44960.79311342593
03/02/2023 19:04:50 JOB CREATED |  | 44960.79502314814
04/02/2023 07:21:03 JOB CREATED |  | 44961.30628472222
04/02/2023 07:51:44 JOB CREATED |  | 44961.32759259259
04/02/2023 08:15:51 JOB CREATED |  | 44961.34434027778
04/02/2023 07:51:44 JOB CREATED |  | 44961.32759259259
04/02/2023 09:11:35 JOB CREATED |  | 44961.38304398148
05/02/2023 [NAME] JOB CREATED |  | 44962.31363425926
05/02/2023 08:11:05 JOB CREATED |  | 44962.34103009259
05/02/2023 08:12:10 JOB CREATED |  | 44962.34178240741
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
Spreadsheet: 741614d1627204574-excel-room-booking-sheet-using-sumproduct-and-conditional-formatting-excel-room-booking-sheet-using-sumproduct-and-conditional-formatting-amended-250721-
Sheet: Room Reservation

Room Type - for calendar | Room No - only for calendar |  |  |  |  |  |  |  | Guest Name | Check In | Check Out
Standard | 2 |  |  |  |  |  |  |  | Guest 4 | 2021-07-15 00:00:00 | 2021-07-22 00:00:00
Standard | 4 |  |  |  |  |  |  |  | Guest 5 | 2021-07-15 00:00:00 | 2021-07-23 00:00:00
Standard | 1 |  |  |  |  |  |  |  | Guest 6 | 2021-07-17 00:00:00 | 2021-07-24 00:00:00
Standard | 2 |  |  |  |  |  |  |  | Guest 8 | 2021-07-21 00:00:00 | 2021-07-29 00:00:00
Standard | 3 |  |  |  |  |  |  |  | Guest 7 | 2021-07-24 00:00:00 | 2021-07-28 00:00:00
Standard | 1 |  |  |  |  |  |  |  | Guest 9 | 2021-07-24 00:00:00 | 2021-07-30 00:00:00
Standard | 3
Spreadsheet: 1cad0fbb-e93d-4055-b70e-ab5d3d2f308b
Sheet: RefWorks Usage 11-12

RefWorks
2011-2012
Metric | 2011-07-01 00:00:00 | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | Total | 2011-2012 Price | Cost per unit
New Users | 11 | 3 | 167 | 80 | 71 | 11 | 34 | 40 | 36 | 28 | 9 | 16 |  | 14450
Repeat Users | 42 | 24 | 56 | 144 | 155 | 10 | 42 | 95 | 88 | 108 | 43 | 35 |  | 14450
Total Monthly Users | 53 | 27 | 223 | 224 | 226 | 121 | 76 | 135 | 124 | 136 | 52 | 51 |  | 14450
Total Sessions per month | 247 | 115 | 847 | 1174 | 1087 | 488 | 295 | 661 | 498 | 629 | 214 | 195 |  | 14450
Average Sessions Per User | 4.66 | 4.26 | 3.8 | 5.24 | 4.81 | 4.03 | 3.88 | 4.9 | 4.02 | 4.63 | 4.12 | 3.82 |  | 14450
Total Subscriber References added | 817 | 1328 | 2104 | 3082 | 3086 | 1200 | 1173 | 1686 | 1164 | 1482 | 532 | 858 |  | 14450
Average References added per user | 15.42 | 49.19 | 9.43 | 13.76 | 13.76 | 9.92 | 15.43 | 12.49 | 9.39 | 10.9 | 10.23 | 16.82 |  | 14450
TOTAL USERS = 2,654
TOTAL REFERENCES = 104,440
Spreadsheet: 109759d1306523036-formula-requiring-three-actions-advfilterexample
Sheet: Sheet1

Name1 | [NAME] | Name3 | Value
[NAME] | Betty | [NAME] | 25
Fred | [NAME] | Tyler | 48
[NAME] | [NAME] | Jeanne | 75
[NAME] | Jake | Mandy | 14
Data is above
[NAME] is below
Name1 | [NAME] | Name3 | Value
Fred | [NAME] | Tyler
Name1 | [NAME] | Name3 | Value
Fred | [NAME] | Tyler | 48 | <<Answer
Spreadsheet: 871765d1718188509-march-fishing-xls-hpe-needed-sac-league
Sheet: INTERIM

Rank | Points |  | Events |  | Last Meeting | Previous meeting |  | Members | Interim weight results | Interim total points | Rank [NAME]
1 | 12 |  |  |  |  |  |  | [NAME]
2 | 10 |  |  |  |  |  |  | [NAME]
3 | 8 |  |  |  |  |  |  | [NAME]
4 | 7 |  | 4 |  |  |  |  | [NAME]
5 | 6 |  | 5 |  |  |  |  | [NAME]
6 | 5 |  | 6 |  |  |  |  | [NAME]
7 | 4 |  | 7 |  |  |  |  | [NAME]
8 | 3 |  | 8 |  |  |  |  | [NAME]
9 | 2 |  | 9 |  |  |  |  | [NAME]
10 | 1 |  | 10 |  |  |  |  | [NAME]
11 | 1 |  | 11 |  |  |  |  | R beasly
12 | 1 |  | 12 |  |  |  |  | M Jaques
13 | 1 |  | 13 |  |  |  |  | [NAME]
14 | 1 |  |  |  |  |  |  | c puffet
15 | 1 |  |  |  |  |  |  | [NAME] webber
16 | 1 |  |  |  |  |  |  | k puffet
17 | 1 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | D Neal
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | I hickson
 |  |  |  |  |  |  |  | J daly
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Ruben sampson
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Bingo
Spreadsheet: sara_shackleton__36756__Entity locations of trades
Sheet: Ownership 2000_11 Start

 |  |  |  |  | Enron Corp
 | Enron Power Corp |  | Enron Europe LLC
 | 0.863 |  | 0.137
 |  | ECT Europe Inc |  |  |  |  |  | ENAC |  | Shared entity
 |  | EEL |  |  |  |  |  | ECTRC |  | Entity employing staff etc
 | EPOL |  | ECCL |  | Dedicated entity
 | Entity owning systems, employing staff etc |  | EFET LLC |  | Irrelevant entity
Ownership 100% unless otherwise stated
Key: | Dedicated trading |  | Shared trading |  | Shared operations
Spreadsheet: 817265d1676083378-stock-allocation-tool-need-formula-with-2-conditions-cartel1
Sheet: Foglio1

 | MIN | 1
 | MAX | 3
 |  |  | 18 | 31 | 5 | 39 | 33 | 4 | 15 | 52
 |  | ALLOCATION KEY | BOLLITORE ELETTRICO 1,7 LT | 6 BICCHIERI ACQUA BORMIOLI | COMPLETO LETTO SINGOLO M.ITALY | TOVAGLIA 100% COTONE 140X230CM | TOVAGLIA ANTIMACCHIA 140X180 | LENZUOLO CON ANGOLI 180X200CM | LENZUOLO CON ANGOLI 90X200 CM | SET 18 PEZZI PIATTI VETRO B.CO
 | TOT | Priority | 73020 | 1733 | 15043 | 35075 | 45015 | 45031 | 75031 | 3056
808 | LI-COLLESALVETTI | 99
807 | LI-ROSIGNANO MARITTIMO | 98
817 | [NAME] COREGLIA | 97
803 | FI-FUCECCHIO | 96
822 | PI-LARI | 95
809 | LI-VIA LULLI | 94
813 | LU-MASSAROSA | 93
823 | PI-FRAZ.PUTIGNANO | 92
814 | LU-PIETRASANTA | 91
812 | LU-ALTOPASCIO | 90
821 | PI-MONTESCUDAIO | 89
819 | MS-MONTIGNOSO | 88
815 | LU-PORCARI | 87
811 | LI-VIA DI COLLINAIA | 86
820 | MS-AVENZA | 85
810 | LI-VIA MASTACCHI | 84
818 | LU-PIEVE FOSCIANA | 83
816 | LU-VIAREGGIO | 82
Spreadsheet: 24995d1216061620-continue-searching-a-table-with-vlookup-despite-finding-one-match-calendar-help
Sheet: background

Account Manager | IFE Name | Avionics Name | Payloads Name | Confirm | Region | Begin Day | End Day | Customer | [NAME] |  | Ives, [NAME]
Ives, [NAME] | [NAME], [NAME] | Crist, [NAME] |  | 1 | Americas | 2008-07-02 00:00:00 | 2008-07-04 00:00:00 | CQT | 2008-07-02 00:00:00 | 2008-07-04 00:00:00 | Ives, [NAME]
 |  | Winger, [NAME] |  | 1 |  | 2008-07-02 00:00:00 | 2008-07-04 00:00:00 |  | 2008-07-02 00:00:00 | 2008-07-04 00:00:00
Churchill, Brett |  |  |  | 0 | Europe | 2008-07-07 00:00:00 | 2008-07-10 00:00:00 | AAL | not booked | not booked
Bevis, [NAME] |  |  |  | 1 | Europe | 2008-07-07 00:00:00 | 2008-07-14 00:00:00 |  | 2008-07-07 00:00:00 | 2008-07-14 00:00:00
Bevis, [NAME] |  |  |  | 0 | Europe | 2008-07-07 00:00:00 | 2008-07-14 00:00:00 |  | not booked | not booked
Ives, [NAME] |  |  |  | 1 | Americas | 2008-07-28 00:00:00 | 2008-07-31 00:00:00 |  | 2008-07-28 00:00:00 | 2008-07-31 00:00:00
Ives, [NAME] |  |  |  | 1 | Americas | 2008-07-12 00:00:00 | 2008-07-18 00:00:00 |  | 2008-07-12 00:00:00 | 2008-07-18 00:00:00
Ives, [NAME] |  |  |  | 0 | Europe | 2008-07-07 00:00:00 | 2008-07-14 00:00:00 |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
 |  |  |  |  |  |  |  |  | not booked | not booked
Spreadsheet: 733667d1621696622-extract-data-with-conditions-extracting-data
Sheet: source_data

PRODUCT CODE | PRODUCT NAME | COUNTRY | 1Y SALES-1 | 1Y SALES | 1Y GROWTH-1 | 1Y GROWTH | 3Y SALES-1 | 3Y SALES | 3Y GROWTH-1 | 3Y GROWTH
AAA | AAA PLC | England | 100 | 110 | 2 | -1 | 50 | 55 | 3 | 4
BBB | BBB PLC | England | 110 | 120 | 3 | 4 | 55 | 60 | 3 | 5
CCC | CCC PLC | England | 120 | 130 | -1 | -2 | 60 | 65 | -1 | -2
DDD | DDD PLC | England | 130 | 140 | 3 | 5 | 65 | 70 | -2 | -1
EEE | EEE PLC | England | 140 | 150 | -1 | -2 | 70 | 75 | -1 | 2
KKK | KKK PLC | Scotland | 150 | 160 | 2 | -1 | 75 | 80 | 3 | 4
LLL | LLL PLC | Scotland | 160 | 170 | 3 | 4 | 80 | 85 | 3 | 5
MMM | MMM PLC | Scotland | 170 | 180 | -1 | -2 | 85 | 90 | -1 | -2
NNN | NNN PLC | Scotland | 180 | 190 | 3 | 5 | 90 | 95 | -2 | -1
OOO | OOO PLC | Scotland | 190 | 200 | -1 | -2 | 95 | 100 | -1 | 2
VVV | VVV PLC | Wales | 200 | 210 | 2 | -1 | 100 | 105 | 3 | 4
WWW | WWW PLC | Wales | 210 | 220 | 3 | 4 | 105 | 110 | 3 | 5
[NAME] | XXX PLC | Wales | 220 | 230 | -1 | -2 | 110 | 115 | -1 | -2
YYY | YYY PLC | Wales | 230 | 240 | 3 | 5 | 115 | 120 | -2 | -1
ZZZ | ZZZ PLC | Wales | 240 | 250 | -1 | -2 | 120 | 125 | -1 | 2
Spreadsheet: 734945d1622617737-leave-calendar-to-count-the-number-of-days-of-leave-each-staff-has-left-leave-plan-draft-v3
Sheet: September

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
Spreadsheet: 64665168-470a-4551-9869-09c2005eac12
Sheet: Balance Sheet

Autodesk, Inc.
Condensed Consolidated Balance Sheets
(In millions)
 | July 31, | April 30, | January 31, | October 31, | July 31, | April 30, | January 31, | October 31, | July 31,
 | 2014 | 2014 | 2014 | 2013 | 2013 | 2013 | 2013 | 2012 | 2012
ASSETS:
Current assets:
Cash and cash equivalents | 1323.1 | 1609.6 | 1853 | 1473.4 | 1401 | 1655.8 | 1612.2 | 827 | 930.2
Marketable securities | 583.3 | 510.1 | 414.1 | 587.1 | 596.9 | 432.1 | 342.1 | 502.1 | 500.5
Accounts receivable, net | 365.3 | 323.3 | 423.7 | 304.1 | 303.9 | 285.8 | 495.1 | 293.3 | 361.4
Deferred income taxes | 76.3 | 54.5 | 56.8 | 53.5 | 51.6 | 56 | 42.2 | 48.4 | 44.8
Prepaid expenses and other current assets | 102 | 92.8 | 87.4 | 99.8 | 83.1 | 81.4 | 60.8 | 53.8 | 65.8
Total current assets | 2450 | 2590.3 | 2835 | 2517.9 | 2436.5 | 2511.1 | 2552.4 | 1724.6 | 1902.7
Marketable securities | 262.1 | 268.2 | 277.3 | 418.5 | 410.1 | 392 | 411.1 | 408.3 | 286.1
Computer equipment, software, furniture and leasehold
improvements, net | 146.9 | 142.1 | 130.3 | 134.1 | 133.4 | 129 | 114.9 | 114.6 | 109
Purchased technologies, net | 100.7 | 89.4 | 63.1 | 54.3 | 63.1 | 69.2 | 76 | 75.9 | 71.4
Goodwill | 1447.6 | 1263 | 1009.9 | 922.3 | 903.2 | 895.7 | 871.5 | 824.6 | 739.2
Deferred income taxes, net | 86.8 | 93.6 | 131.1 | 118.3 | 125.3 | 134.3 | 122.8 | 128.3 | 136.8
Other assets | 209.3 | 202 | 148.3 | 156.1 | 151.7 | 158.4 | 159.7 | 152.9 | 130.7
 | 4703.4 | 4648.6 | 4595 | 4321.5 | 4223.3 | 4289.7 | 4308.4 | 3429.2 | 3375.9
LIABILITIES & STOCKHOLDERS' EQUITY:
Current liabilities:
Accounts payable | 92.4 | 90.3 | 84.5 | 75.3 | 74.4 | 86.1 | 94.2 | 75.9 | 82.9
Accrued compensation | 165.7 | 156.6 | 181.2 | 154.7 | 125.7 | 123.2 | 189.6 | 155.6 | 136.6
Accrued income taxes | 37.3 | 36.4 | 24.3 | 37.2 | 42.5 | 35.4 | 13.9 | 14.2 | 17
Deferred revenue | 763 | 749.7 | 696.2 | 610.8 | 636.9 | 663.7 | 647 | 558.1 | 590.9
Borrowings under line of credit | — | — | — | — | 0 | 0 | 0 | 110 | 0
Other accrued liabilities | 98.9 | 85.7 | 85.3 | 70.1 | 76.4 | 71.4 | 99 | 71.5 | 74
Total current liabilities | 1157.3 | 1118.7 | 1071.5 | 948.1 | 955.9 | 979.8 | 1043.7 | 985.3 | 901.4
Deferred revenue | 217.8 | 213.8 | 204.4 | 154.9 | 168.6 | 187.7 | 187.6 | 155.6 | 161.1
Long term income taxes payable | 186.8 | 170.5 | 211.8 | 209 | 203.4 | 193.3 | 194.2 | 184.4 | 179
Long term notes payable, net of discount | 746.8 | 746.6 | 746.4 | 746.2 | 746 | 745.8 | 745.6 | 0 | 0
Other liabilities | 111.3 | 110.3 | 99.4 | 101.4 | 98.3 | 98.6 | 94.1 | 86 | 83.1
Stockholders' equity:
Common stock and additional paid-in capital | 1697.1 | 1683.1 | 1637.3 | 1535.1 | 1455.8 | 1499.5 | 1449.8 | 1438.9 | 1457.3
Accumulated other comprehensive income (loss) | 2.3 | 5.6 | -0.6 | -4.1 | -7.5 | -2 | -5.7 | -6.4 | 0.6
Retained earnings | 584 | 600 | 624.8 | 630.9 | 602.8 | 587 | 599.1 | 585.4 | 593.4
Total stockholders' equity | 2283.4 | 2288.7 | 2261.5 | 2161.9 | 2051.1 | 2084.5 | 2043.2 | 2017.9 | 2051.3
 | 4703.4 | 4648.6 | 4595 | 4321.5 | 4223.3 | 4289.7 | 4308.4 | 3429.2 | 3375.9
Spreadsheet: 03b356fa-0b76-4798-80aa-8203414f2bb1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | OP CODES | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22
 |  | 0 - Summary Control
 |  | A - Add |  |  |  |  |  |  |  |  |  |  | STATE  OF  HAWAII |  |  |  |  | Date Prepared
 |  | C - Change |  |  |  | REC CODES |  |  |  |  |  |  | STATE PROCUREMENT OFFICE
 |  | D - Delete |  |  | 0 - Summary Control |  |  |  |  |  |  |  | DETAIL  INVENTORY  OF  PROPERTY
 |  | X - Removal |  |  | 1 - Org/Loc Header Title |  |  |  |  | Classification of Property |  |  | SPO FORM  17-A  (REV 10/04) Excel2000 |  | Quarter Ended Date |  |  |  |  | PAGE _______ OF
 |  |  |  |  | 3 - Detail Inventory
 |  |  | DEPARTMENT / DIV./ SUB-DIV / |  |  |  |  |  |  | PROPERTY CUSTODIAN |  |  | PREPARED BY: FULL NAME & PHONE NO. | PURCHASED FROM |  |  | A | CARRYING  VALUE | D | VALUE OF ITEMS
 |  |  | BRANCH / ISLAND |  |  |  |  |  |  |  |  |  |  | APRN SYMBOL |  |  | C | OF ITEMS ON HAND | I | REMOVED
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Q | AND ACQUIRED | S | FROM INVENTORY | DECAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CD | SINCE JULY 1st | P | DURING FISCAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LAST YEAR BY | CD | YEAR BY | NUMBER
 |  |  |  |  |  |  |  |  |  |  |  |  | Phone Number
 | OP CODE | REC CODE |  |  |  |  | FUND | PROPERTY
 |  |  | ORG  CODE |  |  |  |  |  |  |  |  |  | [NAME] OF PROPERTY |  | FISCAL |  | 1 | Donations | 1 | Physical  Disposals
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | YEAR |  | 2 | Transfers-In | 2 | Transfers-Out
 |  |  | DEPT | DIV | S/DIV | ISL |  |  |  |  |  |  | START WITH A NOUN INCLUDE IF APPLICABLE |  |  |  | 3 | Phy Inv Adj-Gains | 3 | Phy Inv Adj-Losses
 |  |  |  |  |  |  |  |  | LOC | MAINT | ITEM | QTY | MAKE / MODEL / SERIAL  NUMBER ) |  | L   2 | A | 4 | Prop Code Change Gains | 4 | Prop Code Change Losses
 |  |  |  |  |  |  |  |  | CODE | CONTROL | CLASS |  | Maximum : 39 Characters Including Blank Spaces |  | A  D | P | 5 | Purchases | 5 | Declass to M&S-Losses
 |  |  |  |  |  |  |  |  |  | NUMBER |  |  |  |  | S   I | P | 6 | Accounting Adj-Gains | 6 | Accounting Adj-Losses
 |  |  |  |  |  |  |  |  |  |  |  |  | Font [NAME] 11 or 12 |  | T  G |  | 7 | Location Change-Gains | 7 | Location Change-Losses
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * | 8 | Price [NAME] C3 | 8 | Price [NAME] C3
 | 1 | 2 | 3-4 | 5 | 6 | 7 | 8 | 9 | 10-12 | 13-19 | 20-23 | 24-28 | 29 - 67 |  | 68-69 | 70 | 71 | 72-82 | 83 | 72-82 | 84-91
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 5
Spreadsheet: 109465d1306325288-excel-randomize-text-example
Sheet: Sheet1

I am a Man. I am 51 years old. I like to Play Guitar |  |  | 1 | Man |  | 1 | Read
I am a Man. I am 52 years old. I like to Play Guitar |  |  | 2 | Woman |  | 2 | Play Guitar
I am a Man. I am 1 years old. I like to Play Guitar |  |  |  |  |  | 3 | Football
I am a Woman. I am 33 years old. I like to Play Guitar
I am a Man. I am 18 years old. I like to Play Guitar
I am a Woman. I am 34 years old. I like to Play Guitar |  |  | Press F9 to generate random text
I am a Man. I am 55 years old. I like to Play Guitar
I am a Woman. I am 36 years old. I like to Football
I am a Woman. I am 53 years old. I like to Read
I am a Woman. I am 11 years old. I like to Play Guitar
Spreadsheet: 880992d1728899527-how-do-i-rewrite-the-filter-formula-in-cell-l2-to-display-duplicate-x-y-axis-filter-x-y-duplicates-a
Sheet: Sheet1

X | Y | X | Y | X | Y | X | Y | X | Y |  | X | Y | X | Y | X | Y | X | Y | X | Y
-2 | -7 | -7 | -3 | -2 | -7 | -4 | 1 |  |  |  |  | -7
-3 | -5 | -2 | -3 | 9 | -6 | 6 | -1
0 | -6 | -5 | 3 | 6 | 0
-6 | -2 | -5 | -1 | -6 | -2 | -6 | -2 |  |  |  | -6 | -2
DATA IS RANGE A2:J5. |  |  |  |  |  |  |  |  |  |  | RESULTS RANGE L2:U5
=LET(f,FILTER(A2:J2,A2:J2<>""),s,SEQUENCE(COLUMNS(f)/2,,0),u,UNIQUE(INDEX(f,,s*2+{1,2})),ss,SEQUENCE(COUNT(u),,0),TRANSPOSE(INDEX(u,INT(ss/2)+1,MOD(ss,2)+1)))
The FILTER formula above (In cell L2:L5) will display non duplicates x,y axis in range L2:U2. HOWEVER, I want to do the opposite. I  want to display only the duplicate (x,y) axis.
Then I can copy the FILTER formula down to resolve the ranges for each row which are ranges:  L3:U3, L4:U4, and L5:U5.
Even if the any data is change, the FILTER formula should recalculate accordingly. This following is only a sample: [NAME] is 2. Cell B1 is 3.  Cell C1 formula is =SUM(A1:B1). The answer will be 5. However, if B1 is change to -3, the answer will now be -1
 | So the FILTER formula must work accordingly whenever the data is change.
IF you can revised the FILTER formula above and enter into cel L2. I can copied it down it should display only x,y axis that are duplicates in range L2:Y5.
Once the FILTER formula is written to do the opposite, the results will display duplicates that are in each row:
Row 2: Range L2:M2 is -2,-7 (Because -2,-7 is repeated two times)
Row 3: blank (Because there are no duplicates)
Row 4: blank (Because there are no duplicates)
Row 5: Range L5:M5 is -6.-2 (Because -6,-2 is repeated three times)
Spreadsheet: 788456d1658486026-calculating-a-total-referencing-data-in-different-worksheets-cl-geodata-v3-3-
Sheet: Project2Data

Name | First name | Surname | Nickname / other name | Phone | Mobile | [NAME] | Website | Address line 1 | Postcode
 |  |  |  |  |  |  |  | Flat 2, Building 137-145 | BS15 1BH
 |  |  |  |  |  |  |  | 17a Crown Road | BS15 1PP
 |  |  |  |  |  |  |  | 73 Downend Road | BS15 1SN
 |  |  |  |  |  |  |  | 72 Downend Road | BS15 1SP
 |  |  |  |  |  |  |  | 72 Downend Road | BS15 1SP
 |  |  |  |  |  |  |  |  | BS15 1SW
 |  |  |  |  |  |  |  |  | BS15 1UE
 |  |  |  |  |  |  |  | 16 [NAME] | BS15 1UQ
 |  |  |  |  |  |  |  | 16 [NAME] | BS15 1UQ
 |  |  |  |  |  |  |  | 14 North Park | BS15 1UW
 |  |  |  |  |  |  |  |  | BS15 1XX
 |  |  |  |  |  |  |  | 23 Henderson Road | BS15 3AB
 |  |  |  |  |  |  |  | 62 [NAME] | BS15 3BT
 |  |  |  |  |  |  |  | 10 [NAME] | BS15 3FN
 |  |  |  |  |  |  |  | 75 Kingswood High Street | BS15 4AD
 |  |  |  |  |  |  |  | 71A Hollyguest Road | BS15 9NQ
 |  |  |  |  |  |  |  | 21 Bredon Close | BS15 9PG
 |  |  |  |  |  |  |  |  | BS15 9PZ
 |  |  |  |  |  |  |  | 71 Bellevue Road | BS15 9QQ
 |  |  |  |  |  |  |  | 44 Glanville Gardens | BS15 9WU
 |  |  |  |  |  |  |  |  | BS30 5DT
 |  |  |  |  |  |  |  | 21 Kennilworth Drive | BS30 6DZ
 |  |  |  |  |  |  |  | 21 Kenilworth Drive | BS30 6DZ
 |  |  |  |  |  |  |  | 122b Bath Road | BS30 6HS
 |  |  |  |  |  |  |  |  | BS30 6JR
 |  |  |  |  |  |  |  | East Barn | BS30 6NY
 |  |  |  |  |  |  |  | 12 Stibbs Court | BS30 7DH
 |  |  |  |  |  |  |  | 2 Isleys Court | BS30 7DR
 |  |  |  |  |  |  |  | 6 Tanner Close | BS30 7XF
 |  |  |  |  |  |  |  | 12 Worles Close | BS30 8XD
Spreadsheet: 1be038d2-12c5-41b3-9e68-bafd4ea7543c
Sheet: Sheet1

Table S4: The set of 46 microRNAs, which was used to generate the statistics. These microRNAs are conserved in all flies and have unique nuclei. | Unnamed: 1
microRNA ID | microRNA sequence
dme-miR-92a | CAUUGCACUUGUCCCGGCCUAU
dme-miR-315 | UUUUGAUUGUUGCUCAGAAAGC
[NAME] | AAAGGAACGAUCGUUGUGAUAUG
[NAME]5p | ACGUAUACUGAAUGUAUCCUGA
[NAME] | AGGUGCAUUGUAGUCGCAUUG
dme-miR-317 | UGAACACAGCUGGUGGUAUCCAGU
dme-miR-307 | UCACAACCUCCUUGAGUGAG
dme-miR-210 | UUGUGCGUGUGACAGCGGCUA
[NAME] | UGGACGGAGAACUGAUAAGGGC
dme-bantam | UGAGAUCAUUUUGAAAGCUGAUU
dme-miR-125 | UCCCUGAGACCCUAACUUGUGA
dme-let-7 | UGAGGUAGUAGGUUGUAUAGU
[NAME] | UGUCUUUUUCCGCUUACUGGCG
dme-miR-287 | UGUGUUGAAAAUCGUUUGCAC
dme-miR-219 | UGAUUGUCCAAACGCAAUUCUUG
dme-miR-304 | UAAUCUCAAUUUGUAAAUGUGAG
[NAME] | UGGCAGUGUGGUUAGCUGGUUG
[NAME] | UGUAUUUACGUUGCAUAUGAAAUGAUA
[NAME] | CAGCGAGGUAUAGAGUUCCUACG
dme-miR-283 | UAAAUAUCAGCUGGUAAUUCU
[NAME] | UUGAGCAAAAUUUCAGGUGUG
[NAME] | AACCCGUAAAUCCGAACUUGUG
dme-miR-12 | UGAGUAUUACAUCAGGUACUGGU
dme-miR-31a | UGGCAAGAUGUCGGCAUAGCUGA
[NAME]3p | CGGUAUACCUUCAGUAUACGUAAC
dme-miR-286 | [NAME]
dme-miR-4 | AUAAAGCUAGACAACCAUUGA
dme-miR-1 | [NAME]
[NAME] | UCAGUCUUUUUCUCUCUCCUA
dme-miR-2b | UAUCACAGCCAGCUUUGAGGAGC
dme-miR-314 | UAUUCGAGCCAAUAAGUUCGG
[NAME] | AUUGUACUUCAUCAGGUGCUCUG
dme-miR-306 | UCAGGUACUUAGUGACUCUCAA
dme-miR-285 | UAGCACCAUUCGAAAUCAGUGC
dme-miR-7 | UGGAAGACUAGUGAUUUUGUUGU
[NAME]* | CCUUAUCAUUCUCUCGCCCCG
dme-miR-9a | UCUUUGGUUAUCUAGCUGUAUGA
dme-miR-263a | GUUAAUGGCACUGGAAGAAUUCAC
[NAME] | ACCCUGUAGAUCCGAAUUUGU
[NAME] | UAAGGCACGCGGUGAAUGCCAAG
dme-miR-282 | AAUCUAGCCUCUACUAGGCUUUGUCUGU
dme-miR-288 | UUUCAUGUCGAUUUCAUUUCAUG
dme-miR-133 | UUGGUCCCCUUCAACCAGCUGU
[NAME] | UAGGAACUUAAUACCGUGCUCU
dme-miR-318 | UCACUGGGCUUUGUUUAUCUCA
dme-miR-277 | UAAAUGCACUAUCUGGUACGACA