Thread: Formula to copy every other cell value from a single row to a single column,
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default Formula to copy every other cell value from a single row to a single column,
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
Reply With QuoteReply With Quote