Find and copy number to new cell [Archive]

View Full Version : Find and copy number to new cell

holmbjerg

2011-10-20, 09:06 AM

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

2011-10-21, 04:03 AM

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.