• I have a spreadsheet with several thousand lines. The data has been extracted from a database and the column that I need to work with has descriptions that are inconsistently set up. The information is recorded but not in a format that makes standard sorting easy.


    I want to identify items using a simple code in another column which I could then sort by.


    I thought I could use a series of IF commands however, I am not having much success getting Excel to find a text string and return a numerical value.


    Can someone provide a suggestion.


    Thanks

  • Re: Sorting


    Hi Zabanero,


    It would be difficult offer any suggestions withput actually understanding the requirement. Please post back with example/Sample data.


    Have you tried AutoFilter option(Data - Filter - AutoFilter).


    HTH.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!