|Posted: August 26, 2011, 1:57 pm - IP Logged|
How can I create a formula that would give me the 2nd & 3rd non blank cell?
A1 - blank
A2 - 48
A3 - blank
A4 - 05
A5 - blank
A6 - 20
The formula above would give me the first number that is not blank - which is 48
I would like a formula that would give me the second number - which is 05
& the third number - which is 20
Is this possible?
"It's evolve or die, really, you have to evolve, you have to move on otherwise it just becomes stagnant."