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

    Highlight row with top 2 largest value

    Hi , Something like this ? Narayan
  17. N

    How to fix ClassFactory Cannot Supply Requested Class

    Hi , Does this mean anything ? Narayan
  18. N

    How to fix ClassFactory Cannot Supply Requested Class

    Hi , Can you go through this and say whether it clarifies the problem ? If not , I will explain in more detail. https://stackoverflow.com/questions/33798867/vba-userform-with-dtpicker Narayan
  19. N

    select range to be selected based on the active cell

    Hi , These are two different requirements ; resizing the screenshot can be done if the actual size constraint is known. Can you give the final dimensions to which the screenshot needs to be sized ? Hiding the empty cells has to be done in Excel before the screenshot is taken. This can be done...
  20. N

    select range to be selected based on the active cell

    Hi , See the attached file. Narayan
  21. N

    Weighted average from text values

    Hi , Try this : =SUMPRODUCT(($D$3:$D$5="Done")*LOOKUP($C$3:$C$5,{"High","Low","Mid"},{1,0.25,0.5})/SUM(MMULT(--($C$3:$C$5={"High","Low","Mid"}),{1;0.25;0.5}))) Narayan
  22. N

    Work Calendar

    Hi , I doubt that any help will be forthcoming , because the format of the calendar is such. Secondly , there is no data collected in one place in the workbook ; all it contains is calendars for various months , some of them with some data filled in , some blank. It may be easier if the data...
  23. N

    Need Serious Help on a Moving Bubble Chart - Please

    Hi , As an aside , this may be of some use : https://excelcharts.com/animation-interaction-and-dynamic-excel-charts/ Narayan
  24. N

    Need Serious Help on a Moving Bubble Chart - Please

    Hi , What do you mean by a moving bubble chart ? Narayan
  25. N

    Help me in understanding the sheet methodology

    Hi , What is your level of learning as far as VBA is concerned ? Do you want every line of code to be explained , or are there specific portions of the code which you want explained ? As far as learning VBA is concerned , there are many good websites which teach VBA starting from the basics ...
Back
Top