Recurring sequence: Include date for 5 days, then ignore next 2.

**helpbitte** · 09-03-2012, 12:59 PM

Hi there,

I have data for each day of the week. Monday to Friday has date, whilst Saturday and Sunday are closed and hence has no data, and is always represented with 0.

I need a formula that gives me the data where the recurring sequence is consistent - 5 successive days, ignores the next 2 days etc. The raw data is in column A, and the expected data should look like Column B.

Any pointers would be much appreciated.

Thanks,

Adam

A B
0 1
0 2
1 3
2 4
3 5
4 6
5 7
0 8
0 9
6 10
7
8
9
10
0
0

**oeldere** · 09-03-2012, 01:01 PM

You get better help if you post an Excel-file (example of your workbook), without confidential information.

Make sure the workbook demonstrates your desired results if possible, or just highlight the cells you're trying to fix.

Use BEFORE/AFTER sheets if that helps make it clearer.

**helpbitte** · 09-03-2012, 03:11 PM

Here is the attachment.

Thanks

**shg** · 09-03-2012, 03:19 PM

That's not a very helpful example.

What should appear under other circumstances, and why?

**oeldere** · 09-03-2012, 03:22 PM

I think helpbitte wants to delete the 0 (null) in column A.

It can be done with a filter and delete the filtered items (rows).

Maybe a macro is a better solution, but i can't make the macro.

**oeldere** · 09-03-2012, 03:29 PM

This one works for me if the 0 is in column A

Please Login or Register  to view this content.

+++++++++++++++++++++++++++++++++++++++

file attached.

See the file, and run the macro.

**helpbitte** · 09-03-2012, 04:28 PM

That works absolutely fine Oeldere.

Thanks very much for your help on this one.

**oeldere** · 09-03-2012, 04:29 PM

Glad I could help. Thanks for the reply.

If the question is solved, will you mark your question as solved?

If you have (other) questions, on this item, just ask.

@helpbitte

Das habe ich gern fur dich gemacht.