Check 2 columns and get the results

Hi All,
I have a request for a macro
Attached excel has the detailed explanation

Column "A" and "B" is what i need to compare with "D" and "E"

The counts are identical/Less/Greater or the URL is not found need to get the results in "C" with these stats

Thanks a lot in advance
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Paste this ARRAY formula in C2 and copy down

=IF(ISNA(MATCH(A2,D:D,0)),"Not found",CHOOSE(2+SUM(SIGN((A2=$D$1:$D$11)*(B2-$E$1:$E$11))),"Lower","Identical","Greater"))
mtthompsonsAuthor Commented:
After row 11 i get
for all others
I have 40K rows now
mtthompsonsAuthor Commented:
Got it thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.