| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding largest number from list
Hoping someone can help....as couldn't find anything relevant in the forum.
In sheet 1, I have coulmns of data that includes below. In sheet 2 i need to return the highest value that is in column B if column A is 'Kerry Beniston1'. In this instance it would be 22Kerry Beniston. If it could just return the value of 22, that would be even better, but if necessary, can live with the whole text. Please can anyone help. Many thanks Column A Column B KERRY BENISTON0 0KERRY BENISTON KERRY BENISTON0 0KERRY BENISTON KERRY BENISTON0 0KERRY BENISTON KERRY BENISTON1 16KERRY BENISTON KERRY BENISTON1 17KERRY BENISTON KERRY BENISTON1 22KERRY BENISTON KERRY BENISTONFALSE 1KERRY BENISTON |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How: List in col D whichever number greater; B4 or varying # in Co | Excel Discussion (Misc queries) | |||
| How do i number a list of data in excel 2003? | Excel Discussion (Misc queries) | |||
| find next number in list | Excel Discussion (Misc queries) | |||
| finding the largest number from the last row and look up its name. | Excel Worksheet Functions | |||
| Lookup closest number in list | Excel Discussion (Misc queries) | |||
Threaded Mode
