tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 738235d1624912549-budget-amounts-from-budget-setup-sheet-book1-1-
Sheet: Budget Setup

 | Year | 2021
 |  |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December
 |  |  | Income
 |  | 1 |  |  |  |  |  |  |  |  | 3200
 |  | 2 |  |  |  |  |  |  |  |  | 2800
 |  | 3
 |  | 4
 |  |  | Totals
 |  |  |  |  | January | February | March | April | May | June | July | August | September | October | November | December
 |  |  | 1. Housing (25-35 %)
 |  | 1 |  |  |  |  |  |  |  |  | 1280
 |  | 2 |  |  |  |  |  |  |  |  | 200
 |  | 3 |  |  |  |  |  |  |  |  | 250
 |  | 4 |  |  |  |  |  |  |  |  | 350
 |  | 5 |  |  |  |  |  |  |  |  | 25
 |  | 6 |  |  |  |  |  |  |  |  | 150
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 2. Transportation (10-15 %)
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 3. Food (10-15 %)
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 4. Utilities (5-10 %)
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 5. Insurance (10-25 %)
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 6. Healthcare (5-10 %)
 |  | 1 |  |  |  |  |  |  |  |  | 2000
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 7. Debt Payments (10-20 %)
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 8. Personal (5-10 %)
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 9. Entertainment (5-10 %)
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
 |  |  | 10. Miscellaneous (5-10 %)
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  |  | Totals
Spreadsheet: 677271d1589280787-need-help-with-nesting-if-functions-if-function-questions
Sheet: Sheet1

 |  |  | [NAME]
 |  | Yesterday's Run | 6
 |  | 1st RUN | 4
 |  | 2nd RUN | 7
 |  | 3rd RUN | 11
 |  | 4th RUN | 14
 |  | 5th RUN | 22
 |  | Today's Run | 7
 |  | I need to make "Today's Run" (TR) one step longer than "Yesterday's Run" (YR).
 |  | For example, if YR were 5 or 6 miles, then TR needs to be 7 miles. If YR were 12 or 13 miles, then TR needs to return as 14 miles, etc.
 |  | I need to find a way enter variables for YR (D3) and have TR (D11) automatically choose the next highest distance.
 |  | I've tried nesting IF formulas and have had success with them in the past, but can't seem to make this work.
 |  | I can get separate IF formulas to work alone, but as soom as I start to string them together I get a #[NAME]!
 |  | Below is a simple example of what I'm trying to achieve:
 |  | The variables cell is D26 and the results and nested IF's are in D34
 |  |  | SOUND
 |  | ANIMAL | HEN
 |  | CAT | CLUCK
 |  | DOG | MEOW
 |  | SNAKE | BARK
 |  | COW | HISS
 |  | HEN | MOO
 |  | Today's Run | CLUCK
 | Back to the original table:
 |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME]
 |  | Yesterday's Run | 3 |  |  | Yesterday's Run | 6 |  |  | Yesterday's Run | 11
 |  | 1st RUN | 4 |  |  | 1st RUN | 4 |  |  | 1st RUN | 4
 |  | 2nd RUN | 7 |  |  | 2nd RUN | 7 |  |  | 2nd RUN | 7
 |  | 3rd RUN | 11 |  |  | 3rd RUN | 11 |  |  | 3rd RUN | 11
 |  | 4th RUN | 14 |  |  | 4th RUN | 14 |  |  | 4th RUN | 14
 |  | 5th RUN | 22 |  |  | 5th RUN | 22 |  |  | 5th RUN | 22
 |  | Today's Run | 4 |  |  | Today's Run | 7 |  |  | Today's Run | 0
 | Above in D50 is a single IF function that addresses a run of less than the 1st RUN (D44):  =IF(D42<D44,D44)
 | Then a formula for the next step:  =IF(AND(H42>=H44,H42<H45),H45)
 | And the next:  =IF(AND(L42>=L45,L42<L46),L46)
 | Of course, each time YR is outside the parameters of those individual formulas, it returns FALSE.
 | Below is an example what happens when I try to string just the first two together.
 |  |  | [NAME]
 |  | Yesterday's Run | 2
 |  | 1st RUN | 4
 |  | 2nd RUN | 7
 |  | 3rd RUN | 11
 |  | 4th RUN | 14
 |  | 5th RUN | 22
 |  | Today's Run | #N/A
 | I've done nested IF functions in the past that were as or more complicated.  What am I doing wrong?
 | Any help is greatly appreciated!
