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
Is your data in tabular format? One way would be to do the following:
After that, you just need to right click and update the PivotTable to keep the list in sync with your data.
- 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
Ken Puls, FCPA, FCMA, MS MVP
Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!
Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter
If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.
Bookmarks