Check A Combination Of Two Cells

Aug 18, 2009

I would like to check a combination of two cells, if these two cells are both empty (not zero, just blank) then it will return a blank in another cell. I tried using AND but am unsure how it works. I would like to use a "Case" Function.

Function FirstCheck(Count1, Count2)
Select Case FirstCheck
Case Count1 = "", Count2 = ""
FirstCheck = ""
Case Else
FirstCheck = Abs((Count1 - Count2) / (Count1 + Count2))
End Select
End Function

View 3 Replies


Formula Value Based On Combination Of Two Other Cells?

Mar 10, 2014

Modifying my formula to work. I'm trying to have the value of Cell B2 based off the combination value of two other cells.


View 2 Replies View Related

Matching Combination Of Two Cells With A Table And Return Value

May 8, 2014

As shown in the attachment, I'm trying to return value when matching cell B7 + D5 with cell G5:I7. Is there any way to do so?

Attached File: File Type: xlsx Book1.xlsx‎

View 3 Replies View Related

Projected Date Formula From A Combination Of A 2 Cells

Aug 3, 2009

I am trying to make the "Next Phase up DATE" cell automatically configure accorfing to the Issue date and the PHASE 1, PHASE 2, PHASE 3 Selection.

Phase 1 last for 14 days
Phase 2 last for 21 days
Phase 3 has no phase up date

So if I put 1 July 09 in Issued Date cell and select Phase 1, the "Next phase up date will be 15 July 2009. If 1 July 09 in Issued Date cell and select Phase 2, the "Next Phase up date will be 22 jul 09. If 1 July 09 in Issued Date cell and select Phase 3, the "Next Phase up date cell will be (N/A or something to that nature.) The Doortag portions are refrenced to the upper portions, so I only need the formula for (merged)CDE10 & (merged)CDE32

View 3 Replies View Related

Find Number Combination In A Group Of Cells

Oct 28, 2011

I'm looking for another excel game changer (for the work I do anyway).

I have a dollar amount, and I want to know if any combination of dollar amounts in a particular range of cells will equal that dollar amount. Is this possible in Excel?

Example: I have 20 different dollar amounts in a column. I want to know what combination of those 20 different dollar amounts, if any, will equal $257.97. The dollar amount I'm looking for and the numbers in the range will change with each use. I'm hoping for a formula, but VBA will work too as I could just make a template and copy / paste the numbers in.

View 6 Replies View Related

Sumif Criteria Based On Combination Of 2 Cells

Sep 19, 2012

I have different products with different sizes becoming operational in various months & years. I need to sum those sizes that are operational in a given month/year. In the example below, I have

-product A with 100 unit size, operative since 2007/03
-product C with 200 unit size, operative since 2007/10

So in the table with months on left, and years on top,
from 2007/01 to 2007/02, value must be 0,
from 2007/03 to 2007/09, value must be 100,
from 2007/10 to 2008/06, value must be 100+200=300 and so on.

For this specific example, I tried the following:

E2 = D2&TEXT(C2,"00")
fill to E7
B11 = sumif(E2:E7,"

View 2 Replies View Related

VBA Check If A Cell Is Empty - Move 7 Cells Over And Check Again (Loop)

Aug 10, 2012

I have data in Row 53 that spans 7 columns, but stays in the same row. I want to design a loop to select every 7th cell in that row and check if it is empty. If not, add onto a "counter" then display the final number of occupied cells (the value of the counter) at the end. This is what I have so far, but I get all sorts of errors.

Sub Tester()

Dim WB As Workbook
Dim WS As Worksheets
Dim modCounter As Long
Dim Cell As Range

Set WB = Workbook("Transverse Series.xlsm")
Set WS = WB.Sheets(BM18)

[Code] ......

View 1 Replies View Related

Only Display Value If Combination In Two Columns Matches Combination In Two Other Columns

Jul 12, 2012

I have a formula that I can't get to paste successfully in the forum - it keeps getting cut off?!? ... but I think I can probably simplify my explanation to get the answer I want anyway.

I need to only show the value from AUS!$H$2:$H$17 if the C2 & D2 combination are the same as the AUS!$B$2:AUS!$B$17 & $AUS!$C$2:AUS!$C$17 combination.

View 9 Replies View Related

Check Out The Cat ID #'s In Cells

Jul 26, 2007

******** ******************** ************************************************************************>Microsoft Excel - test.xls___Running: 11.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutH2I2J2K2L2H3I3J3K3L3=
HIJKLMNOPQRSTUVWXYZ1Cat*ID*#ELECTMTC*HoursInv.*Material*$Mutiplier096450965509656097510975209757098891023610673106751067610842108772108429655#N/A1.5813310317206365573396459655#N/A1402310317206365573Buchanan Survey*
[HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box

This is a partial of the sheet that I am working on.

The current Formula in Column L is manually entered for each line. What I would like to know is if there is a way to have a macro that would create this formula?

What we would need it to do is check out the Cat ID #'s in cells H - J and based upon the numbers in there, look up the $ amount (right now they are in columns N-Z). The amount in column M would be manually input and then the formula in column L would be

the value in M multiplied by the sum of the values that correspond with the ID #'s in H-J plus 10.

View 10 Replies View Related

Check If Range Of Cells Contain Certain Value?

Mar 26, 2010

I have a range of cells which contains one of two text values (Ok and Not Ok). I would like to check my range of cells for these values. If this range have one cell that contains the text "Not Ok" I would like the formula to say "Not OK". If all cells contain "Ok" I would like the formula to say "Ok".

View 8 Replies View Related

How To Compare Cells To Check If They Are The Same

Dec 13, 2012

I have multiple colums that I want to compare (A=F), (B=G)........

I want to see the difference of the two as shown in Blue column (example file is attached.)

Skærmbillede 2012-12-13 kl. 18.37.15.jpg

View 2 Replies View Related

Check The Cells Are Empty

Jun 14, 2009

I have a number of worksheets, each sheet is set up like a data entry form, at the bottom of which is a command button that takes them to the next worksheet based on a value in a cell. what i want to do is before it takes them to the next worksheet it checks a selection of cells, if any of which are blank it shows an error message and wont allow them to continue, better still the cell that is blank it high lights with a red border.

View 2 Replies View Related

Check All Cells Are Entered

Jul 13, 2009

I am using the followng code to check data is entered in a cell ...

View 6 Replies View Related

IF Arguement Check 7 Different Cells

Jan 23, 2008

I am trying to get a statement to check 7 different cells to see if they contact the same value, i go into a little depth

if a person is late to work then, a text value of 'LT' for late is placed in the cell, if they are late the next day then another LT will be used and so on.

from this then how many mins they are late is loaded into the next cell so

i have so far (in english) =IF Cell Mon,Cell Tue,Cell Weds, Cell Thurs, Cell Fri, Cell Sat, Cell Sun = 'LT' then SUM all mins late

but excel is saying there are to many arguements, any one any ideas can provide sample spreadsheet if needed

View 9 Replies View Related

Array To Check Cells

Oct 7, 2011

I have the following code that i want to use to run trough a few checkboxes to check the value and then wright something in a cell. i have written the the checkbox name to a variable and then want to use it in the if command but gives me a type mismach.

Dim CheckBox As String
For i = 1 To 204
For c = 3 To 227
CheckBox = "Sheet3.CheckBox" & i & ".Value"
If CheckBox = True Then
Range("J" & c) = "Done"
Range("J" & c) = ""
End If

View 9 Replies View Related

Check 4 Cells Have Same Numbers In

Apr 8, 2012

I want to do a check with one cell that has a list of a maximum of 4 numbers seperated by a comma and space, with 4 cells that have one of these numbers in each of them. The numbers wont be in the same order, and they wont be repeated.

A3 = 4, 12, 19, 34
A4 = 12
A5 = 19
A6 = 4
A7 = 34

I only need to highlight if they dont match. So result could either be a tick or cell changes colour.

View 9 Replies View Related

Check If Cells Contains Only Numbers

Dec 12, 2006

how to check if cells contain only whole numbers (cells are in text format)?

I do not know how the code is for the activecell checking

Example Range("A1:A10")


As soon the code hits a cell containing something other then numbers then Msgbox "Error"

Sub Check()

i = 1
Do Until Cells(i, 1).Text = ""
Cells(i, 1).Select

If Not Activecell.Text only numbers then
MsgBox "Error"
End If

i = i + 1


End Sub

View 9 Replies View Related

Create Cells To Be Like A Check Box

Aug 13, 2007

Is there a way to create cells to be like a check box. I am creating a survey in which there are 5 options and what I would like to do is make the cells so that that when they click into the cell it puts an X in it or maybe highlights that cell.

View 9 Replies View Related

Check Blank Cells

Jun 4, 2008

I'm trying to scan a column of data, example column H, for empty cells, if it's empty then skip it. This doesn't work, because cell.Value = " ":

If cell.Value 0 Then
'Extra coding
End If

View 9 Replies View Related

Check Locked Cells

Nov 6, 2008

Sub PastSpec()
If Selection.Locked = True Then Exit Sub
On Error GoTo ErrHan
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Exit Sub
End Sub
I recorded part of it and adapted it afterwards. You will notice I have a line to check for locked cells, this does its job if the cell selected is locked. However if the cell selected is unlocked and the cell below is locked the code still excutes and pastes.

View 9 Replies View Related

Check First 2 Cells Of The Last Row Is Null Or Not

Jan 19, 2009

In a column "V", when the user enter "Y", i need to copy the entire row to another sheet("Written-off"), its working fine.Sometimes the first 2 columns of that entire row where the user enter "Y" may be null, so using my code, copy first entire row where user put "Y" and paste to another sheet("Written-off"), then user also enter "Y" to wherever in "V" column, this time the entire row should overwrite the last row in the "Written-off" sheet.

I found the reason is first column of the last row was null, so when check the first cell, if it is empty then the next entire row should be copied that area.
Is there anyway to check first 2 cells of the last row in a sheet in null or not?

If Right(Left(ActiveCell.Address, 2), 1) = "V" Then
myColumn = "V"
If Intersect(Target, Columns(myColumn)) Is Nothing Then Exit Sub
On Error GoTo last
If UCase(Target.Value) = "Y" Then
Target.EntireRow.Copy Sheets("Written-Off").Range("A" & Rows.Count).End(xlUp)(2)
Application.CutCopyMode = False
Exit Sub
End If

View 9 Replies View Related

Get A Formula To Check 2 Cells For A Value

Feb 15, 2007

I have two cells which refer to employee number: A1 and A2
(employee numbers are 001, 002, 003, etc)

I want Cell A3 to check if either A1 or A2 = 001

If both cells is 001, I want an "error message" because that is not allowed, and if one of them = 001 then I want the value from Cell A4 to be but in Cell A3.

So in my head the forumla should go like:

=If(A1 Or A2 = 001;A4;"-";)

View 9 Replies View Related

Check If 2 Cells Are The Same To A Tolerance

Mar 3, 2007

I am successfully using VBA to check a cell on one sheet against a cell on another sheet.

How easy would it be to check if this is the same OR less than 2 or more than 3? I have done part of this using nested formulas but cant find anything to help me with the syntax in VBA

The code I am using is

If W1.Cells(a, 3).Value = W2.Cells(b, 3).Value Then

View 4 Replies View Related

Check Cells Value Before Macro Run

Jul 29, 2007

I have completed a formulation and included in a macro but I dont know about coding to check for specific cell string values before macro will take off. I want macro to check that if specific cell text are not matched, use MsgBox to display the wrong versus correct cell string text, then vbOK to exit macro. Also, if Range(B2:G2,J2) are completely blank, use MsgBox to display "missing data", then vbOK to exit macro.

cell B =REQ
cell C =SS
cell D =Current Stock
cell E =PO
cell F =Sales Order
cell G =In-coming
cell L =unit cost

If these cell texts (U or L case will do) are in their specific cells, macro will proceed. If either one or some of these cell texts are not matched, display MsgBox of the wrong and correct cell texts. Then button OK to stop macro run. If Range(B2:G2,J2) are completely blank, use MsgBox to display "missing data", then vbOK to exit macro.

View 3 Replies View Related

Check For Values Greater Than Zero In 2 Cells

Nov 3, 2008

I want to divide the numbers from 2 cells, down a long column. Let's further say that in some instances there aren't any numbers in either of the cells. You get a divide by zero error.

So you have values in a1 and b1 through a10 and b10. You want to divide the value in the a column by the value in the b column and return the answer in the adjacent c column. You've copied the formula all the way down to c20.

All the cells from c11 to c20 will have divide by zero errors.

What is the syntax to check if both cells in columns a and b are greater than zero so that either an answer will be returned or just a blank cell will result, (when nothing is in one of the cells from a or b?

The following formula works for checking the status of cell A, how do I also check the value in cell B?

something like?:
=(IF(A5>0 and B5>0,A5/B5,""))

View 4 Replies View Related

Check Range Of Cells For A Word?

May 28, 2014

This does not seem to be working and I do not know why.

If Range("T3:T999").Value = "Duplicate" Then
MsgBox "It did work"
MsgBox "What happened??"
End If

View 1 Replies View Related

Check If 2 Cells Contain The Same Specific Text?

Aug 7, 2014

What I am attempting to do is search if 2 cells contain specific text. For example in Column C I want to output "Yes" only if cell A and B are Yes otherwise the output is "No".


I have tried =IF(A1=B1="Yes", "Yes, "No") to no avail

View 4 Replies View Related

Check A Range Of Cells For Empties

Dec 11, 2008

Upon deactivation of a worksheet I am trying to check a range of cells("B8:M8") for empties. If any cells are empty I want to generate a MsgBox that asks the user to remedy the situation. It is not necessary to tell them which cell is empty but it would be nice. Can anyone help me format this code?

View 2 Replies View Related

Check Range Of Cells For Data

Apr 12, 2009

I am using the following code to check data is entered in certain cells...

View 2 Replies View Related

Check Selected Cells For Information

Sep 8, 2009

I have the following code in a macro of mine which checks each cell has something entered and if not gives the message box.

View 5 Replies View Related

Copyrights 2005-15, All rights reserved