• 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.


  • 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).


Participate now!

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