tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 166489d1341600190-formula-problem-vlookup-combined-with-if-statement-excel-spreadheet-if-statement-with-vloolup
Sheet: Wendy Count

Invoice Creation Date | Billing Specialist | Comments | Invoice Number | Contract Type
2012-07-05 00:00:00 | [NAME] |  | 1154511 | OPEN MRKT GOVT CONTRACT
2012-07-05 00:00:00 | [NAME] |  | 1154417 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154402 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154403 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154404 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154405 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154406 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154418 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154421 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154422 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154430 | GSA #GS-07F-6072P
2012-07-05 00:00:00 | [NAME] |  | 1154392 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154428 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154515 | OPEN MRKT GOVT CONTRACT
2012-07-05 00:00:00 | [NAME] |  | 1154337 | BPA-GOVT
2012-07-05 00:00:00 | [NAME] |  | 1154393 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154400 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154413 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154434 | GSA #GS-21F-0110X
2012-07-05 00:00:00 | [NAME] |  | 1154425 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154416 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154415 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154414 | GSA #GS-07F-5965P
2012-07-05 00:00:00 | [NAME] |  | 1154386 | EXCHANGE
2012-07-05 00:00:00 | [NAME] |  | 1154381 | EMALL GSA BPA SPM7W108DE055
2012-07-05 00:00:00 | [NAME] |  | 1154385 | EXCHANGE
2012-07-05 00:00:00 | [NAME] |  | 1154410 | GOVT CC
2012-07-05 00:00:00 | [NAME] |  | 1154407 | GOVT CC
Spreadsheet: 27e1dbf7-f1c1-411a-b889-7c91ea7ccb53
Sheet: 13d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other | HY | IG | Other
Index Tranche
Europe | . | . | 972150 | . | . | 130320
North America/Asia | 98697 | 911946 | 7653 | 26859 | 84547 | 4259
Other | - | - | - | - | - | -
Index
Asia | . | . | 192604 | . | . | 44956
Europe | . | . | 5464180 | . | . | 1386239
North America | 909428 | 3941188 | 164772 | 425057 | 1724963 | 48411
Other | . | . | 482198 | . | . | 78411
OTHER* | . | . | 841187 | . | . | 354770
TOTAL
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 0a573ff8-ade3-4de0-b86d-a2b412aca56b
Sheet: Sheet1

form   W-4 | Employee's Withholding Allowance Certificate | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | OMB No 1545-0010
 |  |  |  |  |  |  |  |  |  |  | 2003
Department of the Treasury
Internal Revenue Service | For Privacy Act and Paperwork Reduction Act Notice, see page 2.
1  Type or print your first name and middle initial |  |  |  |  | Last | name |  |  | 2  Your social security number
Home address (number and street or rural route) |  |  |  |  |  | 3  oSingle   o Married  o Married, but withhold at higher Single rate.
 |  |  |  |  |  | Note: If married, but legally separated, or spouse is a nonresident alien, check the single box.
City or town, state, and ZIP code |  |  |  |  |  | 4  If your last name differs from that on your social security card, check
 |  |  |  |  |  | here and call [PHONE] for a new card . . . . . . . . . . .          o
5  Total number of allowances you are claiming (from line H above or from the applicable worksheet on page 2) |  |  |  |  |  |  |  |  |  |  | 5
6  Additional amount, if any, you want withheld from each paycheck     .     .     .     .     .     .     .     .     .     . |  |  |  |  |  |  |  |  |  |  | 6
7  I claim exemption from withholding for 2003, and I certify that I meet both of the following conditions for exemption.
l Last year I had a right to a refund of all Federal income tax withheld because I have no tax liability and
l This year I expect a refund of all Federal income tax withheld because I expect to have no tax liability.
If you meet both conditions, write "Exempt: here     .     .     .     .     .     .     .     .     .     .     . |  |  |  |  |  |  |  |  | 7
Under penalties of perjury, I certify that I am entitled to the number of withholding allowances claimed on this certificate, or I am entitled to claim exempt status
Employee's signature
(Form is not valid
unless you sign it) |  |  |  |  |  |  |  | Date
8  Employer's name and address (Employer complete lines 8 and 10 only if sending to the IRS |  |  |  |  |  |  |  | 9  Office code |  | 10  Employer identification number
 |  |  |  |  |  |  |  | (optional)
