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.
This question generated 26 answers. To proceed to the answers, click here.
This thread is current as of November 29, 2013.