Search results

Wow I didn't know we could do this. Your formula is so simplified.

Attached is a spreadsheet I have made up. I feel like I have over complicated my formulas. Basically it must follow the rules below: If someone works between 7am to 4pm they get $140 per hour less breaks If someone works before 7am or after 4pm they get $185 per hour less breaks I don't know...

Thank you everyone it works on my raw data. I will take everyone advice in for self learning :)

That would be correct, I had been using COUNTIF up to this point. It was working in the past until we decided to separate the bookings by topic. It should treat multiple bookings on the same day as 1 booking. My issue is the COUNTIF formula was treating each line as a booking, so I am double...

Wow it works. Thank you p45cal. I'll see if the logic works on a bigger set of data. I have been heavily reliant on the COUNTIF formula so I was trying different combinations with AND and > but failed. Who knew it was so simple on your one.

Thank you for the COUNTIFS.

Slightly off. I give it another shot.

Hi Ali, I believe if I insert another criteria in a COUNTIFS formula it will reset my counter. Do you have a specific criteria for this or example of this on the sample worksheet?

Hi, I have a issue that is very similar to the spreadsheet attached. Each day I get dumped raw data. I arrange it by name and date from earliest date to the latest date. I have been using countif up to this stage and it works. But now my issue is someone has suggested to split the bookings by...

Finished product! :) If anyone comes across this on the internet.

Wow I used this one it works with new items being listed on the pivot table! =SUMPRODUCT(($B$10:$E$13)*($A$10:$A$13=$L24)*($B$9:$E$9>=$M$20)*($B$9:$E$9<=$M$21)) I will study this formula. I really appreciate this.

Hi Hui, I really sorry I should of worded it more accurately. 1) Raw data is pasted into "raw data" tab 2) pivot table will than refresh in the "pivot table" tab 3) staff will inquire on the front end via the "staff inquiry" tab Note: staff inquiry tab will have fix names If I introduce...

Mail Merge.

1. find suitable cell to insert formula. 2. Insert this below =SUBSTITUTE(TRIM(TEXTJOIN("",TRUE,IFERROR(MID(reference cell,ROW(INDIRECT("1:100")),1)+0," ")))," ","-") 3. Hit Ctrl+Shift+Enter 4. Donate to your nearest charity.

Hi Everyone, I am stumped on this I have the logic but can't find a way to do it. Attached is an spreadsheet with pivot table that will feed a sumifs formula. The issue is when a new "name" is introduced the sumifs reference will shift. I am trying to match my sumifs criteria than recalculate...

Ah Thank you. I was using the 64 version and didn't see anything. I got it now :)

Hi, how do I use this? Does it come with instructions? I attempted to run the modules in Alt+F11. I got the notification it says that it "VBA Project is unprotected!" but failed to unlock the password :(

How are you setting up your level table so quickly?! I spend 3 hours on it and I got this far lol .... Man you a god at this

Thank you for the help! I did some reading... is there any way to build a bigger table and have it automatically fill based on the raw data? I have a longer extract, is there a quicker way to apply this logic and build that table faster

Hello, I have come across a hurdle in trying to map this out. I have an accounting system that can extract reports like this in text format. The file follows a hierarchy format where Level 1 is 61, Level 2 is 1141, Level 3 is 171 or 172 than Level 4 is 17111 only for 171 or 17112 is only for...

Please find attached. Could merge them into 1 formula like the guys above.

Jesus that formula is soo good! I will study this. Thank you :)

Nice way of doing it on the raw data but the second condition would make them all HIGH. "Of course in an event where multiple conditions are met for column C than HIGH get's first priority than MED then LOW. E.g. customer has 7, 15 and 32 in column C than HIGH is given." If OCEANA APARTMENTS...

Hello, Need some help with figuring out this task given to me. So the description is, if a customer under column A has any value below than the following answer is given: - Column C contain any number equal to or below 7 than "LOW" is given - Column C contain any number equal to and between 8...

I would use the =max date for the payment batch to be the payment date. Once again it would be a estimate sadly