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

  1. N

    Conditional formatting - lock cells based on other cells values

    Hi , Shouldn't that be : =COUNTIF(H$5:H$26,"x") = 1 Narayan
  2. N

    Find first non-blank cell value combined with =CELL("format"

    Hi , In my Excel 2010 , the CELL function remains G irrespective of whether a cell has been formatted BOLD or not. Narayan
  3. N

    Formula needed and get corrected

    Hi , At this rate , we will never get anywhere. Can you mention just one worksheet cell and the worksheet tab where you have a formula which needs to be corrected ? Just one worksheet cell. Just one worksheet tab. Unless this is given , please do not bother to reply with anything else. Narayan
  4. N

    Formula needed and get corrected

    Hi , I am not able to understand what formulas need to be fixed. Can you start with the first column where formulas need to be fixed , and explain what you want done ? Narayan
  5. N

    Formula needed and get corrected

    Hi , I don't think this is the correct file , corresponding to your post. Please check and upload the appropriate file. Narayan
  6. N

    Formula needed and get corrected

    Hi , Thanks.This file is OK. Narayan
  7. N

    Formula needed and get corrected

    Hi , The uploaded file gives errors when I open it. Can you ensure that your file is fully verified ? Otherwise , any uploads may be missing important parts such as data validations. Narayan
  8. N

    Roll Length Calculator

    Hi , If the diameters are entered in centimetres , and the thickness in millimetres , the result in metres is given in the attached file. Narayan
  9. N

    HELP Super Bowl Pool

    Hi , See the attached file. Narayan
  10. N

    Roll Length Calculator

    Hi , See the attached file. Narayan
  11. N

    HELP Super Bowl Pool

    Hi , I have not understood your requirement. Do you want names from C12 downwards to be the distinct names from the range C5:F8 or from C4:F8 ? Can you check out this post ...
  12. N

    Excel automatically change the font after enter data in new row

    Hi , I have no idea what is causing the problem , but using structured table referencing eliminates it. Use the formula : =SUMIF(Table13[col6],A1,Table13[col5]) in cell F1 and copy down. Narayan
  13. N

    Invoice Number increment with Formula

    Hi , Doing this without VBA is risky because it is entirely dependent on the recalculation method being manual. Excel has no foolproof formulaic method for detecting transitions , which is what you want here. VBA has the Worksheet_Change event which recognizes when a worksheet cell has been...
  14. N

    HELP Super Bowl Pool

    Hi , Can you check the attached file for the names in the range C5:F8 in the PAYOUTS tab ? Narayan
  15. N

    Excel automatically change the font after enter data in new row

    Hi , I have opened your workbook in Excel 2010 , and the same behaviour is present. Strange. What ever be the font of those cells which contain the formulas , what ever be the font size , the moment a new row is added to the table , the font of those cells changes to Calibri , font size 11...
Top