View Single Post
  #6   Report Post  
Max
 
Posts: n/a
Default

You're welcome !

I used "255" as the width param in the OFFSET
to cover all the cols from col B across to col IV
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"rlchavda" <rlchavda.1s2hq4@ wrote in message
...

Hi,
I have got one answer like
SUM(OFFSET(B1,MATCH(A10,A2:A5,FALSE),0,1,55)) and yours also seems to
be what I was looking for.Thanks

I greatly appreciate both of your help.

Thanks
Raj.


--
rlchavdaPosted from http://www.pcreview.co.uk/ newsgroup access