Hi Sandy Mann,

Based from the requested HELP infos, i don't know who's head was hit !

regards,
driller
--
*****
birds of the same feather flock together..



"Sandy Mann" wrote:

I'm glad of that but I don't see any substantial difference between mine and
driller's answers

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Barty" wrote in message
...
That hit the nail on the head

"Sandy Mann" wrote:

Try:

=IF(AS18=ROW(A18),A18,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Barty" wrote in message
...
How do i get the constants in a formula to change when i fill down
EG
=if(as18=18,a18,"") in cell X
=if(as19=19,a19,"") in cell Y