I have a list of items and a range where I put those items. I use this two formulas =IF(M23="","",COUNTIF($E$8:$J$29,M23)) on one column and =IFERROR(INDEX(M:M,AGGREGATE(15,6,ROW($M$23:$M$120)/($P$22:$P$120=0),ROWS($O$22:O22))),"") on the other one. Those formulas show me what items is left unused from the main data list. So I have one column that shows unused items and what I need is a formula which could show me what is used on my range. What formula could show me this?
Bookmarks