Hello Gurus,
I am using Office 2016.
I have two files, one file is Experiment Log Entry Sheet.xlsm, in which column A has Experiment ID and column E has Date of execution, and another file "Data_file.xlsx" in which I want to extract a list of Experiment IDs matching today's date (which is in ELISA_Sheet_Plan!L$4 of the file).
I have surfed the internet and tried the below formulae:
=IFERROR(INDEX('[Experiment Log Entry Sheet-2023.xlsm]Database'!$A:$A,SMALL(IF('[Experiment Log Entry Sheet-2023.xlsm]Database'!$E:$E=ELISA_Sheet_Plan!L$4,ROW('[Experiment Log Entry Sheet-2023.xlsm]Database'!$A:$A)),ROW(1:1))-4,1),"")
I am looking for a solution without using VBA.
Best Regards,
S
I am using Office 2016.
I have two files, one file is Experiment Log Entry Sheet.xlsm, in which column A has Experiment ID and column E has Date of execution, and another file "Data_file.xlsx" in which I want to extract a list of Experiment IDs matching today's date (which is in ELISA_Sheet_Plan!L$4 of the file).
I have surfed the internet and tried the below formulae:
=IFERROR(INDEX('[Experiment Log Entry Sheet-2023.xlsm]Database'!$A:$A,SMALL(IF('[Experiment Log Entry Sheet-2023.xlsm]Database'!$E:$E=ELISA_Sheet_Plan!L$4,ROW('[Experiment Log Entry Sheet-2023.xlsm]Database'!$A:$A)),ROW(1:1))-4,1),"")
I am looking for a solution without using VBA.
Best Regards,
S