Who plays whoM?

[Lako42]

42

nearly 44

 

[Joe_Fox]

It's 96 you buffoons

 

[lazzer]

The answer is ....................... Barnsley. (When he isnt injured )

 

[Yorkshire Vixen]

The answer is ....................... Barnsley. (When he isnt injured )

ive seen it

 

[lazzer]

ive seen it

well you would :icon_wink

 

[highland fox]

ive seen it

i bet you have

 

[bocadillo]

97

It's 96 you buffoons

eeerrr...

 

[highland fox]

theres no need to quote joe to show he's a lemon,he does it all by himself

 

[pisyndrome]

Joe out of interest why did you include columns for home and away, and whether they are a rival, when you've clearly indicated in blue rival games and its easy to see if there home or away based on the fixture itself....

I would say that they are there so that the countif formula can be used to calc the numbers of games that meet the criteria of Home / Away / Rivals etc.

the formulas effective but the password protection wasn't

Stu

 

[Joe_Fox]

smart - how did you override the password protection?

 

[bocadillo]

smart - how did you override the password protection?

The password protection doesn't hide the formulae.

 

[Macky]

It's 96 you buffoons

Excuse me sir, please do not call me a puffoon, I am not a puffoon sir, I like the ladies

 

[Yorkshire Vixen]

Excuse me sir, please do not call me a puffoon, I am not a puffoon sir, I like the ladies

but do they like you.....:icon_bigg:icon_wink

 

[pisyndrome]

smart - how did you override the password protection?

A little bit of VBA code will do the trick. Excels passwords dont mean alot, the password to unlock your file was AAAAABAAAABf.

Ace

Stu

 

[pisyndrome]

The password protection doesn't hide the formulae.

But it was stoping you from selcting the cells with them in and therefore stoping you seeing them. Unless your ctrl ` ing the sheet to view cell contents

 

[bocadillo]

But it was stoping you from selcting the cells with them in and therefore stoping you seeing them. Unless your ctrl ` ing the sheet to view cell contents

It didn't stop me at all. I just selected the cell.

D3 holds '=COUNTIF(B3:B10,"h")


No password. No ctrl-anything.

 

[pisyndrome]

It didn't stop me at all. I just selected the cell.

D3 holds '=COUNTIF(B3:B10,"h")


No password. No ctrl-anything.

Strange one man what versiojn of excel you on?

 

[bocadillo]

Strange one man what versiojn of excel you on?

An old one. I'm on a fixed income, you know.