Hi
I want to return the name of cities that have no sale in specefic month and product. data is in the file.
my question is urgent
Hi
I want to return the name of cities that have no sale in specefic month and product. data is in the file.
my question is urgent
Last edited by ieumts; 02-07-2021 at 03:33 PM.
Try this:
=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($C$2:$C$7)/((IF(($A$2:$A$7=$I$1)*($B$2:$B$7=$I$2)=0,$C$2:$C$7,"")<>"")*(COUNTIF(K$1:K1,$C$2:$C$7)=0)),1)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Hi
Thanks for your formula
Your Formula Work good. but for example if the 7th Row is: Month:5 Product:A2 City:c2 TotaL Sale: 6000
The formula return c2 that it is wrong.
because in month=4 and product=a1, only c1,c3,c4 have no sale.
The new file is attached.
thanks
Hi
try this in L2 and down:
=IFERROR(INDEX($C$1:$C$6,AGGREGATE(15,6,(ROW($C$2:$C$6)/(($A$2:$A$6&$B$2:$B$6<>$I$1&$I$2))),ROWS($E$1:E1))),"")
Hi
that was not work true
because the range of data is A1:D7 but your formula is including C6
Thanks
An alternative, but needing a list of cities...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks