Thanks again, Thats so obvious, I should be ashamed of myself!

On Mon, 6 Mar 2006 22:36:37 -0000, "Roger Govier"
wrote:

Hi Vert

Substitute the cell reference B1 for "Fred Bloggs"
{=IF(A1=MAX(($A$1:$A$120000)*--($B$1:$B$120000=B1))1,0)}
Make sure you use Ctrl+Shift+Enter when you edit the formula