I have two problems I'm trying to solve with the same table.
The goal is to create a 3D pie chart showing the numbers of each unique type of unit.
Problem #1, in the table (shown below) I have both efficiency units and bed/bath listings. I have been able to extract the unique values of beds and baths but this method does not work for the term "Efficiency" since I'm triggering off of the backslash.
Problem #2 is that I can create the unique values, i.e, "1 Bed", "2 Bed", etc., in the table but I cannot figure out how to chart the numbers of units that match each unique value.
The formulas used currently are:
C2: "=LEFT(A2,FIND("/",A2)-1)"
D2: "=RIGHT(A2,LEN(A2)-FIND("/",A2))"
E2: "=IFERROR(IF(COUNTIF(C$2:C2,C2)=1,C2,""),"")"
I've also attached an example worksheet.
Bookmarks