Count of Unique Values based on who it's assigned to?
I have a table of landowners, agents assigned to them, and the status of project.
In column F, I want a unique count of how many unique landowners are assigned to each agent (column E) based on the value "Outreach" in column C.
The picture is expected output based on this formula, but it's not working when I type in the formula?
=COUNTA(UNIQUE(A:A,COUNTIFS(B:B=E2,C:C="Outreach")))
Any ideas?
If I understood correctly your goal, you want to group the range by two fields.
=COUNTA(UNIQUE(FILTER(A2:A10,(B2:B10="Mike")*(C2:C10="Outreach"))))
You can combine this with UNIQUE(B2:B10) to generate a list of agents.
This is a very temporary solution as of this time. The beta channel in Excel just released a new function GROUPBY(). Once it goes to main channel, you would be able to do what you want just by using it.
see https://insider.microsoft365.com/en-us/blog/new-aggregation-functions-in-excel-groupby-and-pivotby
UPD 2025-02-10 Per request, this is possible solution for GROUPBY()
=GROUPBY(B1:B10,C1:C10,COUNTA,3,0,1,C2:C10="Outreach")
COUNTA should be used for strings, COUNT will only work on values.
see syntax at https://support.microsoft.com/en-us/office/groupby-function-5e08ae8c-6800-4b72-b623-c41773611505
- Sortby function combined with Unique and filter functions: how to use it correclty?
- Count of Unique Values based on who it's assigned to?
- Excel ActiveSheet.Shapes.Range(MyArray).Select
- How to color excel cells with specific values in dataframe Python
- Talend import, transform a raw file and export to CSV
- How to change Font Color of dates without changing color of other text or background using VBA for Excel
- Auto Size Text To Fit Shape via vba
- How to recolor dates without recoloring other text or numbers
- Send Keys is Disabling NumLock
- Use VBA to Clear Immediate Window?
- Extract the first and last entries for each day
- using XLOOKUP to find matching names over multiple tabs and supplying data from specific cells as a result
- PowerPoint VBA code is inconsistent when running in attempt to export OLE objects as high resolution JPG files
- Convert 2-D array to 1-D array & paste 1-D array to another sheet
- I dont want to extract data of chart from excel cells
- VBA Autofilter Using Multiple Criteria
- Save entries from one sheet to another sheet
- How to make Uppercase Month Names in Y axes of the Chart via vba?
- Fill PDF form data from Excel with Adobe Acrobat Pro
- Webscraping dynamic content using Excel VBA
- I am having Zip Code Replacement Issues Excel VBA
- Handle multiple text boxes together
- Excel VBA If range.value = something then
- Openpyxl How to get row from worksheet by index
- Are there any performance advantages to use `Application.Match` on a VBA array instead of looping over it to check if an element is present or not?
- Import recordset from Access to Excel ListBox
- Sum and subtract among column and row cells in excel
- Call one of two templates depending on a variable
- Chart range based on the value in a cell
- Excel VBA Union Delete Columns Quickly Producing Error 1004