Find and copy number to new cell

[holmbjerg]

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]

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.