Posts by PETRODATAjames

Thanks, and sorry for the late reply, lets's try subgroups.

Hmmm?

=IF(OR(AL2=5,AL2=10,AL2=25,AL2=50,AL2=100),TRUE,FALSE)

I am curious how I can edit this formula to be this:

AL2=5 but is less that the next number 10 (including 6,7,8, and 9)

AL2=10 but is less than the next number 25 (including 11 through 24)

AL2 =25 but is less than the next number 50 (including 26 through 49)

AL2 =50 but is less than the next number 100 (including 51 through 99)

Thanks

PERFECT!

=IF(OR(AL2=5,AL2=10,AL2=25,AL2=50,AL2=100),TRUE,FALSE)

I see this.

Thanks again!

How do I add the additional values to 'Filtered Check-ins'? When I set this filter to TRUE, I see customers with 5 and 10 visits. What if I want to add additional visit values like 25, 50, 100, and so on?

Thanks

I have a worksheet that has a column 'AL' named Total Check-ins - All Time. I would like my PivotTable to list the customer's name and then a column that show me the Sum of Total Check-Ins - All Time, but only if the number is 5, 10, 25, 50, 100, maybe more, but those fixed numbers only.

I cannot find how this can be done.

Well I do not know, let me get back to you tonight and I'll show you what I came up with.

This Tiered Instructor Payroll (w_ No Shows + Late Cancels) UPDATED (Training Mate) je3v2.xlsm has a tab named 'Instructor Summary'. This tab has a couple of PivotTables on it. Where is the PivotTable Field menu? When I create a PivotTable this menu is displayed on the right. I would like to add the number of classes that the instructor taught. This can just be a count of his name, I think. This class count can be added to column 'C' on the same row as their name.

Thanks

I am needing to find the number of days from column 'D' 'Creation Date' to column 'Q' 'Class Start Date'. This formula can be placed in the column 'AY'. The issue using DATEIF is the formatting in column 'D2'. It is displayed as ##:##.#, but is 1/23/2023 6:22:47 AM and if I format the cell as Number > Date, I am still unable to calculate the date difference. Is there a formula or a macro that can do this?

Thanks

I am very happy that this was possible and that I can learn so much from the VBA.

Thanks so very much! Great job, it is so appreciated.

James

I have added a new request if this can be done.

I need to have a command button named 'Filter' on the 'Instructions' tab to run a macro. This macro will display a list from the column 'AB' on the 'Instructor and Location Payrate'. I would like to be able to select more than one item on this list at a time. The items select if a match is found from column 'J' on the 'Instructor Pay Data' tab, the value in column 'Z' on the same tab 'Instructor Pay Data will change the color of the font and the value will not be included on the PivotTable located in the tab named 'Instructor Summary'

I realize this is a lot, just very curious if this can be done, and how that VBA looks.

Thanks

PERFECT again, thanks!

This has been resolved.

Oh I just noticed something that maybe you can look at. I see on the tab 'Hourly Pay Data', column K has a Pay Rate formula. that is displaying an #N/A. Can this formula be edited to do a pay rate match from tab 'Pay Rates'? I would like the match be on the name and the just add the pay rate from that name match to Hourly Pay Data tab in column K. It would look like this: Thanks

PERFECT again, Thanks!

This question has been answered.

May I ask, where I would add = WEEKNUM(C2) in this formula? [email protected](A2<>"",(IFS(AND(C2>='Pay Rates'!$D$2,C2<='Pay Rates'!$E$2),'Pay Rates'!$F$2,(AND(C2>='Pay Rates'!$D$3,C2<='Pay Rates'!$E$3)),'Pay Rates'!$F$3,(AND(C2>='Pay Rates'!$D$4,C2<='Pay Rates'!$E$4)),'Pay Rates'!$F$4)),"-")

Thanks

I have this formula in column 'J' named 'Week'. It has this formula below.

[email protected](A2<>"",(IFS(AND(C2>='Pay Rates'!$D$2,C2<='Pay Rates'!$E$2),'Pay Rates'!$F$2,(AND(C2>='Pay Rates'!$D$3,C2<='Pay Rates'!$E$3)),'Pay Rates'!$F$3,(AND(C2>='Pay Rates'!$D$4,C2<='Pay Rates'!$E$4)),'Pay

This displays #NAME? in the cells. If I click on the ribbon, then click the menu name Formulas, and then the button named Insert Function, and click OK on the Function Arguments window, the cell now reads Week 1, Week 2, or Week 3 as it should. This will then allow the calculated data to appear on the "Pay Rates' tab and 'Hourly Summary' tab. I Googled the @ in an Excel formula and this @ in the formula was due to an Implicit Intersection. How can this formula be edited so column 'J' does not display #NAME? I have attached this workbook for review.

Thanks

LEGEND! You are the best! I have this worksheet set with your BIG help and my little bit.

Thanks so much, this ticket is resolved.

Gràcies!

I did get an error when I did this second message. I will ask for a bit more assistance on this.

Gràcies!

Oh yes, the original VLOOKUP issue has been solved. THANKS! Let's ask the question twice: Are you going to ask the question TWICE to give total freedom to the User ???

I know I have a lot of questions, and I am learning very much here. Can the command button on the tab 'Instructions' prompt a question before clearing the sheets? I would like the question to be "Would you like to clear the 'Instructor and Location Payrate data?' If yes, let the macro run as is, if no, can a new macro be added that will not clear the data on the tab 'Instructor and Location Payrate data'

Thanks

Does "Express Cycle" need to be there for the exception? Can it be any name as long as it's not MEGA All Levels, which is what is in J2?