Minimum repeated search

[dinesh4you]

Dear all,
Chatgpt is failed to resolve this issue. Please help me for growing my profession

In the below screenshot i have some figures as an example only. Its too much large data. Now i want to know which is minimum repeated. Please note every digit is repeated in future but matter is which is minimum? So please if anybody can help then its a great achievement of my future.

 

[vladimiratanasiu]

Dear all,
Chatgpt is failed to resolve this issue. Please help me for growing my profession

In the below screenshot i have some figures as an example only. Its too much large data. Now i want to know which is minimum repeated. Please note every digit is repeated in future but matter is which is minimum? So please if anybody can help then its a great achievement of my future.

You didn't mention which version of Excel you use. Did you try the next solution: How to find the least or most common / frequent value in Excel? ?

 

[dinesh4you]

Yes sir try this formula. It is also fail when any cell is blank. I am using mobile version of Microsoft 365. No solution is working provided by chatgpt and other forums.

 

[dinesh4you]

Also i try this =IFERROR(SMALL(IF(COUNTIF(BG2:BG200,BG2:BG200)>1,BG2:BG200),1),"No repeated figures")

And also

=IF(COUNTIF(BI3:BI201, BG3)>0, BG3, "")

Both are failed so solve my query.

 

[Fluff]

I am using mobile version of Microsoft 365

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[dinesh4you]

I have updated my profile and info.

 

[vladimiratanasiu]

Yes sir try this formula. It is also fail when any cell is blank. I am using mobile version of Microsoft 365. No solution is working provided by chatgpt and other forums.

Also i try this =IFERROR(SMALL(IF(COUNTIF(BG2:BG200,BG2:BG200)>1,BG2:BG200),1),"No repeated figures")

And also

=IF(COUNTIF(BI3:BI201, BG3)>0, BG3, "")

Both are failed so solve my query.

Photos are not very useful. Post an editable sample, using XL2BB tool or other accepted sources to download and work with it.

 

[dinesh4you]

448 366
399
120 667
228 135
800 290
299 500
346 335

168
223 788
660 359
459
678
347 228
120 346
880 335
390 456
889
347 559
227 189
448
550
122
133 478
790 248
667 589
155 789
249 770
377 788
290 880
569 336
800
179 226
These are figures in column a and b. Black cell means no transaction. Now what will be formula for searching figure with minimum repeatation.

 

[Fluff]

How about

=LET(u,UNIQUE(TOCOL(A2:B34,1)),TAKE(SORTBY(u,COUNTIFS(A:B,u)),1))

 

[dinesh4you]

This is also not working