I have a list like this
A B C
Var1 Item1 Var1Item1
Var2 Item1 Var2Item1
Var3 Item2 Var3Item2
Var1 Item2 Var1Item2
Var3 Item1 Var3Item1
Var1 Item1 Var1Item1
I would like to count the number of items in Column . Each item can be counted more than once, but only if the name in column a is different. In this case the resultat should be 5 as the last row has same name and Item number as a previous row and is already counted.
Daddy Sage <jan120253@gmail.com> wrote:
I have a list like this
A B C
Var1 Item1 Var1Item1
Var2 Item1 Var2Item1
Var3 Item2 Var3Item2
Var1 Item2 Var1Item2
Var3 Item1 Var3Item1
Var1 Item1 Var1Item1
I would like to count the number of items in Column . Each item can be counted more than once, but only if the name in column a is different. In this case the resultat should be 5 as the last row has same name and Item number as a previous row and is already counted.
Make a column C = A&B and count in that column.
--
Vie : n.f. maladie mortelle sexuellement transmissible
Benoit chez lui à leraillez.com
onsdag den 2. oktober 2019 kl. 19.01.11 UTC+2 skrev Benoît:
Daddy Sage <jan120253@gmail.com> wrote:
I have a list like this
A B C
Var1 Item1 Var1Item1
Var2 Item1 Var2Item1
Var3 Item2 Var3Item2
Var1 Item2 Var1Item2
Var3 Item1 Var3Item1
Var1 Item1 Var1Item1
I would like to count the number of items in Column . Each item can be counted more than once, but only if the name in column a is different. In
this case the resultat should be 5 as the last row has same name and Item number as a previous row and is already counted.
Make a column C = A&B and count in that column.
--
Vie : n.f. maladie mortelle sexuellement transmissible
Benoit chez lui à leraillez.com
I can do that, but it will still count all and duplicates are not to be counted more than once.
I found an array formula that will do the trick, but now I wonder if it cn be done without the additional column, that is using oly A and B?
=SUM(IF(C1:C17<>"",1/COUNTIF(C1:C17,C1:C17), 0))
onsdag den 2. oktober 2019 kl. 19.01.11 UTC+2 skrev Benoît:
Daddy Sage <jan120253@gmail.com> wrote:
I have a list like this
A B C
Var1 Item1 Var1Item1
Var2 Item1 Var2Item1
Var3 Item2 Var3Item2
Var1 Item2 Var1Item2
Var3 Item1 Var3Item1
Var1 Item1 Var1Item1
I would like to count the number of items in Column . Each item can be counted more than once, but only if the name in column a is different.
In this case the resultat should be 5 as the last row has same name
and Item number as a previous row and is already counted.
Make a column C = A&B and count in that column.
I can do that, but it will still count all and duplicates are not to be counted more than once.
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 296 |
Nodes: | 16 (2 / 14) |
Uptime: | 37:49:09 |
Calls: | 6,648 |
Files: | 12,193 |
Messages: | 5,329,235 |