Multiple If Statements And Searching Blank Cells

Apr 2, 2014

How can I create a multiple if statements that returns a specific response if the cell is blank?

For instance, =if(K6=[date],"Carry Out"), if(K6=[blank],"Break Out"))).

View 3 Replies


If/then Statements: Find All Blank Cells In Column

Oct 24, 2007

I am manually scrolling through Excel right now to find all blank cells in column L. Some cells have dates, others are blank. IF L is BLANK, I go to row K and copy/paste row K to row L. IF K is BLANK, I got to row I and copy/paste to row L.
Is there a statement I can put into row L to basically say "If blank copy/paste from row K. If row L and K are blank go to row I and copy/paste to L." ???

View 4 Replies View Related

Searching For Multiple Characters Within Range Of Cells?

Dec 10, 2013

The following code works fine to determine if a particular character occurs within the selected range of cells:

Sub CheckIfCharacterIncluded()
For Each MyCell In Selection
If InStr(MyCell.Formula, "#") Then
MsgBox ("The " & "#" & " character was found in cell: " & MyCell.Address & " at position " & InStr(MyCell.Formula, "#"))
End If
End Sub

However, I would like to extend this functionality to check for multiple characters, using some sort of array that contains all the characters I want to check for e.g. "#","*","£" and so on, without having to repeat the above code for each character for which I need to check.

View 2 Replies View Related

Check For Equal Cells With Multiple IF Statements?

Aug 21, 2014

I am trying to check if the dates are equal with multiple if statements! Macro works great if first date is wrong, but if the 2nd or third date is not unequal it does not work anymore.

really tried to do it myself but unfortunately

I added an excelexample

Date in E3 is different (if you type in other date in cell b3 macro does work partially).

View 1 Replies View Related

Macro - Select Multiple Cells By Searching For Specific Text

Nov 8, 2013

I would like to select all cells in column A that begin with the text "SP". Some cells will be contiguous but others will not. For instance in one case, I would like the macro to select cells with the text "SP" which would result in cells A1, A2, A3, A10, A15 being selected. I am working on building a macro that will then do other things to these cells/rows so this is the first step.

The below code will select the first cell with "SP". How would I alter this code to only search Column A and select multiple cells? or totally different code.

Sub test()
Dim r As RangeSet
r = Cells.Find(what:="SP", LookIn:=xlValues, lookat:=xlWhole)
If Not r Is Nothing Then r.Select
End Sub

View 7 Replies View Related

Multiple IF Statements (skip The Next Two Statements Or The Result Will Be Changed Again)

Nov 22, 2008

I have three IF statements as below. the problem is if the first statement is true I want it to skip the next two statements or the result will be changed again.

View 2 Replies View Related

Excel 2007 :: If Then Statements Applied To Multiple Cells And Triggered Automatically

Oct 12, 2011

VBA in Excel 2007. Essentially, what I am trying to do is this:

I have to two columns (A and B) that have a drop down list in each cell containing text options. I created the drop down lists using simple data validation. Let's say that A has the following options (East, West, North, South) and B has (Up, Down, Left, Right). For each combination of these, e.g., A1 = East and B1 = Down, I want C1 to pull a unique piece of data (a $ amount) from a separate worksheet. I can get this to work in its most basic form but I want to be able to be able to do this for cells in rows 1 - 300 without having to write separate lines of code for each.

Additionally, I am having trouble getting C1 to update automatically once A1 or B1 are changed.

View 2 Replies View Related

IF Statement To Leave Cell Blank If Multiple Cells Are All Blank?

Mar 12, 2014

I am looking for an IF statement that would leave a balance cell blank if both the revenue and expense cells are blank, otherwise a formula would be calculated.

View 8 Replies View Related

Combine SUM And Return BLANK Statements?

May 25, 2013

If the cells are left blank I need the SUM column to remain blank, not return 0.

Combine :SUM(F9:BR9) + IFBLANK, return BLANK, not 0

View 3 Replies View Related

Combined If Statements - Make The Second Character In The Blank Cell?

Mar 6, 2014

I have a spreadsheet that i want to create a part number that contains 4 parts. Ex 1rl9. The cell i want this to be in is blank. What formula do i use to make the second character in the blank cell = r?

View 9 Replies View Related

Add Multiple Sets Of Numbers Between Blank Cells

Dec 15, 2009

My spreadsheet is multiple rows and columns of sales data with two blank rows between salespeople. Ex:

$100 ABC Inc. John #101
$150 XYZ Inc. John #101

$200 Golf Inc. Sue #102
$150 BBall Inc. Sue #102

What I need is this:

$100 ABC Inc. John #101
$150 XYZ Inc. John #101

$200 Golf Inc. Sue #102
$150 BBall Inc. Sue #102

