Hi,
I require a function which looks at a ID in a certain column and only compares values across respective rows for that ID:
1) Function looks at cells containing the same ID
2) Looks at which currency is first alphabetically and then if PAY or REC to determine the Buyer
Issue I am having is restricting the formula to just check across Rows where the ID is the same when dragging down the column
<tbody>
</tbody>Thanks,
Tom
I require a function which looks at a ID in a certain column and only compares values across respective rows for that ID:
1) Function looks at cells containing the same ID
2) Looks at which currency is first alphabetically and then if PAY or REC to determine the Buyer
Issue I am having is restricting the formula to just check across Rows where the ID is the same when dragging down the column
<tbody> </tbody> |
<tbody>
</tbody>
Tom