Project Detail
Query Excel Sheet - Excel Expert Needed
Query Excel Sheet - Excel Expert Needed is project number 516111
posted at Freelancer.com. Click here to post your own project.
Bid Count: 29
Average Bid:
$ 59
10/01/2009 at 14:42 EDT
Project Creator:
JordanFanatic
Employer Rating: 
(15 reviews)
Description
I have an excel sheet which contains orders with stock availability. You need to create a query which finds products with high not in stock volume and puts this information within the excel sheet.See attached excelreview1.jpg for reference:
A - Query taken from 'Old' Worksheet
B - Option to select which lines to query (e.g. Line 4080 - 4117)
C - Finds all rows with 'Not in Stock' or 'Incompleted' in Column F
D - Finds the products highlighted red in Column E, regardless of size (e.g. AJ4-20(10) where 10 is the size) - When highlighted Red, it means the item is not stock.
This information queried should be put on a new worksheet within the Excel file. See excelreview2.jpg
Product - Which Product was found Not in Stock
Not in Stock - How many times found Not in Stock
Lines - Which rows on the 'Old' Worksheet is the product shown not in stock
The resulting information should order the products found Not in Stock the most at the top. (e.g. Products found not in stock 10 times should be higher then products found not in stock 8 times)
If you are confident you can create this for me please make your bid. If you can create it before you bid and show screenshots to show it in action, it is more likely I will select your bid as the winner immediately, price depending.
Thank you!
Additional files submitted:
excelreview1.jpg
excelreview2.jpg
Orders.xls
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results
TheBestLinks
Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.