@herofox glad you like it. Normally, single formula solutions are used to avoid duplication of work which saves time as one doesn't need to type or edit the fourmlae repeatedly. Plus, in many scenarios it offers dynamic & robust solution.
hi, Since it is always 4 digits.. you may even try this for the fun sake.
MID(A2,MIN(IFERROR(FIND(ROW($1000:$9999),A2),"")),4)
It is almost on the same lines what Bosco suggested
Acknowledge with CTRL + SHIT + ENTER
here is the simpler one ..
Acknowledge with CTRL + SHIFT + ENTER
IFERROR(IF(J6="","",LOOKUP(SMALL(IF($J$6:$J$99<>"",ROW($J$6:$J$99)),1+COUNT($J$6:J6)),ROW($J$6:$J$99),$J$6:$J$99)-J6),"")
Here you go !!
Frankly speaking, I am not happy with this since I know there must be a simpler way of doing this.. I am working on an alternate solution..will share as soon as I am done.
Meanwhile, you can try this:
Acknowledge with CTRL + SHIFT + ENTER...
Hi,
Count of customer who ordered atleast once in last 3 months..
SUM(N(MMULT($L$2:$N$363,{1;1;1})>0))
Count of customer who have not ordered in last 6 months..
SUM(--(MMULT($I$2:$N$363,{1;1;1;1;1;1})=0))
hi
Put the below formula in B1 and drag it right and down..
TRIM(MID(SUBSTITUTE(SUBSTITUTE(" "&$A1,"/"," ")," ",REPT(" ",99)),COLUMN(A$1)*99,99))
Attached for ref.
I have done an interim fix, however, will fine tune the snippet tomorrow. Time to go !!
Option Explicit
Option Base 1
Sub test()
Dim Seq() As Variant
Dim n As Integer, x As Integer, ColNum As Integer, sCreate As Integer, tCreate As Integer
Dim TotalSeq As Long, nElmnt As Long, p As Long
Dim...
Use the below macro - attached for ref
Option Explicit
Option Base 1
Sub test()
Dim Seq() As Variant
Dim n As Integer, x As Integer, ColNum As Integer, sCreate As Integer, tCreate As Integer
Dim TotalSeq As Long, nElmnt As Long, p As Long
Dim cell As Range
For Each cell In Range("B51:Z51")...
Another solution using formulae.
Follow the below steps:
Copy data from Column A to Column J of “Original” worksheet and paste it on new worksheet e.g. “Output”
Select Column A:J of “output” tab and remove duplicates.
Use the below formula in K2 of Output tab...
I am using the below formula to achieve the result that you already have and in a few cases it is different.
Can you use the below formula and compare with your results plus highlight the rows where the result should be different. Also, please mention the reason why should it be different and...
hey @paulcherianc
Can you please explain the purpose of matching the date in cell S1 with header in X3:BL3 and then selecting the column AH individually.