|
|
#9
02-28-2018, 06:22 AM
|
|||
|
|||
Thanks again - I think the data source is from a pivot table. Could you tell me how to overcome the following please? Ive attached an updated example whereby the delivery numbers all be it the same as its preceeding delivery number (in some cases) isn't in the cell and therefor throws the formula to lookup the value.
It wont always be the case there are multiple product types for a delivery number as per "TestCompany2" in the attached which only has one delivery number for one product. 
|
| Tags |
| filter records |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Image and it's explanation need to stay together
|
mohsen.amiri | Drawing and Graphics | 2 | 10-04-2017 04:10 AM |
|
Digital signatures don't stay
|
namedujour | Word | 1 | 09-26-2012 11:01 PM |
| avoid duplicete record and merge the record with the existed record | hemant.behere | Excel | 0 | 01-10-2012 02:53 AM |
| Stay on One Page - 100% | mnp | Word | 1 | 12-30-2011 11:57 AM |
| MS Project able to import actual start and or actual finish date from Excel? | mhacker | Project | 0 | 04-26-2010 11:29 AM |
Windows 7 64bit 
Office 2007
Threaded Mode