Convert Letter to Number
 

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

Convert Letter to Number
 

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" wrote in message
...
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

Convert Letter to Number
 

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

Eddie

"Rick Rothstein (MVP - VB)" wrote:

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" wrote in message
...
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