I'm looking for a tutorial/guide to help me searching within an array (and then assigning to a variable). I've done a few google searches, but I'm struggling to find what I'm after.
essentially I have an variant array (1 to 4776, 1 to 22), I want to search it for values, conditionally... for example, imagining it as a table, i'd do "countifs" to find what I need, but I'm not sure how to do that within an array.
If someone knows of a guide/tutorial, or even the words I need to search this for myself, that would be awesome, but I'm either finding guides on creating arrays, or how to create Array Formula in excel.
Thanks in advance,