Where the sum of each salesperson's sales figures is shown and formatted. I've been doing this manually. I'm having difficulty figuring out how to do this using VBA. I can do the formatting, and conceptually I see what needs to be done.

View 2 Replies View Related

STDEV With Multiple Criteria With Blank Cells

Dec 24, 2013

I have trouble with calculating standard error with multiple criteria. Below is the formula I used:


The problem is the blank cells in the range that I am calculating (M2:M25). Everything is alright if there were no blank cells in M2:M25. If there were any blank cells, however, the STDEV was wrong (the countifs part was correct). It treated the blank cells as zero.

View 6 Replies View Related

Insert Multiple Blank Rows At Designated Cells

Jun 13, 2014

I have a large list of cells in excel: 15, 33, 90, 102, 149, 159, 217, 228, 238, 247, 305, 312, 369, 417, 428, 486, 538, 548, 606, 621, 671, 679, 737, 805, 816, 874, 915, 923, 981, 1029,1038 .

Under each of these cells I would like to insert 20 blank rows. I have tried various codes but i'm struggling with the fact that as soon as I insert 20 rows at cell 15, all the other cellnumbers change.

This is a reformulation of this post: [URL] ...........

View 1 Replies View Related

Deleting Rows Where Cells In Multiple Columns Are Blank

Apr 17, 2013

I work with a spreadsheet every week to input values and subtotal them. These values change constantly and instead of going through and manually deleting each row in a 100+ row spreadsheet to be able to import into another program, I'm looking for an quicker way to keep my data in order but consolidate by getting rid of only the rows where both column A and B are blank.

Here's an example of what I'm working with:


This is what I need the final product to look like:


So I would like to quickly delete rows 2, 5, and 11. All of the other answers I've found only show how to delete rows based on empty cells in only 1 column. How can I quickly delete the rows where both columns are empty?

View 5 Replies View Related

Counting Blank Cells In Range And Multiple Criteria

May 29, 2013

I have the following table

Team A
Team A


I need to fill the following table in another sheet counting the amount of Blank cell there are according to Month, Team and if the name row is filled. I have tried Sumifs, sumproduct,countblank typing them in as arrays but don't seem to be getting anywhere

Team A
Team B

View 2 Replies View Related

Convert Multiple Columns To Rows Including Blank Cells

Apr 11, 2014

I currently have a spreadsheet that I had to convert from multiple rows to columns:


Now I need a script to change the data so that each column is now in row format, (see attached spreadsheet).

View 5 Replies View Related

Multiple If Statements With Multiple True And One False

Aug 6, 2014

I am trying to get a function in a sheet where it has two possible truth outcomes and one false outcome. Both statements false statement goes back to

'Production Metrics 2'!E11/12

Here are the two If statements as they appear in the formula bar now. I need to combine them so they both work and don't cancel each out out.

=IF('Production Metrics 2'!E11/12>2500,2500,'Production Metrics 2'!E11/12) If c10+b10>=4500,0,'Production Metrics 2'!E11/12

View 10 Replies View Related

Searching Multiple Fields

Sep 27, 2009

I am fillin out a spread sheed with a num ber of codes. I want to create a excel formula that will look at the entire column and search for each of the codes. If I have forgotten to add one of the codes into the column I need the formula to let me know.

What I was thinking might work is this...

To look for one of the codes I would do this.

This works great if the Value is in there. If it is not in there I get #N/A instead of FALSE. Is there a way to get the MATCH to return another value if it is not found in the range?

Is there an easier way to look for multiple values? So far the only solution I have found is like this


For each value I need to look up I add another IF function. I have about 17 different values I need to look for. This makes for a ugly function but it seems to work.

View 9 Replies View Related

Searching For Multiple Data

May 24, 2006

I have been using the VLOOKUP function to search a table of data for a specific value in order to then give me the corresponding data associated with that value. I can do this and it works!!

However, as I am searching for names some people have more than one set of data and the VLOOKUP only finds either the first set of values (if the FALSE command is used for ‘range_lookup’) or the last set of values (if the TRUE command is used for ‘range_lookup’). I have attached a small example:

How can I get all values to be displayed?

I know that this may have been explained horrendously but I have written and re-written this several times and this is the best I can get!

View 9 Replies View Related

Searching Multiple Workbooks

Sep 29, 2006

i am trying to set up an interface through Excel for a database of record also held on excel. I have very very basic VB skills and have no idea what im doing lol but what i would like to do is have a search box and button, something similar as you would find on most websites. I would also like (if possible) for it to search up to 8 workbooks to look for a name or vaule.

View 3 Replies View Related

Searching For Multiple Text Strings?

Aug 12, 2014

I want to search a longer text field for a shorter string that may be within it. However, I want to do this for multiple short strings.

