Excel column values compare




here i need to compare the values in data column and i need to assign 1 for the least value as shown below.

it two data values are same, then 1 will assigned to the value which appeared first.

any ideas?

thank you.


You can try to get the Min value and when you find multiple values find the index and then assign to the one whose occurrence is first Sample Attached
SampleExcelSheet.zip (13.5 KB)


Hi @prankurjoshi

how to achieve that? any sample?

thank you.


Have attached one see if that helps

You can have a look at this too