Forum Discussion
A columns' data under custom sort but still report to subsequent sheets
=IF(July!B5="","",July!B5)
=IF(July!B5="","",July!B5) should be entered in August in B5 to get the value of the last month (in this case July). Pay attention to the name in column A.
If July!B5 is empty:
The formula evaluates as TRUE and returns "" (empty).
If July!B5 contains a value (e.g., 100):
The formula evaluates as FALSE and returns 100.
But I see an error in your pictures. August starts with the name "Adrian" and all other months with "Gsaba". In general, the names are not in the same order as the other months, which may be why there is an error in the formula.
With your permission, I recommend to provide more information.
You'll get a quicker and more accurate answer, and those who want to help don't have to invest time guessing the problem.
I recommend: Always inform about your Excel version, formulas you using, operating system, storage medium/hard drive, OneDrive, Sharepoint, etc.).
If possible, add a file (without sensitive data) and use this file to describe your project step by step, or add photos with the appropriate description (step by step – Cell by Cell).
Don't forget that not every Excel user has a clue about every job.
Thank you for your understanding and patience
Hope I was able to help you with this information.