Just wrap it in a iferror - =IFERROR(DATEDIF(A2,B2,"m"),"")
if the data is exported from a system with commas and imported as a text file with the comma, it is likley that excel is just treating it as text and ...
do you want a unique number per row or per category per row? How many numbers in the unique number? can the number contain characters or just numbers?...
Hi Amy You have only attached the data not any of your attemps. I would be better if you can add what you were trying so we can help with where ...
Just had a quick check and i think it is a combination of missing the displayformat & using colorindex rather than color This deletes the red c...
yes quite straight forward Sub OpenWBwithPW() Dim p As String Dim f As String p = "F:Moth" f = "TestOpenPW.xlsx" Workbooks.Open (p & f...
The LEFT($A2,7) takes the first 7 characters of a2, the trim gets rid of any spaces, the search looks for the result of left/trim in the rest of colum...
Certainly not the finished article but this seems to work on the limited data set you have attached =IF($B3=1,SUMPRODUCT(--ISNUMBER(SEARCH(TRIM(LEF...
Hello Tom I am a bit confused with the layout of the spreadsheet at the moment, so if you can clarify the following • I get the 1/2/3 in Column ...
can you add an example workbook rather than a screen shot? oitherwise we have to guess the data layout
Is this what you are after? =IF(C2="","",C2&"/"&MAXIFS(C:C,F:F,F2))
VBA and sending emails has been cover loads of times on this forum, i would suggust reading through the blogs
Not sure why you would want to in a worksheet but...... Sub scrollbars() ActiveWindow.DisplayHorizontalScrollBar = False ActiveWindow.DisplayVer...
Nothing attached
By its nature the drop down can only have one number in it, so i assume you mean that you want a 3 page PDF for each row in the master sheet? Try t...