Forum Home
Press F1
 
Thread ID: 55275 2005-03-07 02:45:00 Excel Dannz (1668) Press F1
Post ID Timestamp Content User
331415 2005-03-07 02:45:00 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
Dannz (1668)
331416 2005-03-07 04:03:00 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.
Parry (5696)
1