Search:

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

Page 1 of 16 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    1
    Views
    108

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

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

    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?...
  4. Replies
    3
    Views
    280

    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". ...
  5. Replies
    2
    Views
    460

    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...
  6. Replies
    3
    Views
    323

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

    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...
  8. Replies
    3
    Views
    395

    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
  9. Replies
    3
    Views
    395

    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...
  10. Replies
    2
    Views
    290

    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!
  11. Replies
    2
    Views
    290

    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...
  12. Replies
    5
    Views
    537

    wow. THANKS!

    wow.
    THANKS!
  13. Replies
    5
    Views
    537

    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...
  14. Replies
    2
    Views
    415

    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.
  15. Replies
    2
    Views
    415

    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...
  16. Replies
    8
    Views
    2,360

    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...
  17. Replies
    8
    Views
    2,360

    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,...
  18. Replies
    8
    Views
    2,360

    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?
  19. Replies
    0
    Views
    387

    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...
  20. batch print outlook message and attachments

    We have several pst files for which we need to generate a pdf of each message and attendant attachments.

    Is there a way in Outlook to print each message (and any attachments) in a folder as a...
  21. thanks!

    thanks!
  22. Importing PowerPoint slides with different aspect ratio

    I need to import slides that are in a different size thn the one Iím importing into. In other words, letís say I set my slide master to the 16:9 size and I want to add slides from an older PPT...
  23. Thanks to all. Since the dataset is reasonable...

    Thanks to all. Since the dataset is reasonable small, my workaround is to visually check the ones that don't have the correct date and then search and replace the excel date number; e.g., 40365.
  24. Exporting from Adobe produces wrong date format

    I have exported some pages from Adobe and the dates when imported look correct as mm/dd/yyyy. However, if I format them as a number or a date format some, but not all, format as dd/mm/yyyy. Any...
  25. Replies
    2
    Views
    1,901

    Thanks. Macro expanded waaay too much. Will...

    Thanks.
    Macro expanded waaay too much. Will learn to live with the IMAP limitations.
Results 1 to 25 of 394
Page 1 of 16 1 2 3 4