reference

Is it possible to reference a cell for it's text? The problem I am trying to fix is the following: =SUMPRODUCT(COUNTIF(January!E36:E36,{"Completely Satisfied","Very Satisfied"})) I am not in the January sheet. However, the cell E36 in the sheet I am in contains "AI", which is actually the cell...

Hello, The formula in my calculator answer cell is =F10/LOOKUP(F10,Sheet1!$B$3:Sheet1!$B$1000,Sheet1!$C$3:Sheet1!$C$1000)+F5 But I would like to reference a different "Lookup" depending on the value in F4 If F4 is below 15 I would like to reference columns B & C (as in the current formula...

I am trying to put the following formula in a text box ="Total: " & Data!B8 But I keep getting the following error: "The formula is missing a range reference or a defined name." Could anyone tell me what I am missing? I thought this was pretty straight forward..... Thank you Carla

I have a list of values in range B6:B52; each value represents a report. In column D, I have the name of the reports going down the column referencing column B such that: D6 = B6 D57 = B7 D108 = B8 D159 = B9 .. and so on As I add values to column B, the value automatically gets referred to the...

Hi, I have problem with my workbook, I solved first issue with user defined functions, but now I have very slow workbook, with small amount of data (comparing other workbooks I made), can somebody help me? reference to my last thread...

My Data Range is B2:G10 having 4 columns B,C,D & E. These 4 Columns are ‘continuous’ & have values which are either ‘INCREASING’ from B to E or ‘DECREASING’ from B to E. Reference range is from G2:G10 Output required: 1. I2=’Nearest’ value from B to E with reference to G 2...

Hi In a worksheet I am trying to generate data using a formula that points to different workbooks on a network by concatenating text and cell values. The original formula looks like this: code 1 =’\\Network address\customer\year\[order]worksheet’!cell reference This works perfectly but the...

Hi all of you, kindly require to provide me support so that to run a VBA code which should remove the 8 left characters through col. "C". Therefore that the row 1 are the headings and the code should run from "C2". I present below an extract with original data and expected result. Thank you all...

Hi, I'm using index match reference, but I have to change every formula one by one, is there a faster way? https://ibb.co/X2pcKzP See the photo attached, I have to change the formula in G56 from '[7 July Shop Yields.xlsx]1.7' to '[7 July Shop Yields.xlsx]2.7'! manually but whereby F56 already...

Hi, guys, I am using this formula in order to copy data from another worksheet. =INDIRECT("'[EU_Export costi immobiliari.XLSX]Sheet1'!G2") Now I need to pull dow this G2, but obviously I can't now with this formula. I think I need to add in this formula something with the row, something...

Morning, I have a list of monetary values that are associated to reference numbers. What formula can I use in order to sum up the monetary values of the reference numbers if they are the same reference numbers. For example Ref: #123 Value: £100 #123 £200 #124...

Hi, I have a Workbook that serves as an aggregation of data from several other external workbooks (same file directory). The workbooks being referenced are all uniform, so the specific sheet and cell reference is always the same in a column with the only thing changing being the workbook name...

Hi all of you, kindly require to provide me a VBA code so that, to run through col. “B” and where the reference is duplicate should add a letter at left side of the reference, starting from letter “A”. Therefore, that is double entry and so the letter should place the same in 2 lines and so on…...

Hi, I have a huge table with hundreds of values and then another table with formulas and inside the formulas are a reference to the values in the first table. I would like to have the values (each of which is different) inside the formula instead of having two tables. However, it would take me...

G’day Excel Gods, I have multiple files that reference a single MASTERFILEfor specific data. Traditionally, I have used a standard VLOOKUP formula, but this runs into problems if you want to add a column in the middle of the reference sheet later. It throws out all of the reference column...

I'm trying to reference a filename and path that I've created with a formula. I can't get it to work either in a formula or with a Macro.

Each day I get in a bank statement, and on there I need to search within the reference column for specific text in the form of invoice numbers. but to get around the fact the invoice numbers and letters are different, I want to make a table with these values in, but have wildcards in between...

Hi dear forum members, Is there a formula that would take a cell address and return the corresponding cell reference so I can then use this reference as an argument in other fonctions such as INDEX etc... ? Looking for a Non-UDF solution. Regards.

https://1drv.ms/x/s!AvjBsEPEq12ngTWjooUrD2AsRCFa?e=BpSibC I am trying to do a SUMIFS formula calculating the sales column if the country equals australia, india and china (actual data has more countries) =sum(sumifs(B2:B4,{ If I try to click on the cell to reference it, Excel doesn't let us...

I'm putting together a master list of phone numbers across the US. In order to keep things neat, each state is on a different sheet. Rather than change the formula 50x, I'm curious how I could adapt this formula so that it reads the cell that indicates the state...