Not to put a downer on it but i need them to stay as constants so 18,19,20ect

SORRY

For what reason you're sorry?

regards,
driller

--
*****
birds of the same feather flock together..



"Barty" wrote:

Not to put a downer on it but i need them to stay as constants so 18,19,20ect

SORRY

"driller" wrote:

Hi Barty.

EG
=if(as18=ROW(AS18),a18,"") in cell X
=if(as19=ROW(AS19),a19,"") in cell Y

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



"Barty" wrote:

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