Hi Marsil Nothing attached, but to break it down (I am sure you know most of it) =IF(TRIM(LEFT(A2,LEN(C2)))+0=C2,"Ok","not Ok") Len(C2) gets ...
Its always better to upload an example workbook so we know how the data is setup Are you after something like this? =IF(TRIM(LEFT(A2,LEN(C2)))+0...
i thought the 15th issue had been covered by the calc i added in column H but you are right the 15th/16th issue was a problem, just no examples in the...
Is the attached what you are after? My columns are in a kind of orange colour Column F works out the lien date to 2 months from the due date rounde...
Jigar Panchal said Hi Purfleet, Thank you for your try..but that did not work as I wanted "1" on first occurrence, "2" on second occurrence, "3" on ...
Hi Carolyn I assume you are talking about the Test() sub as is the only one in that workbook but its not the one referenced by the Complete Button?...
i think it is because you are referring to an expanding range in a table - you don't need an expanding range as the table functionality already does t...
That's exactly what i was worried about
i cant believe that i type spilled instead of spilt and now i cant edit it. the shame of it!
Hi I am fairly sure that you can only use the # on spilled ranges, so you use =UNIQUE(B2:B11), then if you want to sort the output from thge unique...
I am not really clear on what you want, I am guessing some type of conditional concatenation. Can you just show one the issues and describe in a bit ...
Hi It is much easier to work on a formula if you attach a workbook so we can see exactly how the data is setup and we don’t need to spend time crea...
Hi Manny There isnt any data for Feb & march so i cant test any further but the below seems to work =SUMPRODUCT((TblHeadDays[Lot]=$G$5)*(Tbl...
Hi Have you read through this blog post? Might help you make a start Purfleet
Hello David Please see the attached. I have updated the formula in column F to be relative to todays date as it seems a bit more reliable (feel ...