Kawasaki Sportsbike Riders Club - Australia - Online Forum

I want make a kind of timetable up, it will have the work day broken up into Half hour blocks (1cell) I want it so when if someone puts a "P" in for example cell A1 it will put a "1" in cell A20 if they put a "I" in A1 it will put a "1" in cell B20 or if they put a "W" in A1 it will put a "1" in cell C20 anyone know the formula?
Thanks in advance
Paul

If no one has given it to you before I get in front of a computer after my weekend away up north I could probably help ya.

ducati_paul wrote:I want make a kind of timetable up, it will have the work day broken up into Half hour blocks (1cell) I want it so when if someone puts a "P" in for example cell A1 it will put a "1" in cell A20 if they put a "I" in A1 it will put a "1" in cell B20 or if they put a "W" in A1 it will put a "1" in cell C20 anyone know the formula?
Thanks in advance
Paul

In cell A20, put this:
=IF(A1="P",1,"")
That means, if cell A1 contains P, cell A20 will contain 1. If cell A1 does not contain P, cell A20 will contain nothing - is that what you wanted?

If so, then in cell B20, type:
=IF(A1="I",1,"")

And in cell C20, type:
=IF(A1="W",1,"")

Let me know if this isn't what you're after and I'll try again!

Yup that's it! Thanks very much, I'm tracking staffing hours at work but what I've been doing is using the written table then just putting a 1 into three seperate tables depending on what the job was, it was very manual, now I can just enter the code in one table and it will automatically sort itself into the correct table from there.
I thought I might get an answer here but never expected one so quick, thanks heaps

No worries
I love Excel, so if you have any more questions, feel free!

Cath wrote: if you have any more questions, feel free!

Are Flanno shirts "Uncool" I love them 'cos they're warm but my G/F says they are daggy

ducati_paul wrote:

Cath wrote: if you have any more questions, feel free!

Are Flanno shirts "Uncool" I love them 'cos they're warm but my G/F says they are daggy

ducati_paul wrote:

Cath wrote: if you have any more questions, feel free!

Are Flanno shirts "Uncool" I love them 'cos they're warm but my G/F says they are daggy

best thing since sliced bread i reckon

Was going to answer the same as Cath - however there's no way I'd ever say I love Excel.

ducati_paul wrote:

Cath wrote: if you have any more questions, feel free!

Are Flanno shirts "Uncool" I love them 'cos they're warm but my G/F says they are daggy

I say flanno's are awesome, but I'm fashion-disabled, plus have recently become a little bit country, so may word may not go very far with the missus

Ya goose!


Oh and Ty -> I'm calling my firstborn "Excel". I expect he'll get beaten up regularly

Cath wrote:
Oh and Ty -> I'm calling my firstborn "Excel". I expect he'll get beaten up regularly

07 or 2010? The beatings will vary depending on his/her middle name

Hmm, i was thinking one of these... Time to go to bed after the nightshift methinks.

ducati_paul wrote:Are Flanno shirts "Uncool" I love them 'cos they're warm but my G/F says they are daggy

Take it from me, flannos are the new black.

I use excel, but I enter all the info manually I never could work out how to make it add up the columns etc etc
Flanno's are fantastic.

mmmm Excel............I love a good spread


































sheet