For instance:

PhraseHidden word
Please search the text for the hidden message: Blue
The hidden word, Green, may be at any point
And the word may be different lengths like Yellow

I have a table of the hidden words (Blue, Green, Yellow, Pink)

I know I could use search to find one word, but is there a way to look for multiple words, and return the value of which one it finds? I have many hidden words (and the list is dynamic) so I don't want to just split into multiple searches.

View 5 Replies View Related

Searching For Multiple Criteria In Array

Nov 1, 2009

I have an array of data that i need to find multiple data points in: ...

View 11 Replies View Related

Searching Multiple Columns On Same Sheet

Mar 26, 2009

Fall - Columns A-G
Spring - Columns I-O
Summer - Columns Q-W
Unduplicated - Columns Y-AD

I am needing to take each student in the Unduplicated section and see which terms they attended. If they attended a specific term, I need to grab a piece of data from that term and put it in over in the undulicated area.

The only way I could think to do this is with three separate searches. This is probably grossly inefficient and so far it has not worked at all. I have posted below the code I am currently using. Again this code is not workin at all.

View 2 Replies View Related

VBA- Searching Through Multiple Wksheets/workkbook

May 13, 2009

I need to do the following:I have multiple worksheets/ workbooks that hold user info such as address, country, first name,last name, ID,dob, gender, occupation etc
I need to make a search dialog whereby the user is allowed to do this:

1-Search by ID by selecting thru the calendar tool OR

2- search by first and last name. When he clicks search, I need the particular worksheet holding the data to pop up and show the user the data that was requested for.All data in ID column is unique...but for first n last name, i have a few people who have identical names

View 2 Replies View Related

Searching Table When Value Has Multiple Results?

Feb 2, 2014

i have a spreadsheet that i use for work which has 1 page that contains all the data for the workbook. on other pages i use this data, and tables, to pull information to those pages or other pages which complete my work in a more timely fashion.

that issue i'm having is when i try to look up specific values within the data page tables and there are multiple values.

i need a way to choose different values rather than the "first" value in the instance of a vlookup which only finds the first value.

in the pictures i have picture 1 (vlookup samples) has a section where i can type in the "office" code and it will auto pull "switch name" and "switch clli" via vloookup.

in picture 2 (switches sample) i have created a table, which is on another page as stated above, but if i try to search for the example "LSGT5" it only returns a switch name value of "LFTYINXFDS0" and there is also a value of "LFYTINXFDS1".

there are many more within the table(for this office code alone) but this is just an example of how i need a way to choose the proper one or somehow have a drop down without having to create a bunch of tables for each office itself.

View 6 Replies View Related

Searching Returning Multiple Matches

Mar 6, 2007

I am looking to perform a search that will return a match and place it somewhere else, and then search again until its finished the list?

View 9 Replies View Related

Multiple IF Statements

Nov 23, 2008

I'm having trouble joining the followinf IF Statements. They work independently, however, I cannot get them to work in the same Cell.

Any help would be greatly appreciated.

=IF(A9="YES", SUM(A15+A21),"0")

=IF(B9="YES", SUM(B15+B21), "0")

View 14 Replies View Related

Multiple If Statements....

Aug 31, 2009

Trying the following multiple if formula, however it only works for my first if statement and not the rest.

=(IF(G21="onl",WORKDAY(E21,L27,K26:K43),(IF(G21="telb",WORKDAY(G21,L27,K26:K43),(IF(G21="mrt",WORKDA Y(G21,L27,K26:K43),(IF(G21="tlr",WORKDAY(G21,L26,K26:K43),(IF(G21="atm",WORKDAY(G21,L26,K26:K43),(IF (G21="chq",WORKDAY(G21,L26,K26:K43),(IF(G21="crcdwu",WORKDAY(G21,L28,K26:K43)))))))))))))))

View 4 Replies View Related

Multiple IF Statements ..

Apr 28, 2007

Is there a way to write a forumula that read, if it's January, add column A1:A10, if it's February, add column A1:B10, if it's March, add column A1:C10 and it's April, add column A1:D10

View 9 Replies View Related

Searching Multiple Worksheets And Retrieving Data

Aug 27, 2009

I have two lists. One is a database (Worksheet 2) with a lot of information, and another is the list (worksheet 1) I need to fill up the data for. What I want to do is to search for the names that are in worksheet 1 in worksheet 2, and if there is a match, retrieve the missing data in those rows, and paste it back into worksheet 1. For example:
Worksheet 1: Joe
Tim 23

Worksheet 2: Alex 45
Joe 23
Mark 47
Tim 44
Matt 24

I basically want it to be able to search for the corresponding name, and then pull the number associated with it.

View 2 Replies View Related

Copyrights 2005-15, All rights reserved