Convert Letter to Number

[ExcelMS]

I am trying to design a workbook so that when I enter an "R" or "L" in a
column on Sheet 1, the appropriate column with Category L or Category R in
Sheet 2 gets a 1 underneath it. Do you have any ideas about how might be the
best way to accomplish this?

Category Category L
Category R

R 1
1
R 1
1
L 1

L 1
L Total = 4
Total = 2
L

Sheet 1
Sheet 2

 

[Rick Rothstein \(MVP - VB\)]

Assuming your data starts in Row 2 (with Row 1 being a header row) and that
the Category column is Column A, put these formulas in the indicated cells
on Row 2 and then copy them down...

Category L column: =IF(A2="L",1,"")

Category R column: =IF(A2="R",1,"")

Rick

 

[ExcelMS]

Thank you Rick, it works awesome, you are the man!

Eddie