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