Quick Excel function to sort and group incoming data sets

Đã hoàn thành Đã đăng vào 7 năm trước Thanh toán khi bàn giao
Đã hoàn thành 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)

Excel

ID dự án: #13052316

Về dự án

11 đề xuất Dự án từ xa 7 năm trước đang mở

Được trao cho:

scorpionobaid01

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

$15 CAD trong 0 ngày
(5 Đánh Giá)
2.7

11 freelancer chào giá trung bình$21 cho công việc này

emmanverz

Hi Sir, I want to apply for the job. I'am a Web Developer/Information Technology student who wants to earn even low only. I'am knowledgeable in data entry and data processing using MS Office such as Word, PPT and of co Thêm

$25 CAD trong 0 ngày
(0 Nhận xét)
0.0
aakmde

Hello Sir, This is Muruganandam from India. I'm a professional design engineer. I know some software's like Autocad, Solidworks and Unigraphics. I'm new for this feelancer website. Please give me this task I will do Thêm

$10 CAD trong 1 ngày
(1 Nhận xét)
0.0
gouriprasad41

A proposal has not yet been provided

$25 CAD trong 1 ngày
(0 Nhận xét)
0.0
hectorvasquezt

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!

$15 CAD trong 0 ngày
(0 Nhận xét)
0.0
chrysanthiep

I am used to working with data entry, (current position Data Gathering expert), i pay attention to detail and am experienced in excel.

$25 CAD trong 1 ngày
(0 Nhận xét)
0.0