Sorting Huge Table with numbers and 2 text values

[DCoulthard]

Hi all,

Trying to get huge data table to sort by column smallest to largest for all columns at once. Most cells are numbers but two other cell values are NS or ---

Would like smallest number to show at top of each column followed by next smallest number below that etc etc.

If this can't be done just a quick way to find smallest number in table would be good.

I have tried sort function but this does not seem to sort entire table at once and cell values NS or --- seem to be randomly placed.

Thanks for the help.

Using windows 10

Office 365

[#2]

@DCoulthard 

Why not simply place the formula =MIN(B3:B552) in B1 and then copy it across, it will give you the minimum value for each column.

[#3]

@DCoulthard 

How about this for overall MIN?

Or as @Subodh_Tiwari_sktneer suggests you can copy a formula across the top to get the MIN for each column