p3gladiator
New Member
- Joined
- Oct 11, 2021
- Messages
- 8
- Office Version
- 2010
- Platform
- Windows
Hello all,
I need some help, please.
I have a spreadsheet that has a list of several hundred employees in one column and columns for each payroll week with an "A", for active "T" for Termed and "NOR" for Not on report.
I need an excel formula that will return the last data entered that is not equal to "NOR".
Example:
Thanks for your assistance
I need some help, please.
I have a spreadsheet that has a list of several hundred employees in one column and columns for each payroll week with an "A", for active "T" for Termed and "NOR" for Not on report.
I need an excel formula that will return the last data entered that is not equal to "NOR".
Example:
Name | 08/05/2021 | 08/12/2021 | 08/19/2021 | 08/26/2021 | 09/02/2021 | 09/02/2021 | 09/09/2021 | 09/16/2021 | 09/23/2021 | 09/30/2021 | Need formula that will return last A or T |
Mickey mouse | A | A | A | A | T | NOR | NOR | NOR | NOR | NOR | T |
Donald Duck | A | A | A | A | A | A | A | A | A | NOR | A |
Thanks for your assistance