Forum Discussion
how to sort rows based on content within column A
Hi, If someone can provide an easy solution I'd really appreciate it. I'm new to Excel, is there a way to do this? Thanks! David This a screenshot of a file listing items (old vinyl records) sold...
The simplest way to do it would be to go back to the source and insist they deliver it with the type of record as a column of its own.
That said, you'll need to use the various text manipulation functions, and that will be imperfect, but should process the bulk of them. Is it possible for you to upload and post the actual spreadsheet (unless it's just huge; in which case maybe 100 rows of it).
Since you're a beginner with Excel, it would be a lot easier for somebody else to write the formula for you, and it would be easier for me (or somebody else here) to write and test the formula on the actual sheet rather than an image.
- thank you! I think i can actually do this by filtering
