Good morning
I have three columns of data:
Column A = ID#
Column B = Week: Week1, Week2, Week3 . . . . up to Week30 for each ID #
Column C = various codes: S, D, NS, A
In Column D, I want to only count the A's for each week for each ID#
A B C D
ID# WEEK CODE A
1 Week1 A 1
1 Week1 D 1
1 Week2 A 2
1 Week2 A 2
1 Week2 S 2
2 Week1 A 2
2 Week1 A 2
2 Week2 A 3
2 Week2 A 3
2 Week2 D 3
2 Week2 A 3
I know I can use pivot tables, but this file will be used in a statistical package so I need to code the data a particular way.
Thanks
Marby
Bookmarks