I've about 30,000 recordes in Column A of numbers between 1 and 100. In Column B I'm looking for a formula to return "Less than 10", "10-20" etc up to "90-100".
I think I need to use excel vba If...Then...Else, but I'm not sure how to get to the next step.
Any help would be much appreciated.
Thanks in advance.