scanning and grouping entire rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how would I set something up to scan a spreadsheet's rows for certain
criteria and if that criteria is met within one of the rows cells, then
list/group that entire row?
 
Nate

Programmatically or via the UI, you would use Data>Filter>Autofilter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete rows but keep formatting to 1000 4
Copy Entire Row 4
CF or VBA 2
Auto Copy Data from one worksheet to another 1
delete entire row with condition 7
Best Method to Remove Data Rows 7
Insert number of rows based on criteria 6
Programm Auto filter for overdue time 1

Back
Top