Forum Discussion
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 firs...
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.
Any further suggested solution utilising version 2007 functionality would be very much appreciated.
Thanks.
That is strange Excel 2007 definitely works with mentioned functions Excel functions (by category) - Microsoft Support if the speak about English function names.
Please try to open attached file in your environment. Idea of the formula is the same, just changed a bit to avoid array formulae.
=B2*(C2+E2*(ROW() = AGGREGATE(15,6,$E$2:$E$9/$E$2:$E$9*ROW($E$2:$E$9),1)))