I have assumed your data starts in row 2 allowing for a header.
This is the formula for cell K2 ... and then copy down.
Regards
I have assumed your data starts in row 2 allowing for a header.
This is the formula for cell K2 ... and then copy down.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi TMShucks
It works!!
But then you knew that. Well done!
I'm still unclear what the formula is actually doing. Any enlightment would be very much educative and appreciated.
Many thanks
mgerada
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks