Hello Excel specialists,
As I’m sure many of you are aware (as I have used this forum a lot), I am in the process of building a recording program for moths and butterflies and on this occasion I have an issue as regards loading the ‘earliest’ and ‘latest’ dates on which a species of butterfly has been recorded.
The problem is in cells G2542:H2649 the ‘index’ worksheet of the attached workbook, Column G should give the ‘earliest date’ recorded and column H should give the ‘latest date’ recorded. The source for these dates is in column K on the ‘Butterfly’ worksheet.
As can be seen in cells G2541 and H2541 the formula for the earliest and latest dates does work right to the top of the sheet for both the ‘macro moths’ and the ‘micro moths’, but when I drag it down to get the same results for the butterflies, I just get an error ref and I just can’t work out how to fix it.
I apologise in advance for sending the complete recording program, but stripping bits out to send you is not an easy task.
For your information I am using Excel 2003 and Windows 10.
Thanks for any help.
Bookmarks