Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Search row of numbers, find highest value.
I have a spreadsheet like this:
1 2 3 4 Total A 5 6 7 8 26 B 1 2 3 4 10 I am trying to find a function that will search the row (let's say Row 'A') and return the highest value (8)...and then the 2nd highest value (7). Row B's results are '4', and '3', of course. Can someone please help me find the function I should use for this? Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel cannot find numbers using control/F search | Excel Discussion (Misc queries) | |||
How do I find the 12 highest numbers in a row of 52 numbers | Excel Worksheet Functions | |||
how do search a list of numbers to find what adds up to a large # | Excel Discussion (Misc queries) | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions |