check range

  • Thread starter Thread starter crapit
  • Start date Start date
C

crapit

How to check whether which data does "name" refer to by check exist date that fall between range of start and end date?




data start date end date
a 05/02/1984 23/01/1985
b 24/01/1985 11/02/1986
c 12/02/1986 01/02/1987



name exist date
hyrdo 10/03/1984
potat 14/02/1985
dalci 24/04/1986
 
Hi

If you do away with the start date column altogether, and have 01/01/1900 in
the cell containing End date, then with those values in cells A1:B4 enter
the following formula alongside the first exist date in cell C9

=INDEX($A$2:$A$4,MATCH(B9,$B$1:$B$4,1))
and copy down

--
Regards
Roger Govier
How to check whether which data does "name" refer to by check exist date
that fall between range of start and end date?




data start date end date
a 05/02/1984 23/01/1985
b 24/01/1985 11/02/1986
c 12/02/1986 01/02/1987



name exist date
hyrdo 10/03/1984
potat 14/02/1985
dalci 24/04/1986
 
Back
Top