MathGenius

My friend is a registered standby passenger with United (i am not, I'm flying roundtrip in Economy). I’m planning a trip to Copenhagen (CPH) in late August, and we’re trying to coordinate our flights so we can meet up and travel together.

To be honest, I'm really not aware of what allows someone to use the standby option. There seems to be little to no information online about it, which is weird, considering how important of an option it is for flying.

So, I just wanted to clarify:

• What are the exact requirements to be eligible for United standby? Is there a difference between being a "registered standby passenger" and just "flying standby"?

• Do the flights have to be “United metal,” or can you standby on codeshare flights operated by partners like Lufthansa, Air Canada, or Brussels Airlines if the flight number starts with UA?

• Does cabin class or booking type (e.g. Basic Economy) affect standby eligibility in any way?

• Are there any ways to check if a flight is truly United-operated vs just codeshare?

Thank you for the help :)

I'm currently trying to make an ELO system for a marble racing tournament project, and my next goal is to have the group of each marble automatically show up in the B column whenever you type their name in any of the 4 groups (column F, H, J, or L).

For example, when I put Apocalypse in Group C (column J), I want it to automatically show that in cell B2, right next to their name.

However, when I try to do that by using this function:

=ARRAYFORMULA(
  IF(
    ISNUMBER(MATCH(F2:F13,"Apocalypse",0)),
    "A",
    IF(
      ISNUMBER(MATCH(H2:H13,"Apocalypse",0)),
      "B",
      IF(
        ISNUMBER(MATCH(J2:J13,"Apocalypse",0)),
        "C",
        IF(
          ISNUMBER(MATCH(L2:L13,"Apocalypse",0)),
          "D",
          ""
        )
      )
    )
  )
)

It leaves a bunch of blank cells and throws the "C" all the way down to B5.

It's like it's copy-pasting all of Group C, shifted it to the left, and deleted all of the names except for the one name I asked it to find.

Is there a way that I can have the ArrayFunction result stay in just one singular cell (B2), rather than covering all of (B2:B13)?

Thank you :)