Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default hi,how to make the best present interchange formula for xmas

A friend is organizing a secret present interchange and I need a formula
that would tell me who gives who but duplicates not allowed. I tried using
randombetween but I get dups. How can YOu do it ? Also CAn I have
exceptions like guy A never gives to guy C ?

This is the list of guys :
ame
leo
cely
tere
richard
tamez
vero
tono
lore
viole




  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,572
Default hi,how to make the best present interchange formula for xmas

See answer to your post in the excel group.

Please don't multi-post.


--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Enrique Arredondo" wrote in message
et...
A friend is organizing a secret present interchange and I need a formula
that would tell me who gives who but duplicates not allowed. I tried using
randombetween but I get dups. How can YOu do it ? Also CAn I have
exceptions like guy A never gives to guy C ?

This is the list of guys :
ame
leo
cely
tere
richard
tamez
vero
tono
lore
viole






Reply
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
for xmas, i wish this is possible dribler2 Excel Discussion (Misc queries) 7 December 24th 06 01:26 AM
How do I make sure all empty columns are present in a .csv file? Decision Assist Excel Worksheet Functions 1 September 6th 06 04:40 PM
Bachelor cooking Xmas dinner ! Graham B. New Users to Excel 4 December 31st 05 02:18 PM
Xmas Week Dates rac Excel Discussion (Misc queries) 4 July 23rd 05 05:41 PM
Xmas Michael Excel Worksheet Functions 1 December 23rd 04 10:27 PM


All times are GMT +1. The time now is 08:14 AM.

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

About Us

"It's about Microsoft Excel"