Flexible formula within standard table format

[FMulho]

Hi All,

I am currently operating with the current formula:

=(J12-MIN(IF($B$12:$B$172871=B12,$J$12:$J$172871)))*K12 + CTRL,SHIFT,ENTER

I thought this change would make the formula flexible for any length of columns:

=([@Name4]-MIN(IF([Groupid]=[@Groupid],[Name4])))*[@Name5]

But it doesn't work.

Has anybody got any suggestions?

Thanks in advance

 

[RoryA]

What do you mean by "doesn't work"? I can't see anything wrong with the formula - unless you are trying to array enter it into the entire column at once, which is not allowed (or necessary).