Archive for the ‘Compare’ Category
sissey asks: Hi Oscar, There are multiple columns in two different worksheets, one has more columns than another. I need […]
Comments(0) Filed in categories: Compare, Excel
Sean asks: How would you figure out an unique list where the sum of in one column doesn't match the […]
Comments(5) Filed in categories: Compare, Excel, Unique distinct values
This animated picture shows you the most urgent work orders for a location. Type a location in cell F3 and […]
Comments(1) Filed in categories: Compare, Excel
There are text values in column A and column B. The question is how do you compare the values in […]
Comments(3) Filed in categories: Compare, Excel
Peter Voss asks: This is close to what I need. I have three lists of email addresses. If an email […]
Comments(5) Filed in categories: Compare, Excel
Table of Contents Compare two tables: Remove common rows Compare two tables using a condition Let me demonstrate how to extract […]
Comments(5) Filed in categories: Compare, Records
This post describes how to compare two price lists in excel 2007. I am going to create three conditional formatting […]
Comments(7) Filed in categories: Compare, Excel
This blog post demonstrates how to quickly compare two tables in excel 2007. Table1 Table2 Create a fourth column and […]
Comments(0) Filed in categories: Compare, Excel, Records
Today I am going to show you how to quickly compare two tables using conditional formatting. We are comparing two […]
Comments(2) Filed in categories: Compare, Conditional formatting, Excel
In this example we are going to use two lists with identical columns in excel 2007. It is easy to […]
Comments(0) Filed in categories: Compare, Excel, Records
Overview There are two lists in this example: Sheet: List 1 Sheet: List 2 Create named ranges Select A2:A13 on […]
Comments(1) Filed in categories: Compare, Excel, Records
Overview In this blog post you will learn how to: Create a countifs function Create a conditional formatting formula and […]
Comments(2) Filed in categories: Compare, Excel, Records
This blog post describes how to extract common rows (records) from two lists in excel 2007. Sheet: List 1 Sheet: […]
Comments(7) Filed in categories: Compare, Excel, Records
This post describes how to filter values existing only in one out of two cell ranges. See picture. This udf […]
Comments(0) Filed in categories: Compare, Excel, User defined functions (udf)
I tried the array formula in this post: Filter common values between two ranges using array formula in excel to […]
Comments(2) Filed in categories: Compare, Excel, User defined functions (udf)
Question: Hi, I have seen a lot of examples related to unique list ... mais not found what I need. […]
Comments(4) Filed in categories: Compare, Excel
Array formula in B26: =INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)>0)*ISTEXT(tbl_1)*NOT(COUNTIF($B$25:B25, tbl_1)), ROW(tbl_1)-MIN(ROW(tbl_1))+1)), MATCH(0, ISNONTEXT(INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)>0)*ISTEXT(tbl_1)*NOT(COUNTIF($B$25:B25, tbl_1)), ROW(tbl_1)-MIN(ROW(tbl_1))+1)), , 1))+COUNTIF($B$25:B25, INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)>0)*ISTEXT(tbl_1)*NOT(COUNTIF($B$25:B25, […]
Comments(0) Filed in categories: Compare, Excel
Click image to enlarge. Array formula in B26: =INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)=0)*NOT(COUNTIF($B$25:B25, tbl_1))*(ISTEXT(tbl_1)), ROW(tbl_1)-MIN(ROW(tbl_1))+1, "")), MATCH(0, ISNONTEXT(INDEX(tbl_1, MIN(IF((COUNTIF(tbl_2, tbl_1)=0)*NOT(COUNTIF($B$25:B25, tbl_1))*(ISTEXT(tbl_1)), ROW(tbl_1)-MIN(ROW(tbl_1))+1, […]
Comments(0) Filed in categories: Compare, Excel
Question: i have two sets of data - one has an identifier column and one result column. A2 data1 B2 […]
Comments(1) Filed in categories: Compare, Excel
Array Formula in A15: =SUM(IF(COUNTIF(List1, List1)+COUNTIF(List2, List1)=1, List1)+IF(COUNTIF(List2, List2)+COUNTIF(List1, List2)=1, List2)) + CTRL + SHIFT + ENTER Named ranges List1 […]
Comments(0) Filed in categories: Compare, Excel, Unique values
Question: How do I filter common values between two ranges using array formula in excel? Answer: Formula in B12: =INDEX(One, […]
Comments(1) Filed in categories: Compare, Excel
Question: How do I filter values existing in one range but not in an other? Answer: Formula in B13: =INDEX(One, […]
Comments(0) Filed in categories: Compare, Excel
Question: How do I filter values that exists in all three columns? Answer: Formula in A14: =INDEX(List1, MATCH(0, COUNTIF($A$13:A13, List1)+IF(IF(COUNTIF(List2, […]
Comments(4) Filed in categories: Compare, Excel
Conditional formatting formula in B2:E5: =IF(ROW(B2)>MIN(ROW(tbl)), COUNTIF(OFFSET(tbl, 0, 0, MIN(ROW(B2)-MIN(ROW(tbl))), MAX(COLUMN(tbl))), B2)+COUNTIF(OFFSET(tbl, MIN(ROW(B2)-MIN(ROW(tbl))), 0, 1, MIN(COLUMN(B2))), B2), COUNTIF(OFFSET(tbl, 0, 0, […]
Comments(1) Filed in categories: Compare, Conditional formatting, Excel, Unique distinct values
Question: How do I highlight duplicate values in two ranges combined? Answer: Range 1, A1:D4, named tbl Range 2, A6:D9, […]
Comments(1) Filed in categories: Compare, Conditional formatting, Excel
Question: How many common cell values are there in list 1 and 2? Answer: Here is how to count matching […]
Comments(2) Filed in categories: Compare, Count values, Excel
Question: How do i remove common values between two lists? Answer: The solution in this article, removes common values and […]
Comments(1) Filed in categories: Compare, Excel
Question: How to identify two consecutive dates in a list? Answer: Array formula in cell B1: =IFERROR(LARGE(IF((A1+1)=$A$1:$A$30,A1+1,""),1),"") How to enter […]
Comments(0) Filed in categories: Compare, Excel
Question: How can I compare two columns to find common values? Array formula in C2: =INDEX($A$2:$A$11, SMALL(IF(COUNTIF($B$2:$B$11, $A$2:$A$11), MATCH(ROW($A$2:$A$11),ROW($A$2:$A$11)), ""), […]
Comments(13) Filed in categories: Compare, Excel
Question: How to filter out data from List 1 that is missing in list 2? Answer: This formula is useful […]
Comments(4) Filed in categories: Compare, Excel
