I have been using the following function (w/ CSE) to successfully pull unique instances from a long list:
{=INDEX($G$40:$G$4556, MATCH(0, COUNTIF($A$17:A17,$G$40:$G$4556),))}
Output of which:
Column A17 w Summary of Unique Entries in Column G
Account 1 (appears multiple times in Column G)
Account 2 "
Account 3 "
etc
I want to now pull a similar list of unique instances from another associated column (J) for cases where an entry in G matches my previously pulled list of unique instances from Column G.
What I need:
if Account 1 appears in Column G, return me list of unique associated instances in column J:
Sub-Category A that appears multiple times in column J, associated w Account 1 in column G
Sub-Category B of Account 1 " "
Sub-Category C of Account 1 " "
I am doing this to sum the money from each account and then do the same by sub-categories. The data just appears as a long list of entries that have been categorized by Account and then sub-category. Should be able to do this:
Account 1=120,400
Account 1 Sub Category A= 10,100
Account 1 Sub Category B= 18,000
Account 1 Sub Category C= 34,760
etc
etc
Using Excel for Mac 2011
{=INDEX($G$40:$G$4556, MATCH(0, COUNTIF($A$17:A17,$G$40:$G$4556),))}
Output of which:
Column A17 w Summary of Unique Entries in Column G
Account 1 (appears multiple times in Column G)
Account 2 "
Account 3 "
etc
I want to now pull a similar list of unique instances from another associated column (J) for cases where an entry in G matches my previously pulled list of unique instances from Column G.
What I need:
if Account 1 appears in Column G, return me list of unique associated instances in column J:
Sub-Category A that appears multiple times in column J, associated w Account 1 in column G
Sub-Category B of Account 1 " "
Sub-Category C of Account 1 " "
I am doing this to sum the money from each account and then do the same by sub-categories. The data just appears as a long list of entries that have been categorized by Account and then sub-category. Should be able to do this:
Account 1=120,400
Account 1 Sub Category A= 10,100
Account 1 Sub Category B= 18,000
Account 1 Sub Category C= 34,760
etc
etc
Using Excel for Mac 2011