Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    18
    Views
    244

    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...
  2. Replies
    18
    Views
    244

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

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

    Kevin
  3. Replies
    18
    Views
    244

    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.
  4. Replies
    18
    Views
    244

    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
    ...
  5. Replies
    18
    Views
    244

    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...
  6. Replies
    18
    Views
    244

    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.
    ...
  7. Replies
    18
    Views
    244

    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.
  8. Replies
    18
    Views
    244

    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...
  9. Replies
    18
    Views
    244

    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...
  10. Thread: office 2003

    by kweaver
    Replies
    7
    Views
    136

    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...
  11. 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...
  12. [SOLVED] These are really SLICK.

    These are really SLICK.
  13. Thread: US Citizenship

    by kweaver
    Replies
    15
    Views
    489

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

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

    by kweaver
    Replies
    15
    Views
    489

    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.
  15. Replies
    6
    Views
    201

    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.
  16. Replies
    3
    Views
    116

    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...
  17. Replies
    6
    Views
    634

    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 ...
  18. Replies
    2
    Views
    111

    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 = _
  19. Replies
    8
    Views
    248

    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...
  20. Replies
    7
    Views
    533

    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...
  21. Replies
    7
    Views
    533

    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...
  22. How about this: =ROW()&". "&"This is the text...

    How about this:

    =ROW()&". "&"This is the text item wrapped."

    with the column width adjusted so that wrapping will cause the lines to be under the numbered item.
  23. Correct me if I'm wrong, but if I use form...

    Correct me if I'm wrong, but if I use form controls and a set of radio buttons, don't they ALL interact with each other?
    I need, for example, 3 sets of 4 radio buttons where the 1st row of 4 can...
  24. See the sample here.

    See the sample here.
  25. That would be if I could get that dialog box for...

    That would be if I could get that dialog box for ActiveX check boxes and radio buttons. Am I missing something for ActiveX? Obviously.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4