Thread: HOW TO FIND A LAST NAME IN COLUMN OF LAST NAMES?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
  
Posts: 1,766
Default 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 With QuoteReply With Quote