Here's what I'd like to do (I've tied myself in logical knots trying to figure out how, but someone may be able to help):
The sheet I've got has headings, then four pieces of information for each customer that are mostly duplicates - ie, cells b2, b3, b4 and b5 are all the same customer's first name.
Therefore I want a formula that will not show anything except rows 1, 2, and every 4th one thereafter (1,2,6,10,14 etc). This could be in a new sheet or in a different part of the same sheet.
I need this doing for definite, the second bit would be nice to have but i can work around it:
I want certain colums to behave differently - in column L, instead of just the cell we'd normally show (2,6, etc), I'd like that cell and the cell below it, concatenated. And in column R i'd like just the cell below the one that would normally be shown.
Many thanks in advance, hopefully that was clear, if not then feel free to ask questions
Bookmarks