Search results for query: *

Hi, I have an averageif formula that I'm trying to adapt (unsuccessfully) to give me the median instead. Can anyone advise where I'm going wrong or a better way of doing this? AverageIf works: =AVERAGEIF(OFFSET(Source!$A$1,1,MATCH("Incident...

Hi, I have a sumproduct formula that matches a reporting month and year in the format mmm-yy (cell I15) to a column of dates (colH). It then counts all rows where column N contains 'Late Start' as a substring. =SUMPRODUCT(1* (MONTH('Stats Tracker'!$H$2:$H2000)=MONTH(I15)) * (YEAR('Stats...

Hi, I have a long complex macro that is acting very strange and was after some advice. This macro does: 1.) Loops through 3000 or so rows (which will grow). 2.) On each row it needs to filter for a code in another sheet, copy filtered list, paste to a new sheet, sort by earliest date first...

Hi, I have a master worksheet matrix consisting of lookup values in column H and months in the format 'Apr-13', 'May-13', etc. in cells AF1:BE1 What I need to do is pull the 'actuals' sales figures in to the master worksheet. The actuals worksheet is in exactly the same format as the master...

Hi, I'm trying to create a formula that calculates the YTD value for April (start of our fiscal year) to the month selected in a validation list. I have multiple columns per month as shown below: Row 6 March March March March March March Row 7 Volume Volume ASP ASP Value Value Row 8...

Hi, Using a couple of different previous threads I have created dependant validation lists of unique values in Excel (e.g. choose a specific drug in column A then column B validation will show the different drug strengths for that drug only). The drug name and drug strength lists are in Excel...

Hi, Can anyone advise on how to enter date() or today() criteria into the Excel vba filter? I'm trying to exclude rows that have been added within the last 3 days. This command runs without error but does nothing: wb1.Sheets("Master").Range("A2:AS2").AutoFilter Field:=dateAddedToMasterCol...

Hi, Formula trouble! Can anyone advise on how to change the following formula to count ONLY ONCE if both columns Q and U are <> ""...

Hi, I'm trying (without much success) to build a rather complex formula. The first part marked in green is working. What I've got so far...

Hi, I'm trying (without much success) to build a rather complex formula. The first part marked in green is working. What I've got so far...

Hi, Can anyone spot my syntax error in this formula. It's driving me mad. I think it's somewhere in the "?"),"?"),"?"),"?"),"?"),"?")) part...

Hi, I'm attempting to calculate the days between two dates (normally easy enough). My problem is that the columns that contain the two dates can also hold text and so have the general cell format. Can anyone advise on where I'm going wrong in my formula? =IF(AND(O1>0...

Hi, I have an Excel sheet that I built years ago to calculate hours worked (great). But my latest employer required submission in decimal days. For example, an 8 hour working day=1, 4 hours=0.5, 2 hours=0.25, etc. Does anyone know a formula for doing this conversion? Any help or advice would be...

Hi, I have a sub that extracts selected (non-contiguous) dates from a very large worksheet (based on another column). I then need to compare these dates to one another to find the most recent date. I have copied a snapshot of my code below. My problem is I get a type mismatch error on the...

Hi, I'm trying to use a Word VBA find/replace to fill a word template table that is in an unusual format (MailMerge method dosn't work). I currently have a hard coded version working but when it runs the Excel data overwrites the formats of the table merge field. Can anyone advise a way to do a...

Hi, I have an Excel userform that has option buttons completely overlayed with labels (e.g. make them visible if something else is clicked). My problem is now that I've got a label on top of it how do I select the option button? Any advice would be much appreciated. Thanks, Roy

Hi, I'm a newbie when it comes to Word VBA and am trying to use something along the lines of the code below to do a mailmerge from Excel to a Word template containing multiple tables that contain merge fields. endRowshtName = ActiveWorkbook.Worksheets("ns1").Range("A65536").End(xlUp).Row...

Hi, I have a word table name string in the form of txtTableName: For a1 = 1 To tblCount ' count of word tables txtTableName = "txtTable" & a1 If Form1.Controls(txtTableName).Value <> "" Then 'do stuff End If Next a1 How can I convert this string to a Word.Table object so I can...

Hi, I've just used this to sort my data first ascending (row number column), then descending (name column): Set WS = wb1.Worksheets(vGroupName) Set rSortRange = WS.Range(vColumnLetterToSortGroupBy2 & "1") rSortRange.Sort Key1:=WS.Range(wb1EndColLetterPlus1vGroupName & "1")...

Hi, I have a problem that I can't seem to trace and would really appreciate some advice. I have been given an Excel 2010 VBA add-in style workbook to 'finish off' that has been fully tested and is working on everything from Windows XP service pack 3 to Windows 7. Unfortunately this needs to also...