How count present date count based on row by row

[Raja.G (Mr.RPABot)]

Hi @supermanPunch ,

How count present date count based on find least count date present cell value

Hi Team, I have one excel , In the data table i want find name column based count today date for each person and find who is least count today date. Input excel: [image] Expected output: XXX = 2 YYY = 1 ZZZ = 4 Result : Least count is person: YYY if suppose same count come in two person or three person will choose random one person. Please help me anyone for this Regards, Raja G

This solution once same count appear na always pick first item , i want random anyone data

Expected output:
XXX = 2
YYY = 2
ZZZ = 4
AAA=3
BBB=2
Any one of data like XXX or YYY or BBB

Please help me for this

Regards,
Raja G