Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!
So if there is a "Y" in any cell in a column, you want the full column to be displayed on a seperate sheet?
working example:
if column "A" has a Y in cell A8, you want that full column to be displayed on a different row?
Sounds simple enough but trying to understand what you're looking to...
Well if they are shite I will bob round and sort it for you if you want. They have good reviews though. A guy at work who races a mk1 escort rally car has used them before and claims they are good.
I think the a4 piece of paper that went into peoples car was a good idea that nik created for FCS 2010, as it was nice to see who's car was whos. Name badges also have their benefits but they are majorly gay I agree.
If nik has the time before CSS, we will definitely create the functionality...
We did note this but we were very limited regarding dates we could have that were suitable unfortuanately :(
Not ideal but i'm sure it won't have a massive bearing on our event.
Type this in cell i2, then drag down:
=IF(ISNUMBER(A2),A2,I1)
There is no easy formula way to do it within the same column, unless you use visual basic.
easiest way to do that would be to insert a row above your data
put an auto filter on said row.
filter column a by blanks
type in blank cell = & cell reference above (so in your case you would do =a2 once you've added in the new row)
copy this cell, select all blank cells and paste. then...