Index data horizontally and return data vertically

Aton999

New Member
Joined
Dec 3, 2015
Messages
39
Hi,

I have a set of data (table below) assuming data start from A1. Basically I am looking to match multiple criteria (Team1=Team1) & (Low = Low) & (Full Time = Full Time) and when matched, return values vertically (Skip empty rows).

<tbody>
</tbody>

ABCDEFGHIJKLMNO
1
Team1Team1Team1Team1Team1Team1Team1Team1Team1Team2Team2
2TeamJob TypeTaskCriticalityTomJohnkelmatSuejanhaymattmoonAm1hel1
3Team1
Full Time
Task1
Low
7322932029908626932678
4Team1HourlyTask2Low5690719968846135278823
5Team1Part TimeTask3Low6720966150369685506520
6Team2HourlyTask4Low2772256443337542742050
7Team2HourlyTask5High4025337136799563482637
8Team2Full TimeTask6Low7437794064767932899979
9Team3Full TimeTask6Mid6693993627705270554730
10Team1Part TimeTask7High9890893524915342429352
11Team3Full TimeTask8Low2961332568964631247061
12Team3HourlyTask9High2388402365996949744747
13Team3HourlyTask10Mid2493643470892593834545
14Team1Part TimeTask11High21100405153698560692545
15Team3Full TimeTask12Low3490506081875151404750
16Team2HourlyTask13Low9035877862315760464771
17Team4Full TimeTask14
High6468762642833941505157
18Team4Part TimeTask15High6763545465962529705770
19Team4HourlyTask16High4321815345294453296440
20Team4Full TimeTask17Mid5260218158807129237996
21Team4Full TimeTask18Low9692742439667346942376

<tbody>
</tbody>


Attached is link of sample data

Thank you in advanced
Aton
 
Last edited:

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
Aton999,

When I attempted to download your workbook, I received the following message:

Book1.xlsx is unsafe to download and was blocked by SmartScreen Filter.


You can post your workbook/worksheets to the following free site (sensitive data changed), and provide us with a link to your workbook:

https://dropbox.com
 
Upvote 0
Aton999,

I received the same message with the new link.

Click on the Reply to Thread button, and just put the word BUMP in the thread. Then, click on the Post Quick Reply button, and someone else will assist you.
 
Upvote 0

Forum statistics

Threads
1,213,506
Messages
6,114,025
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top