Search:

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

Page 1 of 17 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    3
    Views
    71

    Thanks. I'd rather get used to a new QA location...

    Thanks. I'd rather get used to a new QA location than lose the territory.
    BTW, windows versions before XP and Windows 8 get my vote
  2. Replies
    3
    Views
    71

    quick access toolbar height

    In moving from Excel 2010 to 2016, I noticed that the ribbons,tabs, and Quick Access toolbar take up more territory, about 3 rows worth on my laptop as shown on the attached screen shot. Is there...
  3. Replies
    2
    Views
    940

    Daisy-chain Wi-Fi?

    I have a wireless network with a NAS in my camper that is password (WEP) protected. When I'm on the road I either use my phone hotspot or a campground wifi for internet access. When I have the...
  4. Replies
    4
    Views
    514

    hotspot network

    is there a way that I can connect my cell phone hotspot to my router and NAS. That way I could have internet access through the router.
  5. Replies
    3
    Views
    559

    newbie NAS questions

    I'm looking to setup a NAS at home. I have a Verizon router (M1414WR) with a free LAN port.
    (1) I assume that any of the NAS devices will connect properly through the LAN?
    (2) Since data...
  6. Thread: sorting macro

    by jepalmer
    Replies
    2
    Views
    256

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

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

    by jepalmer
    Replies
    2
    Views
    256

    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...
  8. Replies
    1
    Views
    542

    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.
  9. Replies
    3
    Views
    1,006

    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'...
  10. Replies
    1
    Views
    350

    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...
  11. 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...
  12. Replies
    1
    Views
    272

    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...
  13. Replies
    2
    Views
    695

    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.
  14. Replies
    3
    Views
    473

    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?...
  15. Replies
    3
    Views
    473

    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". ...
  16. Replies
    2
    Views
    830

    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...
  17. Replies
    3
    Views
    563

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

    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...
  19. Replies
    3
    Views
    1,022

    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
  20. Replies
    3
    Views
    1,022

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

    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!
  22. Replies
    2
    Views
    424

    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...
  23. Replies
    5
    Views
    854

    wow. THANKS!

    wow.
    THANKS!
  24. Replies
    5
    Views
    854

    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...
  25. Replies
    2
    Views
    708

    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.
Results 1 to 25 of 405
Page 1 of 17 1 2 3 4