-
Continue reading →: How to Use FILTER Function in Excel for Value Extraction
The FILTER function is used to extract values from a list based on one or more conditions. Lets create a list with points or values – enter some data in column A – starting in cell A2. Lets say that we want to extract all values that are above 100.…
-
Continue reading →: Count number of occurrences in ExcelHere we are going to use Excels in-built function UNIQUE to count the number of times a specific car appears in a list. Now we need to find all the UNIQUE values in this list. In cell C2 – enter the following formula: =UNIQUE(A2:A11) Now we are ready to use…
-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Excel tutorials 