#n/a blank data

Hi! I have a rather complex rating sheet that I am attempting to proliferate throughout my company. I have encountered the first use error in the wild when a coworker entered "NA" for a rating, rather than leaving the cell blank, which appears to have messed up my calculations. How can I not...

I have an odd situation. One of my forms contains a VLOOKUP to a spreadsheet containing employee information. Enter the employee ID #, and the employee information is automatically populated. This is repeated about 10 times on the form, so you can enter the employee ID for up to 10 people...

I need to obtain the most commonly used value (string) from a set of three rows in 3 category columns and then output this word into the result column. The matching is based off the rows though not the columns. So Row 2's most commonly used word from these three columns is "Marketing"...

Hello, I'm trying to use a trendline for a one month period (daily on X axis), where I show actual vs forecast data. The trendline is for the actual data, which shows 1 week in the total month. I'm using #N/A to replace zeros, however the trendline is still treating the #N/A as a zero.. Any...

Hey all, I am stuck on this formula. So I created key to lookup and match a type a for a month to get a value. Some the keys do not have a value (meaning key is non existent) for a month so it returns as #N/A in the cell. This is the lookup formula I have...

Hi, I want to count all dates in column B that are within one year back or date in the future. The below formula works and ignores blank cells, which is exactly what I want, however, the dates are from a vlookup formula, which returns #n/a when it can't find a matching value on the source sheet...

Objective: to display conditional formatting of one cell based on another Conditions: If the cell is blank = white if the cell has a value less than variable X = green if the cell has a value equal to or greater than 1.24 of * X = yellow If the cell value is greater than 1.25*X = red. {X is...

Hello, longtime lurker, first-time poster here. I didn't happen to see any topics that directly mentioned this, but I apologize if I missed it. My question is: if I'm populating a chart series with an array formula rather than a range, how do I have missing data points be charted as gaps...

Hi guys, Im trying to create a stacked column chart that only shows rows with values and excludes rows with #N/A values. NOTES: 1. I can't filter as I have 2 columns I wish to display in the stacked chart, and sometimes a #N/A value in column B does not equal #N/A in column C.. 2. I can't...

i've got a formula that looks like this: =vlookup($A2,MASTER!$A$2:$E$125,3,false) te formula runs down the A collum pulling information. Problem i have is that other people with use this sheet and I want them to be able to add in information so i want to keep the formulas alive and just have...

So my boss ask me to find the data for S&P 500 in different time frame and put it on separate sheets, he also want me to make a main page so that he can choose different time frame with a button, and the corresponding sheet will pop out. I have been trying to figure this out with nested IF but...