This is a short example, but I have thousands of entries that show an ID and a Date in the sam row. What I need to do is make a conditional statment that can count how many entires D1 has on 1/1, N1 has on 1/1 etc. Also I would like to seperate the D's and N's as shown bellow.
Date D's N's
If anyone could help that would be great because I am stuck. I have tried countif but that can only use 1 condition and everythin else I have tried will not search through a list of ID's that I have for N or D.