I need to ty and get more specific please excuse me I know enough excel to
get into trouble
I need a formula to do the following
I have a summery page with that comapares our products to a competitors
I have our products listed on the a colum cells 2:20 and the competitors
along the a row cells 2:20
I have multiple data worksheets that are identical except for specific labels
e.g. sheet 2:4 have the same Heading and footing and the data that changes
fits in the same cells in all worksheets except summery sheet.
how can I compare our product to competitors by counting the number of times
that "AS123" (Our Product)is in the same worksheet that "ZX987"(Competitors)
