Hi,
I would like a formula which counts the number of rows away from a dynamic cell.
In my data set I have 3 customers “customer 1, Customer 2 and Customer 3”.
I would like to count the number of “F”’s for each particular customer. The number of customers can vary.
I have uploaded sample data with expected outputs.
Can anyone help please?
Try this array formula in E6 then drag down:
=IF(D6="F",ROW()-MAX(IF($D$5:D6<>"F",ROW($D$5:D6))),"")
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Quang PT
Here is a possible solution for you. Enter in E6 and fill down.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank you both! Each formula worked
Thank you for the feedback and the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks