The main table is already quite full, having one license type cell that can hold the required info would be ideal. Is there a simpler way to store this info? Only other way I can think is a seperate table with multiple entries of name/license type, which would be cross referenced. I know it can be done in drop downs by following a tutorial from TrumpExcel and using a little VBA, but I really am trying to keep it simple and not venture too far outside my understanding. Later I'd like to use a slicer and select C to see all employees with a car license. I wanted to have a license type column and store values like C,HC,R in a single cell. But each license can have many variations, car, bike, boat, truck, manual/auto. Some have licenses with expiries, easy enough. I have a similar question, but your link didn't really hit the nail on the head. They are identifiable with a special user flair.Ī community since MaAsking a question? Describe if you are using Excel (include version and operating system!), Google Sheets, or another spreadsheet application. Occasionally Microsoft developers will post or comment. Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors Date 3) Add a slicer based on the new column Location. Make sure the cross filter direction is Both. You can then type in or paste the following: 2) Create a relationship between City in the new table and City the initial table. You can also use the Shift key to select multiple adjacent items. I propose the following solution: 1) Create a new table by going to Home -> Enter Data. This will filter your data to only show the selected items. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. Select Multiple Adjacent Slicer Items To select multiple adjacent items in a slicer, click on the first item then drag the cursor to the last item and release the click. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. And to then have slicers that when I select Red it would filter for all Names that have Red in column B. So A2 - David then B2 - Green, Red, Yellow. An example would be to have in one column a list of names and each name should be able to select multiple colours but not repeat colours. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block I then want to be able to use slicers to filter the list. This will award the user a ClippyPoint and change the post's flair to solved. I need both slicers set to 'multiselect.' Everything works fine, but if I save the workbook and then reopen it, the 'multiselect' feature is turned off again. OPs can (and should) reply to any solutions with: Solution Verified I have 2 slicers set up to filter data from a single formatted table.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |