Hello Excel experts,
I need to show in worksheet only rows that cointans 2 first digits Uppercase, it is possible?
Hello Excel experts,
I need to show in worksheet only rows that cointans 2 first digits Uppercase, it is possible?
Try this, untested:Please Login or Register to view this content.
Click the * to say thanks.
its not working runtime error 438
This one will work. I used the range of rows from 2 to 100. Change as you find fit:
Please Login or Register to view this content.
This is working but honestly not like i need this is my fault i didnt say that correctly, for example ive got row like this :
someAAa some SOme some1 sOMe and can i filter only cells that contain 2 Uppercase digits next to , doesnt matter in first digit or last
Try
Please Login or Register to view this content.
Wow this is working excatly that i wanted, can I also colour or do something with this cells in row that contain 2 uppercase digit? and this is all for me
Not filter out but color the cell?
Please Login or Register to view this content.
Attachment 644238 it should color more than this there is more situation where is 2 digits in row Uppercase : (
Invalid attachment.
Upload a workbook instead of a picture, I don't work with a picture.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks