Thread
:
If then statement
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
If then statement
=IF(ISNA(MATCH(A6,B6:F6,0)),"",A6)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Kat" wrote in message
...
I have a spreadsheet that i need to do an if then statement for that I
can't
figurar out. This is what I need done: Any number that equals the same
as
the key row needs to be displayed in the results row. See below
Key B C D E F
G Results
1 1 2 3 4 5
6 1
2 2 3 4 5 1
5 2
3 3 4 5 1 2
7 2
So in the results column i need to put the if then statement = If column
B:F=A1 or " " then =
I hope someone can understand this.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett