tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77388d1277877453-rolling-30-days-different-rows-book1
Sheet: Sheet1

JAN | 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
Date | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00 | 2010-01-16 00:00:00 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 2010-01-19 00:00:00 | 2010-01-20 00:00:00 | 2010-01-21 00:00:00 | 2010-01-22 00:00:00 | 2010-01-23 00:00:00 | 2010-01-24 00:00:00 | 2010-01-25 00:00:00 | 2010-01-26 00:00:00 | 2010-01-27 00:00:00 | 2010-01-28 00:00:00 | 2010-01-29 00:00:00 | 2010-01-30 00:00:00 | 2010-01-31 00:00:00
Value | 5 |  |  |  |  | 5
Total
FEB | 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
Date | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-03 00:00:00 | 2010-02-04 00:00:00 | 2010-02-05 00:00:00 | 2010-02-06 00:00:00 | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00 | 2010-02-14 00:00:00 | 2010-02-15 00:00:00 | 2010-02-16 00:00:00 | 2010-02-17 00:00:00 | 2010-02-18 00:00:00 | 2010-02-19 00:00:00 | 2010-02-20 00:00:00 | 2010-02-21 00:00:00 | 2010-02-22 00:00:00 | 2010-02-23 00:00:00 | 2010-02-24 00:00:00 | 2010-02-25 00:00:00 | 2010-02-26 00:00:00 | 2010-02-27 00:00:00 | 2010-02-28 00:00:00
Value
Total
Spreadsheet: 756065d1637257863-populating-data-from-one-sheet-to-another-items-sold
Sheet: SingleSort

 | Date | Amount | Code
 | 2021-01-02 00:00:00 | 5 | LE7
 | 2021-01-03 00:00:00 | 0
 | 2021-01-04 00:00:00 | 0
 | 2021-01-05 00:00:00 | 7 | LT5
 | 2021-01-06 00:00:00 | 0
 | 2021-01-07 00:00:00 | 6 | [NAME]
 | 2021-01-08 00:00:00 | 0
 | 2021-01-09 00:00:00 | 0
 | 2021-01-10 00:00:00 | 0
 | 2021-01-11 00:00:00 | 10 | LE219
 | 2021-01-12 00:00:00 | 0
 | 2021-01-13 00:00:00 | 11 | [NAME]
 | 2021-01-14 00:00:00 | 0
 | 2021-01-15 00:00:00 | 12 | LE12
 | 2021-01-16 00:00:00 | 0
 | 2021-01-17 00:00:00 | 13 | LE26
 | 2021-01-18 00:00:00 | 0
 | 2021-01-19 00:00:00 | 17 | LE2
 | 2021-01-20 00:00:00 | 0
 | 2021-01-21 00:00:00 | 0
 | 2021-01-22 00:00:00 | 5 | LT23
 | 2021-01-23 00:00:00 | 0
 | 2021-01-24 00:00:00 | 0
 | 2021-01-25 00:00:00 | 2 | LT12
 | 2021-01-26 00:00:00 | 0
 | 2021-01-27 00:00:00 | 0
 | 2021-01-28 00:00:00 | 7 | LE128
 | 2021-01-29 00:00:00 | 0
 | 2021-01-30 00:00:00 | 6 | LT58
 | 2021-01-31 00:00:00 | 0
Spreadsheet: 830279d1684844063-lookup-match-structed-table-360-photos-required-testing-1-
Sheet: Unplanned orders

From |  |  | To |  |  |  |  |  |  | =VLOOKUP(Table_Query_from_Kerry_Live[[#This Row],[WarehouseProductGroup]],'Prod sites'!A:B,2,FALSE) | =SUMIFS('Current stock'!F:F,'Current stock'!B:B,Table_Query_from_Kerry_Live[[#This Row],[Product]]) | =IF(L4=K4,"picked",IF((K4-L4)>O4,"Possible Shortage","ok")) |  |  |  | Short warning formula previously~ | =IF(Table_Query_from_Kerry_Live[[#This Row],[OrderQty]]>=Table_Query_from_Kerry_Live[[#This Row],[Current stock ( all status)]],"POSSIBLE SHORTAGE","") |  | =IF(L473=K473,"picked",IF(R473>O473,"Possible Shortage","ok"))
Unplanned orders |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(L4=K4,"picked",IF((K4-L4)>O4,"Possible Shortage","ok")) | =IF((OR(L485=K485, R485<=O485)),"OK","Possible Shortage")
OrderNumber | OrderSalesNumber | DespatchDateODBC | LoadRef | DelPointName | CreateDateODBC | OrderType | OrderRef | CompleteDeleteFlag | DeliveryPoint
[PHONE] | [PHONE] | 2023-05-23 00:00:00 |  | [NAME] | 2023-05-23 00:00:00 | EXPT | IOM2301493 |  | [PHONE]
[PHONE] |  | 2023-05-23 00:00:00 |  | KIF Ltd - Tenbury Wells | 2023-05-19 00:00:00 | TRAN |  |  | CC07401
Spreadsheet: 890064d1741208798-dynamically-calculate-ytd-figures-income-statement-sample
Sheet: Summary

Reclass |  |  | Internal Financial Format |  |  | 2024-10-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  | LYTD vs YTD
Parent | Child |  |  |  |  | Reported |  |  |  | Difference |  |  |  | Reported |  |  |  | Difference |  | Reported |  | Difference
INC |  |  | Adjusted Historical and Projected Statements of Income (in 000's)
 |  |  | Revenue |  |  |  |  |  |  |  |  |  |  | 12962.75655
Revenue |  |  |  | Revenue
 |  |  | Total Revenue
 |  |  | Cost of Goods
Materials |  |  |  | Materials
Direct |  |  |  | Direct Costs
Indirect |  |  |  | Indirect Costs
 |  |  | Total Cost of Goods
 |  |  | Gross Profit
 |  |  |  | % Margin
 |  |  | Selling & General & Administrative
Sales |  |  |  | Marketing & Sales
G&A |  |  |  | General & Administrative
 |  |  | Total Expenses
 |  |  | Operating Income
 |  |  | Other (Income)/Expense
Depreciation | Depreciation |  |  | Depreciation
Amortization | Goodwill |  |  | [NAME]
Amortization | Financial |  |  | Financial Amortization
 |  |  | Total Depreciation & Amortization
Interest | Income |  |  | Interest Income
Interest | Expense |  |  | Interest Expense
Interest | Revolver |  |  | Line of Credit Interest
Interest | Equipment |  |  | Equipment Loan Interest
Interest | Subdebt |  |  | Secured Promissory Note Interest
Interest | Subdebt-discount |  |  | Secured Promissory Note Discount Amort
 |  |  | Total Interest (Income)/Expense
Other | OpTax |  |  | Sales Tax Discount
Other | Gain |  |  | (Gain)/Loss on Sale
Other | Income |  |  | Extra-Ordinary Items (Income)/Expense
Other | MgmtFee |  |  | Mgmt, Board & Consulting Fees
 |  |  | Total (Income)/Expense
 |  |  | Total Other (Income)/Expense
 |  |  | Net Profit (Loss)
 |  |  |  | Depreciation
 |  |  |  | Amortization
 |  |  |  | Interest
 |  |  |  | Taxes
 |  |  | EBITDA
[NAME] |  |  |  | Sale Leaseback Transaction Fees
SLG |  |  |  | Sale Leaseback Gain
MgmtFee |  |  |  | Mgmt, Board Consulting Fees
ADJ | Bank |  |  | Bank Fees
ADJ | Legal |  |  | Professional Fees
ExtraOrdinary |  |  |  | Extra-Ordinary Items
 |  |  | Adjusted EBITDA
Spreadsheet: 800422d1665662340-trying-to-use-vlookup-function-to-match-row-ticket-ids-to-column-names-file-1
Sheet: Sheet1

Ticket ID | 1. [Grammar & Syntax] - Ability to use business proficient language, including correct grammar, spellings & syntax.  Grading options:  1 - FAIL 2 - NEUTRAL 3 - PASS NA - NOT APPLICABLE  If you select one of the options: 1 - FAIL or 2 - NEUTRAL, make sure to include short explanation. | 2. [Appropriate communication starter] Asses the agent ability to build a First touch impression and set context for query resolution. Grading options:  1 - FAIL 2 - NEUTRAL 3 - PASS NA - NOT APPLICABLE  If you select one of the options: 1 - FAIL or 2 - NEUTRAL, make sure to include short explanation. | 3. [Customer Empathy] Ability to acknowledge customers priorities & show empathy  Grading options:  1 - FAIL 2 - NEUTRAL 3 - PASS NA - NOT APPLICABLE  If you select one of the options: 1 - FAIL or 2 - NEUTRAL, make sure to include short explanation. | 4. [Positive Tone] Ability to maintain a positive tone and professional customer centric attitude. Grading options:  1 - FAIL 2 - NEUTRAL 3 - PASS NA - NOT APPLICABLE  If you select one of the options: 1 - FAIL or 2 - NEUTRAL, make sure to include short explanation. | 5. [Understand the Issue] Assess agent approach to confirming the nature of the issue/problem and understand properly if not provided.  Grading options:  1 - FAIL 2 - NEUTRAL 3 - PASS NA - NOT APPLICABLE  If you select one of the options: 1 - FAIL or 2 - NEUTRAL, make sure to include short explanation. | 6. [Accountability & Ownership] Ability to take complete ownership for case resolution and represent one unified service  Ensure the agent followed -up on any other commitments made. Grading options:  1 - FAIL 2 - NEUTRAL 3 - PASS NA - NOT APPLICABLE  If you select one of the options: 1 - FAIL or 2 - NEUTRAL, make sure to include short explanation.
831511 | 3 | 3 | 3 | 3 | 3 | 3
819815 | 3 | 1 (Test) | 3 | 3 | 3 | 3
816463 | 3 | 3 | 3 | 3 | 3 | NA
831991 | 3 | NA | NA | 1(Test) | 1(Test) | 3
12345 | 3 | 3 | 3 | 3 | 3 | 3
Spreadsheet: 61314953-8d04-4bb4-8c14-e90b9051bbf7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8582 | 7981 | [NAME] | [NAME] | USA | 26 | 00:13:23 | 00:01:44 | 00:31:18 | 00:00:48 | 00:22:04 | 1 | [NAME]
Spreadsheet: 68604d1269194819-excel-2007-pivot-table-with-conditional-value-ranges-forum-4
Sheet: Sheet1

question | property | response 1 | response 2 | response 3 |  |  | Property | Min Positive
1 | X | 3 | 5 | 7 |  |  | Z | 3
2 | Y | 5 | 1 | 6 |  | [NAME] | 3 | 1 | > min pos
3 | X | 5 | 4 | 6
4 | Z | 4 | 2 | 1
N | Z | 3 | 2 | 5
Spreadsheet: 38d32a0d-c78a-4857-9886-1870bc1f9a6c
Sheet: Table 6.3

Monthly Statistical Bulletin
6.3 Terms of trade
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Implicit price deflator for exports of goods and services (a) (b) – index
September | 79.8 | 96.4 | 104.7 | 90.1 | 93.6
December | 79 | 94.7 | 102.3 | 89.4 | 94.4
March | 82.5 | 99.7 | 95.4 | 90.7
June | 95.2 | 103.5 | 97.1 | 90.7
Annual average | 84.21133486958554 | 98.66203422564234 | 100 | 90.1534435162944
Implicit price deflator for imports of goods and services (a) (b) – index
September | 105.7 | 102 | 98.4 | 99.3 | 106.9
December | 100.9 | 98.1 | 101 | 100.3 | 107.2
March | 100.3 | 98.4 | 98.9 | 100.3
June | 101.9 | 98.3 | 101.4 | 100.4
Annual average | 102.0392117565896 | 99.07030247511425 | 100 | 99.92069067803226
Terms of trade (a) (b) (c) – index
September | 75.5 | 94.5 | 106.3 | 90.7 | 87.5
December | 78.3 | 96.6 | 101.3 | 89.2 | 88.1
March | 82.2 | 101.4 | 96.4 | 90.4
June | 93.5 | 105.3 | 95.8 | 90.3
Annual average | 82.52840591366807 | 99.58790047141073 | 100 | 90.22500035231921
(a) Quarterly figures are seasonally adjusted.
(b) Base: 2010-11 = 100.0.
(c) Index of the ratio of the implicit price deflator for exports of goods and services
to the implicit price deflator for imports of goods and services
Sources: ABS, Balance of payments and international investment position, Cat. no.
5302
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | Early June 2014
Spreadsheet: 288530d1389214696-how-to-extract-unique-numbers-from-a-list-and-sort-them-by-date-or-age-test-list-number_alkey
Sheet: Φύλλο1

number | name1 | [NAME] | age | phone number | date | Unique | Sorted
276354 | ΚΕΛΟ | ΝΤΕΙΒΙΝΤ | 10 | 6984940786 | 2013-03-28 00:00:00
280714 | ΤΑΤΗΣ | ΑΡΕΝ | 40 | 6946622276 | 2013-06-18 00:00:00
261154 | ΚΟΡΕΞΙΑΝΙΔΟΥ | - | 50 | 6974879427 | 2012-07-29 00:00:00
271475 | ΜΑΓΓΙΝΑΣ | - | 20 | 6955099985 | 2013-01-17 00:00:00
273526 | ΜΑΛΕΗ | ΝΙΚΟΛΑΟΣ | 30 | 6984940786 | 2013-02-16 00:00:00
275641 | ΜΠΑΚΑ | ΑΒΑΠΤΙΣΤΟ | 20 | 6972882192 | 2013-03-18 00:00:00
278164 | ΑΛΕΞΙΟΥ | ΑΠΟΣΤΟΛΟΣ | 56 | 6906241928 | 2013-04-28 00:00:00
313706 | ΠΕΡΑΚΗ | ΕΛΕΝΗ | 60 | 6944333450 | 2013-06-26 00:00:00
313973 | ΜΕΛΑΣ | ΛΕΩΝ | 60 | 6984940786 | 2013-07-02 00:00:00
314168 | ΡΙΤΤΑ | ΝΙΚΟΛΕΤΑ | 55 | 6906241928 | 2013-07-07 00:00:00
315784 | MAC FARLEY | LEONARDO | 20 | 6972550865 | 2012-04-11 00:00:00
316701 | ΑΝΤΩΝΑΤΟΥ |  | 30 | 6944445382 | 2012-04-18 00:00:00
318026 | ΚΟΥΚΟΥΤΣΗΣ | ΤΗΛΕΜΑΧΟΣ | 20 | 6944834332 | 2012-05-12 00:00:00
319151 | ΒΕΡΓΟΥ | ΒΑΣΙΛΙΚΗ | 40 | 6942706543 | 2012-06-28 00:00:00
319598 | [NAME] | ΑΒΑΠΤΙΣΤΟ | 44 | 6972648522 | 2012-07-30 00:00:00
273003 | ΜΕΛΙΣΣΑΡΗΣ | ΕΥΑΓΓΕΛΟΣ | 50 | 6982160551 | 2012-08-01 00:00:00
245127 | ΣΑΡΙΔΑΚΗΣ | ΑΒΑΠΤΙΣΤΟ | 20 | 6950514384 | 2012-08-05 00:00:00
245184 | ΑΒΑΠΤΙΣΤΟ | [NAME] | 33 | 6947434752 | 2012-08-10 00:00:00
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 12 March 2012

Daily Morning Staff |  |  |  |  | Monday
 | 07:30-14:30 |  | 2012-03-12 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Relation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:30:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS | Sick leave
[NAME] | 4440 | Attendant | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 716797d1612368036-round-with-an-if-exception-round-example
Sheet: Sheet1

X COST | TAXES | TOTAL | PACKAGE TOTAL
125 | 100
125 | 85
180 | 75
180 | 180
210 | 0
Y COST | CURRENCY |  | Y COST
 |  |  | 268
Z COST | CURRENCY |  | Z COST
 |  |  | 500
 |  | TOTAL TOUR
Spreadsheet: darrell_schoolcraft__7638__imball0201
Sheet: burlington

56423
Day | Measured | Scheduled | Imbal
1 | 165610 | 167344
2 | 166480 | 167796
3 | 137938 | 137645
4 | 125026 | 124963
5 | 146499 | 137011
6 | 145029 | 145160
7 | 142059 | 140564
8 | 158164 | 152788
9 | 146090 | 145561
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  |  |  |  | 20
2001-12-31 00:00:00 |  |  | 47594.94 |  |  |  | 530
2002-01-09 00:00:00
 |  |  |  |  |  |  | 5989
CBS Volume
 |  |  | 20411
Spreadsheet: 833933d1687348898-extract-multiple-dates-from-cell-amongst-text-dateextract
Sheet: Sheet1

What | Formula1 | Formula2 | Expected OutputFirstDate | Expected OutputLastDate
Customer agreed to take, PO in progress - Invoice 21/06 |  |  | 2023-06-21 00:00:00 | 2023-06-21 00:00:00
to release 06/06;  waiting for more info - Release and invoicing not expected until 30/6 Confirm that convo with customer started...or when it will |  |  | 2023-06-06 00:00:00 | 2023-06-30 00:00:00
Ship to NL 20/06 - Invoice by Monday 26/6 |  |  | 2023-06-20 00:00:00 | 2023-06-26 00:00:00
Ship to NL 20 Jun - Invoice by Monday 26/6 |  |  | 2023-06-20 00:00:00 | 2023-06-26 00:00:00
Ship to NL 20 Jun - Invoice by Monday 26/6 |  |  | 2023-06-20 00:00:00 | 2023-06-23 00:00:00
Due for release 22/6 - Invoice by Friday 23/06 |  |  | 2023-06-21 00:00:00 | 2023-06-21 00:00:00
Certs to do, then  release 21/06 |  |  | 2023-06-22 00:00:00 | 2023-06-23 00:00:00
Due for release 22/6 - Tablets to release  and passed to admin, Invoice by Friday 23/06 |  |  | 2023-06-23 00:00:00 | 2023-06-23 00:00:00
Need 3rd batch released, invoiced by Friday 23/06 test |  |  | 2023-06-23 00:00:00 | 2023-06-23 00:00:00
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -6314 | -4260
2 | -3164 | -4260 |  |  |  |  |  |  |  |  |  |  |  | Avg
3 | -4573 | -4260 |  |  |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -8603 | 45 |  | -8433
5 | -9653 |  |  | -8241
6 | -16437 | 181 |  | -17010 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 | -8957 | 181 |  | -3732 |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 | -14890 |  |  | -14366 |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 | -13952 |  |  | -14366 |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 | -14001 | 100 |  | -14366 |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 | -53448 | 181 |  | -54000 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 | -48863 | 181 |  | -49000 |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13 | -41699 | 181 |  | -41318
14 | -12168 | 181 |  | -8926
15 | -50889 | 181 |  | -50196
16 | -55543 | 181 |  | -50196
17 | -47329 | 181 |  | -50196
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-11-30 00:00:00 |  |  | -125961.81
 |  |  |  | 2001-12-17 00:00:00
 | CBS Volume
 |  |  |  | -30730
Spreadsheet: 721041d1614440200-help-proof-a-formula-with-sumproduct-and-average-average-days-held-sample
Sheet: Sheet2

 |  |  |  |  | Status | Symb. | Qty | Days Held
 |  |  |  |  | Closed | NLY | 5 | 43 |  |  |  | NLY |  | <<< Formula A
 |  |  |  |  | Closed | NLY | 5 | 36
 |  |  |  |  | Open | AGNC | 5 | 26 |  |  |  | NLY |  | <<< Formula B
 |  |  |  |  | Closed | NLY | 5 | 134
 |  |  |  |  | Closed | NLY | 5 | 208
 |  |  |  |  | Closed | NLY | 5 | 50
 |  |  |  |  |  |  |  |  |  |  | In my original template There are Multiple Symbols, Qty, Status and Days.
 |  |  |  |  | Closed | NLY | 5 | 78 |  |  | I Need to Calculate The average Days these multiple Positions were Held
 |  |  |  |  | Closed | AGNC | 5 | 130
 |  |  |  |  |  |  |  |  |  |  | I am Not Sure If [NAME] is Correct. I know [NAME] is incorrect
 |  |  |  |  | Closed | NLY | 2 | 204 |  |  | Can Someone Proof Formula A ?
 |  |  |  |  |  |  |  |  |  |  | And If [NAME] is [NAME], What would be the Correct Formula?
 |  |  |  |  | Open | NLY | 2 | 204
 |  |  |  |  | Closed | NLY | 1 | 204 |  |  | Thank you:)
 |  |  |  |  | Closed | AGNC | 5 | 130
 |  |  |  |  | Closed | AGNC | 3 | 125
 |  |  |  |  | Closed | NLY | 2 | 125
 |  |  |  |  | Open | NLY | 5 | 32
 |  |  |  |  | Closed | NLY | 1 | 86
 |  |  |  |  | Open | NLY | 1 | 160
 |  |  |  |  | Closed | AGNC | 1 | 58
 |  |  |  |  | Closed | NLY | 10 | 15
 |  |  |  |  | Closed | NLY | 10 | 88
 |  |  |  |  | Closed | NLY | 5 | 86
 |  |  |  |  | Open | NLY | 9 | 0
 |  |  |  |  | Closed | NLY | 10 | 71
 |  |  |  |  | Closed | AGNC | 4 | 0
 |  |  |  |  | Closed | NLY | 4 | 0
 |  |  |  |  | Closed | NLY | 2 | 0
 |  |  |  |  | Open | AGNC | 5 | 0
 |  |  |  |  | Closed | AGNC | 1 | 0
 |  |  |  |  | Closed | AGNC | 10 | 0
Spreadsheet: 81115d1281377264-excel-2007-unique-entry-in-column-with-count-and-date-specific-report-required-_-abhinav-gupta
Sheet: Sheet2

RAW REPORT
Name | Account Name | [NAME] | Amount | Close | User | Date Created
[NAME] | [NAME] co Pvt Ltd (N) | Prospecting | Rs.2,500,000.00 | 2010-09-30 00:00:00 | [NAME] | 2010-08-09 00:00:00
[NAME] | [NAME] co Pvt Ltd (N) | Prospecting | Rs.2,500,000.00 | 2010-09-30 00:00:00 | [NAME] | 2010-08-09 00:00:00
Alpha | Alpha Analytics Services Pvt Ltd (W) | Prospecting | Rs.500,000.00 | 2010-09-30 00:00:00 | saumya.roy | 2010-08-09 00:00:00
Torres Networks (S) - Managed Services | Torres Networks (S) | Prospecting | Rs.500,000.00 | 2010-08-31 00:00:00 | ratika.l | 2010-08-07 00:00:00
Wireless T T Infoservices Ltd (S) - 1 Mbps ILL | Wireless T T Infoservices Ltd (S) | Prospecting | Rs.100,000.00 | 2010-08-31 00:00:00 | ratika.l | 2010-08-07 00:00:00
Wireless T T Infoservices Ltd (S) - SSL | Wireless T T Infoservices Ltd (S) | Prospecting | Rs.100,000.00 | 2010-08-31 00:00:00 | ratika.l | 2010-08-07 00:00:00
Origin ITFS (S) - 2 Mbps ILL | Origin ITFS (S) | Prospecting | Rs.150,000.00 | 2010-08-31 00:00:00 | ratika.l | 2010-08-07 00:00:00
Beekeyen Freight Services (S) - VPN 4 Locations | Beekeyen Freight Services (S) | Prospecting | Rs.200,000.00 | 2010-08-31 00:00:00 | ratika.l | 2010-08-07 00:00:00
Paxar India Pvt Ltd-VPN | Paxar India Pvt Ltd | Prospecting | Rs.300,000.00 | 2010-10-31 00:00:00 | bhumikas | 2010-08-07 00:00:00
System Solutions (S) - 2 Mbps ILL | System Solutions (S) | Prospecting | Rs.150,000.00 | 2010-08-11 00:00:00 | ratika.l | 2010-08-07 00:00:00
 | this is the sheet that I want to be converted into a report. Points to be considered are :
1 | if the account name is repeat count it as one
2 | the opportunites of a particular date should be checked e.g 7-Aug-2010 only. Others can be ignored.
3 | The above highlighted in grey will be considered
4 | The output of the report will be like this mentioned below for 7 Aug 2010
ACTUAL REPORT REQUIRED
Date | Name of the User | Count of cases generated | Account name
2010-08-07 00:00:00 | ratika.l | 5 | Torres Networks (S),Wireless T T Infoservices Ltd (S),Wireless T Torres Networks (S),Wireless T T Infoservices Ltd (S),Origin ITFS (S),Beekeyen Freight Services (S),System Solutions (S)
2010-08-07 00:00:00 | bhumikas | 1 | Paxar India Pvt Ltd
Spreadsheet: 740606d1626423492-how-to-merge-a-substitute-and-right-formula-together-referencing-the-same-cell-how-to-merge-a-substitute-and-right-formula-together-referencing-the-same-cell
Sheet: Sheet1

 | DS123.DPPPO.DQQ Land Air Vehicle Maintenance
 | [NAME] 99-999: PART 1 - E M R f D S P: 1 : R
 | [NAME] 44-444: PART 2 - E M R f D S P: 2 : G
 | DQQ02: D L S R P A R F H S A E P
 | Significant Train and S P (STaSP) S a E M S (SaEMS)
 |  | TRIM(SUBSTITUTE(B2,E2,"")) | IFERROR((TRIM(RIGHT(C6,LEN(C6)-FIND(":",C6)))),C6)
 |  | How to merge these two formulas together into one formula?
 |  | To produce the desired outcome in column D
Spreadsheet: 31692d1227630708-never-ending-time-sheet-time_sheets_2009
Sheet: Pay Periods

2009 Pay Periods
Pay Period |  |  | Payday
2008-12-27 00:00:00 | to | 2009-01-09 00:00:00 | 2009-01-16 00:00:00
2009-01-10 00:00:00 | to | 2009-01-23 00:00:00 | 2009-01-30 00:00:00
2009-01-24 00:00:00 | to | 2009-02-06 00:00:00 | 2009-02-13 00:00:00
2009-02-07 00:00:00 | to | 2009-02-20 00:00:00 | 2009-02-27 00:00:00
2009-02-21 00:00:00 | to | 2009-03-06 00:00:00 | 2009-03-13 00:00:00
2009-03-07 00:00:00 | to | 2009-03-20 00:00:00 | 2009-03-27 00:00:00
2009-03-21 00:00:00 | to | 2009-04-03 00:00:00 | 2009-04-10 00:00:00
2009-04-04 00:00:00 | to | 2009-04-17 00:00:00 | 2009-04-24 00:00:00
2009-04-18 00:00:00 | to | 2009-05-01 00:00:00 | 2009-05-08 00:00:00
2009-05-02 00:00:00 | to | 2009-05-15 00:00:00 | 2009-05-22 00:00:00
2009-05-16 00:00:00 | to | 2009-05-29 00:00:00 | 2009-06-05 00:00:00
2009-05-30 00:00:00 | to | 2009-06-12 00:00:00 | 2009-06-19 00:00:00
2009-06-13 00:00:00 | to | 2009-06-26 00:00:00 | 2009-07-03 00:00:00
2009-06-27 00:00:00 | to | 2009-07-10 00:00:00 | 2009-07-17 00:00:00
2009-07-11 00:00:00 | to | 2009-07-24 00:00:00 | 2009-07-31 00:00:00
2009-07-25 00:00:00 | to | 2009-08-07 00:00:00 | 2009-08-14 00:00:00
2009-08-08 00:00:00 | to | 2009-08-21 00:00:00 | 2009-08-28 00:00:00
2009-08-22 00:00:00 | to | 2009-09-04 00:00:00 | 2009-09-11 00:00:00
2009-09-05 00:00:00 | to | 2009-09-18 00:00:00 | 2009-09-25 00:00:00
2009-09-19 00:00:00 | to | 2009-10-02 00:00:00 | 2009-10-09 00:00:00
2009-10-03 00:00:00 | to | 2009-10-16 00:00:00 | 2009-10-23 00:00:00
2009-10-17 00:00:00 | to | 2009-10-30 00:00:00 | 2009-11-06 00:00:00
2009-10-31 00:00:00 | to | 2009-11-13 00:00:00 | 2009-11-20 00:00:00
2009-11-14 00:00:00 | to | 2009-11-27 00:00:00 | 2009-12-04 00:00:00
2009-11-28 00:00:00 | to | 2009-12-11 00:00:00 | 2009-12-18 00:00:00
2009-12-12 00:00:00 | to | 2009-12-25 00:00:00 | 2009-12-31 00:00:00
Spreadsheet: 539493d1506175839-finding-lowest-cost-carrier-among-an-arry-sample
Sheet: Sheet1

Monthly Active Premiums
 | Aetna | Cigna | [NAME] | Geisinger | Health Net | HCSC | Kaiser | Kaiser WA | United | UPMC
[NAME] | 613.27 | 492.02 | N/A | N/A | 513 | 534.26 | 323.12 | N/A | 455.11 | N/A
[NAME] | 654.49 | 533.3 | N/A | N/A | 538.49 | 564.45 | 334.86 | N/A | 502.66 | N/A
Silver | 739.02 | 604.56 | N/A | N/A | 659.66 | 600.94 | 357.04 | N/A | 549.12 | N/A
Gold | 907.17 | 737.33 | N/A | N/A | 397.03 | 685.6 | 467.24 | N/A | 691.05 | N/A
Platinum | 1055.3 | 833.43 | N/A | N/A | 984.8 | 807.06 | 518.52 | N/A | 809.82 | N/A
Lowest cost carrier:
Spreadsheet: 756334d1637443834-sumif-function-showing-a-zero-value-everytime-sumif-function-problem
Sheet: Sheet1

Months | Branch Sales
Jan | 2346990
Feb | 5598067
Mar | 6278199
Apr | 5123580
May | 5378822
Jun | 6184512
Jul | 8140894
Aug | 7248380
Sep | 5628090
Oct | 4987535
Start: | Mar | End: | Aug
[NAME]:
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: Sheet7

Number | Box Number
737 | 896
65 | 369
587 | 609
139 | 282
729 | 24
313 | 408
305 | 32
839 | 563
756 | 635
235 | 772
800 | 298
73 | 385
661 | 606
669 | 111
543 | 206
589 | 517
354 | 673
755 | 514
788 | 219
584 | 532
273 | 833
319 | 196
333 | 47
245 | 332
797 | 723
789 | 157
490 | 589
771 | 877
855 | 882