| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to copy every other cell value from a single row to asingle column,
On Wednesday, 6 June 2018 12:51:06 UTC+1, Claus Busch wrote:
Hi Andy, Am Wed, 6 Jun 2018 04:30:48 -0700 (PDT) schrieb Andy McNicol: Just one thing now and then I am sorted, I am still; getting a 0 between each of numbers./ Thus how do I get rid of this so I only get the cells with the actual values in it. Note that on the original sheet there will be an entry every 5th cell on the row. have a look: https://1drv.ms/x/s!AqMiGBK2qniTgc5oNtEN1ZcSxHN4NQ Regards Claus B. -- Windows10 Office 2016 Claus, You are a superstar, thank you very much all is good now. That link explained it all and let me know what I had to do visually. Thanks again, Hopefully I can return the favour in the future. Andy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can I copy a number of cells in a column to a single cell ina row | Excel Discussion (Misc queries) | |||
| I would like to copy UNIQUE data from a column in a SINGLE CELL | Excel Discussion (Misc queries) | |||
| From single cell variables to a single column serie | New Users to Excel | |||
| Copy column range of "single word" cells with spaces to a single c | Excel Discussion (Misc queries) | |||
| Copy column of cells to a single cell? | Excel Discussion (Misc queries) | |||
Threaded Mode
