1
vote
1answer
91 views

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further ...
0
votes
1answer
632 views

How to automatically populate a lookup column in Sharepoint 2013

I have 2 Sharepoint lists in SP2013: Errors and Locations. The errors list has a lookup column to the locations list. I need the location information (phone, address, etc) to populate automatically ...
0
votes
0answers
49 views

Use the formatting from data table cells for drop down table results

I am setting up a risk ranking table and risk analysis spreadsheet in Excel 2010 The user selects from two drop down boxes (liklihood and consequence) and it gives the corrosponding result. I have ...
0
votes
0answers
266 views

Cascading dropdown list in Excel 2010

I created dependent dropdown lists in my workbook. The first dropdown selected is nails_screws the second dropdown dependent on that choice will not display. All of the other dropdowns in the sheet ...
1
vote
1answer
55 views

Enforce style of named list items in Excel 2010

I have a named list with some values which have their own style (e.g. different colors): However when I apply that list as a data validation and select some values, the styling disappears: : How ...
1
vote
1answer
1k views

Excel 2010 filter arrow not showing text values

I have an odd problem on a tracker spreadsheet i use. All the columns have a filter, but when you click on the filter arrow it doesnt show you a breakdown of all the text values for that column. All ...
1
vote
3answers
887 views

How do I create a dropdown list for a column of constantly-changing values in Excel 2010?

I have an excel spreadsheet with a column for years, with a header: Years 1993 1993 1994 1994 1994 ... 2011 2011 There are duplicate values for the years, and additional rows will be added over ...