excel formula

[John777]

How do I get "=MATCH(C2,ADDRESS(B17+4,1,4,1):ADDRESS(B17+4,10,4,1))" to work?

 

[JE McGimpsey]

one way:

=MATCH(C2,INDIRECT(ADDRESS(B17+4,1,4,1) & ":"
&ADDRESS(B17+4,10,4,1)))

Although it would be much more efficient to use:

=MATCH(C2,OFFSET($A$1,B17+3,0,1,10))

 

[John777]

Thank you, your fix worked perfectly.

one way:

=MATCH(C2,INDIRECT(ADDRESS(B17+4,1,4,1) & ":"
&ADDRESS(B17+4,10,4,1)))

Although it would be much more efficient to use:

=MATCH(C2,OFFSET($A$1,B17+3,0,1,10))

 

[meena khan via OfficeKB.com]

Hi dear !

i need ExceL formula if you help Me tHeN pLz send Me tHe Excel formulas ok
.......



thanks

Tanha

 

[meena khan via OfficeKB.com]

hi dear

i need Grade formula and persontage if any one have plz seNd me




thaNks

khan

 

[Max]

Try: =MATCH(C2,INDIRECT("A"&B17+4&":J"&B17+4),0)

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----

How do I get "=MATCH(C2,ADDRESS(B17+4,1,4,1):ADDRESS(B17+4,10,4,1))" to

work?

 

[Kassie Kasselman via OfficeKB.com]

Hey Tanha

I suggest you start a new thread, and specify what it is that you are
looking for