• 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

    how to sum a column if criteria column # 0

    Hi Roypabitra, One more approach. =SUM(IF(B2:B6>0,A2:A6,0)) Note: This is an array formula. Need to press ctrl+shift+enter after pasting this in a cell. Thanks
  2. A

    Auto increment by 1 within text

    Hi, If your question is regarding increasing the number you can do any of these. 1. Type the formula =row() (if data starts from first row) 2. in cell B1 type formula =A1+1 Thanks
  3. A

    Text data

    Hi GGGG, If your concern is not to bother Vlookup function then you can use text to columns as Deb said. 1.Select column.. Text to Filter 2.Select delimited option and Next and again Next 3. Select Text format under column data format tab and click finish. Thanka
  4. A

    Cell showing the formula instead of result/ F9

    Hi GGGG, Try the following steps: 1. Select your range 2. Press Ctrl + H (For find and replace window) 3. Enter = (Equal to sign) on both Find what and Replace with textboxes 4. Hit Replace all. Thanks
  5. A

    SImple FORMULA question in Excel

    Hi, If you are expecting result in a single cell try something like this.. =SUM(X1:X250)+(SUM(X1:X250)*3%)
  6. A

    Create filtered list in new worksheet

    Hi JB, If you have any workings to find the % of attendance then it can be donw by Pivot. Thanks
  7. A

    Count the number of months

    Hi Serene, You can use the datedif function. =DATEDIF(start_Date,end_date,"m"). However, Since your dates are in text format could you please share few examples? Thanks,
  8. A

    How to use Vlookup in Excel.

    Try using Index + Match functions
  9. A

    Hi Chandoo.. I am your new user

    Hi Ramesh, You are welcome. There are tons of useful info availaible on this site. You can search artilces which you are looking for and become an Excel hero :-) Thanks, Anand
  10. A

    Hi Chandoo.. I am your new user

    Try =DATEDIF() Function Syntax : =DATEDIF(start_date,end_date,"d")- will give result in days =DATEDIF(start_date,end_date,"m")- will give result in months =DATEDIF(start_date,end_date,"y")- will give result in years Thanks, Anand
  11. A

    Advanced VBA macro courses

    Hi T100, Even I am new to VBA and I would like to share few things which i follow. * Maximum usage of help window - The reference library in help function has all the major topics in it. * Use youtube videos - there are lot of videos which has very neat explanation of concepts and codes...
  12. A

    sumproduct with multiple strings

    Hi Narayan, I am new to this forum and to be honest i am very much impressed on the way you guys address the queries. You guys are awesome and the best !!! Coming to the point, Can you help me on understanding the subtotal part of the formula (SUBTOTAL(103,OFFSET(F2,ROW(F2:F236)-ROW(F2)) ...
Back
Top