| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Request for formula to refer some letters from Cell
COL-A COL-B
00XA10010253 5 00XXXA10012267 1 00XA20045682 2 00XXXA23564457 4 00XAA1000253 1 00XAA200000 3 00XXA106402A01 5 I WANT IF COL-A = X , SUM COL-B XX , SUM COL-B XXX , SUM COL-B PLEASE NOTE, I WANT AFTER THER LETTERS -BETWEEN FIRST 2DIGIT NUMBER(00) AND EXCEPT -A EXAMPLE IF 00XXXA200202A01 MEANS - I WANT" XXX " AWAITNG YOUR HELP PLESE -PER ANISH |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows but need to refer to same cell in original formula | Excel Worksheet Functions | |||
| How do I refer to the tab name in a cell formula in Excel? | Excel Discussion (Misc queries) | |||
| How do I enter a formula in a cell so that letters= a number i.e.. | New Users to Excel | |||
| How do I enter a formula in a cell so that letters= a number i.e.. | Excel Worksheet Functions | |||
| How do I enter a formula in a cell so that letters= a number i.e.. | Excel Discussion (Misc queries) | |||
Threaded Mode
