COUNTIF Adding New Reference cells

So what I'm trying to do is have an attendance sheet where attendee id numbers are put in one column and it removes their name from an absent list. This way, when all attendees have "shown up", I can quickly see who is missing.

The problem I am having is updating the master attendee list. If I need to add someone in the middle of the list (for alphabetical order sake) the COUNTIF function I am using does not add.

I am using the insert cell command to add more attendees to the list (in columns H and I), but column E will not update my "Absent" list.

I have attached pictures and a sample workbook. Is there any way to make these lists dynamic so I can easily update my Attendee and ID list on the fly?

Any advice would be really appreciated!!

Working Page.PNG

Not Working Page.PNG

My thinking is that this may need to be a VBA thing...

Whilst I dislike the indirect function the below may work in E3 and copy down

=IF(COUNTIF($B$3:$B$100,INDIRECT("I"&(ROW()+1)))>0,"",INDIRECT("H"&(ROW()+1)))

This is a pretty solid workaround, I am gonna mess around with this!

I've never seen the INDIRECT function, I'll look into it! Seriously, thanks so much for the help!

It works in this situation but I don't like it for some of the reasons below. Although for your problem it works!

https://fastexcel.wordpress.com/2016...evil-function/