Hi, I have a table that shows the brand preference(B2:B50)
For range E4:E13, I want to calculate the number of times that the brand name appears in the table in B2:B50
Hi, I have a table that shows the brand preference(B2:B50)
For range E4:E13, I want to calculate the number of times that the brand name appears in the table in B2:B50
Try this in E4 and drag down
Formula:Please Login or Register to view this content.
Ferdy
Remember to mark as Solved and give out rep.
Thx mate, works well!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks