n/a

Morning, I have 2 columns as explained below. Column J consists of values like Z159, R235, P004, N/A Column L consists of values like JHMCN129357842S87, N/A The columns have a drop down where the only selectable option is N/A When i use the Data Validation Circle Invalid Data option i see a...

Hi all, Using Excel for Office 365 MSI 16.0.11 x64 version 1902. I have a scenario where I think TEXTJOIN would work, but I can't figure out how to concatenate several IF statements together. I have: - Column A (id) with hundreds of row entries, simple numbers 1-..... - Column B (category)...

Hi, The working code supplied below is what i use to view a saved invoice. What i am looking for is to now use the same code but with an edit. Once the button is pressed it will look for the invoice number & print it as opposed to viewing it. Thanks Private Sub OpenInvoice_Click() Const...

Thanks in advance for any suggestions for which I will provide feedback. I am getting an error on the following formula as it's when i added, the "N/A" part for the IFERROR. Cells(i, 4).Formula = "= IFERROR( MATCH(TRUE,INDEX(Sheet1!E" & i & ":" & LastColumnLtr & i & "<>0,),0)," & ""N/A" )"...

Hi all I am trying to SUM multiple vlookup values as below: =VLOOKUP(A3,Academy!A:M,13,FALSE)+VLOOKUP(A3,'AJ Blunt'!A:M,13,FALSE)+VLOOKUP(A3,BUILT!A:M,13,FALSE)+VLOOKUP(A3,Carbridge!A:M,13,FALSE)+VLOOKUP(A3,'Carter Corp'!A:M,13,FALSE)+VLOOKUP(A3,'Cleanaway - Transpacific'!A:M,13,FALSE) Column...

Hi, I have a table with various columns. Cells in Column A can contain one of "First", "Same", "Last", "Unique". Cells in column B specify whether or not a client is homeless. So cells in this column can contain any one of "Homeless", "Not Homeless", "N/A" Finally, Cells in column C specify...

Is there a way for this code to only look until the last populated row in column A vs the entire columns D:K. IE, the data stops on row 84, but the following populates ' N/A' all the way down D:K where a cell is blank. Thanks in advance! Columns("D:K").Select Selection.Replace...

I have the following array formula: ={INDEX(r_base_liability,MATCH(1,("Liability"=r_peril_liability)*(i_score=r_score_liability)*(i_liabilit_bucket=r_terr_liability),0))} This performs a 3 way look up, and so far it is working fine. However, I want to loop through the parameters i_score, and...

Hi All, I'm calculating the number of days between 2 dates which is really easy, however some of the cells don't have dates in them and I'd like it to return something other than value, maybe "N/A" so we know it's been seen to. Currently it's just "AS2-AC2" Is there an easy way to do the...

Can anyone tell me why this code will return N/A even though when I walk through it the steps look like it should return an actual result? =IF(OR($I$3="RHP",$I$3="LHP",VLOOKUP($G$3,STATS19pitch,16,FALSE)),VLOOKUP($G$3,STATS19sb,15,FALSE))

Hello, I am trouble creating a formula to go into Cells B2:I2, Im trying to have Excel say Find the Text "Scheduled Date" match the date below with a date in Row 1 and provide the information in Column M for Test 1 , Only Information from the Text "Scheduled Date to Subtotal" Belongs to Test 1...

Hi, I have a list of machines that can produce diffrent types of products. some machine can produce same part but there is diffrent between machine in the quality performance. also not all macines can produce all products. I would like to get the best setup in order to set the product that will...

Hi, The top table is my excel sheet named Vlookup. As you can see the value I am trying to get is on the 13th row. It is still returning N/A. Please help. Thanks

Morning, I am using the code supplied below. The code checks to make sure that the value entered in TextBox4 doesnt already exist on my worksheet before it then makes the save. If there is a matching invoice number alreay then i see the msgbox show up advising me "Already Exists" I would like...

I have a table where rows are individual submissions, and columns are questions within those submissions. Submissions contain information such as name, month & location, and questions are answered with either Yes, No or N/A. <tbody> A B C D E F G 1 Name Month...

Hello, I have a sheet that has a number of three column groupings. In each -- The first column is people's names. The second column is a range of numbers that also includes N/A (i.e. N/A, 1, 2, 3, 4... 20) The third column has another number. I have another sheet that has two columns: Name and...

i would like to calculate how many item outstanding will be due on weekend in N/A and blank in the range. <tbody> Item Mail No. Date Received Type Forwarded Date Response Response Date Due Date Day Process Status Days Overdue Remarks 9 SSP-PDP2-WTRAN-856277 01/01/2019 Workflow Transmittal...

I have a series of 8 option buttons and 1 text box in a frame. Whichever button or text box is selected. Enter yes or result (text box) and the remaining will show N/A (They all have their own cell in a row on the worksheet. When I run the code now. I get True or False for the option buttons...

im a newby to excel ..trying to work something out. If date in G1 = H1,then return yes in K1 and N/A in columns L1 to Q1 if false, leave k1 empty and allow input yes or no or n/a date is dd/mm/yy thanks in advance

<colgroup><col><col><col><col></colgroup><tbody> Holdings - - Duration N/A N/A N/A Meets Expectation N/A - - Meets Expectation Meets Expectation - - Meets Expectation N/A - - Meets Expectation </tbody> "There is N/A under Holdings and I filled N/A in next columns manually, before...