Some Excel Work

Status: Closed
Prize: $10
Entries Received: 11
Winner: priyal1997

Winner

Contest Brief

Provide a set of formulas and steps (not macro) that are able to generate automatically the sheet "Results" from the sheet "Input", regardless of the number of item types, number of appearances for each item.

In short, the generated sheet called "Results" should be able to sum the quantities which appear within the sheet "Result" and display them in the manner presented in the attached file.

Please note that the contest is for Microsoft Word '97-2003 only.

Thank you.

Recommended Skills

Winner

Post a Contest Like This

Employer Feedback

“Great person which indeed delivers quality work. Clean descriptions, elegant problem solving, while paying attention to all the minute details that do make a difference when aiming for proficiency.”

razvanbadiu, Romania.

Public Clarification Board

tomislav1975
- 11 years ago
I have created 3 solutions for your project, all under same entry no.14. Regular formula, array formula and pivot table, all as separate cases. I have to agree with hemsingh1 that your contest seem to be bogus.
- 11 years ago
Contest Holder
- 11 years ago
Thank you all for your time and for all your efforts. Please kindly consider this contest as officially closed, as I have already designated the winner. All the best from Bucharest, Razvan
- 11 years ago
cadnalin
- 11 years ago
Hi ! this is very easy job comparing to excel jobs which I did in my career. I am a graduate civil engineer and looking for a extra works for my free time. I am self confident to do this work very easily. I would like to help your project please.
- 11 years ago
renesontiongson
- 11 years ago
Hi! the presentation I had is that it sum up the quantity of all products. As you can see the same grand total from the source or group of data to our sample other sheet. I am please to help your project.
- 11 years ago
renesontiongson
- 11 years ago
Great! your project is so easy for me and I can do that in short time. I do the separate quantity as sample that is from other sheets of all list of your products.
- 11 years ago
floridalouis
- 11 years ago
Are you asking for a total number for each Item Type, or a number of consecutive Item Types? (I am wondering what it means that "Alpha" is in the results more than one time.)
- 11 years ago
1. Contest Holder
  - 11 years ago
  Thank you for your message. The contest requires the display in separate sheet of the sum of the quantities for each type, while also sorting them in ascending and unique alphabetical order
  - 11 years ago
HRKonnect.Tech
- 11 years ago
This is the explicit solution. You and your contest both seem to be bogus. Thank you .
- 11 years ago
1. Contest Holder
  - 11 years ago
  Please note that you have provided a solution to another problem. I would like to receive a solution that sums the quantities and not counts the number of items as you proposed.
  - 11 years ago
tomislav1975
- 11 years ago
why not use pivot table?
- 11 years ago
1. Contest Holder
  - 11 years ago
  Well, by all means, please kindly provide such a solution.
  - 11 years ago
2. tomislav1975
  - 11 years ago
  I can do this using formulas but I really do not see point. This is much more efficient.
  - 11 years ago
Contest Holder
- 11 years ago
All the contestants are to provide a full and complete solution. The lack of explicit solution accompanied only by general ideas of approach are going to be rejected. Thank you.
- 11 years ago
HRKonnect.Tech
- 11 years ago
Yes sure. You can use the pivot tables
- 11 years ago
tomislav1975
- 11 years ago
Is this for word or excel?
- 11 years ago
1. Contest Holder
  - 11 years ago
  This is required to be done in Microsoft Excel '97-2003 only. Thank you.
  - 11 years ago
2. HRKonnect.Tech
  - 11 years ago
  yes it is done in 97-2003 excel.
  - 11 years ago
HRKonnect.Tech
- 11 years ago
I am unable send the excel file as attachments support only images
- 11 years ago
HRKonnect.Tech
- 11 years ago
It is in excel
- 11 years ago