n/a

Hi, I have been struggling with this VBA code for quite some time now and would appreciate any help with it. I have attached a sample spreadsheet I am working with. First sheet shows the raw data that comes from the SharePoint and second sheet shows the report I am trying to build form the raw...

Hello - How do I get the following equation to return 0 instead of N/A if no match? Note - I'm on excel for Mac. Thank you in advance {=INDEX('OPEX Detail'!$Y$2:$Y$927,MATCH(1,('Updated Budget Upload 2019'!J16='OPEX Detail'!$F$2:$F$927)*('Updated Budget Upload 2019'!F16='OPEX...

Hi, I am expecting the result to produce "NO APPROVAL REQUIRED", but it is coming up with N/A. is there something wrong with the formula? the VLOOKUP result of F16 does match Q4 =IF(OR(VLOOKUP(D16,'Approver Data'!O:R,4,0)=Q4,VLOOKUP(F16,'Approver Data'!C:F,4,0)=Q4),"NO APPROVAL REQUIRED","")...

Thank you again. Darko Hi all, I'm currently working with a fairly large data set (a sample of which is attached) that contains a drop-down list of options that respondents can choose from. I've written some VBA that will place a certain race selection into a category in the cell next to it...

Please Help.. I am trying to get a formula that will return the wt. per lf of size of bar in F3 from the table B30:J41 and will also return the length of lap required in F5 from the table B30:J41. I have tried several different formula's but nothing has worked. I have even tried breaking it down...

Hello. I have an if/and formula that is working just fine however, I'm wondering if when there is no data returned (either N/A or "blank") can that cell not show up? Example: Now A1: NA A2: NA A3: Hobbit A4: Harry A5: N/A A6: Speed Racer Example: What I'm trying to get A1: Hobbit A2: Harry...

Hi Folks, Happy new year to everyone. Please would you be willing to help me with a puzzling error message resulting from my AutoFilter VBA code. Here are the steps I'm asking the VBA to follow: 1) AutoFilter on column 4 to return only N/A. 2) Select first returned cell and then select all...

I'm trying to create a spreadsheet that takes multiple, "Yes", "No", and "N/A" responses and translates them into overall percentage. There are 4 columns, all of which will have a Yes, No, or N/A option as a drop down. I want the spreadsheet to be able to read the these 4 fields and give a...

Hey guys and/or girls! So I started making some more complex use of excel and I have come to an little problem. If I do: =AVERAGEIF(E26:J26, "<>0")+K26 Info: - E26:J26 can be a number but also N/A atm - K26, same as above but I keep getting those #Div/0 warnings, is there anyway to get rid...

Hello, Any idea why a MATCH command does not work? I definitely see the value but it returns N/A. I have entered it as an array. Is there a formatting issue? Thanks

Good day I am using Excel out of Office 365 on Windows10. I have a worksheet that tracks motorcycle rides. The setup is as follows: Column A - date of a ride. formatted as date. Column B - ride number. formatted as number with no decimal points. can go as high as three digits. Column C -...

Hello, Good afternoon please can you help me I have the code below where I am trying to add N/a to the empty textboxes in my userform if not filled but I am getting an error, please can you help me? I am getting an error on Conventional.Show Private Sub CommandButton3_Click() Dim...

Hi I am trying to get a formula to calculate the amount of Y's and N's for one month i.e. April 18 per project and my dates vary from the beginning and ending of the month. My data is below: <colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col...

Tis the season for Christmas gift shopping and I'm trying to do a worksheet where I can do a lookup for items spent per person. It works fine when there is something listed for every person but, if nothing has been spent yet for a person, it returns "N/A." Is there someway I can alter the...

Hi, I'm stumped here. I think this can be done. Well I'm sure it can be done. I just don't know how to do it. What I am looking for is a formula to do a unique word lookup and match. I have a simple sample. Keep in mind the "list of Unique Words" will be several hundred in length. otherwise I...

How do I receive (N/A) in this case ? <tbody> <tbody> A B C D 1 Brand month month2 2 SEPT 18 OCT 18 DIFF (%) 3 AUDI 0 150 =C3/B3-1 </tbody> This returns: #DIVISION/0! in D3. How can I get a (N/A) instead ? Some kind of (IF) function, but I cant get ir right :(...

I have a substantial database with multiple entries for employee evaluations – each entry showing YES/NO/NA responses for up to 40 individual questions. Currently, I have a summary spreadsheet with various formulas (sumproduct, etc) that presents results based on selected employee name and...

I would like to create code.. If sheet VDR exists, then update cells D8:D11 with a hyperlink to sheet VDR. If it does not exist, put a value of N/A. Here is code for the hyperlink. I need to do this for 4 sep sheets and update 4 different ranges of cells with the hyperlink or N/A value...

Hello! I have a formula that makes a division and in some cells it shows #DIV/0! because it tries to divide by zero. That's fine, but I just want these cells to be filled with N/A (not applicable) or zero or a dash or something more pretty than #DIV/0! Any idea?

Hi, I am trying to make a worksheet change other cells to "N/A" if cells contain a specific text. For example if any cell in range J10:J5010 is changed then cells offset to the right "S, T and V" columns of that particular row are changed to N/A. I was thinking I could do this on the...