Quick Excel function to sort and group incoming data sets
$10-30 CAD
Thanh toán khi bàn giao
I want to easily sort registrants for an event, each one of which will have selected a different combination of the 5 possible options when registering, into one of 23 possible combinations, so I can keep track of how many registrants in each category, for better planning and ordering of supplies.
In the attached spreadsheet, Tab A (Date as Received) is a portion of the actual spreadsheet I will receive. Each competitor will have selected any combination of Races 1 through 4 (Tab 1, columns B-E). If they select Race 4, they also indicate if that is for the Quarter of Half option (Column F).
The output I will need is for the groupings on Tab 2, Sorting Categories.
In the attached example:
Competitor 1 would be Combo 22,
Competitor 2 would be Combo 2,
Competitor 3 would be Combo 3,
Competitor 4 would be Combo 23
I want to download a current version of the registrants list on a regular basis and be able to easily see how many in each race Combo.
Note: The actual data contained in Tab A, Columns B-E, is not important in this project. The only information that matters is are they in that race (cell has data) or not (cell shows N/A)
Note 2 My preference is to accomplish through formulas rather than VBA (since I can easily modify a formula to my use, but have no VBA experience)
ID dự án: #13052316
Về dự án
Được trao cho:
Hi I am here to assist u inthis project I am an acca member currently wor in finance dept of Qatar Airways Have great skill and exp in excel can assist u with high regards Plz share more info to proceed Thanks Lookin Thêm
11 freelancer chào giá trung bình$21 cho công việc này
Hi I'm new in this site. I have a lot of experience but I need to get some qualifications in order to achieve new works. (I've just done your demand) Regards!
I am used to working with data entry, (current position Data Gathering expert), i pay attention to detail and am experienced in excel.