formula help needed

I feel like this is relatively easy to solve, but I’m probably overthinking the solution. What would the formula need to be to get the information for H5 & I5?

Hi there, I was given the task to force balance the data in 'Q1_2024_Raw' to sum to the final total by GEO (i.e. all LATAM customers need to sum to 10, so in this case I need to force balance their data down from 20 to 10 and all NAAM customers need to sum to 100 so I need to force balance up...

Hi, I am a teacher and I have been given a list of students who's grades I need to have a closer look at in excel. I have a curated list of students in one column and the raw listing of the students in the next column with the associated grades after that. I want to remove all the students from...

Hi Excel Gurus, I have posted question here before, regarding this project, I did receive a lot of help. I'm about to wrap it up but just can't figure how to do this part. I needed to tweak these Spillable nested Filter Function (In Yellow) to include another criterion, which I can explain by...

I have a travelling allowance bill of my office (file attached). In the column of (No of Days0, Column F, row 6 and 7 if a cell value is changed to 2, I want the value of total of in column I, row 6 and 7 to change to 936. I want to do this because 2 days work changes the value of an employee's...

Hello, I want to create an automated overtime list that will rotate the persons name to the bottom of the list based on the new date added to the sheet, while being able to maintain the last previous dates of overtime. I have tried to follow a roster rotation video with no luck. The reason...

Hi All, I am working on file which has benefits start date for example 01/01/17 and finish date of 30/04/7 with a benefit value $10,000 and in other cases start date 01/10/17 an end date 30/10/18 Benefit value $12,000. I am trying to capture cost by year and month on pro rata basis. So I can...

Hi Folks, I have this formula that finds one column of matches but I need a second column to also be returned. I need help in fixing this formula to allow the second column of matched info to be listed in column D if possible. Thanks Formula: =IF(ISERROR(INDEX('Analysis...

I have a spreadsheet set up as: date utility units used cost 7/2/2016 gas 122 $94.86 7/12/2016 electric 98 $100.00 2/15/2017 water 99 $56.87 2/20/2017 gas 120 $122.25 4/28/2017 electric 147...