Hello,
I search s formula that in LOCATION column(G2,G3,G4,etc) from Sheet1 to show the location of COF ID and the nr. of BUC from that location, and if the COF ID is in multiple location to show all location and the nr. buc from each location.
In Sheet2 is a data base table with location,cof id, description etc and a pivot table(that help me to count all COF ID that are in one location)
Bookmarks