Sorting multiple columns issue

[keith740]

Hello forum,

I have ran into an issue that seems very simple but...

Trying to record a macro to Sort multiple columns (A-N) based on column D ($PH)

Im doing everything correctly, highlight entire range and sort column D values A-Z... But the results are giving me the smallest $PH first, i need the largest to smallest.

Anyone know what im doing wrong?

I ran into this problem on a previous workbook and a great forum member helped write VBA, but i have no idea how to apply to new workbook as columns are different and a cpl different actions are taken. i Remember what we had to do tho was have VBA sort by hours, then sort $PH down to first empty cell.... im thinking their has to ne an easier way tho

Any help/advice is greatly appreciated!

[protonLeah]

I don't know where your data is coming from but column D data has leading and trailing spaces. Even the "empty" cells have two space characters.

[keith740]

column D is from formula =(IFERROR(Data!CL2/'Daily Report'!BB18,""))

I tried adding =TRIM ti formula =TRIM(IFERROR(Data!CL2/'Daily Report'!BB18,""))

But is still giving my lowest $PH first

[FDibbins]

Try this...
=IFERROR(LARGE($C$3:$C$24,ROW(A1)),"")
You can then use INDEX/MATCH to pull in the rest of the data

[protonLeah]

Please Login or Register  to view this content.

[keith740]

Got it!!! TY so much guys!

[FDibbins]

happy to help, thanks for the feedback

[keith740]

=IFERROR(LARGE($C$3:$C$24,ROW(A1)),"")

thought for sure this would work, but if agent has 0 $PH, Index/Match is pulling lots of duplicate rows