| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Pick values from a row
Hi,
I have one challenge: I want to pick values from one column and place them succesively and automaticely in a new one - and ignore every empty cell; f.eks. In Column A there are values/ text in row 3, 5 ,8 and 12 (all other celles are empty). These values i want to automatically transferred to Column B in row 1, 2, 3 and 4. What's the formula for doing this?? Regards dagfinn |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Zero values in a log chart | Charts and Charting in Excel | |||
| Second serie doesn't use X-as values | Charts and Charting in Excel | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| Linked values turn to #REF! after clicking don't update | Excel Worksheet Functions | |||
| Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions | |||
Threaded Mode
