Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find the highest value for multiple cells
if i have the first column with multiple repeating numbers and i need to get
the highest number from each of the set of numbers how does the formula read or get typed? ie.. column A2 has the number 272, a3 has the number 272, A3 has the number 272,, then in column B each entry is different,, can i grab the entry with the highest number rather than the entry that is in the first of the series? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
find the highest value for multiple cells
hi
if i understand correctly, look into the max function. =max(A2:B50) this will give the max value of the range. Regards FSt1 "jbrow" wrote: if i have the first column with multiple repeating numbers and i need to get the highest number from each of the set of numbers how does the formula read or get typed? ie.. column A2 has the number 272, a3 has the number 272, A3 has the number 272,, then in column B each entry is different,, can i grab the entry with the highest number rather than the entry that is in the first of the series? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
find the highest value for multiple cells
Hello,
Array-enter =MAX(IF(A1:A999=272,B1:B999)) [Enter with CTRL + SHIFT + ENTER, not only with ENTER] Regards, Bernd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find the highest value on the column | Excel Discussion (Misc queries) | |||
How to find multiple cells/replace whole cells w/data | Excel Discussion (Misc queries) | |||
Find lowest and highest value from a set of rows | Excel Discussion (Misc queries) | |||
INTRICATE PROBLEM- How to find multiple text,excluding "H", in a multiple range of cells, then replacing 0 with another number in another cell | Excel Worksheet Functions | |||
How to find highest, lowest and last cell in a row? | Excel Worksheet Functions |