Spreadsheet: 751358d1634059406-highlight-or-list-volunteers-who-having-been-assigned-volunteer-schedule
Sheet: Locations

 |  |  | Monday [NAME] | Tuesday [NAME] | Wednesday [NAME] | Thursday [NAME] | Friday [NAME]
 | Location 1 |  | Volunteer 2 | Volunteer 10 | Volunteer 1 | Volunteer 9 | Volunteer 7
 | Location 2 |  | Volunteer 16 |  | Volunteer 4
 | Location 3 |  |  |  |  |  | Volunteer 8
 | Location 4 |  |  | Volunteer 7 | Volunteer 3
 | Location 5 |  |  |  |  |  | Volunteer 13
 | Location 6
 | Location 7 |  |  | Volunteer 16
 | Location 8
 | Location 9
 | Location 10
 | Location 11
 | Location 12
 | Location 13
 |  |  | Mon Volunteers Unused | Tue Volunteers Unused | Wed Volunteers Unused | Thur Volunteers Unused | Fri Volunteers Unused
 |  |  | Ideally, the unused volunteers would dynmaically list below | Ideally, the unused volunteers would dynmaically list below | Ideally, the unused volunteers would dynmaically list below | Ideally, the unused volunteers would dynmaically list below | Ideally, the unused volunteers would dynmaically list below
Spreadsheet: 0292cd15-df30-4c36-9cd9-6f3592ef84dd
Sheet: Sheet1

#3  Course Retention | MSJC BASIC SKILLS LEVEL DATA
 | AY 07-08 | A08-09 | [NAME] | AY10-11 | AY-11-12
 | 2007
Gender | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates
Female
Male
Unknown
AY Average
Ethnicity | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates
White
Hispanic
African American
Asian
Native American
Filipino
Pacific Islander
Multi-Race
Unknown
Age | Retention Rates | Retention Rates | Retention Rates | Retention Rates | Retention Rates
<18
18 & 19
20 to 24
25 to 29
30 to 34
35 to 39
40 to 49
50 +
Unknown
BASIC SKILLS = Courses under 70 level
Spreadsheet: 0241bcd6-4040-433e-aaf2-08a5e85292ec
Sheet: Title Abbrev.

