Thanks for the example file, it helped me understand. But I have some questions for that file:
1. There are 5 different values: A, BB, AE, AF, and AG. Why on cell D3 it says 4? Why D2 won't show a number? How to fix it?
2. I used your formula in column B, but found another issue: I have several items that have the same numbers of repeats, how do I differentiate them?
In your example, if I add 2 rows by adding into A7 and A8 with letter "C". so in B7 and B8 the # ***** 2 in both cells. Now I have 6 values, the previous 5 plus the new one "C", is cell D1 showing the total items? The problem is that for the values "BB" and "C", they both showed twice, so they both got the count of 2. How can I tell the differences between BB and C?
Sorry, I don't understand what did you mean. Pivot table is to convert columns to rows, and vise versa. I have about 1000 rows and only 3 columns. Changing rows to columns will make the file VERY wide, and I don't know how that could help me count how many times each item appeared. Using the same way that suggested, after converted to pivot table?
Wow, sounds very complicated to me. I'll need some time to study on this, and hopefully I can make myself understand it. I'll ask if I am unable to figure it out through your examples. Thanks for your patience.