Please help. How do I go about sorting 4 columns (by one of the columns) where the 4th column has 2 rows in it?
Please help. How do I go about sorting 4 columns (by one of the columns) where the 4th column has 2 rows in it?
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
without seeing your excel file, without confidential information, (so we can test it), it's difficult to explain.
The only criteria is the 4th column has 2 rows.
Then they have to sorted from low to high or from high to low?
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
They need to be sorted alphabetically.
1 しゅうりされて repaired 私の くるま は じどうしゃこう に よって しゅうりされています。
My car is being repaired by the mechanic.
2 ほされて arrested どろぼう は たいほされていません。
The thief isn't being arrested.
3 はなされます spoken ドイツご は オーストリア で はなされます か。
Is German spoken in Austria?
4 みられて watched テレビ は みられています か。
Is the TV being watched?
5 かれません not written たくさん の てがみ は クリスマス に かかれません。
Lots of letters aren't written at Christmas.
1 しゅうりされて repaired 私の くるま は じどうしゃこう に よって しゅうりされています。
My car is being repaired by the mechanic.
They need to be sorted by the 3rd column. Thanks.
Corrected sort should be: (only 3 lines shown)
2 ほされて arrested どろぼう は たいほされていません。
The thief isn't being arrested.
1 しゅうりされて repaired 私の くるま は じどうしゃこう に よって しゅうりされています。
My car is being repaired by the mechanic.
3 はなされます spoken ドイツご は オーストリア で はなされます か。
Is German spoken in Austria?
Without seeing your spreadsheet in its native form (no pictures), we can not tell where a column begins and where one ends. Please attach a spreadsheet for analysis. Also, what non-printing characters may have an effect on the answer.
Copy of original file and file as sorted:
this code should work for you
Please Login or Register to view this content.
Thank you very much alansidman. You have saved me considerable time and also motivated me to update to Excel 2010 and learn programming.
You are welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks