#n/a

Hi, Looking help in constructing a formula to help me interrogate a large data area which if 2 criteria or met then sum the associated hours worked. Basically I want a summary report that gives me the total hours worked by a particular grade for each month as we go through the year. Below is...

Hey guys, can someone tell me please why this file is not working? https://sheet.zoho.com/sheet/editor.do?doc=2f316a5f957451ed09ebbb4a127947ccf5a1467f845cffe4c8a8094a66592afeb433327fda0a94208330b6f8e188e67294c4ed9a2e62d8dd325f910d1a209e47 am using (...

Hi, I’m trying to create a formula that involves using IF and OR. The problem is that the columns the formula references have a lot of #N/A errors in them, so the result of the formula ends up being #N/A if there is an #N/A in either column H or column I. It just seems to disregard what is in...

Hi, Every month a sales report is pulled showing all activity for each sales person from the beginning of the year. This tab is the total sales overview. It is sorted alphabetical per sales person. Then a tab is created per sales person. Each of these sales person tabs needs to reflect all...

I am trying to cleanse a user input list of countries of residence. in some cases the country is hidden in a string of other words like this "kobeshi hyogo japan" I want to lookup from a list of defined countries I have using =VLOOKUP(A4&"*",'country list'!$A$1:$A$165,2,0) but it returns #N/A...

I am trying to do an INDEX and MATCH where the INDEX column contains blanks. This formula works well until the column has blanks. Then I get #N/A {=INDEX(O6:O130,MATCH(TRUE,O6:O130<>0,0))} -- Column O returns #N/A =IFERROR(LARGE(P6:P1300,1),"") -- Column P also has blanks, returns #N/A...

Here is the data which I am trying to extract the dollar amount in D4 from. Excel 2016 (Windows) 32 bitABCDEFGHIJKLMNOP1Tax Credit TypeFederalNLPENSNBONMBSKABBCYTNTNU215%8.70%9.80%8.79%9.68%5.05%10.80%10.50%10%5.06%6.40%5.90%4%3-3-5-1-6-4-74Basic personal amount...

Guys, I have a baseball team and would like a formula to keep the stats. For example, I would like a formula in Cell F3 that counts how many 1b(from Cell F2) does Salvador Martinez(Cell B3) has in the range B33:F:40. So this formula would need to match B3 and find the rows where Salvador...

Hi, I have a worksheet with one tab that has a web query retrieving data from an online table and another tab that uses a series of formulas that start by referencing the tab with the web queries. The order of the formulas is as follows: web query --> cells referencing the table created by...

Hello, I am attempting to do an IF/EXACT formula that contains two different values. Here is the formula that I've come up with, but it keeps returning a #N/A value: =IF(EXACT(G2,"B"),"Btl"),IF(EXACT(G2,"b"),"btl","")

is there a conditional formatting rule I can use that would highlight cells A268:d268 in red if F268 is #N/A? the rows will increase that's just where it's at now. I have a Vookup in column F to look at number in column D and it's #N/A people shouldn't add the information but they still do...

Hi all, Last week I was completely stuck with this concept and Kweaver helped me out with this awesome formula, but since then I needed to modify the formula to add another condition and now I cannot get the formula to make S2 = 0 is the other conditions are "Non-Billable" and "No". Below is...

Trying to return a blank instead of a #N/A or 0 with INDEX and MATCH. Formula Below... =INDEX(Data[GC],MATCH([Product Key],Data[Product Code],0)) Thanks in advance for your assistance and time. Regards Richard T.

I am using the below formula to populate a cell based on dates from a different worksheet. Everything is working properly, but I am getting error #N/A when the date is not available. How can I modify the formula to return a blank cell (no text) when an error #N/A is returned...

Hi, I'm trying to write an excel formula in VBA which gives me a unique count of a certain column. However, I'm getting an #N/A when I write it in VBA. Any thoughts? Here's the part that's giving the #N/A in the code: .Range("B" & NumberofRows + 4).Formula =...

I have inherited a workbook and on some sheets the formula seems to work but in others the cell, Y11, shows #N/A. The formula is: {=Lookup(2,1/(Max(0+Substitute(AH3:AH15&1,”\”, “1/“))=0+Substitute (AH3:AH15&1,”\”, “1/“)} Could someone explain this to me and perhaps why some sheets are showing...

Dear ,I need a formula for doing Reco of un-adjusted entries on daily basis for large amount of entries. Please help me to do it with the help of excel formula . Sample as given below :- "Issue CN" Should be formula output :- <tbody> Document of type ZCR6 Formula Required Amount Sold to...

I have a sheet named 'Diff' that has ID in column A and Difference in column K. I have another sheet named 'Udata' that has ID in column A and amounts in columns B:JG. I am trying to look up the code in row 3 (column header) of the UData tab, based on the ID number and Difference from the Diff...

Hello, Any one can help how it will not result to #N/A ? https://docs.google.com/spreadsheets/d/1WzjH8N-G6Ygs2HLjqxz-CKgj-vKQ9nrSgdh4_zj8BMY/edit#gid=1123400327 Kindly send the correct formula because google sheet formula is not the same with one in the excel sheet in the computer Thanks in...

Afternoon Trying to get a cell to return different messages based on if a Vlookup gets a return or not Ie, Vlookup in Cell G8 returns a result - B8 gives instructions on what to do next (Text in cell A13) Vlookup in Cell G8 returns #N/A result (Failed return) - B8 gives different instructions...