How do I pick the only number in a column and copy it to another?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
If you want to send it to me, I can probably whip out a macro for you pretty
fast. Send it to (e-mail address removed).

- NewGuy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Numbers showing Up Centered in Cell ? 1
Macro to add numbers in a text string 5
Copy Cells - using Variable 3
refer to whole column 2
Pick the low number in a column of Numbers 3
Excel 2002: How to pick up data from multiple columns ? 1
Formula to find the last number of a column (lower cell) 1

Back
Top