I have multiple sheet (sheet1, sheet2). Both has some same data (Name, address) so, i need to check if sheet1 data and sheet2 data is same or not. if same, how do i get sheet1 row number of that data?
@HR_Hmingsangthang if both have same data then it will be at same position also.
Not all datas are same only some data are same.
In that case, how can you check which one has the same data? You then have to call all the cell data 1 by 1 and save the index, and check by comparing the daata and comparing data will take a lot of time and is also not a good practice.
1 Like
Yes.
I initialize row number = 2, then i check the value is true or not, if not i add row number +1, then i check the next data again and so on. Yes, it take a lot of times. What is the other option?
@HR_Hmingsangthang From builder component i would say that this is a time consuming and not a good method, you can try apis or custom extension if that is possible.
This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.