Last seen: May 22, 2025
You can use an array formula: =INDEX(A2:A10,MATCH(MAX(IF(B2:B10>0,IF(B2:B10<=B1,B2:B10))),B2:B10,0)) entered with Ctrl+Shift+Ent...
I still can't see why an autofilter wouldn't suffice if you're only looking in one column (as the original post says, although the subsequent code imp...
You could use: =INDEX($C$4:$C$31,MATCH(MAX(IF($A$4:$A$31=G5,$B$4:$B$31)),IF($A$4:$A$31=G5,$B$4:$B$31),0)) array entered with Ctrl+Shif...
FWIW, you could simplify a little to: =INDEX(2:2,MATCH(C12,INDEX($B$3:$O$8,MATCH(C11,A:A,0),0),-1)+1) thereby also avoiding a volatile INDIRECT ...
Unless you are on Insider Fast channel, you won't have it yet.
I think you have a bracket in the wrong place, and it should be: =INDEX(ClientTable[Company],MATCH([@[First Name]]&[@[Last Name]],ClientTable[F...
Since your data range starts in column F, but you have put the formula in column E, there is no implicit intersection and you get a #VALUE error becau...
Also check File - Options - Advanced, scroll down to the 'Display options for This Worksheet' section and check that the 'Show a zero in cells that ha...
Assuming the date you want is in A2, you'd use something like &TEXT(A2,"yyyy-mm-dd""T00:00:00""") rather than just &A2. Or did I misunderstand...
You are getting top 10 for both. The issue is that you have so many equal counts in the second group (note that there are also more than 10 displayed ...
FWIW, you could also use a couple of user-defined types, like this: Private Type theBarcode theCode As String * 30 End Type Private Type Barco...
That is not the code I suggested. Please at least try what I posted.
You didn't answer my question: did you actually try the code I suggested? If so, what happened? If not, why not? 😉
If it's only a few cells, you could use: =SUM(COUNTIF(INDIRECT({"B16", "B21", "B26", "B31"}),"*"&B16&"*")) Also, just FYI, you don'...
No, I see no attachment. Did you try the code I suggested? If so, what happened?