Need a formula to show the cell coordinates

[akinkaraman]

I want a formula where AVI, PER and DGR belongs to.

Can you help me to write formulas for cells M2, M4 and M6 in a list?

Thanks..

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[akinkaraman]

Hi Narayan; what if, there are more than 9 same items?

I think it can show maximum 9.

It would be better if it shows in one cell with seperating comas.

 

[NARAYANK991]

Hi ,

All you have to do is copy the formula across more columns.

Excel cannot concatenate ranges ; if you wish to have a concatenated output , concatenate the individual outputs from the cells using the & operator or the CONCATENATE function.

Narayan