Hello,
Hoping for some assistance please .I would like to have the list of numbers copied from COL A and placed into COL B. These lists are separated by other info. The first lot are in Row 18,then the next in Row 176,the next in R376 and so on. The amount of numbers in each group varies.
Last edited by plato; 02-01-2012 at 05:21 AM. Reason: solved
Put this formula in B1 and copy down:
=IF(ISNUMBER(A1),A1,"")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Hello JBeaucaire,
Thank you for very fast response.That works well.I was about to edit the post as further down I notice that some of the lists have numbers with an e on the end.For example row 949 15e.I wonder is there a way these could be included?
Maybe we can look the other direction:
=IF(D1<>"", A1, "")
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
try
=IF(ISNUMBER(SUBSTITUTE(A1,"e","")+0),A1,"")
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hello,
Thank you both,it appears I now have two solutions,both working well as per attachment.Thank you for your time and efforts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks