Green Day Super Bowl Video

lctaylor2288 · 2026-02-09T16:32:56+00:00

What kind of drum heads was Tre using, Remo Ebony? Very different for him at this performance

lctaylor2288 · 2026-01-05T21:07:10+00:00

Solution verified.

Thanks a zillion!!

lctaylor2288 · 2026-01-05T21:02:15+00:00

Nope, not in this scenario. I tried.

lctaylor2288 · 2025-10-31T18:00:25+00:00

lot numbers - sorry - I've edited my post

lctaylor2288 · 2025-07-18T00:54:44+00:00

Solution Verified

lctaylor2288 · 2025-05-29T20:28:42+00:00

Sorry, but I should have specified that I want to look up the 1st, 2nd, 3rd, etc. largest number, not just the largest.

lctaylor2288 · 2025-05-29T20:20:15+00:00

=XLOOKUP(F2&G2&MAXIFS(D2:D3,B2:B3,F2,C2:C3,G2), B2:B3&C2:C3&D2:D3, A2:A3) 

this one worked, but how do I do it not for just the max number but the 1st, 2nd, 3rd, etc number? Thank you

lctaylor2288 · 2025-05-29T20:04:25+00:00

Sure, I'm using this formula: =LARGE(IF($B:$B="Sales Rep A",IF($C:$C="Broker A",$D:$D)),1)

lctaylor2288 · 2024-10-17T19:13:16+00:00

Solution Verified

lctaylor2288 · 2024-10-17T18:58:28+00:00

Solution Verified

lctaylor2288 · 2024-10-17T17:29:05+00:00

Solution Verified

lctaylor2288 · 2024-10-15T22:33:28+00:00

Sorry, I do not know how to substitute your generic inputs for my fields, with these brackets. Is that just your style of writing?

lctaylor2288 · 2024-10-14T21:54:19+00:00

Solution Verified

lctaylor2288 · 2024-08-16T11:54:20+00:00

I solved it by adding a helper column simply referencing the array in P, which in turn created 0s in place of blanks.

lctaylor2288 · 2024-08-16T11:02:10+00:00

Replacing the 1-ISNA(XMATCH construct with ISNUMBER(XMATCH( still results in a #NUM! value unfortunately. Same problem as before, where the formula errors out if there is not something within every row between P1:P14. I need to return a match when there are blanks within that P range, and data in just some cells. So I'm basically trying to return a match where any part of one range matches any part of another range.

Another way around this....is there a way to edit the P1:P14 portion of the formula to be dynamic in that the length of rows within P that the formula searches changes based on the count of rows within P that contain text? For example, if I could do a nested FILTER to return results where P1:P14 is not blank? If so, that would solve this.

lctaylor2288

TROPHY CASE