Comparing and retrieving locations NOT visited using two excel docs

jennjax1010 , you are welcome

SergeiBaklan Thank you will give it a go :)

jennjax1010 

You shall change the reference on day of the week as well, from $B4 on B$4

=IFERROR(
    INDEX(Schedule!$A$2:$A$208,
        AGGREGATE(15,6,
            1/((COUNTIFS('Export Report'!$G$2:$G$7529,B$4,'Export Report'!$B$2:$B$7529,Schedule!$A$2:$A$208)=0)/
                LEN(INDEX(Schedule!$B$2:$H$208,0,MATCH(B$4,Schedule!$B$1:$H$1,0)))>0)*
               (ROW(Schedule!$A$2:$A$208)-ROW(Schedule!$A$1)),ROW()-ROW($B$4)
       )
    ),
"")

Please check attached

SergeiBaklan  Thought you were rid of me :) Just out of curiosity...is it possible to have the Not Visited Tab list display vertically, with the days of the week as column headers instead of a horizontal chart? I attempted to do so myself within the formula changing the row/column info but while its generating data as a result its not generating it properly.

Current formula =IFERROR(INDEX(Schedule!$A$2:$A$210,AGGREGATE(15,6,1/((COUNTIFS('Export Report'!$G$2:$G$7529,$B4,'Export Report'!$B$2:$B$7529,Schedule!$A$2:$A$210)=0)/LEN(INDEX(Schedule!$B$2:$H$210,0,MATCH($B4,Schedule!$B$1:$H$1,0)))>0)*(ROW(Schedule!$A$2:$A$210)-ROW(Schedule!$A$1)),COLUMN()-COLUMN($B$4))),"")

Thanks in advance!

jennjax1010 

Great

SergeiBaklan Ahhh!! I wasnt aware, thank you so much! Making note of that :)

It worked!!!!

Hi jennjax1010 

In your first sample in Schedule where were numbers and here are texts. Thus the condition in the middle of the formula as value>0 shall be changed on len(value)>0

=IFERROR(
  INDEX(Schedule!$A$2:$A$208,
  AGGREGATE(15,6,1/((COUNTIFS('Export Report'!$G$2:$G$7529,$B4,'Export Report'!$B$2:$B$7529,Schedule!$A$2:$A$208)=0)/
  LEN(INDEX(Schedule!$B$2:$H$208,0,MATCH($B4,Schedule!$B$1:$H$1,0)))>0)*
  (ROW(Schedule!$A$2:$A$208)-ROW(Schedule!$A$1)),COLUMN()-COLUMN($B$4))),
"")

Please check attached.

SergeiBaklan You are amazing :) Attaching a sample with just a few rows of data...same formula..

jennjax1010 , if you may submit your file keeping only few first records and renaming in them actual names on something abstract (other words removing sensitive information) I could try to check what's wrong with the formula.

SergeiBaklan Thank you for that, I am using B4 as well on my sheet...just not sure why it isnt returning any data at all. Thank you anyway! Will just keep plugging away at it..there are definite locations not visited as evident in the highlighted cells/conditional formatting example...just not sure why not returning them in this method. I dont think that the returning data being longer strings of text besides simple letter like in the example would matter either.

Appreciate all the help!

jennjax1010 

I adjusted first two sheets of the sample file and copy/paste your formula without any changes - it works. Please see in attached file.

It's assumed what Not Visited range starts from the cell B4

otherwise the formula is to be adjusted. Or, you may start from B4 and after that remove/insert columns and/or rows as required.