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

    Sequential Numbering

    The below vba code generating serial number in other columns as well but i want restrict user to insert serials only in column B,secondly if the start number is greater than end range it should pop up message to inform user that you have put wrong range.Similarily it should not overwrite any of...
  2. A

    Sequential Numbering

    Hello Excel Experts, I have been looking for the macro since last week but with no luck till yet. Would appreicate the efforts if you please get me out of the problem that i am facing, I have created excel template (used it for coding list). What i am looking for is that: In Column B we...
  3. A

    pivot table does not give the answer required

    Hi tel57, Then you need to press CTRL+SHIFT+ENTER. Please locate your cursor on formula and press F2 (in editing mode) then press CTRL+SHIFT+ENTER Hope this helps! Thanks Ariff
  4. A

    SO MANY IFs

    Thanks Deb! Perfect in the sense that it gives me the desired result. I think greater and -ve marks can be controlled through validation which we will get it done,:)..don't worry But you people are really great! Thanks a lot!
  5. A

    SO MANY IFs

    WOW Deb you're awesome it seems to be working partially... one thing will make it perfect..what if a student get 0 marks in any of the column ? As i entered 5 in Quiz1 and 0 in Quiz 2.. it is giving me 100% though it should have resulted 50%. I have tried to amend your formula by adding "="...
  6. A

    beginning letters as display trigger in drop down using data validation

    Paramnayak, I guess you meant with "Auto Completion" if your current selection is already listed in above then it should definitely be appeared.(like as your example just typing "su" show the "sunday" if sunday is selected previously in the list then it should be appeared if not then, it will...
  7. A

    SO MANY IFs

    Dear Hui and Roy... Below is the link and both leads to same path... https://skydrive.live.com/redir?resid=F6306DECDB515F3B!318&authkey=!AJpG58dbqNDOgPU http://sdrv.ms/TUq4bF And Roy I have checked your formula =SUMPRODUCT($A$1:$F$1,$A3:$F3) it is not providing intended result...after...
  8. A

    SO MANY IFs

    Hi, This is my first post in this platform...factually in any platform other than Faceboook:) I have stuck with formula that i will try mys level best to make you people understand. I have table with 6 columns 1 - Quiz 1 2 - Midterm 3 - Quiz 2 4 - Assignment 5 - Class Participation 6...
Back
Top