Excel 2003 sort/select problem

  johnincrete 17:30 05 Nov 2010

I have a spreadsheet which has a name in Column A headed "Fullname", a column header "Amt" which contains a monthy payment amount and then 9 columns headed "Sept,Oct,Nov etc These month columns contain a "Y" when the amount is paid.
I want to identify people whose payment is overdue. Thus, we are in November so I want to list those who have not paid in September or October. (Anyone who has paid Oct MUST have already paid Sep) Next month it will be those who have not paid in either Sep Oct or Nov and so on.
Can I do it in Excel?

  VoG II 18:01 05 Nov 2010

Try in L2, copied down

=IF(COUNTIF(C2:K2,"Y")<MATCH(TEXT(TODAY(),"mmm"),C$1:K$1,0)-1,"Overdue","Paid up")

  johnincrete 04:19 06 Nov 2010

As ever, you come to the rescue!
Are formulas such as these documented somewhere?

  VoG II 07:54 06 Nov 2010

"Are formulas such as these documented somewhere?"

No, that is a one-off o:)

  Noldi 08:27 06 Nov 2010

click here

This gives you a list of Functions.
Gives you an idea of what can be achived.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

iPhone X vs Samsung Galaxy Note 8

Les meilleurs navigateurs internet 2017