| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO FIND A LAST NAME IN COLUMN OF LAST NAMES?
Hi,
Try this LOOKUP(REPT("z",255),B7:B15) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "DANIELABAIR" wrote in message ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Replacing A,B,C column names to other names | Excel Discussion (Misc queries) | |||
| How do I replace A, B, C, Column names, with my own names? | Excel Discussion (Misc queries) | |||
| how do I find names in a workbook full of names | Excel Discussion (Misc queries) | |||
| Find a time value in one column based on names in another | Excel Discussion (Misc queries) | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
![Ashish Mathur[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
