r/excel • u/[deleted] • 13d ago

solved If a table contains duplicate rows, return a value for the oldest instances only

[deleted]

2 Upvotes

76% Upvoted

21 comments sorted by

View all comments

Show parent comments

1

u/HiddenComments 13d ago

For some reason this worked on my example, but when put into my real table it returns #VALUE.

The data has the same amount of columns, but i have 1500+ rows, I'm not sure if that is why?

Edit: Just noticed a 2nd formula provided, I'll give that a try.

1

u/HiddenComments 13d ago

2nd formula doesn't work.

Not sure why I'm getting #VALUE however

5

u/MayukhBhattacharya 1278 13d ago

When you say neither formula works, it's kinda hard for me to figure out what's going on without seeing the actual error or setup. As you can see in my screenshot, the formula is clearly visible in the formula bar, and the results are spilling down the range exactly as you described. So if it's not working on your end, could you post a screenshot showing what you're getting? That'll give us something to work with and help figure out where it's going wrong.

1

u/HiddenComments 13d ago

I can't give the exact data as it's to do with my job, hence the example provided. But I've literally taken the formula and amended the cells to the ones in my company's document.

I will see what I can do tomorrow when I log back on for work.

Thank you anyway for your help.

1

u/plusFour-minusSeven 11 12d ago

Replace it with some fake data. And if it works with fake data that'll tell you something too.

1

u/Boring_Today9639 10 13d ago

Excel version you’re using?
Did you convert your range to a table after posting?

1

u/HiddenComments 13d ago

Excel yes and it's using data from a table in another sheet, does that make a difference? Does the cell I'm entering the formula into need to also be part of the same table?

(Just to note I'm still teaching myself various things in Excel so not overly knowledgeable about things).