![]() |
#1
|
|||
|
|||
![]() Here is the breakdown: I am doing an analysis of murders in the US from 2008-2014. More specifically by race I have three colums with 5000 entires, Column A has multiple entries of years, either 2008, 2009, 2010, etc. column B has 4 criteria as the victims (black, white, asian, other), Column C has 4 criteria as the murder (black, white, asian, other). I am trying to count, the number of murders in 2008, committed by a white person, against another white person. Example set answer should equal 2 (2 reported incidents of white on white murder in 2008) A B C 2008 White White 2008 White White 2008 Black Asian 2010 Black White 2013 Asian Black |
#2
|
|||
|
|||
![]()
See the attached. It relies on the FILTER function in the DATA tab.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
phillipsdp | Excel | 1 | 11-09-2016 12:53 AM |
Sorting large amounts of data based on multiple columns | bigmac4 | Excel | 2 | 08-23-2015 10:26 PM |
Hide rows in multiple columns based on zero values | Deane | Excel Programming | 19 | 06-23-2015 11:24 PM |
Link listbox (with multiple columns) to bookmark based on selection | dsjk9190 | Word VBA | 5 | 01-29-2015 11:28 PM |
![]() |
AUHAMM | Excel | 3 | 10-27-2014 09:11 PM |