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.