Title Abbreviations |  |  |  |  |  |  | Start Over
Title | Abbreviation | Always Abbreviate? | Beginning or End of Title? | End of Title Examples | Beginning of Title Examples
Analyst | Anlyst | * | End | Program Analyst | N/A
Assistant | Asst | Yes | ** | [NAME], Program [NAME] | [NAME], Asst Program Mgr
Associate | Assoc | Yes | ** | Research Assoc | Assoc Director
Building | Bldg | * | **
Center | Ctr | * | End
Coordinator | Coord | Yes | End | Program Coord | N/A
Customer | Custmr | * | **
Developer | Dvlpr | Yes | End
Director | Dir | Yes | Beginning
Employee | Emp | * | **
Executive Director | [NAME] | Yes | Beginning | N/A | [NAME], Accounting Svcs
Financial | Financl | * | **
[NAME] | Frmn | * | Beginning | N/A | [NAME], [NAME]
[NAME] | Foreprsn | * | Beginning | N/A | Foreprsn, XXX
Instructor | Instrctr | * | **
International | Intl | Yes | **
Laboratory | Lab | Yes | **
Maintenance | Maint | * | **
Management | Mgmt | * | **
Manager | Mgr | Yes | ** | Program Mgr - Forest Mgr | Mgr, University Residence
Operations | Opns | * | **
Program | Prgrm | * | **
Relations | Rltns | * | **
Representative | Rep | Yes | **
Research | Rsrch | Yes | **
Senior | Snr | Yes | End | Programmer Analyst [NAME] | N/A
Services | Srvcs | Yes | **
Specialist | Splst | Yes | End | Program Splst | N/A
Student | Stdt | * | **
Supervisor | Sprvsr | Yes | ** | Program Sprvsr | Sprvsr, Office Services
System | Systm | * | **
Technician | Tech | Yes | End | Financial Tech | N/A
Training | Trng | * | **
Vice President | VPres | Yes | Beginning | N/A | Vice Pres or V Pres ONLY
Vice Provost | VProv | Yes | Beginning | N/A | Vice Prov or V Prov ONLY
Spreadsheet: michael_maggi__26470__NYMEXWEEKLYSTATS
Sheet: ho

Week Ending: | 2001-02-01 00:00:00
 | Futures Settlement Prices
 | HEATING OIL |  |  |  |  | Contract Symbol:  HO
 | Contract | Monday | Tuesday | Wednesday | Thursday | Friday | Open
 | Month | 2001-01-28 00:00:00 | 2001-01-29 00:00:00 | 2001-01-30 00:00:00 | 2001-01-31 00:00:00 | 2001-02-01 00:00:00 | Interest
 | 2002-02-01 00:00:00 | 0.5313 | 0.5205 | 0.5091 | 0.5229 | N\A | 2346
 | 2002-03-01 00:00:00 | 0.532 | 0.5221 | 0.5131 | 0.5316 | 0.5531 | 57311
 | 2002-04-01 00:00:00 | 0.534 | 0.5251 | 0.5171 | 0.5331 | 0.5552 | 25574
 | 2002-05-01 00:00:00 | 0.537 | 0.5281 | 0.5216 | 0.5356 | 0.5557 | 12718
 | 2002-06-01 00:00:00 | 0.5415 | 0.5326 | 0.5271 | 0.5396 | 0.5582 | 19476
 | 2002-07-01 00:00:00 | 0.547 | 0.5386 | 0.5336 | 0.5456 | 0.5632 | 8494
 | 2002-08-01 00:00:00 | 0.5545 | 0.5466 | 0.5421 | 0.5536 | 0.5707 | 9672
 | 2002-09-01 00:00:00 | 0.5635 | 0.5556 | 0.5511 | 0.5626 | 0.5792 | 6938
 | 2002-10-01 00:00:00 | 0.5725 | 0.5646 | 0.5606 | 0.5716 | 0.5877 | 5411
 | 2002-11-01 00:00:00 | 0.5805 | 0.5726 | 0.5691 | 0.5796 | 0.5957 | 4148
 | 2002-12-01 00:00:00 | 0.588 | 0.5801 | 0.5771 | 0.5871 | 0.6032 | 11149
 | 2003-01-01 00:00:00 | 0.594 | 0.5861 | 0.5831 | 0.5926 | 0.6087 | 4715
 | Total Weekly Volume |  |  |  | Total Open Interest |  | 176643
 |  |  |  | *Weekly volume and open interest reflects all traded months.
 | Historial Volatility-Spot Month Futures
 |  |  |  | Heating Oil
 | 5 Day Hist. Vol. |  |  | 0.6158
 | 20 Day Hist. Vol. |  |  | 0.4513
 | Implied Volatility-Options |  |  | Heating Oil
 | At the Money Call & Put |  |  | 0.4798
 | MON | TUE | WED | THUR | FRI | Total
