Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Let's assume that the date you are starting from...

    Let's assume that the date you are starting from is in cell A1.

    If you are happy to ignore the effects of leap years then you can use the simple formula =A1-365

    If you need to be exact, you can...
  2. Replies
    0
    Views
    41

    Invisible contacts !

    Outlook 2003

    Sometime ago I "lost" my contacts. When I tried to create a new list Outlook said that Contacts already existed, so I named the new list Addresses, imported the contents from a backup...
  3. Replies
    2
    Views
    114

    http://www.microsoftstore.com/

    http://www.microsoftstore.com/
  4. Replies
    11
    Views
    987

    After a bit of research into the helpful...

    After a bit of research into the helpful suggestions here I went for CompanionLink.

    More expensive than gSyncit but so easy to buy, to set up and to use that I'm happy with the higher cost.

    2...
  5. Thread: Copy & Paste

    by MartinM
    Replies
    4
    Views
    108

    Probably not a MS problem. Some possibilities:...

    Probably not a MS problem.
    Some possibilities:
    * A dirty keyboard, or not pressing firmly enough
    * CTRL C doesn't work when a cell is in edit mode, or when the workbook isn't the active Window...
  6. http://office.microsoft.com/en-gb/excel-help/calcu...

    http://office.microsoft.com/en-gb/excel-help/calculate-a-compound-annual-growth-rate-cagr-HP001122506.aspx
  7. Replies
    11
    Views
    987

    Windows XP market share is 25.27% as of last...

    Windows XP market share is 25.27% as of last month so there a more than a few million users who can't be bothered with the update carousel.

    I'm one of them: XP/O2003 is functional, stable and has...
  8. Replies
    11
    Views
    987

    Thanks Superman. However I am using Outlook 2003...

    Thanks Superman.
    However I am using Outlook 2003 and I wanted 2-way synch.
  9. Thread: SyncPST

    by MartinM
    Replies
    2
    Views
    97

    I can't answer your question, but I'd recommend...

    I can't answer your question, but I'd recommend editing your email address out of your post before the world and his brother harvest it for spam !
  10. Replies
    11
    Views
    987

    Thanks Joe, Looks good - I'll check it out...

    Thanks Joe,
    Looks good - I'll check it out
    Martin
  11. Replies
    11
    Views
    987

    Indeed I don't - Google has turned out to be just...

    Indeed I don't - Google has turned out to be just another "reel 'em in and exploit them once escape is too difficult" enterprise.
  12. Replies
    11
    Views
    987

    Synching with Google calendar

    I very much liked the ability to synch my Outlook Calendar with Google Calendar using Google's own app - in effect making my Outlook Calendar web-accessible.
    Out of the blue today, I received the...
  13. Replies
    10
    Views
    170

    What an interesting thread ! I found some good...

    What an interesting thread !

    I found some good advice here - worked for me: http://www.rondebruin.nl/win/s1/outlook/openclose.htm
  14. Incheon

    Incheon
  15. Hi Z, That's amazing, I was born in Leeds ! M...

    Hi Z,
    That's amazing, I was born in Leeds !
    M (80% there)
  16. Really am dashing away now (to Ulaan Baator) but...

    Really am dashing away now (to Ulaan Baator) but meantime take a look at this:
    ...
  17. That's not so easy :o: To print a pdf file you...

    That's not so easy :o:

    To print a pdf file you need to instruct your pdf reader to open the file, and then to print it.

    If you are using Adobe reader, for instance, that will not accept command...
  18. Although this article is fairly basic, it is a...

    Although this article is fairly basic, it is a good diagnostic to set you off in the right direction:

    http://support.microsoft.com/kb/2779852
  19. Use RG's suggestion, or: Instead of...

    Use RG's suggestion, or:

    Instead of =SUM([range]) use =SUMIF([range],"<>#N/A") or =SUMIF([range],"<1E100").

    Both work: the first one just ignores #N/A errors, the second one ignores all errors.
  20. Replies
    13
    Views
    367

    Can you show us the two strings please ?

    Can you show us the two strings please ?
  21. Replies
    11
    Views
    409

    Elegant indeed. I'm still using Excel 2003 -...

    Elegant indeed.

    I'm still using Excel 2003 - happy in all other respects though.

    This construct at least ignores ALL errors rather than specific ones, works with both positive and negative...
  22. Replies
    11
    Views
    409

    Elegant indeed :-) The code looks exactly what...

    Elegant indeed :-)

    The code looks exactly what SUMIF() does, except I can't get the syntax for using ISNUMBER() as a SUMIF() citerion.

    I preferred a formula in this, as in other cases, because...
  23. Replies
    11
    Views
    409

    Thanks Fred, that works and is nicely general. ...

    Thanks Fred, that works and is nicely general.

    And we seem to be proving that there isn't what I'd call an elegant solution.
  24. Replies
    11
    Views
    409

    Neat idea, but unfortunately there are some valid...

    Neat idea, but unfortunately there are some valid negative numbers in the range :-(

    You are observant ! I came back to Wiltshire from Japan a week ago, back in August via Outer Mongolia (yes,...
  25. Replies
    11
    Views
    409

    OK - answered my own question :rolleyes: In...

    OK - answered my own question :rolleyes:

    In case anyone else needs to know . . .

    =SUMIF([range],"<>#N/A")

    I was complicating things by looking for ISERROR or ISNUMBER solutions.
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4