Hi all,
Hope all of you are having a great day/night.
Trying to rank a listing from highest to lowest.
I am having issues with the items with zero values as there are more than one zeroes.
I need the final list to go from highest to lowest and list the items with zeroes last.
Must go from.......
Item A 8
Item B 1
Item C 5
Item D 4
Item E 0
Item F 0
....... to become like this
Item A 8
Item C 5
Item D 4
Item B 1
Item E 0
Item F 0
I still want to see Item E and Item F
I use Large function but it cannot handle the last two items with zeroes...
Has anyone worked out a solution for this?
Thanks
Hope all of you are having a great day/night.
Trying to rank a listing from highest to lowest.
I am having issues with the items with zero values as there are more than one zeroes.
I need the final list to go from highest to lowest and list the items with zeroes last.
Must go from.......
Item A 8
Item B 1
Item C 5
Item D 4
Item E 0
Item F 0
....... to become like this
Item A 8
Item C 5
Item D 4
Item B 1
Item E 0
Item F 0
I still want to see Item E and Item F
I use Large function but it cannot handle the last two items with zeroes...
Has anyone worked out a solution for this?
Thanks