How to get row index if Excel has duplicate row

Help Activities
, ,
18

Hello @PALKUMARI_PATEL
Kindlu try this metod

  1. Read the Excel file and store in Variable as a “DT1”
  2. Set lookuprange and enter the desired value you needed
  3. you can get vale in Excel postion like “C5”
  4. Using regex you can seperete the number and -1 is its index
rowindex=cint(System.text.RegularExpression.regex.match(LookupString,"\d+").tostring.trim)-1

Kindly refer this video, you may got some idea