Hi guys! Hope you have all been well.
I am getting stumped with a formula problem. I need to retrieve the second numeric value in a column.
At the moment the data looks like this (there are sometimes blank cells in between rows). I need the return to be "987"
I am going about this the very inefficient way by =ISNUMBER(A1) and then working out if it's the second "TRUE".
There has to be a smarter way to do this? Can someone help? Thanks
I am getting stumped with a formula problem. I need to retrieve the second numeric value in a column.
Apple | |
Banana | |
123 | |
Cupcake | |
987 |
At the moment the data looks like this (there are sometimes blank cells in between rows). I need the return to be "987"
I am going about this the very inefficient way by =ISNUMBER(A1) and then working out if it's the second "TRUE".
There has to be a smarter way to do this? Can someone help? Thanks