crashing1912
New Member
- Joined
- Sep 8, 2011
- Messages
- 19
I have a set of data 12 columns wide and up to 2,000 rows.
I need to display the unique values of column 11, based on column 8.
I have already used in column 16
{=INDEX($H$233:$H$10055,MATCH(0,COUNTIF($P$233:P233,$H$233:$H$10055),0))}
to show me the unique values in column 8. Now, I need another formula to display the unique values of column 11, based on the results from the Index/Match formula I have in column 16.
I think it's a just a matter of modifying my current formula some, but I'm not sure what to do.
I know there are other ways to do this, but I need this formula driven if at all possible for this template to work, so it can be sent to my clients.
Thanks in advance for any assistance.
I need to display the unique values of column 11, based on column 8.
I have already used in column 16
{=INDEX($H$233:$H$10055,MATCH(0,COUNTIF($P$233:P233,$H$233:$H$10055),0))}
to show me the unique values in column 8. Now, I need another formula to display the unique values of column 11, based on the results from the Index/Match formula I have in column 16.
I think it's a just a matter of modifying my current formula some, but I'm not sure what to do.
I know there are other ways to do this, but I need this formula driven if at all possible for this template to work, so it can be sent to my clients.
Thanks in advance for any assistance.