I have been trying to put the formula into a text box
=GETPIVOTDATA("AMOUNT",Data!$A$3)
But following error is showing
This formula is missing a range refrence or a defined name
hi guys,
i have an issue where the following index letter $E7$:$E$100000 changes whenever i enter a call to refrence sheet "Raw Data for PR Dist"
=IF(INDEX('Raw Data for PR Dist'!$E$7:$E$100000,MATCH(1,(A3='Raw Data for PR Dist'!$A$7:$A$100000)*(B3='Raw Data for PR...
Hi,
I have a weekly file. just for the eaxmple file names are: 4-Oct.xlsx, 11-Oct.xlsx, 18-Oct.xlsx.
now i am working in the file named 25-Oct.xlsx and i want to have a formula that can take values from the 3 above ( 4-Oct.xlsx, 11-Oct.xlsx, 18-Oct.xls)
i want to use a formula so next week when...
Good Afternoon Everyone,
A co-worker asked me a challenging question in Excel today. He has a listing of tab names written out in column B on a tab called "total order volume". He wants to return the value in cell C17 on each of the other tabs into column F on the "total order volume" tab based...
Hello all,
I am using Excel 2010. Looking for some help with a template i am creating for work to find duplicates that match both the column A and B values exactly in another sheet. I work with purchase orders and when a we are trying to track what purchase order AND line items vendors are...
hi all i am usinga lookup formula and need help the forumula is at the momnet
=lookup(d5,{1,2,3,},{11,20,3,0})
this forumul wil have over 100 numbers in each array can anybody advise how to use cell ref in place of actual numbers
For the life of me I cannot remember how to do this and I know it is easy!!
I need a formula that refrences Text in column A but counts the corrosponding row in another column.
So John Smith's total for Owner would be 1 and for Logistics it would be 4.
Stacy Jones' total for Owner would be 2...
I think I can write the code myself, I just need to know how to refrence a different workbook from a drive on my network in my code.
I think I need to have the macro open the workbook in order to use it? How would I go about doing these things?
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.