ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Consolidating a Matching List (https://www.excelbanter.com/excel-worksheet-functions/200479-consolidating-matching-list.html)

Peter

Consolidating a Matching List
 
Assume I have a list of 30 rows with 5 fields each. A user can select whether
a row is a match or not a match. I have setup a test to catch the selected
matches, however since it checks row by row I have blanks (since the
"non-match" return is a blank).

I want to list the matching rows without any blank rows for the non-matching
rows.

Any ideas?

Spiky

Consolidating a Matching List
 
What are you doing now? How does the user select the rows?

I was just doing this today myself. I made an extra column and put a
criteria in there. Then used Autofilter on that last column.


All times are GMT +1. The time now is 12:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com