LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
RonG
 
Posts: n/a
Default calculate permutations of nonnumeric data

I am trying to chart the combinations of applications that run with other
applications and versions of those applications and wanted to use Excel to do
it. Question... How can I calculate numerous permutations of nonnumeric data.
e.g.

MS Op sys Variable 1 Variable 2
WinXP A A
Win2000 B B
WinServer2003 C C

Output would equal - WinXP w/A & A; WinXP w/A & B; WinXP w/A & C; WinXP w/B
& A, WinXP w/B & B, WinXP w/B & C; WinXP w/C & A, WinXP w/C & B, WinXP w/C &
C.
 
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
Calculate data on 2 different worksheets jc Excel Discussion (Misc queries) 0 January 17th 05 05:43 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM
Will not calculate average/median formulas;acts like no data in c. Frustrated User of Excel today Excel Worksheet Functions 3 December 9th 04 05:31 PM
How to calculate the data in excel 2002 including only the last 9. TylerMaricich Excel Worksheet Functions 6 November 8th 04 07:27 AM
What function or formula do I use to calculate ROI with this data? Dave Excel Worksheet Functions 9 November 5th 04 02:42 PM


All times are GMT +1. The time now is 07:23 AM.

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"