Hi,
In the attached samples excel sheet, I need count of
unique values from B:14-B73 which is actually 2
May I please get help in formula for this
Hi,
In the attached samples excel sheet, I need count of
unique values from B:14-B73 which is actually 2
May I please get help in formula for this
The instruction and to where I put the formula is unclear to me but you may use this formula:
=SUM(IF(COUNTIF(range, range)=1,1,0))
ctrl+shift+enter
1. I have asked you once already NOT to post samples that contain background queries, which automatically connect to an external www, in your sample sheets.
You ignored my request.
I will not ask you again. I will block any and all future threads, that contain external link, until YOU remove them.
2. Use this formula:
=SUM(INDEX(1/COUNTIFS($B$14:$B$73,$B$14:$B$73&""),0))
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
The following works in Excel 2000 without array formula entry, so it should work in later versions without array formula entry.
Formula:Please Login or Register to view this content.
Thank you and noted the concern
Go with hrlngrv's... it is FAR faster than mine...
Thank You again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks