Sorted data hiding important columns, how can i solve this

[joseph92]

Hello,


The data is like this

1.PNG


I want it to be like this, sorting by number of replies


2.PNG

but when i sort by number of replies, I get this

4.PNG


How can i solve this please

Bellow is the attached excel document

[joseph92]

I googled a lot without success

[Croweater]

A simple way...

In E2;

=IF(C2="",E1-1,C2*100)

Drag down and sort on that column.

[joseph92]

A simple way...

In E2;

=IF(C2="",E1-1,C2*100)

Drag down and sort on that column.

Thank you so musch, the only problem i when there is a same number of replies, the formula will combine them like this

5.PNG

Attachment 737637

7.png

[Glenn Kennedy]

Maybe this, instead:

=IF(C2="",E1-1,(C2+ROW(C2))*100)

[joseph92]

This message has been deleted

[joseph92]

Maybe this, instead:

=IF(C2="",E1-1,(C2+ROW(C2))*100)

Let me try it

[joseph92]

Maybe this, instead:

=IF(C2="",E1-1,(C2+ROW(C2))*100)

Good formula but the sorting is dostorted

Attachment 737655

Attachment 737656

Attachment 737657

[Croweater]

Maybe?

=IF(C2="",E1-1,(C2*1000+ROW(C2)*10))

[joseph92]

Maybe?

=IF(C2="",E1-1,(C2*1000+ROW(C2)*10))

I tried but the same happens,

Take a look at the actual sheet, when i try it the sorting becomes mixed

[joseph92]

Maybe?

=IF(C2="",E1-1,(C2*1000+ROW(C2)*10))

Check out that file in comment number 10 (above comment) i try it but it becomes distorted

[Croweater]

The advantage of seeing the 'real' data.

Well it is just a matter of adjusting the numbers to suit your data as far as how many rows and how many need to be grouped together, but the 'idea' should still suit.

I tried this combination;

=IF(C2="",E1-1,(C2*100000+ROW(C2)*100))

and it seemed to work.

[joseph92]

SOLVED!!!

It works, Thank you so much

I was also given another formula which works =IF(C2="",E1-1,(D2*1000+ROW(D2)*D2))

I am really interested on what should i learn in order to get knowledge to develop similar formulas.

What shoul i learn?

Thank in advance

[Croweater]

I can't make up my mind whether "What should I learn?" is the most difficult or easiest question to answer, that I've ever been asked!

My answer? Keep reading here. Try to answer some questions. If you have trouble with answering the question, learn from the answer which will (almost) inevitably be posted.

In my experience, the answers aren't the hardest part, it's the questions/problem that's the hardest, and this forum is an endless supply!