Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Say the row is B1 thru Z1. In A1 enter:
-- Gary''s Student - gsnu200821 "JDSkiing" wrote: For example, If I wanted every time the letter F was input as data that, within the fields marked that F would equal the number one, then for example G would equal 1.5, so that if a row had three F's and 2 G's it would equal 6 if I totalled the row across. This is a simple xample of what I am trying to accomplish, but if someone can show me this I can figure out the rest. Thank you James Deutschkron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
replace or substitute a letter for a specific number | Excel Discussion (Misc queries) | |||
replace letter of alfanumeric value by a specific number | Excel Discussion (Misc queries) | |||
how can i make a letter equal 1? | Excel Discussion (Misc queries) | |||
make a letter in a cell automatically equal a dollar amount | Excel Discussion (Misc queries) | |||
How do I get a letter in one cell ito equal a number in anotherl.. | Excel Discussion (Misc queries) |