On multiple sheets I have Column A (Event date), Column B (Event Name), Column C (Participation). Every sheet is populated with event dates in Column A and the Name in Column B. Column C is blank until the event takes place. If there is participation, a brief description is made and is not a limited answer and is a mix of alphanumeric (never starts with a number).
On the 1st sheet, my Summary sheet, I have a cell for each sheet to reflect when the last date was that participation took place at an event and another cell for when the next possible event date will be. The formula for finding the last date participation took place works. The formula for finding the next possible day is not working.
{=MAX(IF(TLSA_S!C$11:C$45<>"",TLSA_S!A$11:A$45))} <------This works
{=MIN(IF(TLSA_S!C$11:C$45="",TLSA_S!A$11:A$45))} <------Doesn't work
It appears to be because it cant find the blank cells because if i change it to
{=MIN(IF(TLSA_S!C$11:C$45="X",TLSA_S!A$11:A$45))}
and put an X in every cell in TLSA_S!C$11:C$45 then it works. I have tried incorporating ISBLANK and using 0 and nothing works. I wouldn't really care to put an X or . in each of those cells to make it work but I am just concerned about a potential error with the other formula and its use of <>"" for the same range (not sure why that didn't happen when I tested it and I assume the solution to that would be <>"X" etc.).
What am I doing wrong? Do I need to use different formulas all together?
Bookmarks