# Posts by PETRODATAjames

• ## Pivot Table with a filter that displays a SUM of Total with a specific number or numbers

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

• ## Pivot Table with a filter that displays a SUM of Total with a specific number or numbers

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

• ## Pivot Table with a filter that displays a SUM of Total with a specific number or numbers

PERFECT!

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

I see this.

Thanks again!

• ## Pivot Table with a filter that displays a SUM of Total with a specific number or numbers

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

• ## Pivot Table with a filter that displays a SUM of Total with a specific number or numbers

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.

• ## Pivot Table questions and a new field to add

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

• ## Pivot Table questions and a new field to add

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

• ## Calculate the date between to cells

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

• ## Payroll worksheet needs a new filter

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

• ## Payroll worksheet needs a new filter

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

• ## Hourly Payroll Template

PERFECT again, thanks!

This has been resolved.

• ## Hourly Payroll Template

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

 Olivia Goughan \$36.00 Olivia Goughan \$36.00 Olivia Goughan \$36.00 Olivia Goughan\$36.00 Taylor Wood \$37.00 Taylor Wood \$37.00 Zoe Schreiber \$38.00 Elizabeth Crosley \$30.00 Elizabeth Crosley \$30.00

• ## Hourly Payroll Template

PERFECT again, Thanks!

• ## Hourly Payroll Template

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

• ## Hourly Payroll Template

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

• ## Payroll worksheet with VLOOKUP issues

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!

• ## Payroll worksheet with VLOOKUP issues

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

Gràcies!

• ## Payroll worksheet with VLOOKUP issues

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 ???

• ## Payroll worksheet with VLOOKUP issues

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

• ## Payroll worksheet with VLOOKUP issues

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?