| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
FORMULA
I have a hodge-podge list of numbers and letter-number combinations. I need
excel to tell me when any of those values appear in collumns J-N . can this be done and how? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMULA
Where do you want an answer. Here or worksheet functions. In the future,
please do NOT post in more than one group as most of us who help read them all. -- Don Guillett Microsoft MVP Excel SalesAid Software "attyshane" wrote in message ... I have a hodge-podge list of numbers and letter-number combinations. I need excel to tell me when any of those values appear in collumns J-N . can this be done and how? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
FORMULA
this might work...assuming your list starts in column a2...
=IF((SUMPRODUCT(--($J$2:$J$65536=A2))+SUMPRODUCT(--($K$2:$K$65536=A2))+SUMPRODUCT(--($L$2:$L$65536=A2))+SUMPRODUCT(--($M$2:$M$65536=A2))+SUMPRODUCT(--($N$2:$N$65536=A2)))0,"Yes","No") "attyshane" wrote: I have a hodge-podge list of numbers and letter-number combinations. I need excel to tell me when any of those values appear in collumns J-N . can this be done and how? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
