I am sure that i have seen a video where someone came up with a mad array forumla that could isolate the overlapping times and work it back (probably ...
Hi Chris Can you supply a sample worksheet so we dont have to spend time recreating data? Purfleet
Hi Mohith Updated macro using b2 as the file name with A2 also appended and the .jpeg is hardcoded - so the file name will be '1330123456 12012020...
Hi Michael The issue is the 3 records in yellow? and this should count as 1 visit of 2:28, rather than the 5:57? Is there anyother data i...
Hi Albert To check that i am on the right tracks, can you please have a look at the attached workbook. It has a macro to extract all the dates i...
Going to need a bit more info than just that! Can you add an example worksheet, with an expected outcome? Purfleet
Hi Mohith Please see attched - i actually wasnt as hard as i thought once i got to grips with the objects and shapes. It could be improved and it c...
If you cant upgrade then a small macro can do the same thing as textjoin Sub StringOfNumbtoCell() Dim NumsRange As Range Dim NumsCell As Range D...
Seems to work for me - did you lock the first part of rows with the $ sign? See attached Its always better to add a work book with some data so ...
Hi Corrie I have no idea about power query and i sure someone will respond, but you could do what you want with a pivot table if it helps Purfle...
Hi Steve See attached, select the client ref you want to copy over then click the button (you can be anywhere in the row) - the first button adds t...
Try this =IF(ROWS($A$1:C1)>$B$1,"",$A$1&IF(ROWS($A$1:C1)<10,"0","")&ROWS($A$1:C1)) Rows with an expanding range - this turns formu...
Could you add a sample workbook so we can see what is going on and save us from recreating the data?
textjoin came up with the name error as you must be on an older version of excel
I dont think that NumToWords is a proper excel formula - i seem to remember seeing a video where someone created a massive fomula to convert numbers t...