Using Filtering in Excel
Excel that allows you to "filter" data as necessary.
On the raw data sheet, select the column you would like to use as
your filter criteria. You should see the whole column highlighted.
${imageID}. Screenshot
Now, from the "Data" menu, select "Filter" -> "Auto Filter".
${imageID}. Screenshot
You should see like a "drop down" menu added to the top of the selected
column. Now from that column, filter on "1". This will show only those rows
where the selected column has a value of "1" (you can filter on anything,
other "1". "1" is just an example in this case).
${imageID}. Screenshot
Please refer to the following web page for help with Excel filtering:
http://www.rdg.ac.uk/ITS/info/training/notes/excel/filters/#FilNum
|
You may also be interested in...
|
