Search results

Dear Ed Please upload a sample file with your structured data

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

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.

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

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.

Happy to help you

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.

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

Thank you vrunda

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

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

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

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.

Help Please.......

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

SirJB7, Thanks for your reply, recently I have installed in a separate PC with this same downloaded file. That has also Windows 7 and Excel 2010 (32 bit), it's working fine. So I don't understand what's happening now.

Operating system Windows 7 Microsoft Office 2010 I have installed PowerPivot (32 bit) successfully. PowerPivot for Excel is shown in the list "Interactive Application Add-ins" from File tab>Options>Add-Ins When I have selected COM-Add-ins from Manage list and selected GO, PowerPivot for Excel...

Dear joshallen78 Think your set of data is like below (A1:A12). in the set of data 1004 and 1005 are repeated. ProdCode 1001 1003 1004 1005 1006 1004 1009 1005 1012 1004 For listing out unique records from the above data, do the following steps. 1. Select the data A1:A12 2. Data tab>Sort &...

Hi Reddy G As you quoted data in your excel file and your required output should be 5557.89 You can type the formula and press Ctrl+Shift+Enter =SUMPRODUCT(B4:B9,IFERROR((C4:C9/D4:D9),0)) Output will be 5557.89 Regards, Muneer

Dear Access, Write =Now() and format the cell using custom ss;@ Regards, Muneer

You should also remember the following points. Limitations of INDIRECT Function: */ It could slow down your workbook, if used in many formulas. */ If the INDIRECT function creates a reference to another workbook, that workbook must be open, or the formula will result in a #REF! error. So if...

Thank you Hui for sharing this link. Regards, Muneer

P0lar, Please upload a sample file regarding your data. Regards, Muneer

HAPPY to help you!

Dear MaunishP Welcome to this forum! Please upload a sample file and quote your need. Regards, Muneer