Descending order of arrangement from one column Data

[pvsvprasad]

Dear Masters,

I need one help for Descending order concept.

I have data in one column and i want to extract to another column by Descending order.

Rule is: Read entire Column data up to end of column data and paste to another column

please find the sample attached file and make a possible code.

Thanking you all,
Best regards.

[oeldere]

with a helpcolumn and a pivot table.


File removed after PM of OP.

--------------------------------------------------------------------------------
Join Date:12-16-2013Location:IndiaMS-Off Ver:Excel 2007Posts:167


Unhappy Post#2 Delete Request_Reg


Dear sir,

Kindly remove or modify yours Post#2 attachment. because at Sheet no.1 some personal data is came with attachment which is attached at Post#1 by me.

so kindly remove that attachment from thread.


Thanking you sir,
Best regards.

[pvsvprasad]

with a helpcolumn and a pivot table.

Dear sir,

thank you for your kind reply and preparing by pivot version. kindly provide by Macro version. because i have no minimum idea about pivots using and editing. and some inconvenience by pivot data.because i need one more output column with respect to "D" Column to "F" Column.

please find final output type file.


Thanking you sir,
Best regards.

[oeldere]

because i have no minimum idea about pivots using and editing.

That is a very good reason start learning it, since it is a very powerfull tool, which is expanded in each new version of excel.
That the way Microsoft tells us (my opinion), that is the way to go (for the future).

[pvsvprasad]

That is a very good reason start learning it, since it is a very powerfull tool, which is expanded in each new version of excel.
That the way Microsoft tells us (my opinion), that is the way to go (for the future).

Thank you for valuable suggestion.

i need automation by macros for many rows. so kindly arrange the macro version.

thanking you,
Best regards.

[oeldere]

VBA is not my kind of expertice. I leave this to other forummembers.

[pvsvprasad]

Dear all Masters,

Please help me for required output.

Thanking you,
best regards

[Leith Ross]

Hello pvsvprasad,

This was an interesting challenge. The attached workbook contains the two macros shown below and a button on the worksheet to sort the data. The sorted data starting in cell "D3" is cleared each time the macro runs down to the last cell in column "D" with data.

The sort is done using a modified bubble sort which is fast on small lists of 1000 or less entries. If sorting speed becomes an issue then I have other algorithms that can used.

Bubble_Sort_Modified Module Code

Please Login or Register  to view this content.

Sort_Data_By_Occurrence Module Code
This is the macro called by the button on the worksheet.

Please Login or Register  to view this content.

[pvsvprasad]

Hello pvsvprasad,

This was an interesting challenge. The attached workbook contains the two macros shown below and a button on the worksheet to sort the data. The sorted data starting in cell "D3" is cleared each time the macro runs down to the last cell in column "D" with data.

Dear sir
Thank you taking challenge and making wonderful code. your code is working in which is provided by you in post.

i copied to another sheet and showing error while running. what is the problem? please observe screen shot of the error. i have small modifications are carried out, i am modified as "S4" instead of "B3", "S" instead of "B", "AE4" instead of "D3". "AE" instead of "D". but not successful.


my final request is, i need another column which is mentioned in post#3, so kindly found attachment with this post.

thanking you sir,
with best regards.

[pvsvprasad]

Dear sir,

Please find Error generated file with sample output.

Thanking you,
Best regards.

[Leith Ross]

Hello pvsvprasad,

You did not copy the macro SortList into your workbook. I have added it and added a button to call the main macro SortData.

[pvsvprasad]

Dear sir,

Thank you for correcting my mistakes,

please find at "AG" Column Sample output and add to your code.

thanking you,
Best regards.

[Leith Ross]

Hello pvsvprasad,

I have added the code to copy the codes into cell "AG".

[pvsvprasad]

Hello pvsvprasad,

I have added the code to copy the codes into cell "AG".

Dear sir,

Thank you very much For modification it is working well.

my final request is any possibility for Ascending order in AG Cell? like 1 2 3 4 5.

Thanking you sir,
With best regards.

[Leith Ross]

Hello pvsvprasad,

I am posting the full code because I made changes to both macros. The attached workbook has the changes installed. Cell "AG2" will display the prefix codes in ascending order separated by spaces.

Revised Code

Please Login or Register  to view this content.

[pvsvprasad]

Thank you very much sir,

well executing.

Best regards.

[Leith Ross]

Hello pvsvprasad,

You're welcome.

[pvsvprasad]

dear sir,

please have a look at my another thread and solve please http://www.excelforum.com/excel-prog...mall-bugs.html

thanking you,
Best regards.