BIRTHDATE |  |  |  |  | RACE |  |  | SEX |  |  | IF NON RESIDENT ALIEN
MONTH |  | DAY |  | YEAR |  |  |  |  |  |  | CHECK VISA PREFIX
 |  |  |  |  |  | American Indian or Alaskan Native |  | M=MALE |  |  | F-1
 |  |  |  |  |  | Asian or Pacific Islander |  | F=FEMALE |  |  | J-1
CITIZENSHIP |  |  |  |  |  | Black |  |  |  |  | COPY ATTACHED
 |  | Y = YES |  |  |  | Hispanic |  | DEPARTMENT
 |  | N=NAME OF COUNTRY |  |  |  | White |  |  |  |  | CHECK IF FULL TIME STUDENT
Spreadsheet: a20b7b1e-ad19-43e3-94b8-b7ef9eed5d2a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Annual Rate for Housing Units Started: United States
 |  | Seasonally Adjusted Total Units [Thousands of Units]
 |  | Period: 2006 to 2012
 |  | Data Extracted on: March 12, 2014 (12:02 pm)
Period | Value
Jan-2006 | 2273
Feb-2006 | 2119
Mar-2006 | 1969
Apr-2006 | 1821
May-2006 | 1942
Jun-2006 | 1802
Jul-2006 | 1737
Aug-2006 | 1650
Sep-2006 | 1720
Oct-2006 | 1491
Nov-2006 | 1570
Dec-2006 | 1649
[NAME] | 1409
Feb-2007 | 1480
Mar-2007 | 1495
Apr-2007 | 1490
May-2007 | 1415
Jun-2007 | 1448
Jul-2007 | 1354
Aug-2007 | 1330
Sep-2007 | 1183
Oct-2007 | 1264
Nov-2007 | 1197
Dec-2007 | 1037
Jan-2008 | 1084
Feb-2008 | 1103
Mar-2008 | 1005
Apr-2008 | 1013
May-2008 | 973
Jun-2008 | 1046
Jul-2008 | 923
Aug-2008 | 844
Sep-2008 | 820
Oct-2008 | 777
Nov-2008 | 652
Dec-2008 | 560
Jan-2009 | 490
Feb-2009 | 582
Mar-2009 | 505
Apr-2009 | 478
May-2009 | 540
Jun-2009 | 585
Jul-2009 | 594
Aug-2009 | 586
Sep-2009 | 585
Oct-2009 | 534
Nov-2009 | 588
Dec-2009 | 581
[NAME] | 614
[NAME] | 604
Mar-2010 | 636
Apr-2010 | 687
[NAME] | 583
[NAME] | 536
[NAME] | 546
Aug-2010 | 599
Sep-2010 | 594
Oct-2010 | 543
Nov-2010 | 545
Dec-2010 | 539
Jan-2011 | 630
Feb-2011 | 517
Mar-2011 | 600
Apr-2011 | 554
May-2011 | 561
Jun-2011 | 608
Jul-2011 | 623
Aug-2011 | 585
Sep-2011 | 650
Oct-2011 | 610
Nov-2011 | 711
Dec-2011 | 694
Jan-2012 | 723
Feb-2012 | 713
Mar-2012 | 707
Apr-2012 | 754
May-2012 | 711
Jun-2012 | 757
Jul-2012 | 741
Aug-2012 | 749
Sep-2012 | 854
Oct-2012 | 864
Nov-2012 | 842
Dec-2012 | 983
Spreadsheet: 76851d1277329086-formula-to-find-correct-time-frame-and-return-assignment-code-example-problem
Sheet: Sheet1

