All Questions
92
questions
1
vote
2
answers
31k
views
In Excel I need to find data matches between two arrays - one horizontal and one vertical
In Excel 2010 (or 2007 - I have both, although my OS is only Win7 32 bit as a limitation for some legacy applications we run), I need to find how I can find and return the matching value from two data ...
0
votes
1
answer
267
views
Excel formula - sometimes array formula, sometimes not
I want to write some data to an Excel file, and I want the first page to show a summary of the data that are spread all over the sheets. The individual data items on a sheet can be included or ...