Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    9
    Views
    269

    RG & Maud...thanks for all your effort to examine...

    RG & Maud...thanks for all your effort to examine this. Your add'l analysis and conclusion, Maud, is quite shocking about the size of this database. Client will have to staff up to wash, rinse,...
  2. Replies
    5
    Views
    117

    Open your first file, then open your second file....

    Open your first file, then open your second file.
    Now from the top menu, select Window > Arrange > and click the vertical option.

    In 2010, it's different...it's under View.

    46517
  3. Replies
    9
    Views
    269

    http://casesearch.courts.state.md.us/casesearch//p...

    http://casesearch.courts.state.md.us/casesearch//processDisclaimer.jis?disclaimer=Y

    If you search for "A" (for example), there's a button at the bottom of the page to download to Excel all records...
  4. Replies
    9
    Views
    269

    Download from website

    A client of mine uses a government website that enables searches by individual last name. The search can take just the first letter of the last name and will return data for every person with a last...
  5. Assuming the dates begin in the A2 cell (e.g.,...

    Assuming the dates begin in the A2 cell (e.g., 1/28/2016), fill this down in the B column: =TEXT(A2,"mmmm")
  6. Good alternative, Maud (of course).

    Good alternative, Maud (of course).
  7. The ROW function returns the row number. So, on...

    The ROW function returns the row number. So, on row #1 of the sheet, the function returns a 1.
    So, I added the row number to 2015 to start the comparison at 2016.

    SUMPRODUCT find the total (SUM)...
  8. In the first case, just 2-D graph the B column. ...

    In the first case, just 2-D graph the B column. Then, select the x-axis values and from the Select Data option in Design, "Edit" your horizontal axis labels, select your A column.

    46375
    ...
  9. If row 9 contains the ACTUAL amounts, try the...

    If row 9 contains the ACTUAL amounts, try the following formula in A8: =SUMPRODUCT(("Actual"=G2:R2)*G8:R8)

    In B8: =IFERROR(A8/COUNTIF(G2:R2,"Actual"),0)
  10. You could make A4: =1+A3 and fill that down. ...

    You could make A4: =1+A3
    and fill that down. Then, entering the first of each month in A2 will make the other dates automatic.

    You could also make B3: =TEXT(A3,"ddd") and fill down and...
  11. Replies
    3
    Views
    677

    Perfect, DavidHLevin

    Perfect, DavidHLevin
  12. Replies
    3
    Views
    677

    Shortest Distance

    (Maud, better jump in early).

    A semicircle has a radius of r centimeters. A chord (not the diameter) is parallel to the diameter.
    If the length of the chord is 2/3 the length of the diameter,...
  13. Thread: Mow the lawn

    by kweaver
    Replies
    7
    Views
    247

    RussB: no it doesn't. BATcher: we have brown...

    RussB: no it doesn't.

    BATcher: we have brown lawns if any because of the lack of water here!

    45801
  14. Replies
    2
    Views
    153

    I assume you mean that each of the 139 cells has...

    I assume you mean that each of the 139 cells has a name that you want a folder named on your PC in some directory...is that right?

    I found some code that appears to do what you want:


    Sub...
  15. Thread: Mow the lawn

    by kweaver
    Replies
    7
    Views
    247

    He's slower but they're working together. How...

    He's slower but they're working together. How did you arrive at 105 min.?
  16. Thread: Mow the lawn

    by kweaver
    Replies
    7
    Views
    247

    Mow the lawn

    Ethan can mow three lawns in five hours.
    Stefan can mow four lawns in seven hours.
    If they work together, how fast can they mow two lawns?

    [show your work]
  17. Replies
    11
    Views
    993

    45750 Using WH in column A and the numbers in...

    45750

    Using WH in column A and the numbers in B, I wrote a concatenate statement in the 3rd column.
    Then, sorted columns A and B by the numbers in B. Does this work for you?
  18. Replies
    11
    Views
    993

    I guessing your "alpha numbers" are text...

    I guessing your "alpha numbers" are text representations of the numbers.
    Can you create a column that has them converted to numbers?

    In 2010 when a sort is attempted on these alpha...
  19. Thanks, RG. Those little quotes mean a lot! ...

    Thanks, RG. Those little quotes mean a lot! GROAN. But, I'm learning!
  20. Saving a file under VBA with cell reference

    In my macro I have this code that doesn't work.


    Selection.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
    "C:\Users\JOE\CompanyDocs\" & Range(A5).Value & ".pdf" _
    ,...
  21. Replies
    3
    Views
    181

    Perfect! Thanks.

    Perfect!

    Thanks.
  22. Good morning, Maud... The master workbook can...

    Good morning, Maud...

    The master workbook can be called DATA.xlsx and the tab that needs to be copied is called DATA.
    I can create another sheet in the DATA.xlsx file that has the full path and...
  23. I have to figure out how to easily carve up the...

    I have to figure out how to easily carve up the worksheet because there's a HIPAA issue/restrictions with confidentiality of data.
    Here's my best (hopefully) description.

    The end user is...
  24. If this were possible, it might be a work-around...

    If this were possible, it might be a work-around my issue:

    Can I copy one sheet from an Excel file and insert that as a new sheet into SEVERAL other excel files? All the sheets can have the same...
  25. jwoods: thanks for that suggestion, but I have NO...

    jwoods: thanks for that suggestion, but I have NO IDEA what I'm looking at or for here.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4