Any Excel experts here?

ducati_paul · Post by **ducati_paul** » Sun Jun 26, 2011 1:42 pm

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

Blurr · Post by **Blurr** » Sun Jun 26, 2011 1:45 pm

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.

Cath · Post by **Cath** » Sun Jun 26, 2011 2:04 pm

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!

ducati_paul · Post by **ducati_paul** » Sun Jun 26, 2011 2:10 pm

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

Cath · Post by **Cath** » Sun Jun 26, 2011 2:14 pm

No worries

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

ducati_paul · Post by **ducati_paul** » Sun Jun 26, 2011 2:31 pm

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

laidback · Post by **laidback** » Sun Jun 26, 2011 2:58 pm

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

h.b.bear · Post by **h.b.bear** » Sun Jun 26, 2011 4:55 pm

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

ty · Post by ty » Sun Jun 26, 2011 5:11 pm

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

Cath · Post by **Cath** » Sun Jun 26, 2011 5:48 pm

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

MrWasabi · Post by **MrWasabi** » Sun Jun 26, 2011 6:01 pm

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

mike-s · Post by **mike-s** » Mon Jun 27, 2011 8:52 am

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

Bogan · Post by **Bogan** » Mon Jun 27, 2011 9:13 am

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.

smithy5 · Post by **smithy5** » Mon Jun 27, 2011 5:46 pm

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.

Gosling1 · Post by **Gosling1** » Tue Jul 05, 2011 10:12 pm

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

sheet

Kawasaki Sportsbike Riders Club - Australia - Online Forum