How to filter the value starting with "EXT" in multiple rows of UserGroupAccess Colum

Hi,

Can any one help me how to display the Value starting with "EXT" in the User Group Access Column in the Attached Excel sheet? I need to display the values starting with "EXT" in the excel sheet for each row in the attached excel sheet.

Thanks,
Ravindra

Originally Posted by Leith Ross

Hello ravi3cha,

Welcome to the Forum!

1. Click the drop down button on "Usergroup Access" column.
2. Select "(Custom...)"
3. In the upper left drop down box select "Contains"
4. In the adjacent drop down box type in *EXT*
5. Click the OK button

Hi Ross,

Thanks for your reply but i need to display only the User Groups starting with EXT not the other groups in each row. As per your suggestion it is displaying the UserGroup other than EXT-groups in each row. But I want to display only the User groups starting with EXT in each of the row. For Ex:In first row, it should display only the EXT-Quanta*Computer*(QSMC) and the other User groups should not display. In the same manner I need to display the User groups starting with EXT in all rows.

Instead of selecting Contain to filter try selecting Begins with

Originally Posted by arthurbr

Instead of selecting Contain to filter try selecting Begins with

Hi Arthur,

Thanks for your updation, but when I use the Begins with "EXT" in Custom Filter, it is displaying only the rows which are starting with "EXT" User Group Access. For Ex: when we try to do as per your suggestion then it will not display the First row, which has one EXT User Group Access(EXT-Quanta*Computer*(QSMC)) and also when we use the above condition, it will display the other User Groups which are not starting with EXT UserGroups. But I need only the User Groups which are starting with EXT and it shouldnot display the Other User Groups in the same row.

Why not post a workbook showing " before " and "after" entered manually. I don't have a clue what you need

Originally Posted by arthurbr

Why not post a workbook showing " before " and "after" entered manually. I don't have a clue what you need

Hi ...Pls find the input and output files,if possible request you to provide a macro code for the same

Thanks..