|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 26th, 2004, 09:05 AM
|
|||
|
|||
|
excel fucction help
I am trying to get two colums of numbers on an excel speadsheet to to compare eachother and return the matching pairs. any ideas
Last edited by tool616 : May 26th, 2004 at 09:51 AM.
|
|
#2
July 1st, 2004, 12:43 AM
|
||||
|
||||
|
Column A:
2 3 4 5 6 Column B: 2 3 4 8 9 Column C: =IF(A1=B1,TRUE,FALSE) =IF(A2=B2,TRUE,FALSE) =IF(A3=B3,TRUE,FALSE) =IF(A4=B4,TRUE,FALSE) =IF(A5=B5,TRUE,FALSE) And the results are that Column C would show this: TRUE TRUE TRUE FALSE FALSE
__________________
J. Paul Schmidt www.Bullschmidt.com - Freelance Web and Database Developer www.Bullschmidt.com/DevTip.asp - Classic ASP Design Tips
|
|
| Viewing: ASP Free Forums > Programming > Code Bank > excel sopreadsheet help\ |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
