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

  1. N

    Using Range name for pivot table

    Hi Srinidhi, As you can see from the formula, values in Row 1 (which is the heading row) is included. I'll share the workbook tomorrow from work. Regards, Ninad.
  2. N

    Using Range name for pivot table

    I have data from A1:K622 and I've created a dynamic range name "lstAuditMasterDetails" =OFFSET(AuditMaster!$A$1,0,0,COUNTA(AuditMaster!$A:$A),11). Row 1 has headers and data beginning from row 2. For the pivot table I am using this range name, but the field names the table picks for the data...
  3. N

    how can I delete the rows and column I am not using?

    Select and Hide.
  4. N

    Process flow chart

    @OP: Use the drawing objects. But XL is not best suited for flow charts. You may be better off with Visio. Depends on your purpose.
  5. N

    IF function not working properly (but only sometimes)

    @OP: can you post a sample file.
  6. N

    Ms Access - Combo Box

    Take the table which has the field (Category) you want. Make a query with only the Category field and use this query as your source to the drop down box.
  7. N

    Ms Access - Combo Box

    @vijay: definitely a post in the wrong forum. But if I've understood your problem (and correct me if I have not), you can create a dropdown from the menu and link to a query which can display the field values which you desire. In fact, IIRC, you can also use a wizard for this. I don't have...
  8. N

    If 6 working days in a week 2 holidays....networking days ?

    try the Networkdays.intl formula OR http://www.cpearson.com/Excel/BetterWorkday.aspx
  9. N

    Excel VBA

    To begin with you could try the Macro Recorder feature.
  10. N

    extract rows from different sheets to one sheet using date as reference PLEASE

    Try this in cells C7 of the worksheet 'Master' =INDEX(OFFSET('Associate 1'!$B$1,4,1,COUNT('Associate 1'!$B:$B),1), MATCH($B$2, OFFSET('Associate 1'!$B$1,4,0,COUNT('Associate 1'!$B:$B),1),0), 1) and replace "1" with 2,3, etc. as below for the rest of the cells. formula in...
  11. N

    Copy data from different sheets to master sheet

    Try this search "combine individual worksheets into single worksheets"
  12. N

    Determine max and min values for a range of cells

    @SirJB7: No worries. But thanks to you for the pointers. Now I can safely sum up my problem in words - MaxIf and MinIf :)
  13. N

    Determine max and min values for a range of cells

    @SirJB7 : "Tip". Didn't get it. Am I missing something ?
  14. N

    Determine max and min values for a range of cells

    @Kaushik03: You can be sure of seeing me here. Ain't going anywhere :)
  15. N

    Determine max and min values for a range of cells

    Hi bobhc, Here's the file. Results are in Sheet3. This forum gives so much. Extremely helpful and most of all, courteous folks around here. http://dl.dropbox.com/u/22668845/WP%20Marine%20Moves%20-%20NP%20-%20Rev%200.xlsx OR http://sdrv.ms/NzaA9d Regards, Ninad.
See more
Back
Top