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

  1. N

    Row() and Column() Fail in Conditional Formatting

    Dear Ed Please upload a sample file with your structured data
  2. N

    How to default Excel 2010 to open any excel file when 2010 and 2013 installed

    Deepak, I have followed the steps as you suggested. Still same problem........
  3. N

    Converting a table to a list

    Dear VikasT You can reconstruct the data inserting a column after location that will be Column D. In this column you can keep the Product name and prepare a PivotTable. You will get your required output.
  4. N

    How to default Excel 2010 to open any excel file when 2010 and 2013 installed

    I have installed Excel 2010 and Excel 2013. Those are working fine. When I try to open any Excel workbook from any location, it opens a blank Excel Workbook with Excel 2010 without opening that workbook. If I open Excel using Start>Microsoft Excel 2010 or Microsoft Excel 2013 and then Ctrl+O, I...
  5. N

    How create retirement planner in excel?

    The picture is not clear. Provide the link where you have seen the video then forum members may provide you the guideline to create this type of dashboard.
  6. N

    Gate Pass Number Generate Automatically....

    Happy to help you
  7. N

    Should I use TREND or LINEST to forecast sales data?

    You want to forecast your sales data. Sales is related to market demand, supply of material/product, margin, cost etc. anyway, you can solve your problem by statistical function regression. In Excel, you can solve regression using =FORECAST() Function.
  8. N

    Excel external workbook link issue

    Dear Dheeraj, You can check/followings points 1. You can try to keep all the 4 Excel Workbooks in a folder 2. Avoid to link from book1, book2, book3...... because when you open a new workbook it is named book1 or book2 or book3.... So the summary file will call data form this opened temporary...
  9. N

    I want to filter the values which begins with a particular number

    Thank you vrunda
  10. N

    Use of If Function to disburse the numbers from a particular range

    Dear Ram Mher, Would you kindly make the forum clear what is your output and Where your output will be set?
  11. N

    I want to filter the values which begins with a particular number

    Dear Ram Mher Think your data is from A1 to A6 Code 10025678 10123456 10221002 10021345 10045678 You want to filter the codes started by 100. So your result will be 10025678 10021345 10045678 Follow the steps.. 1. Set filter the range A1:A6 2. Click on the filter combo (A1) 3. Write 100* in the...
  12. N

    Negative Time Error

    Is your 2nd example correct? What should be the expected result? please clarify.
  13. N

    PowerPivot installed but not shown on Tab

    Dear bobhc, I know that and I agree with you. I think you also agree with me that older postings are gone to downward and most of the members observe only front page postings. I have replied a moment ago so that I can carry forward this issue to the first page.
  14. N

    PowerPivot installed but not shown on Tab

    Help Please.......
  15. N

    Gate Pass Number Generate Automatically....

    Dear Jamir, According to your quoted problem, type the formula in I3 =IF(B3=1501,181010,181010+B3-1501) and copy down Remember that, you have to validate data using condition that same IV no can not be repeat more than 15 times in the column B
See more
Back
Top