Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filter function
Hello all,
I have a long list of items (column A) and say amounts (column B) and want to create a sublist where only the items are shown with positive amounts. Can this be done without using (advanced) filter? My cumbersome solution was to add a counter in column C that increases every time the amount is positive and then use some "match" and "offset" formula's to create a list. My feeling says it must be possible to do this easier. Thanks, Johannes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |