15th May 2012, 04:54 PM
|
|
Suspended
|
|
Join Date: Jan 1970
Location: Melbourne
Posts: 5,359
|
|
Excel Help needed
What I wish to do is for a Star to appear in Column E if the animal is Ranked 6th to 8th
I will manipulate the Data and the animals may change their ranking.
When I have done with the worst Ranked animal I will clear its D Cell.
Then I wish Column E to ignore the worst animal and put a Star in the 5th to 7th worst animals.
I was hoping that Column E would automatically ignore the D Cell if it was empty.
|