Count unique value ignoring Text in range
Rajesh S
123
562
My Data
548
K166
You
1548
123
562
100
My Data
100
I want to count unique values by ignoring text in the above shown list. For this I've tried an array formula, {=SUM(1/Countif(,,,,))} but it's not working properly.
Can anyone suggest a formula or even VBA for the task?
Rajesh S
For the benefit of community I would also like to suggest an array formula with differnt approach, "to count unique values by ignoring text in the given data range".
{=SUM(IF(FREQUENCY(A2:A13,A2:A13)>0,1,0))}
Note, finish the formula with Ctrl+Shift+Enter.
Collected from the Internet
Please contact [email protected] to delete if infringement.
edited at
- Prev: Why do startup updates always fail on my computer?
- Next: How to disable stuck ctrl key in software/memory?
Related
Related Related
- 1
Excel function to determine count for range of an occurrence text value
- 2
Excel: Count of unique items while ignoring junk duplicates
- 3
SQL Query to count Unique records ignoring sub string
- 4
incorrect count of unique text in awk
- 5
MySQL - Count Number of Unique Values with Unique Text
- 6
Count of unique values in a rolling date range for R
- 7
Count the occurences of each unique string in a range
- 8
Count unique names in excel column range
- 9
Count unique values in a set date range
- 10
Count Unique Values in Excel Range 2010
- 11
Collapse and count the number of unique value
- 12
PHP count array by unique value
- 13
Sort and Count Unique value of Array
- 14
Collapse and count the number of unique value
- 15
Unique value count in pandas series
- 16
Unique increment ID for each distinct value in a range
- 17
Unique count of words from text string
- 18
Count number of unique values containing text
- 19
Count unique values IF certain text is found
- 20
Change text dependant on range value
- 21
Formula: Count text instance within table range
- 22
Formula: Count text instance within table range
- 23
count unique value in whole table [MySQL]
- 24
count of unique occurrences of a value pandas python
- 25
count unique value in whole table [MySQL]
- 26
How to count unique value in a table with other condition?
- 27
Finding count of unique value before a character
- 28
Count unique value from awk output
- 29
How to sort by count and retain unique items in value
Comments