Forum Discussion

Twifoo's avatar
Twifoo
Silver Contributor
Jan 07, 2020

Sabeel 

In that case, you have to convert the ranges to tables, such that the formula in M2 will be as shown in the snapshot below: 

Thereafter, copy the last row in the Unmatched Table until the new last row returns empty text (""). 

  • Sabeel's avatar
    Sabeel
    Copper Contributor
    Jan 07, 2020

    entering the  cell data show blank and adjuscent data errorTwifoo 

  • Sabeel's avatar
    Sabeel
    Copper Contributor
    Jan 07, 2020

     

     

    Twifoo 

    • Twifoo's avatar
      Twifoo
      Silver Contributor
      Jan 07, 2020

      Sabeel 

      Excel introduced AGGREGATE in 2010. The #NAME? error presupposes that your version is 2007 or earlier. Thus, I modified the formula in M2 to probably suit your version, as shown in the snapshot below: 

Resources