LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Random names from short list

Ive seen some posts here about what Im trying to achieve and still Im not
able do it. I have a list of only 7 workers. I need to reorder them randomly
in another column. Ive tryied to use a formula Ive seen here
=INDEX($A$1:$A$65,RANK(B1,$B$1:$B$65))

But Im still getting duplicate names and #N/D errors. Ive tryied to
analyse the cause with no success. Can it be because Im using all the seven
names list?

By the way... my language is Portuguese and I think the function RANK
relates to the CORRESP formula right? (by the way, how can I convert formulas
from english to other languages?)

Thx in advance
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create a random list of names from a list of names in EXCEL Givvie Excel Worksheet Functions 2 October 23rd 06 05:10 AM
random pick names from the list jinvictor Excel Discussion (Misc queries) 1 June 26th 06 03:00 PM
list names in random order in Excel 2002 John Murf Excel Discussion (Misc queries) 2 February 25th 06 01:58 AM
I can't save long file names, only short one, how can I do this? short file names Excel Discussion (Misc queries) 0 January 3rd 06 05:13 PM
Setting up a random list from long list of names ? yorkshire exile Excel Discussion (Misc queries) 4 January 6th 05 01:44 PM


All times are GMT +1. The time now is 06:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"