Search results

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.

I was dreading the request for a sample file, problem being the original file contains a lot of sensitive data although I understand the need for it in this case. I will create a sample document and see if I can get it to emulate the issue. Thanks

I have 2 formulas that appear to be behaving differently every alternate week, not so much the formula but the part at the end. =IF(AQ$2="","",IF(SelectedPeriod=$D22,(COUNTIFS('sheet1'!$C$2:$C$1000,"="&BR$2,'sheet1'!$H$2:$H$1000,"<>"&"")),"")) "<>"&"" being what is giving me issues, when I put...

Howdy Chandooins, Anyone know how I can stop this code from clearing my undo stack? The code is in a sheet and is used to determine which picture to display when a user selects a number from a drop down. If there is now way round it I can have it attached to a button that the user will have...

Thanks SM

My thinking was to start with seperate cells, then look for someway to combine the results.

Hi all, Liking the upload file option. Have uploaded a file to demonstrate what I am trying to achieve, how I’ve thought would be the best way to start going about it and where it has hit a dead end. The value in A9 determines what results I should pull back. How I would like those results...

Works a treat, thanks Shrivallabha!

Hi, It must have been a while since I last logged in, the new look looks good. Been banging my head on this one for a while, seems like it should be easy but I am missing something to make it work. I want the following in an address, the problem is that the cell references can vary each...

Just saw your message JB, just as I'm going out the door on my week off :) That one isn't telling me who has it open unfortunately, though I have only tested it on sharepoint files at the moment.

My mistake, I'm that used to calling it esink. It's Microsoft Sharepoint, http://en.wikipedia.org/wiki/Microsoft_SharePoint