Auto Generate Based Off Criteria

[sreising]

What I Currently Have From A Previous Source:

Enter a number in column B in rows 3 through 30. Based off the drop down tab, it fills in the aircraft tail number. When you designate HANGAR or LINE in column E it moves that aircraft to the bottom two yellow areas depending on whether it was LINE or HANGAR. It moves the aircraft based off the SMALL function and numerically moves them around.



What I Want It To Do:

I want it to still move aircraft to their respective spots based off HANGAR or LINE, but I DO NOT want it to look at the SMALL function. I simply want it to move based off the location and even if a lower numerical number gets entered, it just moves in order that the aircraft was entered.

[menem]

Please re-upload again with sample of data entered, so we can know which 'Yellow' is LINE or HANGAR
include others condition that we might not know.

Regards.

[sreising]

Apologies, here is an example of the data.

[JeteMc]

Paste the following into cell B32 and drag the fill handle down to cell B43:

Please Login or Register  to view this content.

Paste the following into cell B45 and drag the fill handle down to cell B64:

Please Login or Register  to view this content.

Note that these are regular formulas which may be activated by pressing the Enter key.
Let us know if you have any questions.

[Gregb11]

Your profile says you have 365. Why don't you just use the FILTER formula? In B32:

=FILTER(B3:B30,E3:E30="Hangar")

In B45:

=FILTER(B3:B30,E3:E30="Line")

[sreising]

Apologies for the confusion. I didn’t realize my profile still says 365. I have both for work and this specific project isn’t utilizing 365.

[AliGW]

So what are you using? That's pretty crucial information. If your profile is incorrect, please amend it now.

[sreising]

Microsoft Office 365 ProPlus, I just changed it. Like I mentioned, I use two different versions and forgot to change it.