Old MacBook version

[Beau the dog]

Good afternoon,

My work laptop has an old Mac version of excel - Version 16.16.27 (201012). there is no filter formula or unique formula etc...

So I have no idea how to achieve what I need...!

The shaded cell in the table below is at A1, this cell, I will change each week. I need a list of registrations from the first column, where the date in cell A1 appears in the any of the cells from B2:N16. The list can start in cell A18.

So with the current date selected in cell A1, the list would say:

BD12FAA
HK57OKL

...as these are the only registrations that have that date in the table. Seen in column 3, row 3 and 11. Thanking you in advance for any help.

 

[Fluff]

How about

=IFERROR(INDEX($A$2:$A$16,AGGREGATE(15,6,(ROW($A$2:$A$16)-ROW($A$2)+1)/($B$2:$N$16=$A$1),ROWS(A$18:A18))),"")

 

[Beau the dog]

How about

=IFERROR(INDEX($A$2:$A$16,AGGREGATE(15,6,(ROW($A$2:$A$16)-ROW($A$2)+1)/($B$2:$N$16=$A$1),ROWS(A$18:A18))),"")

Spot on as usual...!

So I will say thank you...again...!

 

[Fluff]

Glad to help & thanks for the feedback.

 

[Beau the dog]

Good afternoon,

I have another problem to solve for the same worksheet. How would this formula work if I were to drag down a few more rows, so I could add more vehicles in?

I'll be honest and say I have no idea how this formula works, its beyond me...!

 

[Fluff]

You can just increase the ranges, but make sure it doesn't include the cell with the formula, so if you put the formula in O2 you could use.

=IFERROR(INDEX($A$2:$A$1000,AGGREGATE(15,6,(ROW($A$2:$A$1000)-ROW($A$2)+1)/($B$2:$N$1000=$A$1),ROWS(O$2:O2))),"")

 

[Beau the dog]

I think that's was a 'wood for the trees' moment for me!

Thanks!

 

[Fluff]

My pleasure.