Search:

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

Page 1 of 16 1 2 3 4

Search: Search took 0.02 seconds.

  1. Thread: sorting macro

    by jepalmer
    Replies
    2
    Views
    85

    Thank you so much for your efforts. Works...

    Thank you so much for your efforts.
    Works perfectly and a real time saver.
    Thanks.
  2. Thread: sorting macro

    by jepalmer
    Replies
    2
    Views
    85

    sorting macro

    I am combining two worksheets into a third and I would like to then sort the data by date/time for each well. Right now, Iím simply copying the 1st worksheet to a new sheet and then copying the 2nd...
  3. Replies
    1
    Views
    195

    download all links on a web page

    I would like to know if there is a program that will automatically download all of the links on a webpage.
    Suggestions?

    Thanks.
  4. Replies
    3
    Views
    592

    Physical damage on sector

    I'm trying to run a clone backup (Redo Backup) and keeps stopping because it finds 'physical damage on sector'. I've done a Win7 scan and attempt recovery of errors. Is there a way to 'set aside'...
  5. Replies
    1
    Views
    205

    gaining access to mapped drive

    Iím running Win8.1. We just replaced a server and changed the IP address. The drive has been mapped. A check of Windows Credentials confirms user/password are correct.

    If I start the computer...
  6. Win7 doesn't save my Server Access Credentials

    Every time I reboot, my Win7 computer requires me to enter password for the server before I can access it. The other 2 servers are recognized on boot up.
    We just put this server in, so that may be...
  7. Replies
    1
    Views
    143

    array formula question

    I just noticed that SUM and AVERAGE don't appear to work the same in array formulas. As shown in the attached spreadsheet, the 'hardwired' sum is the same as the array SUM, but the averages are...
  8. Replies
    2
    Views
    455

    remove old vpn

    when I click on the network taskbar, 3 VPN links are shown, 2 of which are old/no good. I can't figure out how to remove the old ones.
    Suggestions?

    Thanks.
  9. Replies
    3
    Views
    329

    Thanks for the info! A second thought: If I...

    Thanks for the info!

    A second thought: If I have the server mapped as the Z:\ drive, does that count as 3 characters or does the complete string (\\192.168.61.5\Projects) count as 24 characters?...
  10. Replies
    3
    Views
    329

    I can see them but I can't load them

    I was given some Excel files that appear in the directory and I can see the contents in Windows Explorer preview. But if I try to load the file into Excel, I get a "file could not be found error". ...
  11. Replies
    2
    Views
    576

    Data Validation/List Question

    I am using a list for data validation from an existing table and the table has empty cells, which makes for a long dropdown box. For example:


    CLF-033.3
    CLF-035.3
    CLF-035.4
    CLF-035.5...
  12. Replies
    3
    Views
    378

    separating numeric and text in a column

    I have data in columns in which some cells contain numbers only and some are numbers and text as shown in the attached. I would like to insert a column and move the text to the right of the numbers....
  13. Replies
    2
    Views
    504

    connect older zip drive

    I have a ZIP 100 (S/N PRFJ36339U) and I want to hook it up to my laptop. Is there a converter cable that I can use to connect to a USB port? The cable looks like a 25 pin serial cable. Is that...
  14. Replies
    3
    Views
    514

    Thanks! My data has headers, so I changed it...

    Thanks!

    My data has headers, so I changed it to:
    =AVERAGEIF(C:C,ROW()-1,B:B)

    And for my purposes, the first 52 weeks of the year will suffice
  15. Replies
    3
    Views
    514

    weekly average for daily data

    I have daily data for which I would like to calculate a weekly average. A bigger hammer approach is to do a 7-day running average and delete 6 points, but there has to be a better way? I'd start...
  16. Replies
    2
    Views
    328

    Thanks! BTW, your revision turned up an error...

    Thanks!

    BTW, your revision turned up an error in my typing in the dates, so DOUBLE THANKS!
  17. Replies
    2
    Views
    328

    Using countifs

    I would like to use the following formula and replace the dates with a cell reference.
    =COUNTIFS(Pith_Date,">=1/1/1995",Pith_Date,"<=12/31/1995",Pith_Q,">25")

    What I'd like is something like...
  18. Replies
    5
    Views
    640

    wow. THANKS!

    wow.
    THANKS!
  19. Replies
    5
    Views
    640

    assign variable in data fill

    I have a series of irregularly spaced data for which I need to fill in daily data. The data are recorded anywhere from every 1 to 3 weeks and the filled in data should be a linear series between the...
  20. Replies
    2
    Views
    481

    Thanks. However, it doesn't seem to make any...

    Thanks.
    However, it doesn't seem to make any difference whether "Ignore other applications that use Dynamic Data Exchange (DDE)" is unchecked or checked. There is no apparent change in behavior.
  21. Replies
    2
    Views
    481

    open *.xls in already open Excel 2007

    Every time I double click on a *.xls file, Excel opens a new copy of the program. How do I get Excel to bring the file into the currently open version?
    If I drag and drop, it doesn't do that, but...
  22. Replies
    8
    Views
    3,038

    Right click on the C drive in Windows explorer...

    Right click on the C drive in Windows explorer and select properties. Click on the security tab. What permissions are set when you highlight Administrators and Users?

    BINGO!
    That was it. Don't...
  23. Replies
    8
    Views
    3,038

    reply

    no to dual boot question

    attached file has screen shots of (1) error message that I get when clicking on the C: drive in windows explorer and (2) the folder settings (I reset to defaults)

    Also,...
  24. Replies
    8
    Views
    3,038

    c:\ not accessible

    I just started getting a message every time I try to use windows explorer to look at the c: drive -- c:\ not accessible

    and it isn't.

    I'm using windows 8

    suggestions?
  25. Replies
    0
    Views
    509

    explorer preview slow

    I've recently had a problem with one of my laptops. When using windows explorer and the preview pane, the preview is excruciatingly slow. This does not happen with other computers in the same...
Results 1 to 25 of 400
Page 1 of 16 1 2 3 4