if

Hello, I brazenly copied the below macro section to check the range for the value "Not Allowed". And that works, except if none are found it still ends the sub. If none are found, I would like it to process the rest of the macro. Currently, it counts the number of occurrences "Not Allowed"...

Hi, I have the code below which works well. It checks to see if Cell "A1" is not empty if it is not empty then it runs the code only in the cells are blank in column A. I would like to change the code so that it automatically checks each cell in column A, if has data then it runs the code...

Hello All, Excel novice here, trying to quickly learn how to embed and nest AND into IF(S) logic in excel (using 365 cloud on PC) Situation: We have people who are eligible for a reward based on two independent criteria of participation: (1) the quantity of their participation (i.e. the number...

Hi all, I am trying to compare a range against a single value to see if it exists and return a single Boolean T/F result. The formula is: =IF(COUNTIF(RANGE,CRITERIA)>0, "TRUE", "FALSE") The problem I'm having is the way I supply the RANGE to COUNTIF will be fine if I explicitly highlight...

Hi, I am a beginner Excel user and I have been researching a problem. I cannot figure it out so I thought I would ask this forum. I am looking to combine a COUNTIF and an IF statement into one formula to arrive at my answer (Yes or No) for a survey type of project. Basically, I want to count...

Hi Everyone, I'd like to turn an iferror index match formula for one column and a if(change(vlookup in my second column, into just one column. How would I go about do this? My formulas are: This works for finding out new loans by index matching the type to with the current Join concatenate...

Hello, I want to count data with criteria (N/A), if i want count PN 1 (N/A). what is wrong with this formula ? =IF(G3:G19="PN 1";COUNTIF(H3:H19;"N/A");0) Thanks FGH123PN 1N/A4PN 1N/A5PN 116PN 127PN 138PN 1N/A9PN 1N/A10PN 1411PN 1N/A12PN 2513PN 2614PN 2715PN 2N/A16PN 2N/A17PN 2N/A18PN 2019PN 2120

Hi everyone, i have tried my best to write the IF statement i need but unfortunately i get lost in it. I believe that the below image depicts accurately what i am trying to write. I though maybe breaking down like this would help ne write it, but still i get lost in the formula. If someone could...

Hello I would appreciate some help with a spreadsheet I have. I am trying to determine the responses from a survey that is sent out weekly. The respondent reply options are Yes or No, but I would also like to record if they dont respond. I have Sheet 1 where the survey results are pasted...

I am in the process of making a spreadsheet which help work out some figure for me. I had a working formula but then had to move some columns around. I adjusted all the refs within the formula so column D becomes column K, etc. But now the formula does not give the same answer as it did...

Hi, I think this should be a simple one but it doesn't seem to be working for me. There is a list of numbers in column A. On the next tab there is a list of the largest 5 numbers from Column A. The largest 5 numbers are in column D. Next to each of them (in column E). I want to write "Exp" if...

Hello! Today is my first day exploring VBA coding, and I'm having trouble with the below 'if/then' VBA code (also attached a screenshot). In short, what I need is for data in Column E to automatically populate according to what is in Column D. For example, if any rows in Column D read...

I have 3 columns, where column C should only display the information from column A if column B contains "NO". Any suggestion? A B C (if B has "NO", bring data from column A) 20786WAD - FPAC - GLBL - BTRS NO ABMD NO LFG NO

Hi there! I am trying to come up with a macro, what would deduct cell values from the certain cells, depending on their existence. In the example before, one can see data in the D column for the for the data points "1" and "2" in the C column. Those data points belong to the specific file...

I want to create a checkbox that will hide and unhide a specific row based on the value of another cell. Sheet10 Data (Column K): A A1 A2 A3 Sheet9 Data (Column B): A1 A2 A A3 In this example I click a checkbox next to A on Sheet10 and it looks at the 'A' value then goes to find it in Sheet9...

I'm having a problem with a COUNTIFS function that I've been working with. The logic of it seems sound to me but once the date moves to 10/2/2022 things seem to break. The idea is to see if a machine is running based on the information in the table to the right. Can someone help me understand...

So i have a cell with product codes inside of that. for example cell a1 contains data - 1x ddjed8cx7ee cell a2 contains data - 4x ddjeudaadi3 cell a3 contains data - 1x nddnadjnfke 1x ajo37danunau 4x aud73ndnnak and so on I am trying to find a formula that can A. return the value of 30...

Morning. I'm trying (failing) to find the right syntax to return data using a nested IF, and then OR, AND Requirements: IF, Cell A = "Approved" OR "Authorized", and Cell B = Not blank, the formula should return "Reauth". If Cell B is Blank, Return nothing. If Cell A is anything other than...

Hi everyone, I am attempting to create a function that searches an array for a date match, and if there is one, then subsequently check to see if a the time is between a designated "Start" time and "End" time within the row that contains a match. This function will be placed in the RUNNING...

I have a spill array that is pulling IDs from another sheet. I already have a list of IDs on one side of my visual, and I want to avoid duplicates. The list of my array formula is longer than the existing list I want to compare, and that's tripping me up. My formula with the spill array...