Hi,
I have a monthly rota that I need to create daily lists from.
The table is simple with staff names and day of the month as the axis. There are several shifts they could be working that are abbreviated in each cell.
I currently create daily sheets as a print out by filtering each dy and cutting and pasting names. I'd love to do this by formula to work smarter.
So what could i use if I want to create a list of everyone with either an E, EH, or EL in column B for example?
One of the easier ways to do this would be to introduce a column heading (here I've called it "Types") and turn on the column Autofilter...then select whichever types you'd like to display using the dropdown selector. The XL2BB add-in doesn't show this autofilter, but see the snapshot below. To turn the filter on, used Data > Filter.
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.