Hi,
I have a summary file which has an index and match formula working which returns information from the data sheet based on the month selected by the user.
It currently works for unique entries e.g. project 1, project 2 etc however within each region:
TOTAL - EMEA – USD
TOTAL - Americas – USD
TOTAL - EMPG – USD
I have the following identical headings:
Sales Orders
Other projects
QATAR - Operational Overhead
Freight Reclassification
Commissions
Which means the formula only returns the first instance of the occurance which is incorrect. Is there any way around this at all?
Paul
Bookmarks