#name

I have some lambda functions defined in the name manger. Is there a way to list the content of a lambda function in a sheet, just for reference? It is nice to see the full lambda function to study as the name manger is not optimal for viewing lambdas. For example, I named lambda, "fn", which is...

Good afternoon, I am trying to create a macro, which copies the shapes that I've created on my worksheet and pastes them on a specific presentation. I see my idea very clear, but I can't get it working... All my shapes are named through typing the name at the up-left corner (as you could do to...

Hi I have the formula below where I am trying to count how many cells have a colour and counting, where my range is to a and the cell colour is yellow which is p1, but the code doesn't work I get a #NAME ? please can u help? =ASAPCOUNTBYCELLCOLOR(A:A,P1)

I am getting the #NAME? error on this formula: {=INDEX(O6:O130,MODE(IF(O6:O130<>"",MATCH(O6:O130,O6:O130,0))))} I am using the SAME formula in another data set on daily market prices (the above is for weekly) . . . and I am NOT getting an error on that sheet (??) That error says I have...

Hi I have imported a CSV into spreadsheet and get a funny error in on of the coulums It appears the Excel does not like the data being import into this colum Data - Help Them Please.mp3 Excel changes the cell =- Help Them Please.mp3 And the Cell displays #NAME? Any ideas why this is...

Hi all, I am updating around 90 workbooks for year end by adding an extra named range to an existing formula I will be doing this by looping through all of the workbooks to add the 18/19 spend in year to 15/16 16/17 17/18 Range("HRPreviousYearsSpend").Select ActiveCell.Replace...

Hi, does anyone now if there is another IFS formula or something simular that works with excel 2013 or earlier. The below formula only works with the later versions. Thank you <tbody> A B C D E F G 2 3 < 1 MNTH 1-3 MNTH 3-6 MNTH 6-9 MNTH 9-12 MNTH 1 YR > 4...

I have a spreadsheet that users need to use to scan in bar codes. When they try to scan the bar code the cell populates with #NAME ? The cell is formatted as General Any thoughts about what is causing this?

I have a spreadsheet that I want to pull data from 5 different columns using SUM(VLOOKUP as an array. Problem some of the cells may be blank which leads to an #N/A error. I attempted this: {=IFNA(SUM(VLOOKUP(AB8,'Cash Flow Detail '!B12:AN94,"<>",{24,26,31,33,39})),0)} however that returns a...

Hi Guys, I'm currently experiencing a strange situation when I filter a column for #NAME it returns blank lines. The item is in the column but for some reason the filter is not returning it. You can also see in the filter drop down. My current workaround was to use find and replace and...

Hello, I have a table with months I and various figures for each month. I am wanting to display in columns O the last 3 months that have data in column D (completed). For Example below August, September and October should have a 1,2,3 in column O This is what I have but it won't work...

is there any way this can be done? The formula I am using is: {=IFERROR(INDEX(Teachers,SMALL(IF(subs=$B$3,ROW(Teachers)),ROW(4:4))-1,1),””)} Thanks

I am trying to figure out how to create an IF FORMULA in cell M3... based on following criteria, if cell H3 = “A” then enter formula J3+K3. If cell H3 = “S” then enter formula I3+K3. Been trying but coming up with #name Any hints would greatly be appreciated Thanks Bill

Hi - I've been trying for a simple formula =IF(OR(H4>9.01),”1Point”,IF(OR(H4>3,H4<6),"2Point",IF(OR(H4>6.01,H4<9),"3Point"))) to check if values of a cell >3<6 name it as 2point, if values >6<9 name it as 3point, and if values>9 name it 1point, need suggestions to correct it...

The formula below returns "#NAME?" and I don't know why. I suspect the reason may be because there are columns used in the equation that are formula cells. But if this is the reason, how do I get around it Basically the formula is trying to achieve a sum of column O if two conditions are met...

HHi I want to seach a row looking for any data over 9 columns. There are more than 120 rows so I just drag this formula down the column that I want the answer to apear in. The follow works for some rows but not all? I get #Name for the columns that don't provide the correct result...

Hi All I am trying to make a dynamic reference to a table array in a Vlookup formula. The Table arrays points to a closed workbooks "C:\Dropbox\Agriseed\Present Trials\2018\Grass\Perennials\[Trial Data FLP1801.xlsx]FLP1801" So i can't use Indirect to the first table below. In B5 of the second...

I am getting #NAME ? when executing the below code. Cell F5 in the Manual tab has a number in it so expecting the output to also be a number. Cells(lastRow + 11, "R").Formula = "=R[-1]C/(Manual!F5)" I get #NAME ? and when I press F2 on this erroneous cell it shows =R253/Manual!'F5' I am not...

Hi all I need to copy a list of 100k entries like the one below. =-ad-vehicles. Problem is when i paste, i get #NAME ? in the cell. I know it's doing this because excel thinks this is a formula function but how do i work around this considering that i have to deal with 100K entries?

I have the following formula and it is giving me the #NAME? error. Can anyone identify what is wrong with my formula or help me write a better one...