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

  1. R

    how to fill cells with the same value and then fill when the value changes

    Hi, I have posted the workbook agagin in the following link with comments and demo also.it will clear the picture for you. http://www.fileconvoy.com/dfl.php?id=g81c538fb97070a87999331522a0f36a7321b53388 Regards, Rahul
  2. R

    how to fill cells with the same value and then fill when the value changes

    i am posting the file with the link. all i need in this file is that cell a1 value should be get filled down till the next new cell comes with different vale and then fill the second value till next rows till the next new value comes. one thing to keep in mind is that their is difference in...
  3. R

    how to calculate aggregate [SOLVED]

    thanks a lot hui and narayank991 for replying "FAST" which is not under the rules on this site.thanks a lot.
  4. R

    how to calculate aggregate [SOLVED]

    Hi, i want that if a student passed in 4 or more subjects it should show the aggregate result in cell d9 as pass else if student failed in more than 4 subjects than it should show fail in d9. link for sheet1 problem mentioned below...
  5. R

    find duplicate values corresponding to name

    below is the link for file http://www.fileconvoy.com/dfl.php?id=g4bc98b0fb6d7a7f39993159481a0fae723975d29e i want empcode corresponding to the names.if there are duplicate names the empcode assigned to duplicate names should have same code. Regards, Rahul
  6. R

    Want to separate school,colleges university data in different sheets.

    please send the link of www.fileconvoy.com i can open only link from this site only.
  7. R

    Want to separate school,colleges university data in different sheets.

    i am using excel 2007 and text filter and contains options are not there in this version.i have to do it with formula.
  8. R

    Want to separate school,colleges university data in different sheets.

    I have data in sheet1. i want that based on name of company column all the corresponding details of that column should be placed in sheet2. Like if a2 is the name of college whole of the information of the corresponding row should be placed in sheet2,likewise i need to segregate all colleges...
  9. R

    vlookup question [SOLVED]

    thanks a lot webmax
  10. R

    vlookup question [SOLVED]

    i am not getting correct result in c2 column and down using vlookup approach instead of if condition.below is the link for file. http://www.fileconvoy.com/dfl.php?id=gab0329ab80a475c1999307434d4c78545a2825501 Regards, Rahul
  11. R

    vlookup query [SOLVED]

    yes its working you both were right.i forgot to execute the formula with ctrl+shift+enter. thanks a lot again
  12. R

    vlookup query [SOLVED]

    this formula is working for the first cell but when i am dragging it down its showing n/a for the rest of the 3 values.
  13. R

    vlookup query [SOLVED]

    haahaha instead World Health Organization should take sincere steps to ban keyboard manufacturing companies from putting caps and num lock keys or everytime the user presses it they should charge caps and num lock keys pressed per stroke from manufacturing companies. hehehe Regards, Rahul
Back
Top