| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a list and skipping blanks
Which formula do I use if I want to copy a range of cells but skiping the
blanks. For example, in column A is a list of items, and in column B is a list of the amounts of that item (Eg. Shirts 2, 0 Pants, 5 Socks). Which formula should I use in column C to copy column A but only these items that have amounts in column B? Also I want to have the list without ant blanks cells? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
| Skipping cells problem | Excel Worksheet Functions | |||
| Skipping a cell and moving on to the next, with no blanks in betwe | Excel Discussion (Misc queries) | |||
| Returning list values | Excel Worksheet Functions | |||
Threaded Mode
