Hi,
I've put together a test table and formula - see below - which works but I need to make it more flexible with wildcards.. please can someone tell me how?
Table pasted in Cell A1:
<colgroup><col><col span="2"><col><col></colgroup><tbody>
Order Type
BOM
Item
Sales Value
DISPLAY
VOLTA...