Hi
Sorry about being so vague about what I require.
The data in columns F-I comes in muddled from a customer and we go through a daily process of manually sorting it into the correct columns.
I have attached another copy of the sheet. The data in green has been sorted and is displaying how it should but the yellow data is muddled as we receive it.
What I am hoping to do is have something that will sort the data into the correct column... even the ability to look at the data and return if it's equal to a 6 digit number or return if it is formatted as currency would be a huge help
Thanks againBook2.xlsx