'COUNTIFS function' category
The image above demonstrates a Conditional Formatting formula that highlights unique distinct records. This means that the first instance of […]
The picture above shows an array formula in cell B9:C13 that extracts unique distinct records from two tables in cell […]
The picture above shows Conditional Formatting highlighting cells in cell range F3:Y22Â based on row and column values in column B […]
This article demonstrates how to sort numbers from small to large using a condition or criteria, I will show how […]
This article demonstrates formulas that match two conditions in a column each and return another value on the same row […]
The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]
This article demonstrates how to construct a formula that counts unique distinct values based on a condition. The image above […]
The following image shows you a data set in columns B and C. The formula in cell E2 extracts a […]
The formula in cell B8, shown above, extracts dates not included in the specified date ranges, in other words, dates […]
This article demonstrates array formulas that perform a wildcard search based on a sequence of values. The formulas return the […]
This article demonstrates array formulas that identify two search values in a row or in a sequence. The image above […]
This article demonstrates two formulas, the first formula counts items by quarter and the second formula extracts the corresponding items […]
How would you figure out an unique list where the sum of in one column doesn't match the other column? […]
This article demonstrates techniques on how to merge or combine two data sets using a condition. The top left data […]
This article demonstrates how to set up Data Validation in order to control what the Excel user is allowed to […]
This article demonstrates a formula that distributes given text strings randomly across records in any given day meaning they may […]
Checks multiple conditions against the same number of cell ranges and counts how many times all criteria are met.
Debraj Roy asks:Hi Oscar, I failed to search for "Ask" Section.. so submitting my query here.. Apologize for hijacking someones […]
I will in this article demonstrate four formulas that do lookups, extract unique distinct and duplicate values and sums numbers […]
In this post, I am going to show you how to extract unique distinct values and duplicates using a formula, […]
This article demonstrates different ways to reference an Excel defined Table in a drop-down list and Conditional Formatting. There are […]
This article demonstrates how to get a value from a dataset based on multiple conditions across multiple columns. S.Babu asks: […]
This article demonstrates how to sort records in a data set based on their count meaning the formula counts each […]
Rodney Schmidt asks: I am a convenience store owner that is looking to make a spreadsheet formula. I want this […]
In this post I am going to try to explain formula basics in conditional formatting. It is really good if […]
This schedule uses the year and month in cell D1 and K1 to highlight activities like vacation specified in the […]
Michael asks: I need to identify the duplicates based on the Columns D:H and put in Column C a small […]
This blog post describes how to filter unique distinct records that meet a given condition in an Excel defined Table. This article […]
Question: My issue is that I get the date in this format: 7/23/2011 7:00:00 AM I am trying to count […]
This article demonstrates how to filter records occurring in only one out of two Excel defined tables. It also shows […]
This article demonstrates how to quickly compare two data sets in Excel using a formula and Excel defined Tables. The […]
Sean asks: If Tea and Coffee has Americano,it will only return Americano once and not twice. I am looking for a […]
Today I am going to show you how to quickly compare two tables using Conditional Formatting (CF). I am going […]
This article demonstrates how to filter duplicate records using a simple formula and an Excel defined table.
This blog article describes how to extract coinciding date ranges using array formulas, the image above shows random date ranges […]
In this example we are going to use two lists with identical columns, shown in the image above. It is […]
I will in this blog post demonstrate a formula that extracts common records (shared records) from two data sets in […]
This article describes how to highlight duplicate records arranged into a column each, if you are looking for records entered […]
This article describes how to filter duplicate rows with the use of a formula. It is, in fact, an array […]
This article shows you how to easily identify duplicate rows or records in a list. What's on this webpage Highlight […]
Andre asks:I am trying to list people with the highest scores based on certain criteria. My data: column A B […]
The image above shows an array formula in cell B3 that calculates numbers based on the numerical ranges in cell […]
The array formula in cell B3 extracts overlapping dates based on the date ranges in columns D and E. What's […]
This article demonstrates how to create a list of dates based on multiple date ranges. Table of contents Convert date […]
This article demonstrates how to calculate dates in a given date range (cells B13 and B14) that don't overlap the […]
The image above demonstrates a formula in cell E3 that extracts duplicate items if they are on the same date. […]
Question: Column B has dates Column C as data B5 : 1/1/2010 : 5000 B6 : 2/1/2010 : 4000 B7 […]
This article demonstrates how to extract records/rows based on two conditions applied to two different columns, you can easily extend […]
Question: Does anyone know how to do a VLOOKUPÂ of three columns to pull a single record? Table of Contents VLOOKUP […]
Formula in B14: =INDEX(D3:D6, SUMPRODUCT(--(C10=B3:B6), --(C11=C3:C6), ROW(D3:D6)-MIN(ROW(D3:D6))+1)) Alternative array formula #1 in B15: =INDEX(D3:D6, MATCH(C10&"-"&C11, B3:B6&"-"&C3:C6, 0)) Alternative array formula […]
Question: How do I filter duplicates with a condition? Answer: Column B contains category and column C contains Items. Only […]
Question: I need to calculate how many hours a machine is utilized in a company with a night and day […]
In a previous article "Automatically filter unique row records from multiple columns", I presented a solution to filter out unique […]
Table of contents Filter unique distinct row records Filter unique distinct row records but not blanks Filter unique distinct row […]
This article demonstrates formulas that extract the nearest number in a cell range to a condition. The image above shows […]