• 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.

Search results

  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 ?
  16. oldchippy

    Formula to get calendar day 15th

    Hi @Sasi Kumar To either formula just add to the end +TIME(23,0,0) Then custom format the cell to dd/mm/yyyy hh:mm:ss
  17. oldchippy

    Formula to get calendar day 15th

    Hi @Sasi Kumar I'm not quite understanding your question? Am I right in thinking that if the time is after (say) midday then it should be DATE + 23:00:00, but if it's before it should be the DATE + actual time?
  18. oldchippy

    Formula to get calendar day 15th

    @Sasi Kumar With the given date in A1, then try this =IF(A1-DATE(YEAR(A1),MONTH(A1),0)>14,DATE(YEAR(A1),MONTH(A1),0)+15,DATE(YEAR(A1),MONTH(A1)-1,15)) Edit: Can't seem to get this in one line?
  19. oldchippy

    Display of picture on selection from Drop down list

    Here's a video on how to do it
  20. oldchippy

    Excel Wedding Planner

    Hi @Busymanjohn A free version is still available here
  21. oldchippy

    Lottery Question

    When you've worked it out @NARAYANK991 let me know the answer as well :DD:DD:eek:
  22. oldchippy

    Extract number only

    If you also want the alphabets in another cell - assuming just one each end =LEFT(D2,1)&RIGHT(D2,1)
  23. oldchippy

    Happy birthday Hui..

    Happy birthday @Hui , you're catching me up!
  24. oldchippy

    Alphanumeric Text

    @Sasi Kumar If you need to know more about Tables take a look at this video
  25. oldchippy

    DATEDIF()

    Don't use DATEDIF, but use the formula @Khalid NGO posted in nr.10 above
Back
Top