Repeating an entry

[Timeferret]

If place an entry in F1 what formula do I need to write so the same entry appears in F10?

[Trevor Shuttleworth]

=F1

Regards

Trevor


"Timeferret" <[email protected]> wrote
in message news:[email protected]...
>
> If place an entry in F1 what formula do I need to write so the same
> entry appears in F10?
>
>
> --
> Timeferret
> ------------------------------------------------------------------------
> Timeferret's Profile:
> http://www.excelforum.com/member.php...o&userid=19170
> View this thread: http://www.excelforum.com/showthread...hreadid=571916
>

[Timeferret]

Excellent !! Thank you

[Marcelo]

hi,

in f10 use

=if(f1<>"",f1,"")

--

hth
regards from Brazil
May the force be with you
Marcelo
*******************


"Timeferret" escreveu:

>
> If place an entry in F1 what formula do I need to write so the same
> entry appears in F10?
>
>
> --
> Timeferret
> ------------------------------------------------------------------------
> Timeferret's Profile: http://www.excelforum.com/member.php...o&userid=19170
> View this thread: http://www.excelforum.com/showthread...hreadid=571916
>
>