Okay, I've been working on this long enough. I need help PLEASE.
Location A has a widget1
Location A has a widget2
Location B has a widget2
Location B has a widget1
Location C has a widget4
Location A has a widget2
Location B has a widget1
Location C has a widget4
So, I want to set up a matrix to count how many of which widgets are in what locations:
widget1 widget2 widget4
Location A 1 2
Location B 2 1
Location C 2
So, what's my formula? I've been trying nested IF, COUNTIF, AND, Array formula, nothing seems to work
Thanks,
Location A has a widget1
Location A has a widget2
Location B has a widget2
Location B has a widget1
Location C has a widget4
Location A has a widget2
Location B has a widget1
Location C has a widget4
So, I want to set up a matrix to count how many of which widgets are in what locations:
widget1 widget2 widget4
Location A 1 2
Location B 2 1
Location C 2
So, what's my formula? I've been trying nested IF, COUNTIF, AND, Array formula, nothing seems to work
Thanks,