Find highest value in column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I find the highest value in a spreadsheet column? I have a duty roster in which each person (row) is assigned a number . The highest number in each column has duty for that day. What I want to be able to do is have the spreadsheet identify the highest number in each column and replace it with a zero. The next cell for that person would start over again with a 1. If more than one cell has the same number, it should talk the first instance of that number in the column

Thanks.
 
Have a look in HELP index for MAX function

--
Don Guillett
SalesAid Software
(e-mail address removed)
David said:
How do I find the highest value in a spreadsheet column? I have a duty
Click to expand...
roster in which each person (row) is assigned a number . The highest number
in each column has duty for that day. What I want to be able to do is have
the spreadsheet identify the highest number in each column and replace it
with a zero. The next cell for that person would start over again with a 1.
If more than one cell has the same number, it should talk the first instance
of that number in the column.
 
How do I find the highest value in a spreadsheet column?
Click to expand...

Use the MAX function.
I have a duty roster in which each person (row) is assigned a number . The highest number in each column has duty for that day. What I want to be able to do is have the spreadsheet identify the highest number in each column and replace it with a zero. The next cell for that person would start over again with a 1. If more than one cell has the same number, it should talk the first instance of that number in the column.
Click to expand...

To change the contents of a cell, you will need a VBA routine.
--ron
 
Back
Top