Good morning!
Please see attached.
Is there any way to have the formula in cell B3 on the USE tab count the duplicates that exist within columns B and C on the SITES tab, depending on what value is in cell B1 on the USE tab?
Essentially a formula that provides the answer to: Whatever value exists in tab USE: cell B1, count duplicates within tab SITES: columns B and C which consist of that value.
Thank you for your help.
Bookmarks