I am getting the first occurance of duplicate row as row index in my excel .
I’ve tried lookup range. Can someone help me here.
See attached Sample Excel.
Query : Sample.xlsx (12.5 KB)
I want to read and filter Excel to get only blank from column “P”.
Get the value from column “C” , search on website and compare data from Excel Row to Website.
IF data match then update column P’s row for that C cell’s value. “Completed”.
I have to do this for all the data in excel sheet and sometimes it may be available sometimes not and each of the time will get more data in this sheet.
I will execute this bot once or twice in a month.
SO, first I will check column “Decision” IF any blanks are there .
For that blank rows EX: P2 is blank then I have to pick the value of C2 and search on website.
Need to match the records from Excel to website.
IF match : Update P2 Completed
If not match : Update P2 Not Match
I am able to got it upto this.
Now the Query is :
EX: C2 = 120 , C3=120, C4
: P2= Completed, P3 = “”, P4=“”
When Bot do the above process and try to update P3, it is again updating P2 because It is taking first occurance of the duplicate rows.
I am using Lookup range here, And when multiple same rows on column C then it is just taking first all the time.
Let me know if you still have doubt on the question.
No, JUst see the entire flow I wrote in above post.
This is updating all blank rows as “Completed”.
I just want to update for that particular row (C) which has matching data on Website. I have to compare and find something after using C cell. Then have to update different "Status " on Decision columns. I have almost 8 conditions to check before write the status and have 8 different status to update on excel. For each cell it would be different.
Maybe this is solved… But in Excel, any VLOOKUP HLOOKUP etc formulae will only pick the first occurrence. If there are duplicate values / multiple occurrences; it will not move to the 2nd one and give the lookup value.