Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Keping data of same structure in more than one sheets is a bad idea.
All the performce data in one sheet would allow to use the formula

{=MAX(($Performnces.$E$2:$E$5000=C2)*($Performances.$B$2:$B$5000))}

entered for arry evaluation wit Ctrl+Shift+Enter.

I cannot see how your formula hould return a "ltest" date" if vnot in 206.

Filling an array formula down with the mouse reuires modifiuction with the Ctrl key.

Keping Keeping data of same structure in more than one sheets is a bad idea.
All the performce data in one sheet would allow to use the formula

{=MAX(($Performnces.$E$2:$E$5000=C2)*($Performances.$B$2:$B$5000))}

entered for arry evaluation wit Ctrl+Shift+Enter.

I cannot see how your formula hould should return a "ltest" date" if vnot in 206.

Filling an array formula down with the mouse reuires modifiuction with the Ctrl key.