## '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 […]