REFERENCE DATE AND ITEMS

Svgmassive
Svgmassive used Ask the Experts™
on
I have imported over 10000 rows of data i would like to check for date and item number between sheets and also check for duplicate date and item number.
thanks
REFERENCE.xlsx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Managing Director
Commented:
First question (fill down) :

=COUNTIFS(Sheet2!$A$2:$A$11,Sheet1!A2,Sheet2!$B$2:$B$11,Sheet1!B2)>0

Open in new window


Second question (fill down):
=COUNTIFS($A$2:$A$11,A2,$B$2:$B$11,B2)>1

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial