Recent content by Wulluby

My mistake, I touched it and took the array off the formula forgetting to put it back. This works great, thanks.

If I change A2 in your sample to 09-Sep-14, the result in D3 changes from 3 to 4 when it should remain as 3. If I then change another date, lets say A11 to 01-Nov-14 then the result in D3 again increases to 5.

Thanks for the input Somendra, the resulting answer should be 3 as only 3 days are worked in October in this sample. The 'Task performed' column should only hold 1 task, in the main file this is a drop down option that looks at a validation list of main tasks that may be performed in any given...

Have uploaded

Hello Chandooins! I have a question about tallying dates, with this one whenever I try to google it I am always overwhelmed with solutions on how to calculate the difference between 2 dates which is not what I am after. I have in column A a long list of dates, and column C contains a task...

To start with A cell containing - 10/09/2013 15:42 appears as 41,527.65 A cell containing - 10/15/13 09:16:17 appears as 10/15/13 09:16:17 After the macro is run then all come up with the long number. Just to add some background to what I am trying to do. When colleagues in other regions pick...

Looks a lot tidier, thanks Hui. Still not getting it into that custom format though so thinking it must be a regional thing at my end. Straight from the export, column B looks to be formatted: Custom - dd/mm/yyyy hh:mm Unless the middle digits or what it thinks is 'mm' is above 12 in which case...

Thanks for the responses, that first piece of code still does not change the format, the format remains in date format *14/03/2001. The data is downloaded from one system and uploaded to another after changing a couple of things such as headers. The contents of the columns are dates, as I am in...

I have a need to format a number of cells with custom format "m/d/yyyy". If I do this manually it comes out correct and uploads correctly. I recorded the making of this change into a macro but when I play it back that line does not seem to make the change. Selection.NumberFormat = "m/d/yyyy"...

Yeah, this is a nightmare to troubleshoot as I can't share the data being imported. On one week those blank cells will be counted as having contents by ">""")),"")) but on another week they will be counted by "<>")),""))). Only thing that changes is the data validation selection and the input...

That is why I manually change the data validation period so that users can't select in the future and think they are looking at something that hasn't happened. I import the data into multiple sheets, select the relative reporting period then paste values only in the YTD data so that it becomes...

Hey, no the results there is correct, it is counting where data in Import > header 3 matches the header above the formula and where there is also data under Import > Header 8. Issue I have is that in the production document the blanks are counted when they should not be. To fix the problem I...

Very simplified sample attached. I haven't got it to emulate the problem so I don't know how much this will help, what is interesting though is that if I use either "<>"&"" or ">""" I get the same result, whereas on my production file it does not. On the production file one will count all...

*groan* and just to confuse matters, let me add a correction: =IF(AQ$2="","",IF(SelectedPeriod=$D22,(COUNTIFS('sheet1'!$C$2:$C$1000,"="&AQ$2'sheet1'!$H$2:$H$1000,"<>"&"")),"")) Will get a sample up today.

Hi Hui SelectedPeriod is a cell, named range. The user selects a reporting period from a drop down in SelectedPeriod. $D22 will hold a reporting period in the format of 08 Feb - 14 Feb 14. Column D holds the reporting periods that SelectedPeriod looks at with Data Validation.