refrence

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?