a group by method

[alessandro]

Hi everyone, I've an issue with a long list of datas. I'm looking either for a kind of group by formula in excel or a different method (pivot table??) that allows you to group a list of datas in 1 column based on a value displayed in another column. Ex: column A order number, column B order rows (ex: different products), column C values, column D month. I'd like to have a pivot showing products in rows, values per month (month in column) and count of orders (ie: number of SINGLE orders for each product) ... basically it must count a single order no matters the number of rows with same order number ...


any help?


Thanks a lot i advance!!


alessandro

 

[Sajan]

Hello Alessandro,


Hopefully you got an answer through some other means... but in case it helps anyone else...


To create a pivot table, select your data set (including the headings), and select the "Pivot Table" from the "Insert" menu (or ribbon). Then follow the prompts, to create a nicely grouped table. Add the items that you want to group as "row" fields.


Cheers,

Sajan.

 

[Guest]

<p>Are you in search for a cat which resembles the tiger? Do you wish for an affectionate and well behaved pet cat? Nowadays cat breeding is done to create a completely new and ,http://morgan-nj.org/forums/topic.php?id=1125&replies=2#post-1353monster beats by dr dre ebay indifferent breed of cat which resembles the Bengal tiger. http://bayareahair.com/activity/p/83153/, Burmese, Egyptian Maus, American Shorthairs monster beats studio by dr dre high-definition headphones and Siamese with Bengal cat to give birth to a special cat breed resembling the tiger. There are various cat breeders who appear to be genuine and would sell you an ordinary cat instead of your preferred one.</p> <p>Hence beats by dr dre beatbox sound dock it is always advisable to purchase this breed from a reputable breeder and not someone who is breeding poor quality kittens just for the sake to earn money. Visiting the cat breeder could help you learn a lot about the type of cat the person breeds monster beats solo by dr dre headphones - whitehttp://http://cheapbeatsdre1.blogspot.com/2012/07/monster-beats-solo-by-dr-dre-headphones_09.html by just looking at the breeding facility. You should also take care of the fact that the breeder is not breeding the first three generations of monster beats by dr dre studio hdhttp://http://cheapbeatsdre1.blogspot.com/2012/07/monster-beats-by-dr-dre-studio-hd.html the cross bred feline as the breed produced would not be suitable for domestic purposes. Even the males of this generation could easily become sterile thus resulting in an effortless breeding.</p>