If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Help with Excel

the whole year inn · 2005-11-10 14:36:15

Hi I am using excel but I need some help . I have to consolidate some sales but I cant seem to get it working just get over lapping sourse or some thing like that. I think I thought i was doing it right but I guess not , I am also having some trouble with the vlookup funcition. Searched the internet but I get alot of…

Options

10-11-2005 3:36pm

#1

the whole year inn

Registered Users Posts: 7,090 ✭✭✭

Join Date: October 2002

Posts: 6745

Hi
I am using excel but I need some help . I have to consolidate some sales but I cant seem to get it working just get over lapping sourse or some thing like that. I think I thought i was doing it right but I guess not , I am also having some trouble with the vlookup funcition. Searched the internet but I get alot of information that I dont really need goes into alot of detail.
This is for college so I guess this is the right place to post it?

Thanks any way
gob_smacked

0

Comments

Options
#2 10-11-2005 3:42pm
whiskeyman

Registered Users Posts: 12,564 ✭✭✭✭

Join Date: January 2005

Posts: 12017

what exactly you need done?
How is the data presented?
How big is the file? (you may be able to post it up here and we can have a look).
Lots of excel tutorials on the web too...

0
Options
#3 10-11-2005 3:51pm
the whole year inn

Registered Users Posts: 7,090 ✭✭✭

Join Date: October 2002

Posts: 6745

I can pm it to you if you want its not that big.Its an assisment for class.

I have sales numbers for the year and I need to consolidate the first quater of the year with the sales, and so on for each quater.I can get any answer. any idea .

0
Options
#4 10-11-2005 3:52pm
whiskeyman

Registered Users Posts: 12,564 ✭✭✭✭

Join Date: January 2005

Posts: 12017

post it up or pm and I'll have a look and see if I can help / explain it.

0
Options
#5 10-11-2005 4:02pm
the whole year inn

Registered Users Posts: 7,090 ✭✭✭

Join Date: October 2002

Posts: 6745

just pmed you

0
Options
#6 10-11-2005 4:08pm
the whole year inn

Registered Users Posts: 7,090 ✭✭✭

Join Date: October 2002

Posts: 6745

i uploaded . Small bit messy.
I have to do a vlook up for the date code and the quarter. THe figurses are not exact .

0
Advertisement
Options
#7 10-11-2005 4:16pm
whiskeyman

Registered Users Posts: 12,564 ✭✭✭✭

Join Date: January 2005

Posts: 12017

what exact info you need?
Just to collate quarter spend by department?
I think a pivot table might do the job...

0
Options
#8 10-11-2005 4:23pm
the whole year inn

Registered Users Posts: 7,090 ✭✭✭

Join Date: October 2002

Posts: 6745

I have to group overall sales per quaterer for each quater from quater 1 to quater 4 in 2003 and store it in a sheet named quaterly 03.

I was going to do the v look up later but i think i have to to it first , I have to uses the dates to determine quater 4. What do you tihnk ? Pivot table hard?

0
Options
#9 10-11-2005 4:30pm
whiskeyman

Registered Users Posts: 12,564 ✭✭✭✭

Join Date: January 2005

Posts: 12017

something like this?
I've done a pivot table for 2003 (sheet pivot) showing department spend by quarter - including department and quarter totals.

Pivot tables are simple to use once you get the hang of them - found in "Data" on the toolbar.

0
Options
#10 10-11-2005 4:41pm
the whole year inn

Registered Users Posts: 7,090 ✭✭✭

Join Date: October 2002

Posts: 6745

yea thats it any way you can show me how to do that,If not ill do a search. I am also trying to do a vlookup this is the formula I am trying to get working VLOOKUP(C15,Date$C$12$:D$12,True) I have to determine the quater4 from the dates while hiding the translation table.If you dont already have one ill get you a gmail account for your help .

Thanks for your help

0
Options
#11 10-11-2005 4:45pm
the whole year inn

Registered Users Posts: 7,090 ✭✭✭

Join Date: October 2002

Posts: 6745

ON second look i dont think its right , I have to use the consolidate funcition .Was going through the pivot funcition think i understand it.

0
Advertisement
Options
#12 10-11-2005 4:55pm
whiskeyman

Registered Users Posts: 12,564 ✭✭✭✭

Join Date: January 2005

Posts: 12017

I'm not the greatest at VLOOKUPs - maybe try someone one this forum.
http://www.boards.ie/vbulletin/forumdisplay.php?f=9

As for Pivot tables... I've attached a quick explanation how I did it.... It's well worth looking up some tutorials though and do some simple examples.
best of luck.

0
Options
#13 10-11-2005 4:59pm
the whole year inn

Registered Users Posts: 7,090 ✭✭✭

Join Date: October 2002

Posts: 6745

Thanks for the help .Do you want the gmail account?

gob_smacked

0