You only want to look in column R? Sorry missed that bit just change the selection to set r = range("r2:r50") Or if you want to make it dynam...
THis piece of code will look in the selected range and replace a div error it ignores any other text or errors as far as i can see Sub ReplaceDivEr...
Nothing attached. Be sure to click the upload button after selecting a file.
If I understand this correctly you want to paste row 1 of sheet 3, in sheet 2 (the csv file) the number of rows equal to the rows in sheet 1? Sorry, ...
Can you add the workbook so we dont need to recreate it? Purfleet
it’s the macro that I need uploading as the code that was pasted in is just text and in that format it is very difficult to read. If the issue is t...
HI Shane There was a sub in the last file (New Results File_Full_PurfleetX5.xlsb) called ShaneXRun which has all the subs needed to run the lot in ...
Hi Sholtan Sorry but i have no idea what you want, can you exaplian what the problem is in detail and what is your expect outcome? Can you also att...
Somthing like this? =IF(ISBLANK(INDEX(C:C,MATCH(H3,A:A,0)))=TRUE,INDEX(D:D,MATCH(H3,A:A,0)),INDEX(C:C,MATCH(H3,A:A,0))) You can subtitute the in...
Mind blown Such a simple, obvious concept yet i completely missed it Excellent work Phil
It all depends if you have office 365 or an older version of excel. On 2016 or older you would need nested IF(s) with and(s) =IF(M5<0.4,M6*A3...
Always best to add an example workbook so we can see the data or the code and we don't have to recreated. Have you seen this blog post by Phil?
Can you please add a sample workbook so we dont have to recreate all the data
I think that Averageif needs a range rather than selected cells =AVERAGEIF(B4:H4,">0") seems to work okay, doesn't work with named range either ...
You data isnt in the best format for this type of work. As a bodge you could use =IFERROR(IF(SEARCH(".",A14)<5,LEFT(A14,SEARCH(".",A14)),""),"")...