View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Repeating an entry

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