Quote:
Originally Posted by oscarlimerick
Thanks thatprobably works but it looks a little involved for me, However I t hink I found a way to do this using the text to columns feature so I will close this thread. Thanks again
|
And when you add data, will you do it all over again? Using XOR's formula in an Excel table will adapt automatically and provide immediate answers