|
||||||||||||||||||||
|
|||||||||||||||||||||
|
#1
01-05-2007, 10:02 AM
|
|||
|
|||
Find
In a work sheet and i have one row of two codes like 1000 and 1100 and other row is dates for the fill year occured again and again.
Is there a way to find out that if two codes occured on same date please help me if any body can thanks 
|
|
#2
01-05-2007, 11:30 AM
|
||||
|
||||
|
Say your codes are in A2:Z2....and your dates are in A3:Z3....
try: =SUMPRODUCT(--($A$2:$Z$2<>A2),--($A$3:$Z$3=A3)) copied to the right... If you have a result of 1 or more, then the date is repeated for opposite code...if you have a result of 0, then the "other" code does not appear for same date within range....
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#4
01-06-2007, 09:52 PM
|
||||
|
||||
|
Same idea....just transposed...
Try =SUMPRODUCT(--($F$2:$F$100<>F2),--($G$2:$G$100=G2)) copied down... adjust ranges to suit your actual range sizes.... If you have a result of 1 or more, then the date is repeated for opposite code...if you have a result of 0, then the "other" code does not appear for same date within range....
__________________
Where there is a will there are many ways. Finding one that works for you is the challenge! Please read the Forum Rules: Rules
|
|
#6
01-09-2007, 12:56 PM
|
|||
|
|||
|
find
Hi my helper
thanks a lot you helped me a lot but i have one more question this formula works fine with one person in the list. what to do if there are hundreds of names and every one using those dates. is there any solution for it. thanks again i hope you will be able to help me
|
|
#7
01-09-2007, 01:01 PM
|
|||
|
|||
|
Hi,
NBVC has provided you with an excellent formula, which would work for hundreds of names ... the formula has to be adjusted accordingly ... However, if you want a summary table, I would recommend a simple pivot table ... HTH Carim 
|
 |
| Bookmarks |
New topics in F1 Get the most out of Excel Formulas & Functions
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
