Home |
Search |
Today's Posts |
#1
|
|||
|
|||
If And Or functions
Hello,
Looking for help in using above functions in one formula if possible. A B C 1 1234 195 formula (with "yes" return) 2 1234 190 "yes" return also needed because it corresponds with equal number above it 3 2222 195 "yes" return also needed 4 2222 195 "yes" return also needed 5 2222 190 "yes" return also needed I'm looking to get a "yes" return in column (C) if the number in column A (A1) matches the one after it (A2) but only if the first number (A1) has 195 in column B (B1) and 190 or 195 in column B (B2) for the equal number in (A2). I also need a "yes" return for the second number for filtering purposes. I have a long list of numbers and I've Sorted it first by column A then by B in descending order. I'm looking to autofilter list (column c) by "yes" but need to view all equal numbers (A1 & A2). I hope I explained this correctly. Any help is greatly appreciated. Soz |
#2
|
|||
|
|||
Hi Soz
try - for C1 =IF(AND(A1=A2,B1=195,OR(B2=190,B2=195)),"yes","no" ) for D1 and fill down rest of list =IF(AND(A2=A3,B2=195,OR(B3=190,B3=195)),"yes",IF(A ND(A2=A1,B1=195,OR(B2=195,B2=190)),"yes","no")) Cheers JulieD "Soz" wrote in message ... Hello, Looking for help in using above functions in one formula if possible. A B C 1 1234 195 formula (with "yes" return) 2 1234 190 "yes" return also needed because it corresponds with equal number above it 3 2222 195 "yes" return also needed 4 2222 195 "yes" return also needed 5 2222 190 "yes" return also needed I'm looking to get a "yes" return in column (C) if the number in column A (A1) matches the one after it (A2) but only if the first number (A1) has 195 in column B (B1) and 190 or 195 in column B (B2) for the equal number in (A2). I also need a "yes" return for the second number for filtering purposes. I have a long list of numbers and I've Sorted it first by column A then by B in descending order. I'm looking to autofilter list (column c) by "yes" but need to view all equal numbers (A1 & A2). I hope I explained this correctly. Any help is greatly appreciated. Soz |
#3
|
|||
|
|||
If I understand correctly, you could do a vlookup formula to search your number in column B and then return true if the same number is in the column. If I misunderstood let me know because I do the same thing your doing all the time. -- Coltsfan ------------------------------------------------------------------------ Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982 View this thread: http://www.excelforum.com/showthread...hreadid=345938 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
# of Functions per cell | Excel Worksheet Functions | |||
PivotTable canned functions | Excel Discussion (Misc queries) | |||
Changing the language of built-in functions? | New Users to Excel | |||
How to load Engineering Functions into the Fx function wizard? | Excel Worksheet Functions | |||
Where can I see VBA code for financial functions? | Excel Worksheet Functions |