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

  1. V

    Pivot Table Grand Total

    I have to generate some additional calculation out of pivot table grand total, also I have report filter and with that reference row for each filter is keep changing, how write a formula so that my additional calculation always refer the grand total row based on the report filter values. Please...
  2. V

    ISBLANK Where Value is a Range

    Thanks Kaushik and Deb..its working fine..have a great day!
  3. V

    ISBLANK Where Value is a Range

    @Kaushik, Pls check your formula shows N only if A1 has data, if you keep A1 blank and you write some numbers in A2, A3, ...it shows Y..this is wrong i think
  4. V

    ISBLANK Where Value is a Range

    Hey, @sgmpatnaik Your formula is not working.
  5. V

    ISBLANK Where Value is a Range

    I want formula in different format, formula should look range of cells, if the all range cells are blank then it should display " Y " and if not display " N "
  6. V

    ISBLANK Where Value is a Range

    How to write a formula if range of cells are blank (I mean empty, no values)then it should display "Y" and if not display "N"
  7. V

    How do I compare and highlight the matches from two columns in Excel

    I have two columns of data in an Excel spreadsheet. I have to see that every value in Column A has a match in Column B. I understand that two columns can be compared and highlighted in Conditional Formatting using the Match function. The problem is that the the Match function in Conditional...
  8. V

    Restrict cell values in excel

    Yes, even with that its not working,
  9. V

    Restrict cell values in excel

    Hello, Its working fine only for small range of cells, i added same code for 4000 rows with 10 columns and if I pick any value from drop down list, excel will shutdown. Please suggest me on this. Thanks
  10. V

    Restrict cell values in excel

    I'd like to restrict excel values to X and Y only, I know Data validation will do this but , if I enter any other values that will indicate error and when I copy paste any value it won’t indicates error.I want to know hot to restrict copy/paste also for the validated cells.
  11. V

    Excel Sum for drop down list

    hello, let me try, in addition to the status and formula should look for the closed months also.. for example formula should count all the closed documents in JAN for client A and next formula should count all the on-time closed documents in Jan for client A, so that i can calculate the %...
See more
Back
Top