Volume | 45361 | 54605 | 64304 | 72755 | 47647
Spreadsheet: 820371d1678064137-sumifs-to-aggregate-hours-in-scheduling-problem
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  | Scheduling
 |  |  |  |  |  |  |  |  |  |  | Project | Jan | Feb | Mar | Apr | May | Jun
 |  |  |  |  |  |  |  |  |  |  | A | 1 | 2 | 3 | 4 | 5 | 6
 |  |  |  | Table of Inputs |  |  |  |  |  |  | B |  | 1 | 2 | 3 | 4 | 5
 |  |  |  | No | Hours | Beg M | End M |  |  |  | C |  |  | 1 | 2 | 3 | 4
 |  |  |  | A | 8 | 1 | 2
 |  |  |  | B | 7 | 1 | 3
 |  |  |  | C | 6 | 1 | 4
 |  |  |  |  |  |  |  |  |  | My Formula
 |  |  |  |  |  |  |  |  |  | Expected Result
Spreadsheet: 124109d1318116372-how-do-i-show-list-of-students-names-who-failed-on-a-separate-sheet-final-grades
Sheet: List of failed students

SY 2011-2012
 | BSN-XXX | SUBJECT HERE |  |  |  | [NAME] FINAL | =
 | Name of Student | Concept 1 | Concept 2 | Concept 3 | Compre Exam
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 822116d1679106750-index-match-from-table-and-date-excel-help
Sheet: Theo

Month | January |  |  | COS p/Unit | Total COS |  | Name | COS |  | PLU |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Date |  |  | Source
 | Menu Item Name | Menu Item # | [NAME] | Single | Total |  | Avocado | 3.26 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  | 10070003 | 100030005 | 60040005
 |  |  |  |  |  |  | Bestikk i Bambus | 0.87372 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  | 20040002 | 300010009
1 | Avocado |  | 170 |  |  |  | Coriander | 0.6961 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  | 100030004
1 | Bestikk i Bambus |  | 237 |  |  |  | [NAME] | 5.00039 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  | 700010007 | 700010004
1 | [NAME] |  | 87 |  |  |  | Extra Patty | 5.026 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  | 60040001
1 | Extra Patty |  | 219 |  |  |  | Frisk Chili | 1.2388 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  | 600030001 | 20050009 | 100030001 | 400030001 | 500030001 | 700010013 | 60040004 | 700030001
1 | Frisk Chili |  | 123 |  |  |  | Marinerede rødløg | 0.823 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  | 100030002
1 | [NAME] ([NAME]) |  | 242 |  |  |  | [NAME] ([NAME]) | 1.5389 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  | 10070002
 |  |  |  |  |  |  | Avocado | 3.34 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  | 10070003 | 100030005 | 60040005
 | February |  |  | COS p/Unit | Total COS |  | Bestikk i Bambus | 0.9523 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  | 20040002 | 300010009
 | Menu Item Name | Menu Item # | [NAME] | Single | Total |  | Coriander | 0.685 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  | 100030004
 |  |  |  |  |  |  | [NAME] | 5.0144 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  | 700010007 | 700010004
2 | Avocado |  | 188 |  |  |  | Extra Patty | 4.998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  | 60040001
2 | Bestikk i Bambus |  | 224 |  |  |  | Frisk Chili | 1.244 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  | 600030001 | 20050009 | 100030001 | 400030001 | 500030001 | 700010013 | 60040004 | 700030001
2 | [NAME] |  | 90 |  |  |  | Marinerede rødløg | 0.888 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  | 100030002
2 | Extra Patty |  | 221 |  |  |  | [NAME] ([NAME]) | 1.523 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00 |  |  | 10070002
2 | Frisk Chili |  | 135
2 | [NAME] ([NAME]) |  | 250
Spreadsheet: 79189d1279477494-problem-with-automatic-alphebetizing-macro-customers-alfa-
Sheet: Customers

