Search:

Type: Posts; User: kweaver; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. [SOLVED] If I understand this correctly, how about: ...

    If I understand this correctly, how about: =SUMPRODUCT((N1:N4=">0-1")*T1:T4)
  2. Replies
    12
    Views
    269

    (as a former NYer)...when the elevator doesn't...

    (as a former NYer)...when the elevator doesn't arrive as quickly as you expect, you press the button again ... repeatedly.
  3. Replies
    2
    Views
    70

    I think I solve it! YEAH!! Not as dumb as I...

    I think I solve it! YEAH!! Not as dumb as I look....LOL
  4. Replies
    2
    Views
    70

    breakout stacked data to single rows

    Best to look at the attachment while reading this.

    The real data file has several thousand rows. The listings are medical professionals and detailed data.
    The breakdown is by PA County which is...
  5. Replies
    18
    Views
    368

    Yes, RG, the data came from an internet source. ...

    Yes, RG, the data came from an internet source. I realized when I was doing this manually and then doing some look-ups on the data that there were unusual lengths, so in my master file I created a...
  6. Replies
    18
    Views
    368

    Here is a sample with only 1 tab and...

    Here is a sample with only 1 tab and substantially reduced in row number.

    Kevin
  7. Replies
    18
    Views
    368

    That chg solved that problem, but FYI -- I'm...

    That chg solved that problem, but FYI -- I'm still getting large gaps of blank rows with data above and below. Weird.
  8. Replies
    18
    Views
    368

    Got an error on yours, Maud.... 'DELETE ROWS...

    Got an error on yours, Maud....

    'DELETE ROWS WITH SPACE IN COLUMN 9
    For I = LastRow To 1 Step -1
    If .Cells(I, 9).Value = "" Then
    .Rows(I).EntireRow.Delete
    ...
  9. Replies
    18
    Views
    368

    Still lost the header row. Also, some very...

    Still lost the header row.

    Also, some very strange results, too...a lot of blank rows with data before and after them (on all sheets).

    Also, a few sheets still had formulas that used deleted...
  10. Replies
    18
    Views
    368

    RG. That was pretty fast but it didn't do a paste...

    RG. That was pretty fast but it didn't do a paste special values, so the resulting sheet was filled with #REF! errors. And, the column headers vanished - probably because you sorted everything.
    ...
  11. Replies
    18
    Views
    368

    Maudibe...that's what I did manually. Once I got...

    Maudibe...that's what I did manually. Once I got into the rhythm, it moved along quickly. Whew. It's done.
  12. Replies
    18
    Views
    368

    Thanks, RG. After 45 minutes, I stopped it and...

    Thanks, RG. After 45 minutes, I stopped it and it had only progress through slightly less than half of the sheets (12 of 26).

    Whew. Where's the bottleneck? In 45 min, I think I could have done...
  13. Replies
    18
    Views
    368

    Filter, select, copy, paste

    I have a workbook with 26 sheets. I want to filter each sheet for non-blanks using column I, select the filtered results from columns I - P, inclusive, do a copy then do a paste special values only...
  14. Thread: office 2003

    by kweaver
    Replies
    7
    Views
    167

    If you get a docx or xlsx from the newer version...

    If you get a docx or xlsx from the newer version of Office, you can open them in 2003 but will be missing any features used in the newer versions of Word or Excel. If (probably it won't) 2003 won't...
  15. Welcome to the lounge. If a county has a...

    Welcome to the lounge.

    If a county has a unique zip code in the mail file, you should be able to do a vlookup of the zip code in the customer file and populate the county column.

    Something...
  16. [SOLVED] These are really SLICK.

    These are really SLICK.
  17. Thread: US Citizenship

    by kweaver
    Replies
    15
    Views
    622

    Could it be that the person was born before the...

    Could it be that the person was born before the 14th amendment was enacted?
  18. Thread: US Citizenship

    by kweaver
    Replies
    15
    Views
    622

    Now you have me worried as I was born in...

    Now you have me worried as I was born in Pennsylvania and so were both my parents...guess I better check the legal records!
    Hmmm.
  19. Replies
    6
    Views
    238

    Can't argue with

    Can't argue with <2 seconds in Excel. Out of curiosity I moved the data to an array processing language (called APL) and the same calculation was virtually instantaneous.
  20. Replies
    3
    Views
    123

    Welcome to the lounge. In column B on Sheet...

    Welcome to the lounge.


    In column B on Sheet 1, try: =SUMPRODUCT((A1=Sheet2!$A$1:$A$20)*Sheet2!$C$1:$C$20)

    Change the range (currently row 20) to however many rows you have in sheet2.

    Fill...
  21. Replies
    6
    Views
    683

    Are you trying to take the data in 3 columns and...

    Are you trying to take the data in 3 columns and concatenate all three and place the result in another cell?

    If so, and your data is in A1, B1, and C1, and you want the result in D1: =A1&B1&C1 ...
  22. Replies
    2
    Views
    119

    Welcome. I'm not a strong VB person, but I...

    Welcome.

    I'm not a strong VB person, but I recorded this macro with your original "value" in H2.

    Sub Increment()
    '
    ' Increment Macro
    '
    Range("H4").Select
    ActiveCell.FormulaR1C1 = _
  23. Replies
    8
    Views
    276

    Are you referring to VLOOKUP and/or HLOOKUP? If...

    Are you referring to VLOOKUP and/or HLOOKUP? If so, you can use either with a "block" of data or a more formal table.

    VLOOKUP, for example, needs a value you're trying to find (first argument of...
  24. Replies
    7
    Views
    569

    When I fill up at the gas pump in southern CA, I...

    When I fill up at the gas pump in southern CA, I usually think this is the most expensive LIQUID.
    But, alas, I remember reading some time ago that liquids like King Cobra Venom (by the gallon) was...
  25. Replies
    7
    Views
    569

    It's the sum of the powers of 2 from 0 through...

    It's the sum of the powers of 2 from 0 through and including 63.

    In a related or slightly unrelated question, who is/was the richest individual in history?

    This is quite debatable based on...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4