Hi everyone.
I have a table of results from a form giving me a number of items and whether they are missing or present. The Items are in f1:BM1 and the result (missing or present) are in f2:bm2. I want a list created in cells a4:a(however many results say missing). I found a formula online to do this sort of thing but it is an array for rows and not columns and no matter how much I try and play with it I can't get it to do what I want it to do.
The formula I got online is
I have modified it to fit my parameters and seems to recognised the "Missing" part as when I evaluate it it returns a value for each column number so for F it returned 6 then false for G and then 8 for H and so on
To be honest I don't understand the array formula well enough to work out the problem.
If anyone can help I'd be much appreciated
Neil
Bookmarks