| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
find lowest number and return it's adjacent cell
I need to find the lowest number in a column and return the value in the same
row but different column. Example. A B Data1 1 Column B numbers will change and I need a formula to find the Data2 2 minimum number in column 'B' then return the correct row in Data3 3 column 'A.' So for this problem I would want a formula to Data4 4 return text 'Data1' in a cell I specify since '1' is lowest #in 'B' Data5 5 formula then used a seperate 'IF' formula but ran into the no Data6 6 more than 7 nested functions issue. Can anyone help on this? Data7 7 Data8 8 Data9 9 Data10 10 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and return adjacent value (redux)! | Excel Discussion (Misc queries) | |||
| find and return adjacent value | Excel Discussion (Misc queries) | |||
| Find max number of character and return cell address | Excel Worksheet Functions | |||
| find the lowest value in a row and add a number to it | Excel Worksheet Functions | |||
| how do i find the lowest number in a column in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
