Aguadiablo
New Member
- Joined
- Nov 29, 2013
- Messages
- 13
I have many different tables all on one worksheet, with identical data in appearing in more than one table, but never more than once per table.
It looks something like this:
Table 1 Name | Data 1 | Data 2 | Data 3 | Data 4
Table 2 Name | Data 2 | Data 4
Table 3 Name | Data 3 | Data 4
Table 4 Name | Data 2 | Data 3 | Data 4
Is there a formula that can give the me total number of times that both Data 3 and Data 4 appear together in all the tables?
I.e. Data 3 and Data 4 both appear in Table 1, 3, & 4 so the formula should give me the number 3.
It looks something like this:
Table 1 Name | Data 1 | Data 2 | Data 3 | Data 4
Table 2 Name | Data 2 | Data 4
Table 3 Name | Data 3 | Data 4
Table 4 Name | Data 2 | Data 3 | Data 4
Is there a formula that can give the me total number of times that both Data 3 and Data 4 appear together in all the tables?
I.e. Data 3 and Data 4 both appear in Table 1, 3, & 4 so the formula should give me the number 3.