tenriquez199
asked on
how can i select cells with certain value in excel over numeric cells treating them as string values
hi
i have an excel sheet with numeric values at column D
i need to select rows who contain value 889490 at any record at column D
someone know how to do this via excel or vba?
thanks
MINUTA-2284820110311.xls
i have an excel sheet with numeric values at column D
i need to select rows who contain value 889490 at any record at column D
someone know how to do this via excel or vba?
thanks
MINUTA-2284820110311.xls
Hi
Or
in K2
=RIGHT(D2,6)="889490"
go to Data > Advanced Filter > Check on 'Filter the list, in place'
list range: A1:I827
criteria range: k1:k2
click ok.
Also see the attached image.
Kris
AdvFilter.JPG
Or
in K2
=RIGHT(D2,6)="889490"
go to Data > Advanced Filter > Check on 'Filter the list, in place'
list range: A1:I827
criteria range: k1:k2
click ok.
Also see the attached image.
Kris
AdvFilter.JPG
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
E.g., column M2 and copy down:
[M2]=Text(D2,"0#")
Add column M to the filter, then search on contains 889490
See attached.
Dave
MINUTA-2284820110311.xls