A7 31 . 13
A8 30 . 32
A5 * 30 . 41
A9 30 . 66
A8 * 30 . 06
A6 30 . 51
I have data which is formatted in a strange way.
There are spaces where you would not need or expect them to be.
Also there are some with * which is annoying because they are not
standardized to make it easy to extract the...
I have dates in Col L in format dd/mm/yyy
I am trying to extraxt the highest month in Col L, by using the formula below buy get #value !
It would be appreciated if someone could kindly assist my amending my formula