Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I need to give at the end of a row, a total of a particular value, say 7.5,
to various letter like W or L, S ,O, etc ---some 10 letters--or sum an alphanumerical one. 1.....A.....B.....C.....D.....E.................J 2.....L......W.................................... ...7.5 Column J should keep just those letters, eg. W, on row #2, and change it to 7.5. But if column B (with the W letter) should have a number aside, eg. W3.5 or other, must be keep this value instead of 7.5.on J. I've been looking for some answer in this forum but not a clue at present. Any help, could be helpful. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
New Validation option to format 1st letter as Capital letter | Excel Discussion (Misc queries) | |||
Default Capital letter for 1st letter of a word | Excel Discussion (Misc queries) | |||
Give RELEVANT responses to questions. DO NOT give usless list | Excel Worksheet Functions | |||
Are you able to give a letter a number value | Excel Discussion (Misc queries) | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) |