• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Recent content by oldchippy

  1. oldchippy

    Changing only the column reference of a bazillion cells

    That's the magic of Excel :)
  2. oldchippy

    Please join me wishing ‘Happy Birthday’ (belated) to Narayan Sir !

    It's surprising how quickly these come along as you get older - Happy Birthday my friend :)
  3. oldchippy

    Date Calculation

    Well if you add 1000 days to 00/00/1900 you get 26/09/1902, so it's got something to do with that.........what that is.......your guess is as good as mine.
  4. oldchippy

    List numbering

    Hi @akay47, Welcome to the forum, take a look at this previous question, it may help http://chandoo.org/forum/threads/rank-changing-the-sequens-of-duplicate-values.24731/#post-148676
  5. oldchippy

    It's first 1,000 for vletm

    Well done, keep up the good work :cool:
  6. oldchippy

    Find in a string/cell

    Hi, Can you post a sample so that someone can help you find"DP" and its associated 7 characters? http://chandoo.org/forum/threads/posting-a-sample-workbook.451/#post-73705
  7. oldchippy

    End date in formula

    This should work =IF(AND(G$2>=$C3,G$2<=IF(LEN($D3)=0,TODAY(),$D3)),1,0) Copy across and down Alternative =IF(AND(G$2>=$C3,G$2<=IF($D3="",TODAY(),$D3)),1,0)
  8. oldchippy

    Congrats Asheesh for the 1000 post

    Congratulations on reaching the mark! :cool:
  9. oldchippy

    Hide cells based on value of another cell

    How about this way? http://www.pcreview.co.uk/threads/hide-cell-values-based-on-a-condition-in-another-cell.2947547/
  10. oldchippy

    Need to create pivot table from a Table with merged cells

    @Luke M Thanks for restoring the link ;)
  11. oldchippy

    Need to create pivot table from a Table with merged cells

    @vwwnab Hi, I've asked Luke to reinstall the link so that it works for you ..... give him a little time as he may be sleeping!
  12. oldchippy

    check rows

    See previous post here, it may help? http://forum.chandoo.org/threads/excel-2013-out-of-resources.23485/
  13. oldchippy

    Cell changes from text to number

    What happens when you use Copy/Paste Special/ All
  14. oldchippy

    Excel Experts coming to Australia

    @Hui... I'm surprised they haven't asked you to contribute to the summit with your knowledge of Excel, I'm sure you could teach them a thing or two
  15. oldchippy

    Excel Experts coming to Australia

    Are you going @bobhc ?
Back
Top