Count frequencies for numbers that appears more than one in columns

**Karnik** · 06-09-2019, 11:11 PM

Hi Expert,

In given seven columns that has single digit number, some are duplicate/triplicate
Function required is to count frequencies such numbers
Example is given in attached work sheet.

Thanks in advance
Karnik

**FlameRetired** · 06-10-2019, 03:23 AM

Try array entering this in H2 and fill down.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

Formula:

Please Login or Register  to view this content.

Or without CSE

Formula:

Please Login or Register  to view this content.

**Kaper** · 06-10-2019, 04:13 AM

Another formula (a bit shorter, but not necesserily easier to understand :-)):

Formula:

Please Login or Register  to view this content.

If you would accept 1 for "no duplicates" it would be just:

Formula:

Please Login or Register  to view this content.

**Karnik** · 06-10-2019, 04:52 AM

Hi FlameRetire & Kaper ,

Thank you for addressing my issue.

Array suggested by FlameRetired works brilliantly
Kaper's suggestion work is duplicate value up 3 in total for all in column, some how if more than 4 it does not, may be I am missing something.
Thanks
Karnik

**FlameRetired** · 06-10-2019, 07:04 PM

You are welcome. Thank you for the feedback and marking this thread Solved.

Count frequencies for numbers that appears more than one in columns

LinkBack

Thread Tools

Rate This Thread

Display

Count frequencies for numbers that appears more than one in columns

Re: Count frequencies for numbers that appears more than one in columns

Re: Count frequencies for numbers that appears more than one in columns

Re: Count frequencies for numbers that appears more than one in columns

Re: Count frequencies for numbers that appears more than one in columns

Thread Information

Users Browsing this Thread

Similar Threads

Count how many times a specific date appears in a selection of columns

[SOLVED] count # of times word appears in dataset based also on another columns additional value

Count how many columns a value appears in

Count number of times a value appears in different columns, AND list WHERE they appear?

[SOLVED] HELP: Count for how many times two numbers appears together ?

Formula to count +1 if a value appears anywhere in different columns

Count how many times a number appears within a range of two numbers

Bookmarks

Bookmarks

Posting Permissions