references

I currently have a formula that references cells on another sheet based on multiple criterias. After much googling I've gotten it to work properly however I now need to sort the data without affecting the values. Currently if I sort as normal, the values change due to the cell references...

Hi all, Hope you're well. I am hoping for some assistance. I am trying to identify if there are any potential duplicate references in my spreadsheet and the system doesn't allow the same reference to be entered twice. So if there is a duplicate, it will somehow be slightly different. IE...

Hi, Is it possible to count comma delimited text in a column and return the value in the next empty column but do so based on the header found. (In this instance References to Find is the Header) Example <tbody> References to find Quantity Found A1,A2,A3,A4,A5,A6,A7 7 B11,B9,B20,B333 4...

Good Morning - I have created a text box in which I would like to put 2 cell references. The Cell References are Strings. I have tried, for example: =b40&char(10)&b41 and I get an error "The Text you entered is not a valid reference or defined name." If I put either cell in the box, it...

I need this formula =IF(SUM(AP18,BS18,CU18,DW18)>0,SUM(AP18,BS18,CU18,DW18)," ") to be written like the one below, but using the same line and column references as above. =IF(AND(ISNUMBER(N18*L18),MEDIAN(N18,L18,0)>0),N18+L18,"") Help please :confused:

I want to add "Microsoft Excel XX.X Object Library" to Excel. I have office 2003 so pretty sure XX.X is 11.0. But no such reference appears in the reference list. Googling for help gives this In VS, right click the references > Add Reference... > COM tab Then select "Excel 11.0 Object...

Apologies if a similar situation to mine has already been posted. I searched and wasn't able to find anything. I am using Excel 2016. I have a very long formula (much of which is shown below) and I want to drag this formula down abut 100 rows with each row moving the column reference one to the...

Hello, I'm working on shared files I created for multiple people to access on multiple computers (same type of computer, same excel 2016 software). It was working fine with the group I tested on, but as more people tried to use it, They’re getting an error that there is a problem within a...

I have the following data in a Pivot Table in column C: Value 10 20 30 40 50 60 70 80 90 100 Grand Total: 550 I would like to create a dynamic range that references only the last 5 records of the Pivot Table: 60, 70, 80, 90, 100. The formula I'm using is...

Morning All, I am trying to figure out a way to insert a blank row to separate data with different references within column D The amounts can always change but need all references clumped together for easier viewing Many thanks for any help!

Hi All, Is it possible to search the data within a formula rather than the text that the formula produces? I would like to return a value if a cell references a specific cell. i.e. =IF({A2 references C2},"Yes","No") Thanks in advance!!!

I'm trying to use a vlookup formula that references a cell to obtain the table name Example =vlookup(B3,C2,2,FALSE) I have mutliple tables in another sheet, all tables are uniquely named. I want the user to be able to change the value of C2 which will essentially change the table that the...

I have a scenario where I am attempting to convert .xlsm files to .xlsx. Scenario:1. Browse to a folder with say 500 .xlsm files 2. Open each file, strip out the macro code and save as a non-macro enabled file(.xlsx). I have code that achieves the above scenario; however, all of the .xlsm...

This should be pretty straight forward but I can't get it to work. I want to be able to enter a date in a cell in the first sheet and have it auto-fill a cell in a second sheet. I'm able to do that but when I sort the data in the first sheet the date in the second sheet changes to whatever date...

Hi there I have a cell which contains the following formula: =INDEX(C7:L46,MATCH(1,(A7:A1048576=O1)*(B7:B1048576=MROUND(O3,0.1)),0),INDEX(4:4,MATCH(MROUND(O2,25),6:6,0))) I need to cut and paste this cell into Sheet2 in the same workbook. The formula references automatically update as...

Hi Gurus, I am trying to fix few missing library references using VBA. I am able to use the same code on a sample file with a missing reference to Excel-Addin. However, it is not working on the main file with references to SAP Lib References and MS SOAP Toolkit References. I am adding the...

I asked this on Google but have gotten tired of my results because they are mostly outdated, like for XP or Win7, or older version of XL, etc. I understand that this may require going to the Control Panel but the references were too old for my Win10 machine. I just want to be able to read my...

I have a workbook model which separate teams all over theworld have restricted access to. I use this model to extract info from our GLwith Vision XL. Only the offices in London have Sun accounting softwareinstalled on the PC’s. <o:p></o:p> <o:p></o:p> We have recently done a Sun upgrade which...

So I have stumbled my way through creating a range that will change with the size of the data I am using, but I am wanting to cut that down some in order to do some formatting. Specifically I want "MyRange" (currently using A1:L17) to not include the top row (1) or the bottom row (17), or the...

Hey all :), Quite regularly in our company we need to copy a worksheet from one workbook to another. In the source book this sheet contains many references to cells from other sheets in the same (source) book. However, when copying the worksheet to a destination workbook I need to prevent the...