I gave you my email address:

pashurst at auditel dot net

Pete

On Jul 7, 10:16*am, anyole wrote:
that's great pete. what email shall i use? ?
anyole
--
ino ne sauti ya anyole okhurula ebusikhale emmayoka. orakhaenda omwoyo tawe.
khuli halala. nyasaye akhulinde. embwo



"Pete_UK" wrote:
If your addresses are not confidential, would you like to send the
file to me and I can sort it for you?

Send to:

pashurst at auditel dot net

Change the obvious.

Hope this helps.

Pete

On Jul 7, 9:44 am, anyole wrote:
am about to raise the white flag but something tells me not to. i have opied
the " mark and pasted where appropriate but when i shift+ctr+enter, what i
get in colum B is #N/A and nothing happens in column C either wher i have
pasted the second formula.

for your information, am pasting teh formulae here. plse see if am doing the
right thing.

=IF(MOD(ROW()-ROW($B$4),2)=0,MATCH(1,(MOD(ROW($A$4:$A$33)-ROW($A$4),2)=0)*(**COUNTIF($A$4:$A$33, "< "&$A$4:$A$33)=INT(ROWS($B$4:B4)-1)/2),0),"")

=IF(B4<"",INDEX($A$4:$A$33,B4*INDEX($A$4:$A$33,B3 +1))

as always many thanks
anyole
--- Hide quoted text -

- Show quoted text -