Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Raju Iyer   on Feb 07 In MS Office Category.

  
Question Answered By: Julian Long   on Feb 07

I'm more newbie than expert - but this *might* work:



---------------------------------------------------------------
dim Drow
dim Frow



For Drow = 1 To 608
For Frow = 1 to 3000
IF cells(Drow, 4).value = cells(Frow, 6).value Then
'record the dupe somewhere - in this case the next cell over from
the Drow
cells(Drow, 7).value = "True"
Next Frow
Next Drow

-----------------------------------------------------------------

This will let you know which values from Column D appear in F, but
will overwrite multiple occurances, so you'll need to wtreak it if
you need that info.

Share: 

 

This Question has 9 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on "If/Then" statement in Excel Or get search suggestion and latest updates.


Tagged: