Formula - Return True if any duplicate numbers

[tlc53]

Hi,

I've been struggling with this formula for a little while now. Basically, I want it to return True if any numbers are repeated in the range B8:DG22 however, I want it to ignore text or more precisely, the word "Blank".

=SUMPRODUCT(COUNTIFS(B8:DG22,"<>Blank",B8:DG22,B8:DG22)-1)>0

Can anyone see how to get this working?

Thank you.

 

[jasonb75]

How about

=AGGREGATE(14,6,COUNTIF(B8:DG22,B8:DG22+0),1)>1

 

[tlc53]

How about

=AGGREGATE(14,6,COUNTIF(B8:DG22,B8:DG22+0),1)>1

Awesome! Thank you

 

[Peter_SSs]

Just wondering, how did this question essentially differ from this one you asked a few days ago?
Any follow-up should have been posted in the same thread.

 

[tlc53]

Just wondering, how did this question essentially differ from this one you asked a few days ago?
Any follow-up should have been posted in the same thread.

Sorry Peter. It was based on the same problem however, I didn't see your reply and thought I must have phased the original posting in such a way that it was too confusing. In hindsight, I should have just picked up the original posting and reiterated. I appreciate your time helping me. I'll be more posting conscientious in future. Thank you.

 

[tlc53]

Just wondering, how did this question essentially differ from this one you asked a few days ago?
Any follow-up should have been posted in the same thread.

Further to this, the only reason why I eventually saw your posting was I followed the link on my email notification. Is there a way of easily seeing recent postings to my questions on my MrExcel account? Currently I go to My Profile, then My Activity but the quick view only shows me my latest posting on a subject, not the latest posting from any user. Is there a better place I should be looking or should I just make sure I follow the email links?

 

[Peter_SSs]

Try clicking 'Subscribed Threads' near the top left of the page.

 

[tlc53]

Try clicking 'Subscribed Threads' near the top left of the page.

Very helpful. Thank you. I'll be checking here regularly in future