View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Totteridge Ram Totteridge Ram is offline
external usenet poster
 
Posts: 8
Default 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?