I'm trying to Count duplicate text on sheet 2 and populate the number of times repeated on sheet 1.
On sheet 1 I have A3:A128 and would like the number of times these respective cost centers are repeated in Sheet 2 to populate Column B of Sheet 1.
File attached.
Please help. Not sure which formula to use. I tried CountIF but didn't work with 2 sheets.
Thanks.
Bookmarks