Chestnuttgirl98
New Member
- Joined
- Apr 18, 2020
- Messages
- 12
- Office Version
- 365
- Platform
- Windows
I need to find the last occurrence of a number in a column that will also have text in some of the cells. For example, the column is tracking monthly variance. In future months, there is no variance so the cell returns NA(). I need to find the last number above the first occurrence of NA(), because i need to use that value in a different calculation.