Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
12 dependent series
Dear expert,
Would like to prepare the shift table. Say I put 1 in cell A1 A2 to A13 will show up like this ... Timmy James Patrick Terence Dion Jasmine Kammi Steve Ricky Kelly Fiona Peggy Say I put 2 in cell A1. A2 to A13 will come up like this. Terence Dion Jasmine Timmy James Patrick Kammi Fiona Peggy Kelly Steve Ricky It is hard to use "IF", becasue there are more than 7 choices .... VB can definitely do, but I would like to have a try on worksheet function first. Thanks, Elton |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
Fill Series Dates: not letting me change the series from year to m | Excel Discussion (Misc queries) | |||
2nd Axes - primary series data of only 1 series disappears! | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel | |||
series graph -- one series being added to another series | Charts and Charting in Excel |