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

    Grand Total in Pivot Table

    I have a pivot table, the bottom field is Grand Total, I want this Grand Total at top of the Pivot, How do I do this?
  2. J

    How can prevent a sheet from cut copy pase ?

    How can I prevent a Worksheet sheet from cut copy & pase ?
  3. J

    How can we apply vlookup in ms Access ?

    I have 2 tables, tbl1 and tbl2, in first table i have following field: Emp_code Emp_name Basic Hra Convnc. other tble2 have the same fields, now I have an Emp_code in tbl2 and want to fetch all related values from tbl1 for that emp_code , how can I do this using join ?? thanks in advane.
  4. J

    How can we apply vlookup in ms Access ?

    How can we apply vlookup in ms Access ? Is this possible?
  5. J

    How to send only current sheet in email ?

    Hi I am working on a large excel file and want to send only current worksheet attached to mail (Outlook). how i can do this???
  6. J

    Keyboard Shortcut

    I have a cell in text format, I want to convert this cell as number format, which keyboard shortcut should i use ??
  7. J

    Highlight Duplicate Values

    Thanks to amrit1186, NARAYANK991, Excel_Kid_663
  8. J

    Highlight Duplicate Values

    I have some values in range A1:A34 between 1,25. I need a formula which highlights the duplicate values. Any help will appreciate.
  9. J

    Yet another good excel blog

    yes it is really very good !!!!
  10. J

    Which formula will work for desired result .. pls do fast

    Sir Actually one of my friend is facing interview, and this was his question, so I put pls do fast ,thanks for ur response ...
  11. J

    Which formula will work for desired result .. pls do fast

    Name Jan Feb March April May Vikas 120 90 132 138 133 Rohan 140 154 104 166 167 Shohan 135 154 102 147 123 Poonam 111 107 136 162 148 Radha 80 116 148 110 153 Ruchi 92 84 140 101 107 Savita 170 94 106 142 101 Sonam 128 124 156 88 136 Sani 143 125 167 109 102 Sahil 88 159 154 154 127 Ravi 120 139...
  12. J

    Count Unique values

    Yes Supero... actually i was looking such an array formula .. thanks for your revert...
  13. J

    About Profile Photo

    Thanks Narayan
  14. J

    Count Unique values

    yes it works !!!! Thanks Narayan ...
  15. J

    Count Unique values

    Thanks Narayan but it gives wrong result... in the below list we have only 8 unique values but both formulas return result 18... 111 103 111 104 110 105 110 105 111 113 105 115 113 102 107 112 109 120 117 104 120 100 106 108 101 103 120 105 108 114 101
  16. J

    About Profile Photo

    How can i change my profile photo of this forum?
  17. J

    Count Unique values

    please write down a formula to count unique values in col A: 10269 10272 10272 10279 10257 10266 10270 10261 10288 10266 10258 10263 10286 10279 10274 10272 10274 10265 10278 10282 10282 10290 10268 10287 10283 10256 10258 10272 10289 10263 10282 10271 10264...
  18. J

    HAPPY NEW YEAR TO ALL EXCEL MASTERS !!!!!

    HAPPY NEW YEAR TO ALL EXCEL MASTERS !!!!!
  19. J

    Sumifs Function

    Pls upload your worksheet and give me download link on box.com or dropbox.com
  20. J

    Conditional Formatting

    Thanks to all ......
  21. J

    Interview Questions ...

    How can we hide a worksheet so it can't be unhidden? How can we print the workbook's full path and filename in page header ?
  22. J

    Conditional Formatting

    Thanks Narayan, Actually I want to Highlight Salesman's Name who make Maximum sales.(i.e. Haseeb, Nafees, Rahim, Karim, Navin)
  23. J

    Conditional Formatting

    A B C D E F G H I 1 Haseeb 5701 9527 2704 2757 6968 6275 7799 2487 2 Nafees 4037 1372 5679 5343 8981 2612 4381 1184 3 Rahim 9751 4885 5790 8188 2445 1193 7138 5300 4 Karim 3574 8885 3462 1886 1975 9535 9985 5655 5 Navin 8781 9780 3591 4435 1470 5047 4528 2375 I want to highlight salesman...
  24. J

    Time Issue

    Thanks Suresh...
Back
Top