# | Date | Name | Prefix | First | Initial | Last |  | Address | City | State | Zip | Home Phone | Work Phone | Cell Phone | E Mail | Profession | Gender | Age | Birthday | Height | Weght | Referral |  |  |  | [NAME] | Should look like
1 | 1993-09-17 00:00:00 | Lyons, Kathy M | Ms. | Kathy | M | Lyons |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  | , | [NAME], [NAME]
2 | 1999-05-02 00:00:00 | Fiely, Dennis | Mr. | Dennis |  | Fiely |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  | , | Fiely, Dennis
3 | 2001-02-11 00:00:00 | [NAME], [NAME] R | Mr. | [NAME] | R | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | , | Fiely, [NAME]
4 | 1999-09-10 00:00:00 | Fiely, [NAME] | Mr. | Fletcher |  | Fiely |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | , | Lyons, Kathy M
Spreadsheet: 169324d1342783956-abs-disregarding-zero-values-book2
Sheet: Sheet1

0
0
0
0
0
0
0
98
98
76
78
7
6
76
78
76
7
765
76
6
5
65
4
6
5
Spreadsheet: 862741d1710392239-help-extracting-text-from-inconsistent-text-strings-text-extract-with-pq-too-4-
Sheet: Headers

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21
# [NAME] | ML Odds | Med Eqp | Days Since L/R | Run  Style | P T S | [NAME] | Dist/ E2 | Surf PACE Late | SPEED Spd | [NAME] | E1 | Best Pace E2 | Late | Sp1 | Sp2 | Sp3 | Sp4 | ACL | Spd Avg | Index
4
File Path and Name
Spreadsheet: 722240d1615130719-modify-my-formula-to-to-check-the-values-and-enter-the-result-and-if-no-values-enter-a-m-missing-and-sum-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | M | 2024-04-04 00:00:00 |  |  |  |  |  | P | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | will always .45 points |  |  | M8
 |  |  |  |  |  |  |  |  |  |  |  | if no value in the box get "M"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | we allocate a point system in order todetermine the strength of the box
 |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | will always get .33 points
 |  |  |  |  |  |  |  |  |  |  | Date of Birth |  |  |  |  |  |  |  |  | box |  |  |  |  |  |  |  |  |  |  | each will get 1 point
 |  |  |  |  | 4 |  |  |  |  | 3 |  |  |  |  |  | P | L | K
 |  |  |  |  | 9 |  |  |  |  | M |  |  | if the cells in the box have no values, we say that the numbers are missin so reprsented by "M"
 |  |  |  |  | 2 |  |  |  |  | 1 |  | here I need a formula that allocated points to each cell like t8=.45 and all other cells u8:aa8 will have 1 point each and
 |  |  |  |  |  |  |  |  |  |  |  | ab8 =.33 | We therafter need to sum the total from T8:u8 but end results must not be greater than 3  and result entered into cell M14
 |  |  |  |  |  |  |  |  |  |  |  | as in the case of K12 the value is 3 because e8:k8 total 3.45 rounded to 3
 |  |  |  |  |  |  |  |  |  |  |  | and in the case of m13 because the value is zero, (M)issing  gets pasted into there
 |  |  |  |  |  |  |  |  |  |  |  | the orange shaded cells will contain the fomula that I need help with
 |  |  |  |  |  |  |  |  |  |  |  | e8 will  allocated .45 points
 |  |  |  |  |  |  |  |  |  |  |  | f8 will be allocated 1 point
 |  |  |  |  |  |  |  |  |  |  |  | g8 will be allocated 1 point |  |  |  |  |  | sum total must max 3 points if it’s a decimal must be rounded of greater.5 next number  max 3 points which be 100 % if its 2points 66% and 1 point 33%
 |  |  |  |  |  |  |  |  |  |  |  | h8 will gets no points blank
 |  |  |  |  |  |  |  |  |  |  |  | i8 gets 1 point
 |  |  |  |  |  |  |  |  |  |  |  | [NAME] gets 1 point |  |  |  |  |  |  |  |  |  |  | M12 | will be *.45+1+1+0+1 |  |  |  |  | 3.45 | round 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  | k8 get .45 points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M14  will be *45+1 = 1.45 so will be 1 rounded and will get 33%
 |  |  |  |  |  |  |  |  |  |  |  | and if all the cells in the box are empty , it wiil get a "M" meaning that its missing points
 |  |  |  |  |  |  |  | I tried to use some identifiers that may help to make it a little clearer
