Forum

You can use a simple loop: Sub loadPictures() For Each cell In Selection addpic cell.Value, cell.Offset(, -1) Next cell End Sub Sub addpic(url...

You're welcome.

I think you could use something like: =LOOKUP(B2,PERCENTILE.INC($B$2:$B$10,{0,0.06,0.28,0.5,0.73,0.95}),{2,3,4,5,6,7}) where B2:B10 ha...

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.