Worksheet 1:  Events
Event Number | Location | EventType | Name | Date | Assignment Derived Manually
1 | 1 | A | [NAME] | 2010-06-14 12:53:00 | 110
2 | 2 | B | LEVELL WILSON | 2010-06-14 14:28:00
3 | 3 | C | CODY LAYTON | 2010-06-14 15:48:00
4 | 4 | D | [NAME] | 2010-06-14 18:31:00 | 110
5 | 5 | F | [NAME] | 2010-06-14 20:26:00
6 | 6 | G | [NAME] | 2010-06-14 21:08:00
7 | 7 | H | TAMMY CARSON | 2010-06-14 21:10:00
8 | 8 | I | CODY LAYTON | 2010-06-14 22:03:00 | 110
9 | 9 | J | CODY LAYTON | 2010-06-14 22:37:00 | 110
10 | 10 | K | MATTHEW DEMPSY | 2010-06-14 23:44:00
11 | 11 | A | [NAME] | 2010-06-14 23:46:00
Worksheet 2:  Assignments
Name | Assignment | Ident (Record #) | IsWorking | Stop | Start | DTStamp | Manual Assessment
[NAME] | 110 | 6052 | 1 | 0 | 1 | 2010-06-14 10:59:42 | Entry Error
[NAME] | 110 | 6053 | 1 | 1 | 0 | 2010-06-14 10:59:42 | Entry Error Corrected
[NAME] | 110 | 6056 | 1 | 0 | 1 | 2010-06-14 10:59:43 | Entry Error
[NAME] | 110 | 6057 | 1 | 1 | 0 | 2010-06-14 10:59:43 | Entry Error Corrected
[NAME] | 110 | 6060 | 1 | 0 | 1 | 2010-06-14 10:59:49 | Assigned to 110
[NAME] | 110 | 6068 | 0 | 0 | 1 | 2010-06-14 14:03:04 | Entry Error; Not Working
[NAME] | 110 | 6067 | 1 | 1 | 0 | 2010-06-14 14:03:04 | End 110 Assignment
[NAME] | 110 | 6072 | 1 | 0 | 1 | 2010-06-14 14:24:16 | Assigned to 110 (gap in time)
LEVELL WILSON | 110 | 6108 | 1 | 0 | 1 | 2010-06-14 18:00:22 | Entry Error
LEVELL WILSON | 110 | 6107 | 0 | 1 | 0 | 2010-06-14 18:00:22 | Entry Error; Not Working
LEVELL WILSON | 110 | 6109 | 1 | 1 | 0 | 2010-06-14 18:00:35 | Entry Error
CODY LAYTON | 110 | 6124 | 1 | 0 | 1 | 2010-06-14 20:04:33 | Assigned to 110
[NAME] | 110 | 6127 | 1 | 1 | 0 | 2010-06-14 20:04:53 | End 110 Assignment
CODY LAYTON | 110 | 6137 | 1 | 1 | 0 | 2010-06-14 23:57:33 | End 110 Assignment
Spreadsheet: 5dc174d9-8634-45d6-9c2e-238e179f8ae7
Sheet: Other

Original Budget |  |  | Inst. - Salaries (0100)
[NAME] |  |  | Inst. - Employee Benefits (0200)
 |  |  | Inst. - Purchased Professional & Technical Services (0300)
 |  |  | Inst. - Other Purchased Services (0500)
Project 1 |  |  | Inst. - Travel, Registration and Entrance (0580)
Project 2 |  |  | Inst. - Supplies (0600)
Project 3 |  |  | Inst. - Books and Periodicals (0640)
Project 4 |  |  | Inst. - Other Expenses (0800)
Project 5 |  |  | Support - Salaries (0100)
Project 1-Year 2 |  |  | Support - Employee Benefits (0200)
Project 2-Year 2 |  |  | Support - Purchased Professional & Technical Services (0300)
Project 3-Year 2 |  |  | Support - Other Purchased Services (0500)
Project 4-Year 2 |  |  | Support - Travel, Registration and Entrance (0580)
Project 5-Year 2 |  |  | Support - Supplies (0600)
Project 1-Year 3 |  |  | Support - Books and Periodicals (0640)
Project 2-Year 3 |  |  | Support - Other Expenses (0800)
Project 3-Year 3
Project 4-Year 3
Project 5-Year 3
Project 1-Year 4 |  |  | Capitalized
Project 2-Year 4 |  |  | Non-Capitalized
Project 3-Year 4
Project 4-Year 4
Project 5-Year 4
Project 1-Year 5
Project 2-Year 5
Project 3-Year 5
Project 4-Year 5
Project 5-Year 5
Spreadsheet: 5d1cd9bf-fa19-4d3c-98e0-3b3ab8437862
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-01-30 09:36:18.620000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.5 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
4.375 | 102.035 | 101.91 | 101.785 | 101.41
4.25 | 101.961 | 101.836 | 101.711 | 101.336 |  | Note: | Refer To Price [NAME]
4.125 | 101.888 | 101.763 | 101.638 | 101.263 |  |  | For all Price Adjs
4 | 101.486 | 101.361 | 101.236 | 100.611
3.875 | 100.969 | 100.844 | 100.719 | 100.094
3.75 | 100.138 | 100.013 | 99.888 | 99.263
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.625 | 102.008 | 101.883 | 101.758 | 101.383
3.5 | 101.677 | 101.552 | 101.427 | 101.052
3.375 | 101.323 | 101.198 | 101.073 | 100.698
3.25 | 100.76 | 100.635 | 100.51 | 100.135
3.125 | 99.643 | 99.518 | 99.393 | 98.768
3 | 99.309 | 99.184 | 99.059 | 98.434
2.875 | 98.916 | 98.791 | 98.666 | 98.041 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-02-13 09:36:18.620000
30 DAY | 2012-02-28 09:36:18.620000
45 DAY | 2012-03-14 09:36:18.620000
60 DAY | 2012-03-29 09:36:18.620000
90 DAY | 2012-04-28 09:36:18.620000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 811815d1672818512-resource-allocation-based-on-week-numbers-resource-allocation-1-
Sheet: Sheet1

Status | Name | Start date | Weeks in total | Week number | Week number | Week number | Week number | Week number | Week number
Active | Name 1 | 2023-01-01 00:00:00 | 2 |  | 2
Active | Name 2 | 2023-02-02 00:00:00 | 4 |  | 7 | 8 | 9
Active | Name 3 | 2023-03-03 00:00:00 | 3 |  | 11 | 12
Active | Name 4 | 2023-04-04 00:00:00 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W 1 | W 2 | W 3 | W 4 | W 5 | W 6 | W 7 | W 8 | W 9 | W 10 | W 11 | W 12 | W 13 | W 14 | W 15
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Name 4
Spreadsheet: 237817d1369317100-rota-working-out-unpaid-breaks-sample-rota
Sheet: Sheet1

 | Friday |  | Saturday |  | Sunday |  | Monday |  | Tue |  | Wed |  | Thurs |  |  | Hours less breaks | Daily Break Entitlement Formula 1 |  |  |  |  |  |  | Daily Break Entitlement Formula 2
Name | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish | Start | Finish |  |  | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
[NAME] | 09:00:00 | 18:30:00 | 12:00:00 | 17:00:00 | 09:00:00 | 18:00:00 | off | off | off | off | 17:00:00 | CL | 17:00:00 | CL
[NAME]
[NAME]
[NAME]
Spreadsheet: 65439d1266164189-search-and-return-address-for-all-matches-book6-1-
Sheet: Sheet1

A | F | K |  | Search: |  | Address:
B | G | L |  | B |  | $A$1
C | H | M |  |  |  | $C$4
D | I | A |  |  |  | $B$6
E | J | O |  |  |  | $A$8
N | A | K |  |  |  | $B$8
B | G | L |  |  |  | $C$8
A | A | A |  |  |  | $A$10
D | H | M
A | J | O
Spreadsheet: e9d628b1-8ce0-4697-8c8e-480a7e532f4b
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
PT | Test | PT | Prothrombin Time, Plasma | Prothrombin Time, P | Electromagnetic Viscosity Detection System | Light blue-top 3.2% Sodium Citrate tube(s): BluNaCi |  |  | 4.5 | mL | Platelet-Poor Plasma Collection Container/Tube: Light blue top (3.2% sodium citrate) Submission Container/Tube: Plastic vial [NAME]: 0.5 mL Specimen Stability Information: Frozen  Whole Blood (Available to local accounts only) Container/Tube: Light blue top (3.2% sodium citrate) [NAME]: 4.5 mL Specimen Stability Information: Ambient Collection Instructions: Protime must be completed within 24 hours of draw time. | Whole blood: 1.8 mL Plasma: 0.5 | Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icterus	NA Other	NA | PROTHROMBIN TIME 9.5-13.8 seconds INR 0.8-1.2 The INR is used only for patients on stable oral anticoagulant therapy. It makes no significant contribution to the diagnosis or treatment of patients whose PT is prolonged for other reasons. | Daily; Continuously | 1 day | 1 day | 1 | 85610 |  |  |  |  | Rochester
PT | [NAME] | NACIT | [NAME] |  |  |  | Frozen | 30 days
PT | Result | PTTIC | Prothrombin Time, P | Prothrombin Time, P | Numeric |  |  |  |  | sec |  |  |  |  |  |  |  |  |  | 5902-2
PT | Result | INRC | INR | INR | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6301-6
Spreadsheet: 033d4855-ec7b-4602-8b8c-aaab9c75b6fc
Sheet: 15a

Product |  | Transactions
Single - Name* | Corporate | 21029
 | Loans | <100
 | Municipal | <100
 | Recovery | <100
 | Sovereign | 2007
Index Tranche | Asia | <100
 | Europe | <100
 | North America | 130
Index | Asia | 284
 | Europe | 4368
 | North America | 4539
TOTAL |  | 32357
Estimated swap transaction volumes, week ending February 1, by product type (in number of transactions), all tenors and currencies. This table will be expanded to reflect participant type and cleared status as more complete data becomes available.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: louise_kitchen__24097__NEWCO HEADCOUNT NAMES1
Sheet: East Power Trading

East  Power Trading
Hourly | [NAME] | Analyst
ERCOT | [NAME] | Analyst
MIDWEST | [NAME] | Analyst
Hourly | [NAME] | Analyst |  | 12500
Hourly | [NAME] | Analyst
MIDWEST | [NAME] | Analyst | 6
Hourly | [NAME] | Associate
Hourly | [NAME] | Associate
Options | [NAME] | Associate
SOUTHEAST | [NAME] | Associate |  | 50000
Hourly | [NAME] Seely | Associate |  | 12500
ERCOT | [NAME] | Associate
NORTHEAST | [NAME] | Associate
Hourly | Punit Rawal | Associate
ERCOT | [NAME] | Associate
Hourly | [NAME] | Associate | 10
NORTHEAST | [NAME] | Clerk, Sr. | 1
ERCOT | [NAME] | Director
ERCOT | [NAME] | Director |  | 50000
SOUTHEAST | [NAME] | Director
NORTHEAST | [NAME] | Director | 4
Hourly | [NAME] | Manager |  | 40000
Genco | Eri Serio | Manager |  | 10000
NORTHEAST | [NAME] | Manager
Hourly | [NAME] | Manager |  | 10000
ERCOT | [NAME] | Manager
Genco | [NAME] | Manager |  | 10000
SOUTHEAST | [NAME] | Manager |  | 75000
SOUTHEAST | Narsihma Misra | Manager
NORTHEAST | [NAME] | Manager |  | 100000
Options | [NAME] | Manager
Options | [NAME] | Manager
Hourly | [NAME] | Manager | 12 | 25000
MIDWEST | [NAME] | Sr. Spec |  | 50000
Hourly | [NAME] | Sr. Spec |  | 12500
Hourly | [NAME] | Sr. Spec |  | 12500
Hourly | [NAME] | Sr. Spec |  | 12500
Hourly | [NAME] | Sr. Spec
Hourly | [NAME] | Sr. Spec | 6 | 25000
SOUTHEAST | [NAME] | Staff | 1 | 10000
MIDWEST | [NAME] | Vice Pres
Options | [NAME] | Vice Pres
Options | [NAME] | Manager |  | 25000
EAST POWER | [NAME] | Vice Pres
SOUTHEAST | [NAME] | Vice Pres | 5
 |  | TOTAL
Spreadsheet: 38687d1236836019-sorting-number-letter-combos-dadscool2
Sheet: Sheet1

Test Data | Dash Position | Data Length | Δ | Operate on First Half | Second Half | Complete Soln
6-138 | 2 | 5 | 3 | 6-138 | 6- 138 | 6- 138 | 6- 138
6-255 | 2 | 5 | 3 | 6-255 | 6- 255 | 6- 255 | 6- 255
6-1038 | 2 | 6 | 4 | 6-1038 | 6-1038 | 6-1038 | 6-1038
75201 | 6 | 5 | -1 | 75201 | 75201 | 75201 | 16-  02
16-02 | 3 | 5 | 2 | 16-02 | 16-  02 | 16-  02 | 75201
RH630-35 | 6 | 8 | 2 | RH630-35 | RH630-  35 | RH630-  35 | PH630- 344
PH630-344 | 6 | 9 | 3 | PH630-344 | PH630- 344 | PH630- 344 | RH630-  35
Spreadsheet: 47495d1246521000-using-multipel-sum-ranges-in-sumproduct-and-countif-in-array-position-rank
Sheet: Solution-1

Students Name | Eng | Math | Phy | Chem | Bio | If Pass Then Marks Else Obtained Marks | If Pass Then Student Position in Class | To Show the Student Postion Created This Column | If Pass Then Student Position in Class
[NAME] | 85 | 90 | 59 | 75 | 60 | Fail | Fail | 0 | Fail
Maria | 85 | 69 | 60 | 85 | 75 | 374 | 374-2 | 374 | 2
JANNY | 90 | 60 | 60 | 90 | 60 | 360 | 360-3 | 360 | 3
Gaughan | 0 | 0 | 0 | 0 | 0 | Fail | Fail | 0 | Fail
Madona | 75 | 75 | 80 | 65 | 80 | 375 | 375-1 | 375 | 1
[NAME] | 75 | 75 | 75 | 80 | 55 | Fail | Fail | 0 | Fail
 |  |  |  |  |  | Trying to get  solution as    "If Pass Then Position Else "Fail" "
 |  |  |  |  |  |  |  | I have solved this issue now and using Clomn G & H
 | 1. | I've jammed in below problem and almost struggling from last 2 days.  At last, I ve got the solution but seeking for some improvement in formula.  Hope I'll get some quick solution by you.  My problem is :
 | 2.
 | 3.
 | 4. | 1.In G Column I put logic for Fail and Obtained Marks. G2=IF(COUNTIF(B2:F2,">=60")=5,SUM(B2:F2),"Fail") 2. Now in H column I want use this formula which I obtained from this forum H2=SUMPRODUCT((G$2:G$7>G2)/COUNTIF(G$2:G$7,G$2:G$7&""))+1 To get the position of Students.  But the text value "fail" in the G2:G7 getting Position No. 1 and i've noticed the reason by using evaluate formula as well.  3. I got solution by changing "Fail" with 0 by creating column I and then column H put this formula. =SUMPRODUCT((I$2:I$7>I2)/COUNTIF(I$2:I$7,I$2:I$7&""))+1 or =IF(I2=0,"Fail",SUMPRODUCT((I$2:I$7>I2)/COUNTIF(I$2:I$7,I$2:I$7&""))+1) Now after spending a more time I made this array formula for H2 to control Text Values  ={SUMPRODUCT((IF(ISNUMBER($G$2:$G$7),$G$2:$G$7,0)>N(G2))/COUNTIF(G$2:G$7,G$2:G$7&""))+1} or  ={IF(COUNTIF(B3:F3,">=60")<>5,"Fail",SUMPRODUCT((IF(ISNUMBER($G$2:$G$7),$G$2:$G$7,0)>N(G3))/COUNTIF(G$2:G$7,G$2:G$7&""))+1)} And more work to get total marks + position ......  ={IF(COUNTIF(B2:F2,">=60")<>5,"Fail",SUM(B2:F2)&"-"&SUMPRODUCT((IF(ISNUMBER($G$2:$G$7),$G$2:$G$7,0)>N(G2))/COUNTIF(G$2:G$7,G$2:G$7&""))+1)} Now I am wounder that is there a way to get rid of Column G ?????  By replacing (if there is any method) G2, G3, G4 etc. with Sum(B2:F2); Sum(B3:F3);Sum(B4:F4) etc. in below formula  ={SUMPRODUCT((IF(ISNUMBER($G$2:$G$7),$G$2:$G$7,0)>N(G2))/COUNTIF(G$2:G$7,G$2:G$7&""))+1}
Spreadsheet: 239903d1370061364-using-conditional-formatting-to-highlight-cells-based-on-days-of-the-month-test_month
Sheet: Sheet1

 | NAMES | DATE
 | Name 1
 | Name 2
 | Name 3
 | Name 4
 | Name 5
 | Name 6
 | Name 7
 | Name 8
 | Name 9
 | Name 10
 | Name 11
 | Name 12
 | Name 13
 | Name 14
 | Name 15
 | Name 16
 | Name 17
 | Name 18
 | Name 19
 | Name 20
 | Name 21
 | Name 22
 | Name 23
 | Name 24
 | Name 25
 | Name 26
 | Name 27
 | Name 28
 | Name 29
 | Name 30
 | Name 31
 | Name 32
 | Name 33
 | Name 34
 | Name 35
 | Name 36
 | Name 37
 | Name 38
 | Name 39
 | Name 40
 | Name 41
 | Name 42
 | Name 43
 | Name 44
 | Name 45
 | Name 46
 | Name 47
 | Name 48
 | Name 49
 | Name 50
 | Name 51
 | Name 52
 | Name 53
 | Name 54
 | Name 55
 | Name 56
 | Name 57
 | Name 58
 | Name 59
 | Name 60
 | Name 61
 | Name 62
 | Name 63
 | Name 64
 | Name 65
 | Name 66
 | Name 67
 | Name 68
 | Name 69
 | Name 70
 | Name 71
 | Name 72
 | Name 73
 | Name 74
 | Name 75
 | Name 76
 | Name 77
 | Name 78
 | Name 79