Need help with Filter

megapc

New Member
Joined
Sep 12, 2014
Messages
2
Hello,

I'm doing Staff Training Report Management for my workplace and I stuck with extracting data base on what I need and I need your help. Below is the example of my data table looks like. It contains information about staffs who have been offered training in various types such as: Master Degree, Meeting, Workshop and other courses ect...

51UFMSE.png



And I want to Filter how many staffs have been joining training programs in types of "Meeting" for example, in Row 4, Excel show "Mr C" but Row 14:16, Excel shows only "JKL" as shown in below picture:

mUzPXXi.png


And suppose that I want to find who and what type of training are funded by "ABC", excel shows only Row 14 "JKL" and Row 17 "XYZ".

ERnNQKZ.png


Please help me how to enable Excel to show all information correctly.
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

RickXL

MrExcel MVP
Joined
Sep 9, 2013
Messages
4,328
Hi and welcomre to the forum,

The answer is not to use merged cells. Everything will work then.

It is a problem with Excel that it is used to enter data, store it and display it. These are really three separate jobs that get rolled together in Excel. Merging the cells makes the output look nice but it does not help the data storage aspect.

Merged cells are always problematic in Excel if you are trying to do some serious processing of the data.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,323
Messages
5,600,954
Members
414,417
Latest member
Nobu

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
Top