Need to create a bar graph with the count for 35 different items. Data stored in 917 cells. Each cell contains a different number of items, between 1 and 35, all separated by commas.
Need to create a bar graph with the count for 35 different items. Data stored in 917 cells. Each cell contains a different number of items, between 1 and 35, all separated by commas.
The attached workbook recreates your "Report Out" report using a COUNTIF function to extract the count. Count criteria are listed in column G.
[H2] =COUNTIF($A$2:$A$7,"*" & $G2 & "*")
It also contains a bar chart created form those data.