View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Pinnell Terry Pinnell is offline
external usenet poster
 
Posts: 46
Default Random name from a list?

I have a list of 20 names in col A. In B1 I want to display a random
name from this list. What is the easiest way to do that please? An
(admittedly brief) study of VLOOKUP in Help for Excel 2000 left me a
bit confused.

--
Terry, East Grinstead, UK