Payment received.
Posts by S M C
-
-
Code is ready. Sending Paypal Details to your PM
-
Will look in to it
-
Cool. Thanks for posting it back here.
-
-
I will share my email ID with you
-
Use this in E19 and drag down and across.
PHP=IFERROR(SUMIFS(OFFSET(INDIRECT(Variables!$B$3),,MATCH('Labour Days'!E$15,INDIRECT(Variables!$B$4),0)-1,,),INDIRECT(Variables!$B$3),'Labour Days'!$A19,OFFSET(INDIRECT(Variables!$B$3),,1),'Labour Days'!$B19),0) -
Could you check again. Haven't received it yet.
-
Sent you my mail-id
-
I will have a look at this. Do you have a sample file.
-
Please check the attached. Not sure if this is exactly how you wanted it, but probably a starting point.
-
Try =SUMPRODUCT(--(TRIM(O6:O1005)=TRIM(F1)))
-
What happens when there are 3 duplicates?
-
Not sure exactly what you are trying to do, but assuming you are trying to track the status of training of individuals based on what's the training start status, and what I could understand, use this formula in column K. Sample file attached
[SW]=IFERROR(LEFT(INDEX(A1:J2,,SUMPRODUCT(MAX((A2:I2="Start")*(B2:J2<>"")*COLUMN(B2:J2)))),1),"Not Started")[/SW]
-
Code
Display MoreSub ConvertYMDTextToDMYDate() Dim rngWithTextInYYMMDDFormat As Range Set rngWithTextInYYMMDDFormat = Worksheets("Name Of Your Sheet").Range("A2:A27") With rngWithTextInYYMMDDFormat .TextToColumns Destination:=.Cells(1), FieldInfo:=Array(1, 5) .NumberFormat = "DD/MM/YYYY" End With End Sub -
Hey Judy, good to hear from you again.
The earlier responder had a 64-bit SYSTEM running 32-bit Excel... no help at all!!
same with me. So I guess I won't be of much help either. -
Were you able to get a solution to this?
-
Re: CAD 25$ (About 20USD) - Auto-exporting about 150 PDFs causes a crash after about
Alright Wigi. Cheers mate.
-
Re: CAD 25$ (About 20USD) - Auto-exporting about 150 PDFs causes a crash after about
I'll give a try if this is not resolved yet
-
Re: Search record by Full Name and multiple saves as PDFs USD $30.00
Please check the revised file.
Yes, I have worked on Excel forms.