Hello. I am currently trying to figure out how to do this :
Sort.PNG
Here is the example .xls : http://www.excelforum.com/attachment...1&d=1462254570
There are a lot to put for the description, so I can't just simply type it in a single cell. I want to sort the data by the "Name" column, but it will only take the a single cell from the "Description". I've tried grouping but it won't work either.
Please help me, I don't really know much about Excel.
Thank you in advance.
use a helper column
put this formula in F4
Formula:
Please Login or Register to view this content.
fill down and copy and paste values
then sort by column F
delete column F if no longer required
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi,
See the file attached.
On the table with Orange Headers, click in the Name column and sort A to Z.
Let me know if this is what you want then I'll tell you what I have done.
Cheers!
Deep Dave
Thank you very much for the help! I really appreciate it!
Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks