ansaurus

Question

Answer 1

+1 A:

Not tested, but you'll need the COUNTIF function. Try something like the following for row 2 and just fill it down (I believe the syntax is correct):

=COUNTIF($A$2:$A$65535, $A2)

Subsequent rows should be filled as

=COUNTIF($A$2:$A$65535, $A3)
=COUNTIF($A$2:$A$65535, $A4)
=COUNTIF($A$2:$A$65535, $A5)
.
.
.

lc 2010-02-18 19:54:24

Tnx lc! Syntax is almost perfect ;) but it is possible to find only UNIQUE data, cause when it show me frequency of occurs data "ABC1" three times, when i want ones ... ?

netmajor 2010-02-18 20:53:31

@netmajor It would help if you gave an example of exactly what output you're expecting. If I'm understanding correctly now, what you want is not a column of how many rows include the product ID, but actually the pivot table, as @Patrick Honorez is suggesting above. This would give you one row for each unique product.

lc 2010-02-24 01:12:44

Yes yes , i must do some example to see that, bu it works at last ;)

netmajor 2010-02-24 01:48:23

Answer 2

+2 A:

you could easily do that with a pivot table !

iDevlop 2010-02-18 23:13:39

I try to do this with pivot table but i have a problem with correct create this kind of table :/ or maybe i do it wrong cause... in first table "ABC1" occurs three times so in pivot table i supposed to see 3 times frequency, but it create sum total of "ABC1" and show me nine occurs :/

netmajor 2010-02-20 00:47:01

edit Its works ;)

netmajor 2010-02-23 02:07:36

ansaurus

tags:

views:

answers:

frequency data occurs in the table

related questions