Need Excel spreadsheet creating with VLook up and additional some scenarios building
- or -
Post a project like this3202
£50(approx. $63)
- Posted:
- Proposals: 3
- Remote
- #827448
- Awarded
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
Industry: Education
Description of excel work: Hi
I require a spreadsheet where I can drop in up to 2500 single or double digit numbers and have the table use a vlook up method to identify which 1 of 4 labels should be attached (labels is wrong terminology but I can explain better upon application.
I also need to be able to work out a summary of specific number of batches - so 20's would collect the labels from 1-20 then separately report 21-40, etc, etc and report how many were in each of the 4 categories/labels
20 isn't the number - but it would be good to have the flexibility to alter that easily to accommodate testing
We may not drop the whole 2500 at the same time but build up gradually, so the reporting would require a moving total of the 4 labels (hope this isn't too cryptic)
Extra notes:
Description of excel work: Hi
I require a spreadsheet where I can drop in up to 2500 single or double digit numbers and have the table use a vlook up method to identify which 1 of 4 labels should be attached (labels is wrong terminology but I can explain better upon application.
I also need to be able to work out a summary of specific number of batches - so 20's would collect the labels from 1-20 then separately report 21-40, etc, etc and report how many were in each of the 4 categories/labels
20 isn't the number - but it would be good to have the flexibility to alter that easily to accommodate testing
We may not drop the whole 2500 at the same time but build up gradually, so the reporting would require a moving total of the 4 labels (hope this isn't too cryptic)
Extra notes:
Lee K.
99% (172)Projects Completed
181
Freelancers worked with
198
Projects awarded
40%
Last project
7 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies