Gregory123987
New Member
- Joined
- Jun 23, 2020
- Messages
- 33
- Office Version
- 2016
- Platform
- Windows
I have been searching for an example that can help me with what I am trying to do here. I want to find the number of consecutive populated cells from the right. If the cell is blank, then count the rest of the cells. I found several examples on finding consecutive cells, but none quite fit what I am looking for. I am not an advanced enough user to fully appreciate what you help me with. I would prefer a non-VBA solution to keep the workbook macro-free. Thank you for looking at my little problem.
This is a mock up showing what the answers should be to help to explain it.
The formula would go in the Result column and should have the range 1 to 31.
In row Person 1, the result should be 0 since column 31 is blank.
In row Person 2, the result should be 6 because there are 6 consecutive cells that are not blank.
This is a mock up showing what the answers should be to help to explain it.
The formula would go in the Result column and should have the range 1 to 31.
In row Person 1, the result should be 0 since column 31 is blank.
In row Person 2, the result should be 6 because there are 6 consecutive cells that are not blank.
Day | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Result |
Person 1 | 5 | 6 | 4 | 1 | 3 | 0 | 4 | 4 | 1 | 0 | 5 | 6 | 1 | 3 | 0 | 4 | 4 | 1 | 4 | 0 | 5 | 6 | 1 | 0 | 5 | 1 | 0 | |||||
Person 2 | 4 | 3 | 4 | 1 | 4 | 0 | 5 | 1 | 5 | 0 | 4 | 3 | 1 | 4 | 0 | 5 | 1 | 5 | 0 | 4 | 3 | 1 | 0 | 4 | 4 | 1 | 2 | 2 | 6 | |||
Person 3 | 4 | 0 | 1 | 1 | 4 | 4 | 3 | |||||||||||||||||||||||||
Person 4 | 5 | 4 | 5 | 1 | 5 | 0 | 5 | 1 | 5 | 0 | 5 | 4 | 1 | 5 | 0 | 5 | 1 | 5 | 0 | 5 | 4 | 1 | 4 | 0 | 4 | 4 | 1 | 4 | 4 | 13 | ||
Person 5 | 6 | 5 | 1 | 4 | 0 | 5 | 4 | 1 | 5 | 0 | 6 | 5 | 1 | 4 | 0 | 5 | 4 | 1 | 5 | 0 | 6 | 5 | 1 | 4 | 0 | 4 | 5 | 1 | 6 | 6 | 28 | |
Person 6 | 4 | 4 | 5 | 1 | 0 | 4 | 1 | 4 | 0 | 4 | 4 | 1 | 0 | 4 | 1 | 4 | 0 | 4 | 4 | 4 | 0 | 3 | 0 | |||||||||
Person 7 | 1 | 0 | 4 | 1 | 1 | 0 | 4 | 1 | 0 | |||||||||||||||||||||||
Person 8 | 5 | 6 | 1 | 5 | 0 | 6 | 5 | 1 | 5 | 5 | 1 | 5 | 0 | 6 | 5 | 1 | 5 | 5 | 1 | 3 | 0 | 4 | 4 | 4 | 4 | 2 |