Hi All
I have database with raw data and a summary sheet (entitled “m2”) which uses the following formula:
=SUMIF(Sales!$AW$1:$AW$40881,'M2'!I$3&'M2'!$H5,Sales!$AG$1:$AG$40881)
My problem is that I need to identify items on the “Sales” sheet which do not appear on the M2 sheet. This formula looks at both Column H and Row 3 and matches this with AW on the “sales” tab.
I need help with...- A way I can highlight to see what the missing entries are (then I can make a decision on whether to include them on the M2 sheet)
- For a formula which basically says if it doesn’t appear on the M2 tab classify it as “Other” (which it would then make it appear on the m2 sheet as this is a product category, cell H337).
Anyone know a way to do this?
I have attached a sample file - it is quite large and very slow so if anyone knows of a way to speed this up please say.
Bookmarks