Summarising Dates and Players

[Steve 1962]

Hi

I am attempting to identify the names of players that have not paid up their subscription to a nominated date.

Cells G2 to H5 summarise when each player is due to pay. The nominated fee is $3.00. Anyone that has less than $3.00 will be assigned the respective date that they are due (as noted in the table A1 to E5).

I want Excel to automatically summarise the upaid players (with the correct date) in cells G2 to H5.

Thanks

SH

Book1.xlsx
	A	B	C	D	E	F	G	H
1		11-Apr	18-Apr	25-Apr	2-May			Due
2	Bill	$3.00	$3.00	$2.89			Bill	25-Apr
3	Frank	$3.00	$2.70				Frank	18-Apr
4	Greg	$3.00	$2.55				Greg	18-Apr
5	Arnie	$0.25					Arnie	11-Apr
Sheet1

 

[Andrew Poulsom]

Try:

=INDEX(B$1:E$1,,MATCH(TRUE,B2:E2<3,FALSE))

which must be confirmed with Ctrl+Shift+Enter, not just Enter. If correctly entered Excel will surround this array formula with curly braces {}.

 

[Steve 1962]

Hey Andrew

Really great - works terrifically.

Thanks heaps.

Steve
(Townsville, QLD)