Can anyone help me figure this out. Havent done anything with excel in awhile so im a lil rusty.
trying to create a formula to lookup the data on the data import tab and sort onto the last years sales page in the correct cell. Obviously this has to meet the two conditions of date and time frame.
Im thinking probably with IF statements? or INDEX?
Any help is appreciated
With an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Perhaps try pivot table
Any other suggestions out there?
I don't care for pivot tables as they seem very limited with what u can do with the data once its in them. Thank you for your time and suggestions.
You can use sumproduct for that.
But, you got to be kidding, pivot table is the best way to solve this problem (to my honest opinion).
I posted in excel 2007, but JieJenn posted an excel 2003 file.
Last edited by oeldere; 10-07-2013 at 02:42 PM. Reason: I posted etc.
Hi,
Pivot Tables in 2003 Excel had a lot less features than the latest version of Excel.
Look at http://www.lynda.com/Excel-tutorials.../114891-2.html for how far they have progressed in 10 short years.
Have you ever thought of upgrading to a newer version of Excel?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
trying to access and download files but it keeps redirecting me to not being logged in but I am and keep logging in and it keeps saying the same thing. Anyone else have this issue? fix?
timmiller420,
We are working on resolving this issue.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
timmiller420,
We are working on resolving this issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks