Forum Discussion

NeilAm12's avatar
NeilAm12
Icon for Helper I rankHelper I
7 years ago
Solved

Additional Column for Previous Data Based on Previous Time and Filter

Hello All,   Need your help, i need to get the previous data of Data-Xi column base on Entry Date/Time based with filter of MiniCompany and Machine #. I tried many formula but it shows error. Con...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    I think this error is occuring because there is a duplication combination of Mini Company, Entry Date/Time and Machine#.  For the LOOKUPVALUE() function to work, each row combination should be unique

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

That requires signing in.  Try to share the file via Google Drive.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    Hi,

    I think this error is occuring because there is a duplication combination of Mini Company, Entry Date/Time and Machine#.  For the LOOKUPVALUE() function to work, each row combination should be unique