ststern45
Well-known Member
- Joined
- Sep 17, 2005
- Messages
- 958
- Office Version
- 365
- 2010
- Platform
- Windows
Good day everyone,
I'm looking for a formula that will display the last value (bottom of the cell range) that appears in a range that is the column value.
The values are 0,1,2,3,4,5,6,7,8,9
Values will contain duplicates from 0 through 9 in cell range A1 through last cell containing a value (0 through 9)
For example:
A1 = 9
A2 = 3
A3 = 0
A4 = 2
A5 = 6
A6 = 1
A7 = 4
A8 = 5
A9 = 7
A10 = 8
A11 = 3
A12 = 3
A13 = 5
So in the example above:
B1 = 0
B2 = 1
B3 = 2
B4 = 3
B5 = 4
B6 = 5
B7 = 6
B8 = 7
B9 = 8
B10 = 9
C1 (0) formula = A3 or 3
C2 (1) formula = A6 or 6
C3 (2) formula = A4 or 4
Etc., Etc.
Thank you in advance
I'm looking for a formula that will display the last value (bottom of the cell range) that appears in a range that is the column value.
The values are 0,1,2,3,4,5,6,7,8,9
Values will contain duplicates from 0 through 9 in cell range A1 through last cell containing a value (0 through 9)
For example:
A1 = 9
A2 = 3
A3 = 0
A4 = 2
A5 = 6
A6 = 1
A7 = 4
A8 = 5
A9 = 7
A10 = 8
A11 = 3
A12 = 3
A13 = 5
So in the example above:
B1 = 0
B2 = 1
B3 = 2
B4 = 3
B5 = 4
B6 = 5
B7 = 6
B8 = 7
B9 = 8
B10 = 9
C1 (0) formula = A3 or 3
C2 (1) formula = A6 or 6
C3 (2) formula = A4 or 4
Etc., Etc.
Thank you in advance