View Full Version : Excel

07-03-2005, 03:45 PM
I am desiging a program the calculates placings for competitions

I have 4 cells (A1 to A4) which get filled with Blue,Red,Green,Yellow by a macro but if it is a draw one group name gets overwritten by another which leaves a blank cell

I am looking for either a macro or forumla which tells you which one is missing

07-03-2005, 05:03 PM
Hi, you'll need to clarify this a bit more. So a draw is based upon 1st equal etc? You have 4 colours, so how are the four separated? Its difficult to advise unless I can understand the layout.

I'll send you a PM and you can email the book if you want.