Hi all,
I'm looking to build a dictionary-like excel template where I can slot in new words according to categories (i.e. plant, animal, food,...etc)
I already have something build as in the attached spreadsheet below.
The problem is: I find it incredibly slow when I refresh the spreadsheet.
Therefore, my question is:
1.) Is there anyway to speed up the spreadsheet (as it takes quite a while to refresh). The main culprit , I guess, is the "=SMALL(IF(Index!$A$3:$A$8=Animal!$B$1,ROW(Index!$A$3:$A$8)),ROW(31:31))" formula. So is there any viable and better alternative?
2.) I've a "Car" category, which I would like to capture but for some reason, the spreadsheet isn't able to. Anyway to capture it?
Explanatory Note: I've a "Index" sheet as a content page for my entries. And I sort the entries according to categories in different sheets (i.e. Car, Plant, Animal and so on).
Thanks.Dictionary in Excel.xlsx
Bookmarks