how to figure

  • Thread starter Thread starter cjbarron5
  • Start date Start date
If they're *real* numbers:

=Max(A1:Z1)
=Min(A1:Z1)

If they're Text, you might try these*array* formulas:

=Max(--A1:Z1)
=Min(--A1:Z1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

smallest to largest 9
First Value in Sorted Column is Not Sorted Properly 3
Cannot sort data 1
Sorting numbers 4
random #'s for a population how do you sort w/o changing #'s 3
Random #'s for a population 1
Selecting last five numbers in a selection 10
Cannot sort data 6

Back
Top