| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
List items based on the count given
Hi all,
I have a problem that requires some help here. I have a table that list items and the frequency for each item, as shown below Item frequency A 1 B 3 C 4 D 1 E 0 Base on the above, the system should populate a list base on the above Expected result is: Item Count A 1 B 1 B 2 B 3 C 1 C 2 C 3 C 4 D 1 Item E is not displayed because the frequency count is zero. Anyone could assist on this? Many thanks in advance Last edited by CS Chia : March 12th 14 at 08:06 AM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count items based upon two separate values? | Excel Worksheet Functions | |||
| 2 conditions needed to check and count of items based on that | Excel Worksheet Functions | |||
| How to count and group items in a list depending on size of list? | Excel Programming | |||
| How to count items in a list and group depending on size of list? | Excel Programming | |||
| Count items on the list | Excel Discussion (Misc queries) | |||
Threaded Mode
