Hello,
so I am hooked on excel again, I have this scenario. I have a master worksheet with multiple customers and entries. what I would like to do is add the count of the radios that are in for repair just for that customer in another worksheet. for instance under "'master log" "C8" to "C10" are all under customer they show belonging to customer "AAR/LAX" because they show that on column "A". how can I show that count of repair radios on "COUNT BY CUSTOMER" worksheet "D14"
is this even possible?.
My goal is to be able to show the total count of radios that are in for repair,
and if possible how many radios were shipped for repair somewhere else.
IF ANYONE HAS ANY IDEAS AS TO HOW TO PRESENT THIS DATA.. I WILL LOVE TO HEAR THEM... MAYBE PIVOT TABLES???.
Bookmarks