n/a error

Hi. I have multiple rows with datas but also N\A. I need to delete N\A till there is beginning value by each row. I have sample, can you help? I need only delete N/A till becomes value. In "tomato" row there is no need delete N/A because of first value is number apple N/A 1 2 peach N/A N/A...

HI, I am trying to return a value for a number in a string in a pivot table. Currently I've been using index/match with left but keep getting #n/a return value. Open to any suggestions :) THanks!

Hello, The code below was written to update formulas in F5:N and array formulas in H5:AA, and replace the formulas in F6:A6 and below with the output as values. I am using VBA code to avoid a slow workbook, forcing the formulas to run only after I have updated other data in the workbook. The...

Hello everyone! I am in the process of making a dropdown-based table to fetch data. I have gone through the motions to create the dropdown via data validation, and that works fine, however I am in the process of trying to get the data I need and I will get N/A in the cell. The table I am...

Hi, I want to average some data in a column where the data looks like this: <tbody> A B C D 1 x 1 x 2 z 6 3 y 4 4 x #N/A 5 x 3 6 u #N/A 7 z 1 8 v 12 9 v 8 </tbody> I want to average the data in column B but only when the...

Hi Excel Community, My function is set to not count any "N/As" but it's not working. N/As are being counted as 3. The likert scale of 3 should only be returned when "influential" is stated in the column. Here is the function I typed in: =IFERROR(LOOKUP(AQ8,{"Definitive","Influential","Not...

Hi I have to use a concentrate formula to join to words together to get a unique criteria to look up. That worked no problem. I am now in doing my lookup and have tried all of the following in Sheet 1 =VLOOKUP(E2,Week1,5, FALSE) =VLOOKUP(E2+0,Week1,5, FALSE)...

I have been scratching my head at this one. I am no novice user of excel and I've come up with nothing. I have a basic index/match function throwing an N/A error, seemingly randomly. This may be difficult to conceptualize without *actually* having the workbook but I will do my best to...

I'm writing up a note on #N/A for my students (adult office workers). I condensed the answers to students' questions into 5 paragraphs. I would appreciate any comments about mistakes or potential logical problems. Much thanks, John. #N/A – An IntroductionA display of #N/A means not available...

Hi All the below function is used in a table of many similar functions, The highlighted C is the main value changed to return the desired value. This works fine in all my calculations except when i exchange the C for a D. I have looked at the source data and anything else I can think of, but I...

I ran a search within the forums and didn’t find anything that would help me. If this is double post my apologies. I’m been designated as the Office football pool guy. I have been doing ok but I ran into a problem. I’m trying to make someone’s pick match a list of winners. If a pick matches...

Hello All, Thank you in advance for your help. Here is the problem I am having. I am trying create a table that looks at one cell reference, finds that same text in a table, and returns an Id related to the number. The cell I am referencing has both txt and numbers (ex. 123 Company, Inc.). The...