Filtering information (XP)

Topic

New Reply

The attched is a dummy sheet based upon a poorly developed worksheet containing hundreds of lines. What the end user wnats is to be able to filter based upon the User ID in order to show the information which has been inputted by various users. For example by filtering based on user 1645004 rows 1 to 8 would show; filtering based upon164005 would show rows 19-36.

This is more than just using the filtering option in Excel. Is what the user wants possible? VBA code is fine.

Using Access is not possible.

Reply | Quote

Replies

The worksheet looks like a report from a database system exported to Excel. This format is not intended for or suitable for filtering. If possible at all, you should use the database to filter and display data.

Reply | Quote

Alternatively, export the data from the database in a table format instead of in a report format. You can then use the filtering options built into Excel.

Reply | Quote

Insert a header row above your current Row 1 (add headers, fro example A1 = User ID, B1 = Full Text)

In the new A2 enter:
=IF(ISNUMBER(SEARCH(“Page :”,B2)),RIGHT(B7,7),A1)

Copy A2 down the column. add an Autofilter

Now you can filter on Column A for the User ID desired

Steve

Reply | Quote

Entering the formula in A2 gives me “User ID” not the number I would have expected. Copying down gives me USER ID down the column. When I AutoFilter there are no numbers to select from.

Reply | Quote

Did you follow all the directions?

This is the file Iget from your example

Steve

Reply | Quote

Missed a space between Page :. Thanks this is really helpful.

Reply | Quote