Pulling data from 2 columns for a total
I have 2 columns, one labeled "unit" and the other "injury type". So there
are about 8 different units all numbered like "2W, 2E, 3W, 3E, etc." and the
injury types has "head, eye, hand, etc". I need help to create a formula,
for example that will pull out all the head injuries that happend in 2W. Is
this possible?
|