## Create a list with most recent data available

*Article last updated on March 12, 2018*

**Question:** i have two sets of data - one has an identifier column and one result column.

A2 data1 B2 22

A3 data2 B3 55

A4 data3 B4 44

A5 data5 B5 22

A6 data4 B6 33

A7 data9 B7 22

A8 data6 B8 44

A9 data88 B9 55

in the second set

D2 data1 E2 33

D3 data2 E3 55

D4 data3 E4 44

D5 data4 E5 33

D6 data88 E6 12

the new list should change B2 from 22 to 33.

If there is no change it shows the first sets result . if there is a change it reports from the second set.

To complicate it... the first set of data is twice as long as the second one. not all data is in the second set and finally the lists are not sorted and cant be.

**Answer:**

**Formula in B13:**

**+ ENTER**

copied down as far as needed.

Download excel example file.

Create a list with most recent data in excel.xls

(Excel 97-2003 Workbook *.xls)

**Functions in this article:**

**COUNTIF(**range,criteria**)**

Counts the number of cells within a range that meet the given condition

**IF(**logical_test;[value_if:true];[value_if_false]**)
**Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE

**MATCH(**lookup_value;lookup_array; [match_type]

Returns the relative position of an item in an array that matches a specified value

**INDEX(**array,row_num,[column_num]**)**

Returns a value or reference of the cell at the intersection of a particular row and column, in a given range

data1 |

data2 |

data3 |

data5 |

data4 |

data9 |

data6 |

data88 |

Compare two columns for same values [Excel Formula]

Question: How can I compare two columns to find values that exists in both cell ranges? The picture above shows […]

Filter common values from three columns

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, […]

Compare two tables: Remove common rows

Table of Contents Compare two tables: Remove common rows Compare two tables using a condition Let me demonstrate how to extract […]

Compare two tables: Filter common records

I will in this blog post describe how to extract common records from two data sets in Excel. I have […]

What values are missing in List 1 that exists i List 2?

Question: How to filter out data from List 1 that is missing in list 2? Answer: This formula is useful […]

Sean asks: How would you figure out an unique list where the sum of in one column doesn't match the […]

Filter values that exists in all three lists

Peter Voss asks: This is close to what I need. I have three lists of email addresses. If an email […]

Compare two columns and show differences

Array Formula in B11: =INDEX($B$3:$B$7, SMALL(IF(COUNTIF($D$3:$D$8, $B$3:$B$7)=0, MATCH(ROW($B$3:$B$7), ROW($B$3:$B$7)), ""), ROWS($A$1:A1))) To enter an array formula press and hold CTRL […]

Compare values between two columns and filter values existing in only one column

There are text values in column A and column B. The question is how do you compare the values in […]

How to highlight differences in price lists

Today I am going to show you how to quickly compare two tables using Conditional Formatting (CF). I am going […]

### One Response to “Create a list with most recent data available”

### Leave a Reply

### How to comment

**How to add a formula to your comment**

<code>Insert your formula here.</code>

**Convert less than and larger than signs**

Use html character entities instead of less than and larger than signs.

< becomes < and > becomes >

**How to add VBA code to your comment**

[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org or imgur

Use the img tag, like this: <img src="Insert pic link here">

**Contact Oscar**

You can contact me through this contact form

"A=10

B=8" "Total:

A=?

B=?"

"A=10

B=9"

"A=10

B=10"

"A=10

B=11"

"A=10

B=12"

"A=10

B=13"

"A=10

B=14"

"A=10

B=15"

"A=10

B=16"

"A=10

B=17

here column1 is the values for A and B contained in one cell. I want to sum this values from top to bottom of column for A and B separately, How can i do this?