Identifying how many values greater than 0 in a sum product.

Barchetta99

New Member
Joined
Apr 8, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Hi thanks for looking. I have a list of word that are being searched in a column, e.g. red rose blue car.
what i wanted to do was select the first word found in a list of 41 words.
These words are sorted in a hierarchy my most important word 1 and least important 41.
What i am finding is sometimes more than 1 word is found as the picture shows, word, 14, 15 and not shown also 24 adding to 53, there is no word 53 so errors.
Most words are only found once in the search and should be Ok, but i'd like to know which rows had more than 1 find so i can try a different list.

The outcomes defined range aggregates the words so red and blue would aggregate to colour, rose to flower, car to car etc.

I've around 30k rows to look at so it needs to be automated any thoughts greatfully received or a different approach.

sumproduct.jpg
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,143,638
Messages
5,719,979
Members
422,254
Latest member
sayedsaid

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top