Posts by GuyS

    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.