How can I check for duplicates in Column A over multiple tabs (in months) on Excel Spreadsheet?
Hi,
I have a spreadsheet. Each Tab (in month order) Starting July, August, September and so on. In Column A a store number will be entered. This store number cannot be duplicated across any of the other tabs/months. What formula can I use to check for any duplicates entered on a tab? For example, say the current month is December and 2687 is entered, but its also in July. How can I show that its a duplication to another month?
Hi, I have a spreadsheet. Each Tab (in month order) Starting July, August, September and so on. In Column A a store number will be entered. This store number cannot be duplicated across any of the other tabs/months. What formula can I use to check for any duplicates entered on a tab? For example, say the current month is December and 2687 is entered, but its also in July. How can I show that its a duplication to another month? Read More