Posts by fi1808

Hi there, it works great!

Thanks Carim

Hello, I have a set of column with family name, first name, etc

What i wanted to do was sorting family name a-z and the first name would follow a-z if it is the same family

Problem is, some of the first name sorts a-z, some does not.

Can anybody help, attached together is my work. (The names are just examples cause I like MCU movies )

That is exactly what I wanted, and you modified it beautifully.

Thank you so much.

Hello, I needed help with something im working on.

I have a set data of data that counted average data of several years.

There is a column of average that i hid to help with the calculation.

Below my data which is a bar chart is a total for annual average

What I wanted was when i entered data in year 2015, the average for that year will turns out in that box.

And when I entered data for for 2016 it will updated to the new average in that box

Attached together is my work.

Any help is very much appreciated.

yes

Is what it?

One more thing, my original file has merged cells and the codes wont run. Can I trouble you again to make adjustment for the merged cells.

Attached below is the file, thank you.

Hi again, sorry for not getting back at you earlier. I haven't got the time, and was really busy. I've tried your codes, loved the message by the way. Can I change the content of the message?

But I noticed that it sorted the alphabet well, but then it sorted some of the number descending and some not even ascending or descending.

Attached below is a pdf file of before and after sorting.

As per the title, I need the help of moderator to change it. You're a moderator right? Or do I need to find another moderator?

Hi Carim, the latest request is to make it sort descending, that's what I meant. So the result would be first click sorting ascending and second click sorting descending.

And what do you mean by dealing with each column independently? Does your codes deal with one column only?

My usual work was one sorting button for one column

Sorry for this, I'm not and Excel wiz

Hi Carim, your codes works perfect and I assigned it to a sorting button. As per your question, there are indeed more columns. I thought I could use the same codes for different column. But it doesn't work, there are actually 4 more column that needs the same sorting works. I'm sorry for not being frank with my request. Can I also ask you to add the sorting to go the other way, Z-A

I would like a sort button with macros and 1k rows down

I'm using an old file with new sets of data, but basically yeah

Sorry, forgot about that.

Hi alansidman and Carim, thank you for your replies. My earlier data is kind of incomplete, its more complicated than that. Let me give you the complete data, I wanted to sort based on alphabet first and then based on the number on the front.

Alansidman, thank you for codes but I don't know how to implement your codes.

Carim, your formula works but I need the second sorting based on the numbers in the front.

Thanks for your help.

Hello, I have several columns with alphanumerical data like below

HEADER

1B

2A

3F

4C

5D

6E

I wanted to add a sort button that generates the data like below

HEADER

2A

1B

4C

5D

6E

Any help is very much appreciated. Thanks.