Two Sets of Data Grouped

Closed
robrob - Feb 9, 2011 at 10:43 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 9, 2011 at 11:37 AM
Hello,

I ma trying to create a worksheet where columns of data is compared and grouped. What it is, I am drawing up a spreadsheet in order to determine which group a fighter is in based on age and weight. I have used vlookup formulas to determine a category for each.

I now want to extend that so a specific age group (juvenile, adult...) and specific class (white, blue...) will join a group. So if column A shows Juvenile, and column B shows White that competitor will be an A1. Juvenile blue A2 and so on so forth.

Anyone got any ideas?


Thanks in advance, rob

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 9, 2011 at 11:37 AM
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com, http://wikisend.com/ , http://www.editgrid.com etc
AND post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too.


Note:
your data need not be to be real data but a good representative of how data looks like
0