| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Returning a column reference for a data point
Hi
I have a spreadsheet with unique account numbers in column A, and then across the top, from Column B onwards, I have listed the next 72 months (Jun 09, Jul 09, etc). In each row (ie for each account), a forumula in each cell (under each month for each account) either returns a positive number or 0. I need to identify the month each account has the positive number (it is the maturity value), and have the maturity month listed next to the account number. I have no idea where to start. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cluster column chart with data point labels | Charts and Charting in Excel | |||
| Stacked column chart wit more than one column in a data point | Charts and Charting in Excel | |||
| Looking up data in a column, then returning values of respective row | Excel Discussion (Misc queries) | |||
| Excel should let you graph every n-th data point in a column | Charts and Charting in Excel | |||
| How do I delete data in a column from a certain point on? | Excel Worksheet Functions | |||
Threaded Mode
