Friday, 23 September 2016

How to Resolve - Counting the number of unique values with a criteria in a different column?

Counting the number of unique values with a criteria in a different column

Hello!
I found the following formula on the net to help me count the number of unique values in column B of my worksheet (the column contains dates)
=SUM(IF(FREQUENCY(B2:B1000,B2:B1000)>0,1))
This gets me the total number of unique values.
However, I also want to separate the answer this formula gives me according to the numbers in column A.
This column contains numbers from 10 to 20 representing our sales area.
How can I modify this formula so that I can get the number of unique values per sales area?
Thanks for any help

Keys to the Problem Counting the number of unique values with a criteria in a different column

Download SmartPCFixer for Free Now

Hi,
Try this ARRAY formula, see below on how to enter an ARRAY formula.
The formula as posted counts unique values in B for a 10 in column A.
After you ARRAY enter drag down for 11 etc.
=COUNT(IF(FREQUENCY(IF($A$2:$A$1000=ROW(A10),MATCH($B$2:$B$1000,$B$2:$B$1000,0)),ROW($B$2:$B$1000)-ROW(B2)+1),$B$2:$B$1000))
This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter.
If you do it correctly then Excel will put curly brackets
around the formula .
You can't type these yourself.
If you edit the formula
you must enter it again with CTRL+Shift+Enter.

If this post answers your question, please mark it as the Answer.
Mike H

This particular error can easily be resolved with a few simple steps. However, if you are not confident in your ability to use the methods below or they do not fully remove the issue on your computer, you may want to seek the assistance of a qualified repair technician who is well versed in fixing Counting the number of unique values with a criteria in a different column.

  1. Back-up the Registry of your operating system.
  2. Find the Registry Key: [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\WindowsUpdate\OSUpgrade]
  3. Note: this Registry Key should already exist, if it does not exist, create it.
  4. Create a brand new DWORD Value that is named AllowOsUpdate
  5. Set the Value to 0x00000001.
  6. Close and reopen your Control Panel.
  7. Restart the Microsoft Windows.

Recommended Method to Repair the Problem: Counting the number of unique values with a criteria in a different column:

How to Fix Counting the number of unique values with a criteria in a different column with SmartPCFixer?

1. You can Download SmartPCFixer here. Install it on your computer. When you open it, it will perform a scan.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.


Related: How Can You Update & Download NVidia 6100, 6800 GS/XT Display Driver v.260.89 WHQL,Where to Download NVidia GeForce 8800 GT WHQL-certified driver v.196.21,How to Update & Download NVidia GeForce Go 7400 Display Driver v.260.19.12,[Solved] Download NVidia GeForce GTX 460M Driver v.331.82,Download NVidia Quadro Plex Model IV VGA Driver v.304.43 Certified,Way to Download RealTek RTL8100C(L) Driver v.5.01,Way to Download RealTek RTL8100E Drivers v.694,Way to Update & Download RealTek RTL8101L Auto Installation Program v.6.110 driver,Method to Update & Download RealTek RTL8111G PXE and RPL ROM code v.2.58 driver,How to Update & Download RealTek RTL8411B(N) Driver v.10.003,Best Way to Update & Download ASUS A53SV nVidia Graphics Driver v.8.17.12.6686,Method to Herunterladen ASUS K75VJ Intel Rapid Storage Technology Treiber v.11.6.0.1030,How Can You Update & Download ASUS CG8580 Intel Chipset Driver v.9.3.0.1019,Method to Update & Download ASUS K41VD Intel INF Update Driver v.9.1.1.1015,Way to Update & Download ASUS Pro70T NB Probe v.3.0.0026 driver
Read More: [Solution] COOD1199 PROBLEM WITH MEDIA PLAYER AND PDF FILES DOWNLOADS.......,Troubleshooting:control window is higher than screen - windows7,How to Fix - Count of unique values?,Troubleshoot:current video card driver incompatible with WDDM, blue screen crashes daily and i have windows 7 home premuim mouse on laptop is crazy too...please help me,Troubleshooting:CREATING SPREAD SHEET FOR WORK HOURS PER EMPLOYEE. Error,Closing Internet Explorer causes error,Compare 2 Tables and Calculate the PROFIT Faster,Computer goes to Windows Boot Manager after Start,Connect to one of my network computer remotely when don't allow exception box Marked,computer locking up randomly

No comments:

Post a Comment