How to get row index if Excel has duplicate row

Help Activities
, ,
13

Ok.

  1. First I am filtering blank rows on Column P. EX: P2
  2. Checking Data on website by the column C Value. EX: C2 (there is another for each for Web data because multiple rows are there and have to check each to match)
  3. IF : Data available , Check Column J2 is there on website ? IF Not Update P2= Not Match
  4. J2 match then check N2 on web , If not match , Update P2 : N Not match
  5. If both J2 and N2 match with web , Process something on website and at last update P2 = Completed.

I Hope Above explanation clears the Question.

Current Workflow :
Read Range (Excel)
Filter Data TB (Filter Excel to get blank)
For Each Row : excel
if conditions
Update Excel Column P

Thank you