Quote:
Originally Posted by PSword
I think i have done it! but had to use hidden columns rather than do the whole thing in one go.
see attachement
Paul
|
A slightly more efficient formula would be:
=IF(COUNTIF($AX$4:$AX$6,T4)0,T$2,0)
in cell AF4 and copied down and to the right.
In order for it to work, cells AX4 to AX6 contain the letter P, M & D (one in each). These could be any cells anywhere... I just picked those because they were nearby and empty.