What is the exact date for Earth Day in 2010?

Adding sales of a particular date

QUESTION: Kindly help me with the following. I want to have the sales proceed(product 1) of my sales exec ranjeet of the date 1-08-2010 in another sheet. The sheet 2 should be in auto mode so that i can select a particular date and the sales rep to get his sales figure of that day. Is this possible? if yes please help Date Sales Exec Name Product 1 01-08-2010 Ranjit 50 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 01-08-2010 Ranjit 48 01-08-2010 Ranjit 12 01-08-2010 Ranjit 20 01-08-2010 Ranjit 20 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 01-08-2010 Ranjit 0 ANSWER: I have created a sample file for you, Click or Copy and paste the below link in web browser to download the Example file. http://www.sendspace.com/file/n4g4u3 Scroll the mouse button to the bottom of the website and click Download The File Name is: Sumproduct Solution (30-07-2010).xls ---------- FOLLOW-UP ---------- QUESTION: Thank you very much. But the answer is not exactly as i desired. I am attaching the actual file that i need the work on. Please check it. What i need is mentioned in thefile http://www.sendspace.com/file/vfqk1g and yes ANSWER: I have created a sample file for you, Click or Copy and paste the below link in web browser to download the Example file. http://www.sendspace.com/file/8bgiaj Scroll the mouse button to the bottom of the website and click Download The File Name is: Solution - Cash Memo audit DSR_test.xlsx ---------- FOLLOW-UP ---------- QUESTION: thank you first of all and you have been a great help. One last solution to this and i think i will be all set. Once again The link contains thefile and the question i am asking http://www.sendspace.com/file/1jswtg
Answer:

I have created a sample file for you, Click or Copy and paste the below link in web browser to download the Example file. http://www.sendspace.com/file/r3a0rl Scroll the mouse button to the bottom of the website and click Download The File Name is: Solution - percentage.xlsx Note: The Discount Column should be formatted as Percentage. Format Cells>>Number>>Category>>Percentage

Miningco.com Visit the source

Was this solution helpful to you?

Related Q & A:

How To Get All Components Based On A Schema And From A Particular Publication?Best solution by Tridion
How to delete a particular line from a file?Best solution by Stack Overflow
How to rotate a Direction Arrow to a particular location?Best solution by Stack Overflow
how to print a receipt to a particular printer?Best solution by Stack Overflow
How to search for a particular string in a text file using java?Best solution by Stack Overflow

Just Added Q & A:

How many active mobile subscribers are there in China?Best solution by Quora
How to find the right vacation?Best solution by bookit.com
How To Make Your Own Primer?Best solution by thekrazycouponlady.com
How do you get the domain & range?Best solution by ChaCha
How do you open pop up blockers?Best solution by Yahoo! Answers

For every problem there is a solution! Proved by Solucija.

Got an issue and looking for advice?
Ask Solucija to search every corner of the Web for help.
Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.