| Topic: | Re:Re:Excel sorry another question | |
| Posted by: | George Turner | |
| Date/Time: | 27/04/15 12:46:00 |
| Thanks, that's great. I think I've cracked it with the third col approach using =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))>1,0,1) As it all starts after a header row. This is then copied down and a Pivot Table harvests the results. |
| Topic | Date Posted | Posted By |
| Excel sorry another question | 27/04/15 11:29:00 | George Turner |
| Re:Excel sorry another question | 27/04/15 11:38:00 | Matteo Castagna |
| Re:Re:Excel sorry another question | 27/04/15 12:46:00 | George Turner |