Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula: # entered in column B will transfer to column D
i want to enter a # in one column, then need that number to appear in
another. ie: Column B & D are the same i enter 55 in B and 55 will appear in D. I cant seem to find the formula. Also need the entire column from row 6 to 250. Thanks for any suggestions, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula: # entered in column B will transfer to column D
On Fri, 31 Oct 2008 19:40:01 -0700, JENAB
wrote: i want to enter a # in one column, then need that number to appear in another. ie: Column B & D are the same i enter 55 in B and 55 will appear in D. I cant seem to find the formula. Also need the entire column from row 6 to 250. Thanks for any suggestions, D6: =B6 fill down to D250 --ron |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula: # entered in column B will transfer to column D
Put this in D6:
=IF(B6="","",B6) then copy down to D250. The cells in column D will mirror what is in column B. Hope this helps. Pete On Nov 1, 2:40*am, JENAB wrote: i want to enter a # in one column, then need that number to appear in another. ie: Column B & D are the same i enter 55 in B and 55 will appear in D. *I cant seem to find the formula. *Also need the entire column from row 6 to 250. *Thanks for any suggestions, |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula: # entered in column B will transfer to column D
On Fri, 31 Oct 2008 19:40:01 -0700, JENAB
wrote: i want to enter a # in one column, then need that number to appear in another. ie: Column B & D are the same i enter 55 in B and 55 will appear in D. I cant seem to find the formula. Also need the entire column from row 6 to 250. Thanks for any suggestions, Actually, that should be D6: =IF(B6="","",B6) or else you'll see zeros where there are blanks in col B --ron |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula: # entered in column B will transfer to column D
i tried that kept getting message formula error. what I need is acutally the
numbers i enter in column L to repeat into coloum R; then Column S to repeat to column V, each row from 6 to 250 "JENAB" wrote: i want to enter a # in one column, then need that number to appear in another. ie: Column B & D are the same i enter 55 in B and 55 will appear in D. I cant seem to find the formula. Also need the entire column from row 6 to 250. Thanks for any suggestions, |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need formula: # entered in column B will transfer to column D
Where in column L are you entering the number? L1, L10000, L1000000? or are
you entering different numbers in all the cells L6:L250? When you say repeat do you mean that the number you type in in one cell should appear in all the cells or maybe the one adjacent to it, or ....? For example if you want the entry in R6 to equal the entry in L6 then =L6 if you don't mind seeing 0's when L6 is empty. or =IF(L6,L6,"") if column L's data is only numbers or blanks or =IF(L6="","",L6) for any data type and copy this down to R250. If you want the entry in R6:R250 to equal what you enter in L6 then =L$1 or =IF(L$6,L$6,"") or =IF(L$6="","",L$6) and copy this down to R250. Same comments as above. Identical idea for columns S and V. -- Thanks, Shane Devenshire "JENAB" wrote: i tried that kept getting message formula error. what I need is acutally the numbers i enter in column L to repeat into coloum R; then Column S to repeat to column V, each row from 6 to 250 "JENAB" wrote: i want to enter a # in one column, then need that number to appear in another. ie: Column B & D are the same i enter 55 in B and 55 will appear in D. I cant seem to find the formula. Also need the entire column from row 6 to 250. Thanks for any suggestions, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transfer a column into a row? | Excel Discussion (Misc queries) | |||
Is there a formula to transfer the last value in a column | Excel Worksheet Functions | |||
Looking for formula that selects last value entered in a column? | Excel Worksheet Functions | |||
add numbers in a column and transfer result to another column | Excel Worksheet Functions | |||
transfer data from one column into another column | Excel Discussion (Misc queries) |