So I am fairly well-versed in Excel (I think?), but I don't know much about arrays. I'm trying to modify a spreadsheet made by someone else.
Here's the formula:
=IF(ISERROR(INDEX(Database!$A$1:$B$3000,SMALL(IF(Database!$CE$1:$CE$3000=$B$126,ROW(Database!$A$1:$A$3000)),ROW(234:234)),2)),"",INDEX(Database!$A$1:$B$3000,SMALL(IF(Database!$CE$1:$CE$3000=$B$126,ROW(Database!$A$1:$A$3000)),ROW(234:234)),2))
It looks to me like it's accessing the Database tab and trying to find rows where the data in column CE matches the data in cell B126. This is good, but I don't want it to include that row if column CS (Database tab) has a certain value. Is there an easy way to do this?
Also - this is a massive spreadsheet that takes several minutes to open. Are arrays formulas that require a lot of CPU power? If so, I'm hoping deleting a lot of these rows with the arrays will help the performance of this particular spreadsheet.
Thanks in advance to anyone who is able to help!
Bookmarks