Home » Forums » Open Source Learning Center » Question and Answer

Selecting non zero dates and repeating 24 times( for hours) without macro

Submitted by dimuthumme on 10 April, 2014 - 00:01

Hello,

I want to select the dates(from column H) in which the value(in column I) is greater than zero and paste them in column K(Attachment). At the same time, I want to expand each day for 24 hours. That means, I want to repeat the date 24 times while pasting in column K. Kindly help me. I would prefer the formula as I hv to repeat the same for large number of sheets.

To make it more clear, I hv illustrated what I need in column N & O manually.

Many thanks

AttachmentSize
Non zero date selection for 24 hours without macro.xlsx42.25 KB
‹ Help with a if condition BUDGETING ›
»