n/a

My data table has several columns with both numbers, displayed as %, and Text. The text is: N/A. Please note, it is not #N/A, just simply N/A, and is text, not the result of a formula/function. When I pivot out the data table, the N/A are being shown as a 0 and thus 0.00%. I need to carry...

My case is like this: Copy column B's number (if column A's adjecent cell is n/a) to Column A of sheet 2 from A1 to A2 to A3, etc (one by one) Column A ColumnB Column A of sheet 2 N/A 1...

I have a spreadsheet that tracks tasks with drop down boxes that include the values B, G ,Y, A, and N/A. The number of each status is calculated at the top of the sheet through a count if statement. I am hoping to add in another drop down box above each section using the same as the above. So...

Hi All i have created a pivot bar chart some of the data has 0 or N/A how can i add a custom format the show blank in the data label if it is 0 or N/A? thank you

Hi all, thanks for your help in advance, I've been struggling to find something that fits my need. I have a table of KPI measurements for a number of people/ locations within tables that are conditionally formatted based upon the criteria. I want to be able to count how many people/locations...

Hi all I have a set a data that has N/A in there with numbers also I have created a pivot table at the back of this data using an average function How can i get the pivot table to ignore these N/A values that are stored as text I export this data out and reformat via code therefore I can...

Hi, I want to be able to search a policy number and get the appropriate info in the same sheet. I want my header to adapt to the type of information. Let say my header is on A1 through Z1. This sheet is all my data set. A2 and below are my policy numbers, B2 and bellow are my insurance type...

I have a workbook with lots of sheets and macros. At random times, certain "zero values" are replaced by "N/A" (the string N/A, not the #NA error). I can't find any pattern or reason for why this happens. Only about 1% of zeros are affected - all of them are static values, and none are...

Hi All, I have the below code to count through columns BL, BM and BN on my Completed Sheet. The information entered into these columns can be - 1.1 or 1.2 or 2.1 or 2.2 or 3 or 4. The information is then pasted into OverallStats Sheet columns C22 to E28. Row 22 being 1.1, Row 23 being 1.2...

Hi, I have in cell B4, 201814, formatted as number. I am using the following combination of Left & Right to change the number to 201714. =LEFT(B4,4)-1&RIGHT(B4,2) This gives me the desired result. I am then using this within a Match or Vlookup formula (both of which return N/A, when the data...

Hello all, I am looking for code that will look in column Q for the first open cell, fill every cell with "N/A" all the way down to the last populated row in column A. Another words if column A is blank then stop filling in column Q with "N/A". I've been working with this code but I know I'm...

Hello, i have sheet 1 that is the lookup, sheet 2 is the find and return the total of column3. I keep getting ref# or N/A. I need to sum all instances of A17 from sheet 2. My formula is {=sum(vlookup(A17,'Sheet2'!B1:B30,3,false))} Any help is greatly appreciated

Hi, New to the forum, and fairly novice Excel user so bear with me if my questions really easy to answer :) In cell A1 I have either "N/A" or a value. I want to put a number in cell A2 dependant on the value in A1. It would be as follows N/A = 1 1-2 = 1 3-4 = 0.5 4+ = 0 Anyone any ideas...

Hi everyone <o:p></o:p> <o:p></o:p> Would appreciate some help with a formula which tracks the percentage of time each employee utilises particular ‘Requirements’ – this information is determined by the Job each employee is assigned to. I have completed an initial version of this (with an ugly...

Hello everybody. <o:p></o:p> I’m a bit out of my depth with this one! <o:p></o:p> Effectively what I am trying to do is calculate the time commitment of each employee based on a number of criteria. <o:p></o:p> <o:p></o:p> Each employee is allocated to a number of jobs – the time commitment for...

Hi all, Currently having an issue doing a vlookup. For what seems to be something very simple, it is not working as it should and I am not sure if you could help me out. I think it could be due to the fact that the files are different, but once again I am not sure. I am looking to get updated...

Hiya This table is representative of a larger data set I'm working with. I want to calculate the number of yes / (yes+no)%. I wondered if I could use a named range by highlighting only rows of data which were relevant and ignore those that were blank or contained numerical . But Excel didn't...

Hello, I am looking for assistance on why this array formula isn't working as I expect, I am new to using array's. I have drop down selections i K37:k43, they can be one of the following: - Select One - N/A - 0 - 1 Here is the formula I have...

Hi everyone, I have an Excel Table several columns that contain numbers but a few cells contain "N/A". When I load this table into Power BI and add these columns in a Table Visualization, the cells with "N/A" are blank. I am curious to know if it is possible to have "NaN" or "N/A" and Numbers...

I have a process control spreadsheet that was handed down to me. Its a mess. We have tasks that need to be completed, over 22 of them, and right now they are all 7 days of the week. Is there a way to assign a task based on the day of the week. I have a tab with all 22 tasks laid out...