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 …

Hi, It’s okay just add condition as the following, for example. [img20220826-1] Sample20220826-2v2.zip (12.6 KB) Regards,

How to get row index if Excel has duplicate row

Yoichi (Yoichi) August 25, 2022, 11:41pm 2

Hi,

How about the following sample?

Regards,

1 Like

Topic		Replies	Views
LookUp Range Activity - How to get the index of "second occurrence/Second Match" of a value? Help	7	3563	July 26, 2020
How to find the cell value in the excel Studio studio , question , activities_panel	8	1204	November 29, 2023
Get the row index on the basis on value of index from excel Help excel , activities , question	4	3061	January 31, 2020
Need the row index of a given value if there are multiple intense of it! Studio studio , question , new_feature_request	4	1175	July 12, 2022
How to perform lookup or index on filtered blank cells Activities excel , activities , question	1	882	June 4, 2021