How to pick same column values in an excel. Any leads please?

I need to process a set of data that has the same column values repeated in an excel. Later, I need to collect them and use for next manipulation. Can someone help pls?

Thanks in Advance! :slight_smile:

Hi Pavithra,

can you please provide a sample excel or screenshot to understand the issue better

Thanks,
Arun

Thanks for dropping in! :slight_smile:

Consider the below ex:

Bill no Product code
12345 abc
12547 pgf
12578 uhj
12345 uhg
12758 yhfg

The Bill no 12345 is repeated twice. I need to get that corresponding row… here the bill no is dynamic. I need to collect the Bill no and put it in a list.

Hope this is useful for you.

@PavithraSundaram So the Output What you want is the Bill No. value 12345 in a list, is that right?

1 Like

Yes. Thats correct.

@PavithraSundaram Check this Workflow:
Get Duplicate Values as List.zip (7.9 KB)

Thank you. I will look at them :slight_smile: :grinning:

1 Like