Hello once again!
I'm looking for help - I need to sort a list of items alphabetically if there is not a most popular one. I currently have a formula for the most popular products however I need it to show alphabetically if there isn't a most popular item.
My current formula to show the most popular is;
{=IFERROR(INDEX('Sheet1'!$N$2:$N$10026,MODE(IF(MONTH('Sheet1'!$AB$2:$AB$10026)=(MONTH(Sheet2!BZ14))*(YEAR('Sheet1'!$AB$2:$AB$10026)=(YEAR(Sheet2!BZ14))),MATCH('Sheet1'!$N$2:$N$10026,'Sheet1'!$N$2:$N$10026,0)))),"")}
Can somebody help to sort it by alphabetical if there isn't a most popular item?
Thanks so much
I'm looking for help - I need to sort a list of items alphabetically if there is not a most popular one. I currently have a formula for the most popular products however I need it to show alphabetically if there isn't a most popular item.
My current formula to show the most popular is;
{=IFERROR(INDEX('Sheet1'!$N$2:$N$10026,MODE(IF(MONTH('Sheet1'!$AB$2:$AB$10026)=(MONTH(Sheet2!BZ14))*(YEAR('Sheet1'!$AB$2:$AB$10026)=(YEAR(Sheet2!BZ14))),MATCH('Sheet1'!$N$2:$N$10026,'Sheet1'!$N$2:$N$10026,0)))),"")}
Can somebody help to sort it by alphabetical if there isn't a most popular item?
Thanks so much
Last edited: