How to get the right numbers behind the right teams, from a sorted list.

Good evening (it's evening here, anyway...)

I've got a question because I can't solve the issue. I got quite far, but I can't get it to the end, so I am hoping for your help.

In the excelsheet added to this post, there's a list of numbers, sorted from low to high, with next to it the Formula 1-team the driver using that starting number is using. Now I am looking to find a way to get the starting numbers behind the team, in order from low to high (second example, left from the list). I entered the numbers by hand, but I am looking for a way to do that automatically, because not every driver enlisted is always present. So... how to do it?

I don't care how many steps it will take, I have room enough in Excel, so even if it takes 30 steps, I don't really care... as long as it works.

Thanks in advance for the help.

Daniël.

Please update your thread title to explain what the issue is, as per the forum rules.

No help to be offered until this has been done.

Originally Posted by AliGW

Please update your thread title to explain what the issue is, as per the forum rules.

No help to be offered until this has been done.

Done. My apologies.

Originally Posted by Fluff13

How about in F2 copied down & across
=IFERROR(SMALL(IF($B$2:$B$23=$D2,$A$2:$A$23),COLUMNS($F2:F2)),"")

This needs to be confirmed with Ctrl Shift Enter, not just Enter.
Also the teams in col D need to match the teams in col B

Thanks for the suggestion. Sadly, all I get is '7's... 30 of them. And yes, I changed the names of the teams to match.

Did you enter the formula with CSE as instructed? Sounds unlikely.

Originally Posted by AliGW

Did you enter the formula with CSE as instructed? Sounds unlikely.

I did. Now I see what is happening. All 30 formulae are the same (i.e. the last 'F2' doesn't change in the CSE formula into F3, F4, G2, G3, etc...).

Having solved that, I have another issue that results in this...

Team res.cour. Team afk Cour.1 Cour.2 Cour.3
Alfa Romeo Alf 0
AlphaTauri Alp 0
Ferrari Fer 3 4 5
Haas Haa 0
McLaren McL 0
Mercedes Mer 0
Racing Point Rac 0
Red Bull Red 0
Renault Ren 0
Williams Wil 0

Here is the current result.

Originally Posted by Fluff13

You haven't entered the formula with Ctrl Shift Enter.
Also are you still using Excel 2007?

When changing into CSE, this is what happens. Yes, sadly I have only Excel 2007...

Originally Posted by Fluff13

You need to put the formula in F2 & confirm with Ctrl Shift Enter, then drag it down & across.

Yes, that works...
How come I didn't see that... :o Thanks Now I can try to fit this into column AXD of my database... Yes, column AXD...
I feel silly that I didn't see this, actually. But thanks again, it's solved now.

And now I am searching how to close the thread... I feel like a real nit-wit, sometimes...