Table of Contents
The process of extracting unique values from a dataset based on specific criteria using Excel involves identifying and selecting the desired criteria, using the appropriate functions and tools in Excel to filter and sort the data, and then using the “Remove Duplicates” function to eliminate any duplicate values. This allows for a streamlined and efficient way to extract only the distinct and relevant data from a dataset, facilitating easier analysis and decision-making.
Excel: Extract Unique Values Based on Criteria
You can use the following basic formula to extract unique values based on criteria in Excel:
=UNIQUE(FILTER(B2:B14,A2:A14="West"))
This particular formula finds the unique values in the range B2:B14 where the corresponding cell in the range A2:A14 is equal to “West.”
The following example shows how to use this formula in practice.
Example: Extract Unique Values Based on Criteria in Excel
Suppose we have the following dataset in Excel that contains information about various basketball players:
We can type the following formula into cell E1 to extract a list of unique team names where the Conference column is equal to “West”:
=UNIQUE(FILTER(B2:B14,A2:A14="West"))
The following screenshot shows how to use this formula in practice:
We can see that the formula returned the names of the four unique teams who belong to the West conference:
- Lakers
- Mavs
- Spurs
- Rockets
Note: You can find the complete documentation for the Excel FILTER function .
Additional Resources
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How can I extract unique values from a dataset based on specific criteria using Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-extract-unique-values-from-a-dataset-based-on-specific-criteria-using-excel/
stats writer. "How can I extract unique values from a dataset based on specific criteria using Excel?." PSYCHOLOGICAL SCALES, 28 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-extract-unique-values-from-a-dataset-based-on-specific-criteria-using-excel/.
stats writer. "How can I extract unique values from a dataset based on specific criteria using Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-extract-unique-values-from-a-dataset-based-on-specific-criteria-using-excel/.
stats writer (2024) 'How can I extract unique values from a dataset based on specific criteria using Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-extract-unique-values-from-a-dataset-based-on-specific-criteria-using-excel/.
[1] stats writer, "How can I extract unique values from a dataset based on specific criteria using Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I extract unique values from a dataset based on specific criteria using Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.