Count col C based on uniques in col A

D

Don Anderson

I need help writing a couple of formulas.....
1) I would like to count the occurences of 'Desc' based on 'AC' column.
ie,
#232-2 TAPE MASKING HI PE = 3 (used on 754, 755, 756)
#290FR TAPE POLYKEN FLAME = 2 (used on 754, 755)...etc

2) I would also like to sum the 'Qty' based on 'AC' and 'Desc'.
ie,
754 #232-2 TAPE MASKING HI PE = 4 RL
755 #232-2 TAPE MASKING HI PE = 5 RL....etc

For simplicity sake here I consolidated data in one sheet and sorted it by
Desc, however there are actually 3 unsorted sheets (one each for 754, 755,
756) with about 4200 rows per sheet. I would like to put the summary of #1
& #2 on seperate sheets.

Thanks in advance...
Don


AC Qty UI Desc
754 1 RL #232-2 TAPE MASKING HI PE
754 3 RL #232-2 TAPE MASKING HI PE
755 2 RL #232-2 TAPE MASKING HI PE
755 3 RL #232-2 TAPE MASKING HI PE
756 1 RL #232-2 TAPE MASKING HI PE
756 2 RL #232-2 TAPE MASKING HI PE
756 1 RL #232-2 TAPE MASKING HI PE
754 1 RO #290FR TAPE POLYKEN FLAME
755 16 RO #290FR TAPE POLYKEN FLAME
754 1 EA #ST 010 429 BUS READER
756 6 EA 0-0110-3-5256 BOLT
754 1 EA 0-0120-3-1809 PULLEY
755 0 SH 0-0210-3-0452 BMS8-124 CL
 
D

Don Anderson

Don Anderson said:
I need help writing a couple of formulas.....
1) I would like to count the occurences of 'Desc' based on 'AC' column.
ie,
#232-2 TAPE MASKING HI PE = 3 (used on 754, 755, 756)
#290FR TAPE POLYKEN FLAME = 2 (used on 754, 755)...etc

2) I would also like to sum the 'Qty' based on 'AC' and 'Desc'.
ie,
754 #232-2 TAPE MASKING HI PE = 4 RL
755 #232-2 TAPE MASKING HI PE = 5 RL....etc

For simplicity sake here I consolidated data in one sheet and sorted it by
Desc, however there are actually 3 unsorted sheets (one each for 754, 755,
756) with about 4200 rows per sheet. I would like to put the summary of #1
& #2 on seperate sheets.

Thanks in advance...
Don


AC Qty UI Desc
754 1 RL #232-2 TAPE MASKING HI PE
754 3 RL #232-2 TAPE MASKING HI PE
755 2 RL #232-2 TAPE MASKING HI PE
755 3 RL #232-2 TAPE MASKING HI PE
756 1 RL #232-2 TAPE MASKING HI PE
756 2 RL #232-2 TAPE MASKING HI PE
756 1 RL #232-2 TAPE MASKING HI PE
754 1 RO #290FR TAPE POLYKEN FLAME
755 16 RO #290FR TAPE POLYKEN FLAME
754 1 EA #ST 010 429 BUS READER
756 6 EA 0-0110-3-5256 BOLT
754 1 EA 0-0120-3-1809 PULLEY
755 0 SH 0-0210-3-0452 BMS8-124 CL
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pull data from 2 different Arrays in one cell 1
Make label visible if first record 8
count column c with condition in column A 1
Counting unique records based on date range 3
Count Unique Entires -- with conditions 6
Attn Sprinks- Not duplicate insert records 1
Need to Loop some code based on a count of Cells 1
Program error Excel.exe has generated errors 1

Top