Forum Discussion

Tolley123's avatar
Tolley123
Copper Contributor
Jan 02, 2024

Count First Occurence Only

Help requested please.
Refer to the sample data set provided.
The requirement is to have a formula copied down in column F, that provides an Extended Price Update for only the row that has the first occurrence of an Additional Qty. value in column E (per the example data set, row 4). All other column F results (subsequent to the first occurence in row 4 are required to ignore any column E Additional Qty's. The results in column F are expected to show 5,600 in row 4, and in all other rows the figures shown in column D.
Thanks in advance.

    • Tolley123's avatar
      Tolley123
      Copper Contributor
      Hi _____, I appreciate your response, however I using an older version of Excel (2007) which does not support the NOT and ISBLANK functions.
      Any further suggested solution utilising version 2007 functionality would be very much appreciated.
      Thanks.
      • HansVogelaar's avatar
        HansVogelaar
        MVP

        Tolley123 

        NOT and ISBLANK are supported in all versions of Excel, at least in the English versions. Do you use a different language?

Resources