Find and copy number to new cell

holmbjerg

New member
Joined
Oct 20, 2011
Messages
1
Reaction score
0
Points
0
Hi!

I need a formula that can search for 445 in a column and return only numbers that starts with 445

E.g.

"Raw" Data
1445116
1445116
22126E+12
221653E+12
221629E+12
221161E+12
445502E+14
445502E+14

Output (after formula)
445502E+14
445502E+14

Since I am not that good in VBA I need a straight forward formula ;)

Thanks
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,519
Reaction score
4
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Is your data in tabular format? One way would be to do the following:
  • Run a formula down beside your numbers that looks like =TEXT(A1,"###")
  • Create a PivotTable off that data
  • Put the values in the row field
  • Filter the row field to "Contains " your number
After that, you just need to right click and update the PivotTable to keep the list in sync with your data.
 
Top