Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: tyemm
  • Order by date
  1. tyemm

    MS Excel SUMPRODUCT help

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

    MS Excel SUMPRODUCT help

    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)...
  3. tyemm

    MS Excel SUMPRODUCT help

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

    Excel Paste Link Time-out

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

    Excel Paste Link Time-out

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

    Pivot Chart: referencing the underlying Pivot Table

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

    Pivot Chart: referencing the underlying Pivot Table

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

    Time Range as one of two criteria in Excdel

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

    Time Range as one of two criteria in Excdel

    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!
  10. tyemm

    Time Range as one of two criteria in Excdel

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

    DCOUNT and Dates

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

    DCOUNT and Dates

    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?
  13. tyemm

    DCOUNT and Dates

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

    DCOUNT and Dates

    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?
  15. tyemm

    DCOUNT and 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...
  16. tyemm

    Counting non-exclusives in a query

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

    Counting non-exclusives in a query

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

    Counting non-exclusives in a query

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

    Counting non-exclusives in a query

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

    Counting non-exclusives in a query

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

Part and Inventory Search

Back
Top