Try, in Aussiebear's workbook, in cell D3:and copy down. It should work in any version of Excel from 2007=COUNTIFS($B$3:$B$35,B3,$C$3:$C$35,C3)
Try, in Aussiebear's workbook, in cell D3:and copy down. It should work in any version of Excel from 2007=COUNTIFS($B$3:$B$35,B3,$C$3:$C$35,C3)
p45cal
Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote
