The Open Door Web Site |
|||||||
|
ICT IN BIOLOGY USING EXCEL AS A DATA BASE CONTINUED DATABASE OF FEMALE REPRODUCTIVE HORMONES Using the Custom option This is very
useful if you want to compare results, for example
those of volunteer 3 and volunteer 7.
Enter to information as shown below
And OK 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. Notice that two arrows in line 1 are now coloured (in this case, blue). This means that you have to click on both arrows, selecting ALL in each case, to return to the complete database. |
© Paul Billiet and Shirley Burchill 2007 |
|||||