Last seen: Jun 10, 2026
OK, there are almost certainly simpler formulas, but I think this works in G15 and copied across and down: =LET(firststart,MAX($B15,G$12),firstend,...
Which version of Excel do you have? It will affect which functions can be used. For the first one, I think this formula in G5 and copied across and...
Hi Hans, It doesn't work properly though. DisplayFormat cannot be reliably used in a UDF - try updating some of the values so they go yellow and yo...
You can load a named range in using syntax like: = Excel.CurrentWorkbook(){[Name="filepath"]}[Content]{0}[Column1] For the special characters in...
Try amending the second sub to: Sub ListFilesInSubFolders(StartingFolder As Scripting.Folder, LinksTable As ListObject, ByRef ArrResults() As ...
You can't automatically overwrite it. You have to delete the old one then save the new one. I would suggest moving the kill line to just before the sa...
Depending on your end goal, a quick method is to use an autofilter on the sheet and simply hide rows that way.
I don't see the problem. Once you have it split into entities, you can filter out whatever you are interested in.
For your original data set with the Auxiliary column in place, perhaps: =IF([@Override]="Yes","Yes",IF(OR([@Supplier]="",[@[Comparative Price]]="")...
It would seem to me that it would be simpler to just parse the Applicable QMS Entities column into new rows split on the semicolon, so that you get a ...
Further to what Hans said, using = will cause (for reasons only MS understand) SUMIF to convert numeric text to numbers before doing the comparison, b...
Perhaps you have event code such as a Worksheet_SelectionChange routine that is preventing it. (it may be deliberate) Is it your workbook, or did some...
Is it only Paste Special, or is Paste also disabled? Also, is it a macro-enabled workbook?
Is it one particular file or all files?
Cross-posted here: www.experts-exchange.com/dashboard/#/questions/29267693