Spreadsheet: 835529d1688645561-find-the-maximum-cost-price-to-pay-that-will-achieve-a-gp-of-70-problem-sample
Sheet: Sheet1

 | UOM | Pints |  | Target GP% |  | UOM | Cost Price Low | Cost Price High | Cost Per Pint | Rounded RRP - Pint | Rounded RRP - Half Pint | GP%
 | 11 Gallon | 88 |  | 0.7 |  | 9 Gallon | 34 |  |  | 3.75
 | 18 Gallon | 144 |  |  |  | 9 Gallon
 | 30 Litre | 53 |  |  |  | 9 Gallon
 | 4.5 Gallon | 36 |  |  |  | 9 Gallon
 | 50 Litres | 105 |  |  |  | 9 Gallon
 | 9 Gallon | 72 |  |  |  | 9 Gallon
 | [NAME] | 8 |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
 |  |  |  |  |  | 9 Gallon
Spreadsheet: 99682d1298295399-cross-reference-cell-update-question-update-demo
Sheet: Sheet1

product_id | name | price | manufacturer
1001 | [NAME] | 2 | dell
1002 | Hinge | 3 | microsoft
1003 | Lock | 5 | ibm
1004 | [NAME] | 4 | ibm
Spreadsheet: 061cc7fb-0e73-4feb-91fc-d5a114c904aa
Sheet: Sheet1

AFLAC INC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
8-K
[NAME]
CURRENT REPORT
Georgia |  | 001-07434 |  | 58-1167100
(State or other jurisdiction |  | (Commission |  | (IRS Employer
of incorporation) |  | File Number) |  | Identification No.)
1932 Wynnton Road, Columbus, Georgia |  |  |  | 31999
(Address of principal executive offices) |  |  |  | (Zip Code)
____________________________
Created by Morningstar Document Research.
http://documentresearch.morningstar.com/
Spreadsheet: 884009d1732877333-lambda-and-xlookup-issue-excel-sumif-let-riddle-mmult
Sheet: Sheet1

