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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Forum statistics

Threads
1,181,690
Messages
5,931,467
Members
436,790
Latest member
aelbaitam

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