I have a long list of references. ...
You hadn't mentioned how long.
The formula I posted #8 is an array formula. Though array formulas are usually committed with Ctrl + Shift + Enter that one does not need to be. None-the-less array formulas are resource hungry. If that is slow to calculate over the range of data the SUM(INDEX(ISNUMBER(FIND("-"&ROW($1:$999),C2))+ISNUMBER(FIND("–"&ROW($1:$999),C2)),0)) part is the culprit.
This revision works, too. It reduces the load since the arrays are constants.
Formula:
=IF(AND(ISNUMBER(SEARCH("http:",C2)),ISNUMBER(SEARCH("org/",C2)),SUM(ISNUMBER(FIND("-"&{1,2,3,4,5,6,7,8,9},C2))+
ISNUMBER(FIND("–"&{1,2,3,4,5,6,7,8,9},C2)))),"Journal Article",IF(ISNUMBER(SEARCH("http:",C2)),"Internet",
IF(ISNUMBER(SEARCH("edited",C2)),"Book","Other")))
My apologies.
Bookmarks