| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Identify the cell with Max & Min values
I have a column of price data. I want to identify which cell has max value
and set a text "max" for indication. Col A Col B 10 3 6 2 12 max I only know the max(A$1:A$5), but not know how to set text with it. Please help. skysusan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
