Name the range Drivers!$A$2:$A$65 as MYROW and
Drivers!$B$2:$B$65 as MYCOL
The in Matrix!B2 use this formula.
=CHOOSE(SUMPRODUCT((MYROW=$A2)*(MYCOL=B$1))+1,"","Y","X")
Copy across and down.
Note that the X is there as row 39 column 15 is in your list twice.
Thanks Andy, that's working a treat. One other related question - is it possible that if besides the MYROW and MYCOL columns there was another one called (let's say) MYNUM which has a number in it - is it possible to put that in instead of the Y.
That'll teach me to use RANDBETWEEN!Note that the X is there as row 39 column 15 is in your list twice.
Many thanks,
SamuelT
Yes.
If you named the range of values in column C MYVALUES use this new formula on the Matrix sheet
=SUMPRODUCT((MYROW=$A2)*(MYCOL=B$1)*MYVALUES)
Great stuff. Thanks Andy - much appreciated.
Solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks