[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 84
  • Last Modified:

REFERENCE DATE AND ITEMS

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
0
Svgmassive
Asked:
Svgmassive
1 Solution
 
James ElliottCommented:
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

0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now