Workbook Test26 shows the left hand table of 3 groups of three columns headed GEN TAP and LAB next to it is a table of three groups of two columns
This table is derived from the first by splitting the value in the GEN column and adding a fraction (governed by the value in row5) to both the other columns.
AS the real data has over 100 sets of three columns I would like to do this by devising a single formula that can be dragged across the 2 column table. I feel it should be possible but I cant see how. Can any one help please
John
Bookmarks