Validate a range of cells based on multiple conditions – the exact question can be read from here. You may refer to my solution in the this file.
Read More →
Tags: SUMPRODUCT
Sequencing using advanced filters
{ 0 Comments }
Assume a three column database of Article Number, Size and Quantity. The size column may have five sizes – Small, Medium, Large, XL and XXL. Not all sizes will be available for every article number. The task is to create a three column database in another worksheet, which shows only those article numbers having all […]
Read More →
Sum highest n numbers based on conditions
{ 4 Comments }
Assume a two column database with names in column A and numbers in column B. Names in column A may be repeated. If a user types a certain name in a cell, a formula should sum the highest three values from column B for that name. Depending upon the version of MS Excel which you are […]
Read More →
Count unique values with conditions
{ 13 Comments }
There is a three column database with month in column A, numbers in column B and names in column C. I want to count unique numbers in column B for a specific month and name provided by the end user. Depending upon the version of MS Excel which you are using, there could be two […]
Read More →
Validate based on multiple conditions
{ 0 Comments }