Patcheen
Active Member
- Joined
- Sep 28, 2015
- Messages
- 388
- Office Version
- 365
- Platform
- Windows
HI all
Im currently using this formula
=INDEX(EMD!A2:A2000,MATCH(1,(U1=EMD!B2:B2000)*(V1=EMD!C2:C2000),0))
a2:a2000 are dates
B2:B2000 is numbers 100 to 1000 and c2:c2000 are also numbers 100 to 1000
im trying to include Aggregate so i can see when 2 numbers appeared together more recently.
the above formula works perfectly but only gives me the first time they appeared together
TIA
Im currently using this formula
=INDEX(EMD!A2:A2000,MATCH(1,(U1=EMD!B2:B2000)*(V1=EMD!C2:C2000),0))
a2:a2000 are dates
B2:B2000 is numbers 100 to 1000 and c2:c2000 are also numbers 100 to 1000
im trying to include Aggregate so i can see when 2 numbers appeared together more recently.
the above formula works perfectly but only gives me the first time they appeared together
TIA