Hi,
Given the formula:
=MINIFS(EXPORT4!I:I,EXPORT4!C:C,">="&MINIFS(EXPORT1!E:E,EXPORT1!A:A,B3),EXPORT4!C:C,"<="&MAXIFS(EXPORT1!E:E,EXPORT1!A:A,B3))
The 'EXPORT1!' and 'EXPORT4!' refer to other sheets and are manually inserted. I would like to fill them in based on text in a cell.
For example:
Text in A1 is : 'EXPORT1!'. Whenever i change this to 'EXPORT2!' it should be changed correctly in the given formula.
Thanks in advance!
Given the formula:
=MINIFS(EXPORT4!I:I,EXPORT4!C:C,">="&MINIFS(EXPORT1!E:E,EXPORT1!A:A,B3),EXPORT4!C:C,"<="&MAXIFS(EXPORT1!E:E,EXPORT1!A:A,B3))
The 'EXPORT1!' and 'EXPORT4!' refer to other sheets and are manually inserted. I would like to fill them in based on text in a cell.
For example:
Text in A1 is : 'EXPORT1!'. Whenever i change this to 'EXPORT2!' it should be changed correctly in the given formula.
Thanks in advance!