Raw data |  |  |  |  |  |  |  | Named ranges
Fruits | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 |  |  | References | Name
Apples | 2229 | 2366 | 2623 | 2878 | 3001 |  |  | A3:F4 | tblData
Pears | 700 | 849 | 1140 | 1294 | 1568 |  |  | A4:A14 | lstFruits
[NAME] | 0 | 0 | 0 | 0 | 0 |  |  | A18:D20 | tblBundles
Bananas | 176 | 184 | 219 | 224 | 226 |  |  | A18:A20 | lstBundles
Peaches | 7 | 8 | 9 | 10 | 10
Cherries | 296 | 207 | 205 | 217 | 222
Tomatoes | 155 | 158 | 161 | 164 | 168
Dates | 383 | 390 | 397 | 444 | 451
Nuts | 0 | 23 | 46 | 35 | 89
Raspberries | 4511 | 5622 | 7732 | 8966 | 11132
Strawberries | 11877 | 12088 | 15770 | 16041 | 18154
Bundles
Name | Includes |  |  |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00
Red | Strawberries | Raspberries | Cherries | Tomatoes |  |  |  | Red | 16839 | 18075 | 23868 | 25388 | 29676
Yellow | Pears | Apples | Peaches |  |  |  |  | Yellow | 2936 | 3223 | 3772 | 4182 | 4579
Dry | Nuts | [NAME] | Dates |  |  |  |  | Dry | 383 | 413 | 443 | 479 | 540
Reports
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- This solution works great enough, but I am looking to simplify it even more.
Red |  |  |  |  | =SUM(SUMIFS(B$4:B$14,lstFruits,FILTER(tblBundles,lstBundles=$A25,0)))
Yellow |  |  |  |  | Look in January data,in the list of fruits and sum if fruit is included in the bundle filtered to the bundle color.
Dry
Bundle | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 |  | <- I'd love to have a clean LET function, pass the ranges for months and bundle names to a LAMBDA function
Red |  | 18075 | 23868 |  | and spill the values in the table. I banged my head on the SUMIF only accepting ranges issue for days…
Yellow | 2936 | 3223 | 3772 |  | Can I use the same FILTER approach, and use a LAMBDA to SUM all the XLOOKUP values for each fruit?
Dry | 383 | 413 | 443 |  | I've failed so far…
Spreadsheet: 188932d1351025973-help-with-a-2013-marketing-calendar-2013-marketing-calender-template
Sheet: Campaign Cost

 |  |  |  |  |  |  |  |  |  |  |  |  | Internal | Radio
 |  |  | Item | Est. Cost | Description | Internal/External | Format |  |  |  |  |  | External | Internal Print
 |  | 1 | Blank | 0 |  |  |  |  |  |  |  |  |  | TV
 |  | 2 | 2*4 Cling | 233 |  | Internal | Radio |  |  |  |  |  |  | External Print
 |  | 3 | Billboard | 36000 |  | External | Internal Print
 |  | 4 | [NAME] | 10000 |  | External | TV
 |  | 5 | POS Digital POP |  |  | Internal | Radio
 |  | 6 | Danglers |  |  | External | Internal Print
 |  | 7 | External Website |  |  | External | TV
 |  | 8 | Facebook Ad Campaign |  |  | Internal | Radio
 |  | 9 | Facebook Page promotion |  |  | External | Internal Print
 |  | 10 | Flyers for press/boxes/bags 5.5*8.5 |  |  | External | TV
 |  | 11 | In Store Digital Advertising Boards |  |  | Internal | Radio
 |  | 12 | Internal Website |  |  | External | Internal Print
 |  | 13 | Job Fair |  |  | External | TV
 |  | 14 | Legal POP |  |  | Internal | Radio
 |  | 15 | Letter POP |  |  | External | Internal Print
 |  | 16 | Newspaper ad -1/2 |  |  | External | TV
 |  | 17 | News Paper ad -1/4 |  |  | Internal | Radio
 |  | 18 | News Paper ad -1/8 |  |  | External | Internal Print
 |  | 19 | News Paper ad -Full |  |  | External | TV
 |  | 20 | Radio Ad |  |  | Internal | Radio
 |  | 21 | Radio Campaign |  |  | External | Internal Print
 |  | 22 | Radio Commercial |  |  | External | TV
 |  | 23 | Standee |  |  | Internal | Radio
 |  | 24 | Table Tents |  |  | External | Internal Print
 |  | 25 | [NAME] |  |  | External | TV
 |  | 26 | Translite Boards |  |  | Internal | Radio
 |  | 27 | TV ad |  |  | External | Internal Print
 |  | 28 | TV commercial run |  |  | External | TV
 |  | 29 | Van Wrap |  |  | Internal | Radio
 |  | 30 | Wall Cling |  |  | External | Internal Print
 |  | 31 | Window Clings |  |  | External | TV
 |  | 32 | Special Event |  |  | Internal | Radio
 |  | 33 | Sampling |  |  | External | Internal Print
 |  | 34 | Merchandise Give Aways
 |  | 35 | Coupons/Vouchers
 |  | 36 | Direct Mail out
 |  | 37 | Direct Text
 |  | 38 | [NAME] Campaign
 |  | 39 | Mobile Advertising