A B C 1 #N/A 980200;# 10 2 #N/A 980000;# 20 3 #N/A 980000;Z001 30 4 #N/A 980000;# 15 5 #N/A 980000;Z001 15 6 Something 980000;Z001 100 7 Something 980000;# 200 8 Something 980010;Z001 20 9 #N/A 980010;Z001 20 10 #N/A 980000;# 25 11 Something 980000;# 80 12 #N/A 980030;# 40 13 Something 980030;# 50 14 Something 980000;# 60
Given the table above, what I'd like to accomplish is to get the distinct values on column B from that's with criteria '#N/A' from column A. And then, sum all of the distinct values that matches criteria.
The output in a new sheet would be like the table below.
A B 1 980000;# 60 2 980030;# 40 3 980200;# 10 4 980000;Z001 45 5 980010;Z001 20
What would be the most fastest and efficient way of doing it.
Thanks
Bookmarks