The Open Door Web Site
Using MS Excel as a Database
ICT in Biology Index
ICT IN BIOLOGY
Using MS Excel 2013 as a Database
Using the Custom option
This is very useful if you want to compare results, for example those of volunteer 3 and volunteer 7.
Return to the complete database that you saved to your desktop. The empty lines should have been removed!
Click on the arrow in A1 and select Number Filters and Equals option.
The following Custom AutoFilter pop-up box appears
Enter the information as shown below
You have now filtered the information from volunteers 3 and 7 only.
Now go to cell B1 and click on the arrow
You can now compare the results from day 8 from the two volunteers selected.
N.B. Notice that two arrows in line 1 are now showing the filter icon. This means that you have to click on both arrows, selecting ALL in each case, to return to the complete database.
The Open Door Web Site is non-profit making. Your donations help towards the cost of maintaining this free service on-line.
Donate to the Open Door Web Site using PayPal