Sort Formula

  • Thread starter Thread starter Van W. Padgett
  • Start date Start date
V

Van W. Padgett

Is there a formula to sort either alpha or numeric data in cells? I am
aware of the Data/Sort function within Excel, however it does not seem to
work with protected worksheets.

For example

A B
23 =formula to return "0" from column A
0 =formula to return "2" from column A
2 and so on...
34

Anybody know?

Van
 
Hi Van,

If the sheet is protected you won't be able to enter any
thing in colum B unless those cells have been unlocked.
Why not just unprotect the sheet and do a sort on column A?

Biff
 
Hi Van,

If your numbers are in column A, enter this formula in
column B and copy down:

=SMALL(A$2:A$10,COUNT(A$2:A2))

Adjust ranges to suit.

Biff
 
Thanks Biff,

It works like a charm!

Van
Biff said:
Hi Van,

If your numbers are in column A, enter this formula in
column B and copy down:

=SMALL(A$2:A$10,COUNT(A$2:A2))

Adjust ranges to suit.

Biff
Click to expand...
 
Back
Top