validation and sorting
"Trevor Shuttleworth" wrote:
Add a "Helper Column" and put the following formula in row 2 and drag down
=IF(LEN(A2)6,--RIGHT(A2,6),A2)
which assumes your receipt number is in column A and starts in row 2
Now sort on the Helper Column
Regards
Trevor
Thank you!!! That was exactly what I was hoping for!!!
|