Hi,
I am trying to create a list of the duplicate values in a list so that when we are ordering it says we need 50 apples or something similar.
To create this list I have used this method:
for the first row
=IFERROR(INDEX(tbl[ITEMS],MATCH(0,COUNTIF(G26:$G26,tbl[ITEMS])+IF(COUNTIF(tbl[ITEMS],tbl[ITEMS])>1,0,1),0)),"")
for the rest of the rows
=IFERROR(INDEX(tbl[ITEMS],MATCH(0,COUNTIF(G$26:$G27tbl[ITEMS])+IF(COUNTIF(tbl[ITEMS],tbl[ITEMS])>1,0,1),0)),"")
it looks up the values in the column items in my table and then displays a list from G27:G40.
I would like to know how I can make this formula ignore blanks because currently, it is retuning that I have 100 x blanks as an example.
I would appreciate any help or ideas. Thank you.
I am trying to create a list of the duplicate values in a list so that when we are ordering it says we need 50 apples or something similar.
To create this list I have used this method:
for the first row
=IFERROR(INDEX(tbl[ITEMS],MATCH(0,COUNTIF(G26:$G26,tbl[ITEMS])+IF(COUNTIF(tbl[ITEMS],tbl[ITEMS])>1,0,1),0)),"")
for the rest of the rows
=IFERROR(INDEX(tbl[ITEMS],MATCH(0,COUNTIF(G$26:$G27tbl[ITEMS])+IF(COUNTIF(tbl[ITEMS],tbl[ITEMS])>1,0,1),0)),"")
it looks up the values in the column items in my table and then displays a list from G27:G40.
I would like to know how I can make this formula ignore blanks because currently, it is retuning that I have 100 x blanks as an example.
I would appreciate any help or ideas. Thank you.