Distinct Counts of two sources (ABC & DEF)which has some dimensions There is no Association b/w them along with count of number of rows of each table. And Count number of times that distinct value or code is repeated from each dimension, display them separately.
Can you add an example of what you would want the output to be? I am not sure what you are intending to count.
your expected output is not clear from your description. can you update your spreadsheet to include expected result?
I Need to display the ABC & DEF tables with 8 columns in Excel .say in DEF table curr column has 001 & 064 i need to display as 2 in output same for all other columns
Lets say there are two currency code,005 & 006,so how many times these two are repeated?How many distinct values in Amount ,so how many times the values repeated?
Sample data as
Expected o/p:Currency 005- 4 times
006- 3 times
2000- 2 time
Distinct Counts of Amount and Currency dimensions along with count of number of rows of each Column. And Count number of times that distinct value or code is repeated from each dimension