• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Counting Occurences in rows

Gaurang Mhatre

Gaurang Mhatre

Member
Hi Friends,

I have doubt in the attached sheet .
i want to count how many occurences are there in each row.

Thanks for your help in advance.

Regards,
Gaurang.
 

Attachments

Hi Deepak,

Checked the link, bt still the formula doesnt work in the attached sheet.
It counts text...after putting this formula SUM(IF(FREQUENCY(BN3:DE3,BN3:DE3)>0,1)) BUT ITS counting NA as well..also i have applied the below formula...

SUM(IF(FREQUENCY(IF(LEN(BN4:DE4)>0,MATCH(BN4:DE4,BN4:DE4,0),""), IF(LEN(BN4:DE4)>0,MATCH(BN4:DE4,BN4:DE4,0),""))>0,1))

still it doesnt work.

Regards,
Gaurang
 
Last edited:
Hi Deepak,
Is the above formula counting NA as well...as far as i understand from the above formula counts duplicate of 4,2 and NA...which give count 3.
But, if you check my sheet...the data is in rows.. and i dont want to count NA, only Numbers which are occuring more than 1.

Thanks in advance for your help!

Regards,
Gaurang
 

Attachments

Gaurang Mhatre said:
Hi Deepak,
Is the above formula counting NA as well...as far as i understand from the above formula counts duplicate of 4,2 and NA...which give count 3.
But, if you check my sheet...the data is in rows.. and i dont want to count NA, only Numbers which are occuring more than 1.

Thanks in advance for your help!

Regards,
Gaurang
Click to expand...

Hi,

What's value you want in AV1,AV2 !!!
 
Gaurang Mhatre said:
Hi Deepak,
Is the above formula counting NA as well...as far as i understand from the above formula counts duplicate of 4,2 and NA...which give count 3.

Thanks in advance for your help!

Regards,
Gaurang
Click to expand...


Above formula count unique of 1,2,4 leaving NA & blank cells.
 
Hi Mr. Deepak:
I have slightly different problem. I have a row of values say 0, 100, 2000, 150, 300, 200, 500, 450, 450, 450. (Lets say the row of values are in a range A2:A11).

Excluding Zero, I want to find out the lowest unique 3 values as L1, L2, L3 as well as highest unique values as H1, H2, H3. My answer should be L1 - 100, L2 - 150, L3 - 200 and H1 - 2000, H2 - 500, H3 - 450. Is there a formula by which I can do it?
Thanks a lot!
 
Kamesh63 said:
Hi Mr. Deepak:
I have slightly different problem. I have a row of values say 0, 100, 2000, 150, 300, 200, 500, 450, 450, 450. (Lets say the row of values are in a range A2:A11).

Excluding Zero, I want to find out the lowest unique 3 values as L1, L2, L3 as well as highest unique values as H1, H2, H3. My answer should be L1 - 100, L2 - 150, L3 - 200 and H1 - 2000, H2 - 500, H3 - 450. Is there a formula by which I can do it?
Thanks a lot!
Click to expand...

Don't Hijack others post!!!!
Pls start a new thread for the issue.
 
You must log in or register to reply here.
Back
Top