Kennethy86
New Member
- Joined
- Jul 27, 2018
- Messages
- 3
I have 10 tables with 3 columns, and several rows of data. I need to create a formula in my summary table (table 11) that will show me only the unique rows that exist in all 10 tables.
Several of the tables have the same row values for column 1, 2, and 3.
In this case the summary table will contain one row with the data
Some of the rows may have a different name in Column A, but Column B and Column C contain identical values
In this case the summary table will contain 2 rows with the different names in Column A
Some of the rows may have a different name in Column A, different account type in Column B, and same number in Column C
In this case the summary table will contain 4 rows, 2 with the different names in Column A, 2 with the different account type in column B, and all 4 with the same number in Column C
I appreciate any help on this.
Several of the tables have the same row values for column 1, 2, and 3.
In this case the summary table will contain one row with the data
Some of the rows may have a different name in Column A, but Column B and Column C contain identical values
In this case the summary table will contain 2 rows with the different names in Column A
Some of the rows may have a different name in Column A, different account type in Column B, and same number in Column C
In this case the summary table will contain 4 rows, 2 with the different names in Column A, 2 with the different account type in column B, and all 4 with the same number in Column C
I appreciate any help on this.