File sort help

[Lasantha]

Dear All,

Kindly review the attached file. Can you please help me to sort Visit # by total balance of each visit. (largest to smallest )

Please see the example.

thank you.

 

[vletm]

Lasantha
Should Your 'format what i need' show as 'Largest to Smallest'?
Which column would be 'total balance'?

 

[Lasantha]

Lasantha
Should Your 'format what i need' show as 'Largest to Smallest'?
Which column would be 'total balance'?

Sorry see the attached file.

//Which column would be 'total balance'? //have to calculate total balance of each unique visit by Balance column( column C).

 

[vletm]

Lasantha
Sorry, there were two questions ...
Did You sent same file again?
I did something that this won't be same file anymore.

my 1st question was:
Should Your 'format what i need' show as 'Largest to Smallest'?

 

[Lasantha]

Lasantha
Sorry, there were two questions ...
Did You sent same file again?
I did something that this won't be same file anymore.

my 1st question was:
Should Your 'format what i need' show as 'Largest to Smallest'?

Should Your 'format what i need' show as 'Largest to Smallest'? Yes

There are more than 50 column in original file, so we can't use Pivot table option.

 

[vletm]

Should Your 'format what i need' show as 'Largest to Smallest'? Yes
Okay ... for my eyes that won't look as 'Largest to Smallest'!
.. and if Your original file is '... different' than the example then
how to help to sort something?

 

[bosco_yip]

Try..........

Formula solution with helper.

1] In "helper" D3, copied down :

=IF(COUNTIFS(A$2:A3,A3,B$2:B3,B3)=1,SUMIFS(C:C,A:A,A3,B:B,B3),"")

2] In "Total" H3, copied down until blank :

=IFERROR(LARGE(D$3:D$28,ROWS($1:1)),"")

3] In "visit#" F3, copied across and down :

=IF($H3="","",INDEX(A$3:A$28,AGGREGATE(15,6,ROW($A$3:A28)-ROW($A$2)/($D$3:$D$28=$H3),COUNTIF($H$3:$H3,$H3))))

Regards
Bosco