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

  1. G

    change file format (extension) in folder and sub folder in single go.

    Please help me in same, I am new to vba, know loop only for.....each.... how could I do this with for.....each....
  2. G

    change file format (extension) in folder and sub folder in single go.

    How Could I change file format (extension) in folder and sub folder in single go. is there any way to change .xlsx to xlsb. it would be great help. Regards,
  3. G

    Open as [READ-ONLY] - Excel file on server

    What do you mean by IMHO ?? Yes you are right that after restarting system it does not shows same.
  4. G

    Open as [READ-ONLY] - Excel file on server

    I am working with some files which are kept on server and sometimes it shows that file is already open by gauravkr how ever gauravkr has not opened the file. what could be the possible reasons for the same. Regards,
  5. G

    Planned Schdule, Actual Schedule & progress of excercise

    Hi All, In attached image I got visualizations challenges and as per my brain (if it is) it could be done by using blocks of webding1,webding2,webding3,webding4 fonts or similar family. pelase help me out
  6. G

    Wild Card not working directly

    Hui Sir, Thanks for reverting my concern but sir I we also use it in same way for countifs/vlookup it works there fine. so just for curiosity why it is not working here
  7. G

    Wild Card not working directly

    Hi All, Today I came up with a new problem I usually use wildcards for advance filter/find/replace/countif/vlookup but today I used it directly to check whether cell contains "DON*" or not but it didn't work. VALUE IN cell: DONE IN another cell: =cell="DON*" Image is attached Regards,
  8. G

    Target Line without secondary axis

    @Tiago MF - WOW .. a cool trick I was not aware of same thanks dude @Hui - Thanks a lot I used your solution around in 25 files of mine. Regards
  9. G

    Target Line without secondary axis

    Is it possible to create a graph with target line but without secondary axis. because graph figures are controlled by drop down and axis option for min/max & min unit/max unit are not same. file is attached for referenc Regards,
  10. G

    unable to drag and resize print area in page break view

    Hi All, I am came up with a new problem I have excel 2010 but now days I am unable to drag and resize print area in page break view. please help me out. and it is happeining in all files of my system
  11. G

    line graph not showing lines for single month data

    Hi all, please help me to get out of this thing, blue table is calculated file. all of the stuff is explained in attached image in understandable manner. thanks
  12. G

    Vlookup not working

    @Wudixin I missed below line Just open another workbook via the opened workbook thanks a tonne brother you help me a lot
  13. G

    Vlookup not working

    Wowww, Its awesome its awesome thank a ton bros
  14. G

    Advance Filter "Non Empty" cells

    Hi All, working with advance data filter, can you please suggest what should i do to get for criteria "Empty"& "Non Empty" cells together. currently * is working with "Non Empty" cells hope it is cleat please help. Regards,
  15. G

    Creating shape line but altitude

    Thanks Khalid/Narayan sir for your help, @Khalid i am using 2010 so keeping it 90 degree is not making it vertical altitude @Narayan sir, gr8 findings sir i am very happy with this new learning thanks alot you both
See more
Back
Top