Compare my store current sale v/s last two years sale in Microsoft Excel

Tags:
Microsoft Excel
Hi, I wants to ask that if I compare my store current sale v/s last two years sale, how would I make an Excel spreadsheet?


Software/Hardware used:
excel
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TheRealRaven
    Please provide a more complete description of what you need to accomplish. If possible provide an example of what you want a result to look like. And be sure to include an explanation of what problem you're running into when you try to do it.

    Without that, the only real answer is to tell you to put the store's current sales figures in one column, and then put the last two years sales in the next two columns. Once the data is in place, look at the columns to see how they compare.

    That's a highly simplified answer, but there much more that can be said.

    For example, you haven't said anything about what you mean by "compare". What are you trying to learn?

    Also, there's nothing said about any of the data. Where will it come from? How will it get into Excel? Is it in a database? (If so, why do you need it in Excel?) Are you comparing totals for each year? Totals by department? By product? By salesperson? By vendor?

    What is "sales"? Is that a currency amount? Is it Units_Sold? By weight?

    Many other elements might be needed.

    Is this something you need done for a store that you own?
    33,610 pointsBadges:
    report
  • ToddN2000
    We need more inf like Raven mentioned. Where is the data now is probably the most important. How do you want it formatted, what are the key fields for linking the data for the compare? Is this a one time report or will it be run yearly? Do you want a macro to refresh it for the following years?
    129,355 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: