Search results for query: *

Thanks Skip (& Deniall)-- What I'm aiming for is obviously the sum of the column you've labeled "Both" or 2 in your example above.

How is this example, with my data in array B2:D4 and the two voting dates of interest in cells C6 and C7 Name voted1 voted2 voted3 Terry 11/8/16 11/5/13 9/10/13 Than 11/5/13 9/10/13 11/4/08 Tim 11/8/16 11/4/12 11/5/13 Voters who voted on: 11/5/13 is 3 =SUMPRODUCT(($B$2:$D$4=$C$6)*1)...

Returning after a lengthy absence (had a son at age 60, now 2): I can't believe how skills atrophy!! Here's my sumproduct, on some voting data, which consists of 37592 rows: SUMPRODUCT(1*(Data!$AR$2:$DB$37592=$C$1)) where $C$1 is an election date, gives me a count of those who voted on that...

Actually, the only references are to other worksheets within this one workbook. And I have turned off calculation, as far as I know. Any moving around at all, anything in this workbook file, is turning it and everything else on my computer, including screen redraws, into absolute molasses. I'm...

I have a spreadsheet that takes 2 minutes to open, and the same to display a cell whose formula is merely a link to another cell in a different work sheet, i.e. Sheet2!A1=Sheet1!A1. The result does not display, but only the formula, until I place the cursor to the right of the formula and hit...

Thanks Skip-- When I created that Module and tried to run it, I get: Object variable or With block variable not set (Run-time error '91'). And the answer to your first question is: I'm not sure--but the fact that one of them comes up as PivotTable3 (not so named by me!) suggests that I have or...

When I look today at the pivot chart I created yesterday, I have a problem "finding" the pivot table from which I created it. I cannot right-click, or find the "source data" or "series" readily at hand. Indeed even recreating what I have done is tricky, making documentation a problem. What is...

I am making progress, and still poking around for further tutorials on pivot tables & charts. I'm hesitant to refresh data as this invariably plays havoc with the charts, and the suggestion above for grouping (e.g. by hour, in a column of discreet times) is not something I can get to work...

Wow that was quick-- More importantly, succinct, thorough and correct. Thank you anotherhiggins. I need to find a pivot table tutorial so I won't miss easy shots like that!

I am trying to chart the occurrence of events, as a function of their time of day and their location. I'd like to be able to group all the times into 24 discreet hourly segments, so that an event at 01:14 is grouped with an event at 01:54 but not with 00:54, etc. The events occur in locations...

You were correct! My data had come in as text, apparently. So Formatting in Excel as dates created the illusion of dates, when from a calculating standpoint, it was still text! I'm better now...

I am, when I run the datevalue parameter. So my question is, if my dates are text, how best to convert; they came from csv values I believe?

I have verified real dates, and I am using the assumed date format (the other, dd/mm/yyyy would still give me a non-zero answer). =COUNTIF('Processed since Go Live'!B2:B1436,">" & DATEVALUE("09/01/2007")) is returning zero when it should count about 40 dates. Originally I thought I needed DCOUNT...

Thank you for the reply-- Here is my cell text, accessing a range of date values in an adjacent worksheet: =COUNTIF('Processed since Go Live'!B2:B1436,">" & DATEVALUE("09/01/2007")) Why am I getting zero, or value! when I can see that I have some 40-odd date values in that column range of dates?

A simple question, that I could not find addressed in MS Help or in Que: What is the proper syntax to do a count of dates in a column/range which fulfill a criterion such as >01/01/2001 or between 01/01/2001 and 12/31/2001? If the answer involves serial date formatting, I can deal with that...

Thanks, Leslie What those 104 semi-duplicate records are is not weirdness, but merely cases where a doctor was hired at two or more facilities on the same date, thus appearing in that query as: D.DrName Start Date Facility A.DrName MinDate AEMD 10/10/2006 LIJ AEMD 10/10/2006 AEMD 10/10/2006...

My original table has about 740 records, i.e. doctors, with one or more start dates at one or as many as four facilities. The query gives 844 as a count, so I believe the extra 144 are double-counts, or "cross-affiliated" individuals who began at two or more facilities on the same day, that day...

Pretty good, if not pretty! However I still am double counting records such as what is above: ok if there are records that look like : DRName Start Date Facility DCR 2/5/2008 GC DCR 2/5/2008 LIJ DCR 2/5/2008 NSUH DCR 3/4/2008 PV This...

I have incorporated the format syntax, but it's not working for me: sql of SELECT D.Facility, Format("mm/yyyy", ([D].[Start Date])) AS [Date], Count(*) AS Total FROM [EHS Normalized] AS D INNER JOIN (SELECT DrName, Min([Start Date]) As MinDate FROM [EHS Normalized] GROUP BY DrName) AS A ON...

That was a big help. With a slight modification, to give me different years (over a more than one-year period of months), I displayed the dates as follows: Facility Date Total GC 2/5/2008 3 GC 3/4/2008 2 GC 4/1/2008 4 LIJ 2/3/2006 1 LIJ 2/7/2006 30 LIJ 4/4/2006 8 NSUH 4/4/2006 15 This is just a...