Search results

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...

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"...

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...

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...

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...

Has anyone seen any VBA that will let me see who has a network file open? I thought I had found something with http://www.xcelfiles.com/IsFileOpenVBA.htm but this only seems to work with the xls files I check, it fails on xlsx files.

Hi all, I feel like I'm chasing my tail with something here and was hoping for some fresh creative insight :) In A1 I have test1|test2 In A2 I have test2|test3 In B1 I have test2 In C6 I have =IF(IF(ISERROR(FIND("|",A:A )),A:A,LEFT(A:A,(FIND("|",A:A ))-1))=B1,"1","0") with ctrl+alt+Ent...

Any quick pointers on what I am missing here would be greatly appreciated. I have dimmed a range with Dim rngRole As Range Filled the range Range(&#34;A1&#34;).Select Range(Selection, Selection.End(xlDown)).Select Set rngRole = Selection And now trying to populate a column with a vlookup...

Hi, Does anyone have any pointers on how to grab the text output of an exe. Scenario is that I have access to run an exe which when I run in my cmd window will give me my name. If someone else runs it from their machine it will display their name, seems perfect for putting into vba queries...

Hi, Hoping someone might be able to put me on track for something to replace the VLOOKUP in the following code. It works, but not if the situation has multiple ‘var1s’ for one entry Dim numRows As Integer Dim var1 As Variant Dim var2 As String numRows = ActiveCell.CurrentRegion.Rows.Count...

Hi, Looking for the correct way to translate =countif(u2r,cellvalue) to vba. u2r being a named range. I currently have the following which has been bodged into different variations. Dim numRows As Integer Dim c As Double Range(&#34;A1&#34;).Select numRows =...

Hi, Seems like a simple thing to do but it seems to be eluding me. Hoping for a pointer at how to remedy it or a link to somewhere I can read about doing it. I have a pivot small pivot table that has numbers in first column, 1, 2 and 3. The data in the second column is grouped by those...

Is excel meant to be able to handle more than one xlam? I am trying to run at least 2. One called Dev for working stuff out and at least one more that gets published out onto the network for a given team to use. If I add 'Dev' I don't see it by it's proper name of Dev in the...

Hi, Any tips on the best way to roll these out to a team? I have an xlam with a small number of macros in them. It's just been myself using them and I have just used add ins, tick the box, create custom ribbon, add each macro in individualy etc. There must be an easier way for this I'm...

Hi, Can anyone give me any pointers on how I can find if a date is either in this week, next week, beyond next week, last week or beyond last week? I keep wanting to use something like =if(r ,9) = weeknum then do something but that isn't doing it. I've tried putting it as an if formula in a...

Hi, I am trying to incorporate a line into a macro, the line should pull info from a cell which contains a file name. The filename will always be numbers.extension so for example 12345.txt, I have to pull the numbers only. I can think of 2 ways but wondering if there’s a ‘neater’ way to do...

Hi I am trying to format a column of numbers, an example being: 03/11/2012 to change to 11-Mar-12 02/21/2012 to change to 21-Feb-12 When trying to format the orignal column they wont budge, I have been able to get them to the format I want by using Data&#62;Text To...

Sorry if I have the terminology incorrect, I assume table 1 in the example at the following link to be a matrix; https://skydrive.live.com/redir.aspx?cid=b81cfd1b7bf7bb2c&resid=B81CFD1B7BF7BB2C!217&parid=B81CFD1B7BF7BB2C!195&authkey=!AOSA4wp7N7K-Q50 What I would like to do is convert that...

Hi, If I have a column of say 10 rows all of which contain a formula, 5 of which have TEXT values returned can I total those which just return the text? If I use counta it is counting the formulas as well. Thanks.

Hi, I have a very simplified table with randomised data on: https://skydrive.live.com/redir.aspx?cid=b81cfd1b7bf7bb2c&resid=B81CFD1B7BF7BB2C!213&parid=B81CFD1B7BF7BB2C!195 Is it possible to have excel change the tab colour for the Maternity sheet depending on date and data in Last Working...

Hi, Within a table I have 2 columns, one with text and another with numbers. An example being: Text1 1 Text1 2 Text2 1 Text2 2 Text3 3 Text3 4 Is excel able to pull this into another table in another sheet like so: 1 Text1; Text2 2 #NA 3 Text3 4 #NA The idea being that I am...

Hi, I have a table with one column containing a lot of duplicates: 'Data'!$A$8:$A$1000 I want to create a unique column in another sheet which I have done with: =INDEX('Data'!$A$8:$A$1000,MATCH(0,COUNTIF($AI$14:AI14,'Data'!$A$8:$A$1000),0)) The issue I am having is that it has also...

I'm not sure what I'm doing wrong here but any pointers would be appreciated. I am using the following formula =COUNTIFS('Gantt Chart'!H8:H1000,"&#62;0",'Gantt Chart'!I8:I1000,"",'Gantt Chart'!F8:F1000,"&#60;MIN(INT((TODAY()-'Gantt Chart'!AN5)/7)+1)") Value of the date calc is 5 and I...

Hi, I have a chart that is working with a scroll bar, in cell W15 I have the following formula: =INDEX($Q$15:$Q$78,$Z$38) I am now trying to add the ability to switch from viewing one set of data with another using: =OFFSET(W15,0,$W$38) If I am right in how I am interpreting this I need...