| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help column
hi all,
is there a way to avoid greating a help column (to strip the numbers from column A) as in my case where i have a range containing items like A1=2000 name1 A2=1500 name2 A3=700 otherName A4=500 name1 A5="" A6=1500 name1 ..... now i want to sumproduct for ( name1) only. many thanks for any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Threaded Mode
