Bernd,
If I wanted to make the macro cover 4 or 5 columns instead of 3 what would
that macro look like. Right now what I am doing is using your current sfreq
macro twice to get the 5 columns I need. I minimize one column so it can't
be seen. Just wondering if you can expand the macro to cover 5 columns.
Thank you

"Bernd P" wrote:

Hello Eric,

The macros are intended to be used as they are - just press ALT + F11
in your Excel worksheet, enter a new module and copy my macro text in.
Then go back to your worksheet and enter the array formulas as shown
in my Examples (enter with CTRL + SHIFT + ENTER, not only with ENTER).

Again: If its easier to send me a file I am happy to complete a short
and an instructive example in your file.

Regards,
Bernd