I'm looking to find rows that contain a certain character in column G (*, asterisk) and then sort those rows and data based on value in H, ascending.
I've tried various combination of Index/Match but couldn't get it to count more than one instance of asterisk.
Sample data attached.
Last edited by DavidE21; 01-15-2019 at 02:13 PM.
Try:
Please Login or Register to view this content.
This seems to work! One question though - my original data (D,G,H columns) are on Sheet1 while the sorted selection (columns K and L) along with the macro button is located on Sheet2. How can I reference Sheet1 columns in the above macro? "Sheet!D" doesn't seem to work.
e.g.:
Please Login or Register to view this content.
Brilliant. Thanks.
What's the function of r and rw here? I'm guessing they regarding the cell in which the data starts?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks