Keep grouped rows together while sorting by a value in a cell

Hello,
I am trying to build a spreadsheet that would have an account number in cell A2 and date in B2 and various data in cells C2-C4. I need to be able to sort by the date in B2 while keeping the groups of rows together (rows 2-4) and repeat this arrangement down a sheet. Any ideas how this can be accomplished?
Thanks!

Hi cbrandonsmith

I hope that I have interpreted your requirements correctly.

In any column put the formula on row 2

Please Login or Register  to view this content.

and copy down. Sort on this column.

Let me know if it does not work for you

Regards
Alastair

This actually works quite well. I changed the font to white to hide the date in all cells except the top row of the grouped rows just so the date is not viewed continuously down the column. Thank you so much!!