Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i have num in call A1 whan i push enter i want the same number in A2
how i can do it ?? thx |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Maybe this, in A2: =IF(A1="","",A1)
-- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "MAN3282" wrote: i have num in call A1 whan i push enter i want the same number in A2 how i can do it ?? thx |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
in A2
=A1 -- Regards Roger Govier "MAN3282" wrote in message ... i have num in call A1 whan i push enter i want the same number in A2 how i can do it ?? thx |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm sorry I must point out my question more
I'm have at approximately four thousand row in the first column there Bahey figures To be equivalent or any method urges When I click the introduction of the figure in the row former replication If the equation you must be introduced in each cell No Warning only after the completion of these deficiencies and the problem Thank you for assistance and I hope I explained my question and help me "Roger Govier" wrote: in A2 =A1 -- Regards Roger Govier "MAN3282" wrote in message ... i have num in call A1 whan i push enter i want the same number in A2 how i can do it ?? thx |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I don't know about Roger, but I'm afraid I lost you there.
-- Max Singapore http://savefile.com/projects/236895 Downloads:17,000 Files:358 Subscribers:55 xdemechanik --- "MAN3282" wrote in message ... I'm sorry I must point out my question more I'm have at approximately four thousand row in the first column there Bahey figures To be equivalent or any method urges When I click the introduction of the figure in the row former replication If the equation you must be introduced in each cell No Warning only after the completion of these deficiencies and the problem Thank you for assistance and I hope I explained my question and help me |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Enter =IF(A1="","",A1) in B1
Select B1. In NameBox type B1:B4000 and hit ENTER key. CTRL + d to copy the B1 formula down to B4000 Gord Dibben MS Excel MVP On Mon, 11 Aug 2008 23:37:01 -0700, MAN3282 wrote: I'm sorry I must point out my question more I'm have at approximately four thousand row in the first column there Bahey figures To be equivalent or any method urges When I click the introduction of the figure in the row former replication If the equation you must be introduced in each cell No Warning only after the completion of these deficiencies and the problem Thank you for assistance and I hope I explained my question and help me "Roger Govier" wrote: in A2 =A1 -- Regards Roger Govier "MAN3282" wrote in message ... i have num in call A1 whan i push enter i want the same number in A2 how i can do it ?? thx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
How to search column, copy row, and copy to another sheet in same | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |