| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Display maximum value of matching values in a different column
Hi
I want to highlight the maximum value if values in a correponding column match. e.g below is an example of a spreadsheet A B 1 a 1 2 f 3 3 f 4 4 d 2 5 e 2 6 e 5 7 e 1 In this example cell reference B3 will be highlighted because A2 and A3 are the same cell reference B6 will be highlighted because A5, A6 and A7 are the same Thankyou |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select 50 greatest values with column matching | Excel Discussion (Misc queries) | |||
| returning all matching values in column A that have the same value for columnB | Excel Worksheet Functions | |||
| find a cell matching separate column and row values | Excel Worksheet Functions | |||
| Matching Data in a Row and Display in Column | Excel Discussion (Misc queries) | |||
| Matching values from two columns and making a third column with the results - possible? | Excel Discussion (Misc queries) | |||
Threaded Mode
