Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pick the only number in a column and copy it to another?
I have a column that contains a formula which will return 50 results. 49
results will be false. One will be an actual number. I need to copy that number to another cell automatically. Sounds simple right? The number will move around the column depending on user input. It will rarely be in the same location twice. I need to tell Excel to find the number in the column (there will always be just one) and copy it to a new cell. If the spreadsheet would be helpful, let me know who to email it to. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pick the only number in a column and copy it to another?
If you want to send it to me, I can probably whip out a macro for you pretty
fast. Send it to . - NewGuy "Mawaller" wrote: I have a column that contains a formula which will return 50 results. 49 results will be false. One will be an actual number. I need to copy that number to another cell automatically. Sounds simple right? The number will move around the column depending on user input. It will rarely be in the same location twice. I need to tell Excel to find the number in the column (there will always be just one) and copy it to a new cell. If the spreadsheet would be helpful, let me know who to email it to. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pick the only number in a column and copy it to another?
Cell location
=ADDRESS(MATCH(MIN(A1:A50),A1:A50,0),1) "Mawaller" wrote: I have a column that contains a formula which will return 50 results. 49 results will be false. One will be an actual number. I need to copy that number to another cell automatically. Sounds simple right? The number will move around the column depending on user input. It will rarely be in the same location twice. I need to tell Excel to find the number in the column (there will always be just one) and copy it to a new cell. If the spreadsheet would be helpful, let me know who to email it to. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I pick the only number in a column and copy it to another?
=MIN(A1:A50)
"Mawaller" wrote: I have a column that contains a formula which will return 50 results. 49 results will be false. One will be an actual number. I need to copy that number to another cell automatically. Sounds simple right? The number will move around the column depending on user input. It will rarely be in the same location twice. I need to tell Excel to find the number in the column (there will always be just one) and copy it to a new cell. If the spreadsheet would be helpful, let me know who to email it to. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I pick the only number in a column and copy it to another? | Excel Discussion (Misc queries) | |||
FORMULA TO PICK NUMBER | Excel Worksheet Functions | |||
I need to total col, but pick up number in other col. if not 0 | Excel Worksheet Functions | |||
copy a formula that does not change the column or row number? | Excel Discussion (Misc queries) | |||
How do I pick a number from a list in Excel? | Excel Worksheet Functions |