Forum Discussion

Kymberly2222's avatar
Kymberly2222
Copper Contributor
Jul 06, 2024

A columns' data under custom sort but still report to subsequent sheets

Hi Everyone,  This is the leaderboard in our sales office at work. In every Sheet (Month), column BP shows each salesman's total sales for the month in green. It is custom filtered to order the sale...
excel
Formulas and Functions
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Jul 07, 2024

Kymberly2222 

=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.

Resources