Welcome Guest
Log In | Register )
You last visited December 9, 2016, 5:30 am
All times shown are
Eastern Time (GMT-5:00)

Got formulas-- need help intrepreting

Topic closed. Posted 11 years ago. No replies.

Page 1 of 1
PrintE-mailLink
lottaloot's avatar - AvatarZ56
Redford/MI
United States
Member #3396
January 18, 2004
4867 Posts
Offline
Posted: June 29, 2005, 10:19 pm - IP Logged

=MATCH(TRUE,MMULT(--(H2:M4=TEXT(O1,"@")),TRANSPOSE(COLUMN(H2:M4)*0+1))>0,0)-1
or
=MATCH(TRUE,COUNTIF(OFFSET(H2:M4,ROW(H2:M4)-MIN(ROW(H2:M4)),0,1),O1)>0,0)-1

where O1 would contain the pair of interest.

It's a CSE formula. 

Any excel experts to intrepret this for me & prehaps make an easier formula --because I did not write this

got an excel genie to do it for meBig Smile but they have no time to explain it to me.

And I can't make it work until I know how it works Disapprove well, I can but I don't like not knowing how it works