If you have to separate out;
Items beginning P with C & D but do not count items beginning with either C or D
In the row format you can manually select each P but it trails into well over 500…
Rows doesn’t do much either…
Can anyone excell wizard advise is there a formula for ruling out items beginning with C or D from being counted against total Inventory.
It’s stumping me !
Thanking you in advance.