I have a workbook with 3 tabs. First tab has a master list (Master Invoices) of combined invoices from 2 companies (Company 1 and Company 2). In subsequent sheets, I would like info to be distributed in a concise list based on the Company name (C1).
I used an Index/Array formula but running into errors. It looks like the company name lines up in adjacent column and the other columns do not even show. Also I would like to get rid of #NUM errors. Thanks so much!
Turn the two tables in the company sheet BACK into ranges and delete all formulae.
In A3:
=FILTER(MasterInvoice,(MasterInvoice[Contract]='Company 1'!C1))
similarly on the other sheet.
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks