Archive for NOT function
The following formula in cell D3 counts cells with values stored as text. =SUMPRODUCT(ISTEXT(B3:B14)*1) In other words, cells containing nothing, errors, […]
The NOT function returns the boolean opposite to the given argument. TRUE returns FALSE and FALSE returns TRUE. Formula in […]
Extract unique distinct values from a related table
In a previous post I described how to do lookups in a related table. In this post I am going […]
Merge two columns with possible blank cells
Question: This article is terrific. Thanks so much for posting this solution! I do have one question: Let's say my […]
List all unique events in a month
Question: I have a table with four columns, Date, Name, Level, and outcome. The range is from row 3 to […]
Question: how can i get the date range as : 01/01/09 - 01/15/09, 01/16/09 - 01/31/09 and so on I […]
Extract unique distinct values sorted based on sum of adjacent values
Table of Contents Filtering unique distinct text values and sort them based on sum of adjacent values Filtering unique distinct […]
Sort a range based on value frequency
Learn how to sort cell values by frequency.
How to create a list of random unique numbers
Question: How do I create a random list of unique numbers from say 1 to 10, without using VBA and […]