• 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

    Help me in understanding the sheet methodology

    Hi , Can you explain more clearly what you would like to understand ? What is the meaning of sheet methodology with reference to the workbook you have uploaded ? Narayan
  2. N

    Adding heat element to a XY (scatter graph)

    Hi , Agreed , but only the OP can explain what he wants to convey. Many points may have the same (x,y) value ; also many points may have (x,y) values closely clustered together ; are these two situations to be treated differently or in the same manner ? Unless it is known what the X-axis and...
  3. N

    work allocation to team members

    Hi , In Excel VBA , any name enclosed in square brackets [ and ] is a named range , which has been created using the Name Manager. Thus , [NumberOfNames] , [Employees] , [NumberofTasks] are all named ranges ; if you click on Name Manager in Excel , you can see the definitions of these named...
  4. N

    Count horizontally

    Hi , How will Excel know whether something is yet to be completed or not ? Narayan
  5. N

    problem when I try to add a new row or delete a row it's case error

    Hi , Deleting a row does not figure in points 1 through 4. Why are you deleting a row ? Narayan
  6. N

    problem when I try to add a new row or delete a row it's case error

    Hi , Unless you explain your requirement , nothing can be done. Please explain what you want to do ; going through someone else's code and rectifying errors is no guarantee that your requirements will be met. Narayan
  7. N

    Adding heat element to a XY (scatter graph)

    Hi , Beyond just putting the above points in different segments , how will just adding colours such as red , orange , yellow ,... add value or explanation to the above graph ? What is it that you want the above chart to convey ? Narayan
  8. N

    Count horizontally

    Hi , I do not understand why the first set of counts is highlighted in green , while the next set of counts is highlighted in red. Can you explain ? What we are doing with the counts is to increment the previous count by 1 if the present reading is equal to or above the threshold ; since the...
  9. N

    Countifs Formula Problem!!!

    Hi , Can you please upload your workbook ? In the absence of your workbook , I for one am not able to understand your requirement or your problem. Narayan
  10. N

    problem when I try to add a new row or delete a row it's case error

    Hi , The problem is that the range of cells you are deleting is $C$7:$I$19. Within the code , the reference is to the following : Target.Offset(0, -3).Value This means the code is trying to reference a column which is 3 columns away from column C , this is an invalid reference , since ...
  11. N

    problem when I try to add a new row or delete a row it's case error

    Hi , The error you have highlighted is in the code which is sending an email. I have not looked into this code at all. Can you do the following ? When the error is displayed , click on the Debug button ; execution of the code will be paused , and you can examine the variables in the code. In...
  12. N

    Dimensions of the accounts tree

    Hi , Is this code available in the public domain ? If it is not for general consumption , it should not be uploaded anywhere. Narayan
  13. N

    Count horizontally

    Hi , Is this what you are looking for ? Narayan
  14. N

    problem when I try to add a new row or delete a row it's case error

    Hi , What is the error ? Can you post a screenshot and explain the sequence of actions which generates the error ? Narayan
  15. N

    problem when I try to add a new row or delete a row it's case error

    Hi , See your file now. Narayan
  16. N

    format to Social Security Numbers in Excel doesn't work for some cells

    Hi , The numbers which are getting sorted , have been entered as numbers , 9-digit numbers , and it is their formatting which is displaying the hyphens. The numbers which are not getting sorted , have been entered as text , with the hyphens. Remove the added hyphens and you will be able to...
  17. N

    Behavior of the average function!?

    Hi , The formulas in the range C4:C38 are not all identical ; the range used in the first 33 formulas is $B$4:$B$37 , while that in the last 2 formulas is $B$4:$B$38. If you correct the first 33 formulas so that they also refer to the range $B$4:$B$38 , then the two averages will be identical...
  18. N

    Verification of date range and provide output

    Hi , See the attached file. Narayan
  19. N

    Index and Match

    Hi , That was not suggested as a solution. That was suggested so that if you could fill in the correct results and again upload the workbook , it would help to clarify the logic and verify the correctness of any developed formula. Narayan
  20. N

    Index and Match

    Hi , Can you manually fill up the range E2:E100 with the correct outputs ? Narayan
  21. N

    Required Volume & Percentage table....

    Hi , See the revised file. Narayan
  22. N

    Required Volume & Percentage table....

    Hi , See the attached file. Narayan
  23. N

    help adjust code show the data on listbox

    Hi Marc , The code is not mine. All I did was change the last parameter of the Search function from 0 , which is an invalid value , to 1. Narayan
  24. N

    help adjust code show the data on listbox

    Hi , See whether the problem is still present in this uploaded file. Narayan
  25. N

    help adjust code show the data on listbox

    Hi , Why don't you try it first ? Narayan
Back
Top