Ranking

[KharansuR93]

Hi, I have a situation where, I need to select the 1st row in a column wherever the value changes and for the same value there are two other values in another column and those two rows should also be reflected. For example

A         B

1A      Victory

1A      

1A      Victory

1B      Victory

1B      Success

1C      Success

1C      

1C 

1C      Victory

so here I should only get the rows where Victory or Success or '  ' come 1st with different values in column A

Thanks,

Kharansu

[abhijitnalekar]

Hi @KharansuR93 ,

Can you please describe the data and output in detail?

The tabular format will help to understand the requirement easily

[KharansuR93]

Hi abhijitnalekar,

Let's take the below table - 

and I should get only sl no. 1,2,4,6,7,11,12,15,16 rows as my output. Now I don't have a Sl no. column, can we do it with index or rowno() or anything else?