Dear hmwere
I haven't done this in Excel before. You have to write a macro to do such operations. However to do this in excel you may have to make some arrangements like in C column from row 1 to 22 you have enter 1. Then from cell A25 onwards you have to list all different names twice. Since there are 9 different names this will fill up for eighteen rows. For each name you have to enter Accepted and Deferred in column B. Then in cell C25 you can enter this formula :
SUMIFS($C$1:$C$22,$A$1:$A$22,A25,$B$1:$B$22,B25). Then click and drag this for entire names. That's () all....!
Hope this helps... or someone may guide whether this can be done using Pivot tables.
I haven't done this in Excel before. You have to write a macro to do such operations. However to do this in excel you may have to make some arrangements like in C column from row 1 to 22 you have enter 1. Then from cell A25 onwards you have to list all different names twice. Since there are 9 different names this will fill up for eighteen rows. For each name you have to enter Accepted and Deferred in column B. Then in cell C25 you can enter this formula :
SUMIFS($C$1:$C$22,$A$1:$A$22,A25,$B$1:$B$22,B25). Then click and drag this for entire names. That's () all....!
Hope this helps... or someone may guide whether this can be done using Pivot tables.