| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
seperating a group of common cells
On my worksheet I have a list of products in column O, and I have the
quantity of received products in column Q. Column O has a lot of repeat products with different quantities. I need to take an average of those quantities matched to their respective skus and put it on a new worksheet. AAC LOUNGEEP2 5 AAC LOUNGEEP2 10 AAC LOUNGEEP2 6 I want to be able to have AAC LOUNGEEP2 on a seperate worksheet with the average quantity. AAC LOUNGEEP2 7 I can do the average with no problem, but i want to write a formula that knows to match the skus and than take the average. Any ideas? Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| define group of cells | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
| Heps to design Locked/Unlocked cells in protected worksheet | Excel Discussion (Misc queries) | |||
| copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions | |||
| How can I group a bunch of cells together, so I can sort by colum. | Excel Worksheet Functions | |||
Threaded Mode
