Looking for matches, if true, place number from other cell here

[dailybaseball]

Hello,

I am trying to create a formula in Column D that would look to see if the the value in column A (ID #) is the same as the row above it. If it is, then it would capture the value from column C (Original) in the lower row, and print that value in Column D of the row above it.




ID Type Original Copy
1 A 10
1 B 5
2 A 15
3 A 10
4 A 10
4 B 2
5 A 10
6 A 10
6 B 5
7 A 10
7 B 2



Ideally, after a formula, it would look something like this

ID # Type Original Copy of Original
1 A 10 5
1 B 5
2 A 15
3 A 10
4 A 10 2
4 B 2
5 A 10
6 A 10 5
6 B 5
7 A 10 2
7 B 2



Edit- that below reply works, but I forgot to mention one thing.

It works great when the data is unfiltered. How do I apply this to filtered data? For example, if that info I posted is after I filtered out data between the lines, it needs to look at the rows in the filtered data- the rows I'm comparing in filtered data are directly above one another visually, but in reality, it might be row 201 and row 288. Is there a way to drag the formula down so it looks at the row above it after the data has been filtered? Hopefully this makes sense!

I have thousands of rows so a formula would make this much easier. Unfortunately, I have tried a few different things and used google but have not found something that works that would satisfy what I am trying to do.


Thank you in advance for your help. Please let me know if I need to explain something in greater detail.

[Sam Capricci]

I would think this would do it... =IF(a2=a1,c2,"") and put that in D1 and copy down.

Or =if(a1=a2,c2,"") in d1 would also work.

[dailybaseball]

Hello,
That helps for sure but I forgot to mention one thing.

It works great when the data is unfiltered. How do I apply this to filtered data? For example, if that info I posted is after I filtered out data between the lines, it needs to look at the rows in the filtered data- the rows I'm comparing in filtered data are directly above one another visually, but in reality, it might be row 201 and row 288. Is there a way to drag the formula down so it looks at the row above it after the data has been filtered? Hopefully this makes sense!

Thank you!

[jaslake]

Hi dailybaseball

Welcome to the Forum!!!

I know of know way to drag a Formula down to only Visible Cells. What you describe can be easily done with Code.
If interested, what are you filtering on? ID?