Advancing the Cell

[JMata806]

Wanted to thank @jasonb75 & @Eric W for the previous help I've ironed out a good chunk of my previous endeavor.

As such I was curious if the brains and dreamers of this wonderful forum could help me with a final project that advances my project just a tad more.

The goal of this is to take Columns A-C as the main data table.
Find ONLY E Column within that data table.
Sum the points from those found
Than upon reaching the 10th or greater point report back the date from the corresponding cell from A column.

In short it would filter the data based on the list from E and sum up the points to >=10 than report back the date from that filtered information.

For Example:

Thinking of using either helper tables of lookup, but if there is a simpler process I would be appreciative.

Thanks Excel Genies! Next round of drinks is on me! ^_^

 

[JMata806]

does no one know da answer? would using a combined table list be more advisable to simplify this?

 

[JMata806]

Well it was messy and experimental but I got what I wanted to pull, I know there is probably a simpler way but here is how I worked it.

First I had to use several additional columns (F-I) in order to sort this data.

In the COLUMN F I used (F) -> =IF(COUNTIF(E2:E41, C2:C41),1,0)
In the next column I used (G) -> =IF((F2=1),B2,"")
Than in the proceeding Column (H) but in Cell (H2) -> =IF(G2>=10,G2,"") than in (H3-H41) I used -> =IF(SUM(G$2:G3)>=10,SUM(G$2:G3),"")
Congo line! (I) -> =IF(H2<>"",A2,"")
With the final formula giving me the needed Information using -> =INDEX(I2:I41,MATCH(TRUE,LEN(I2:I41)>0,0))

Luckily I can hide most of this but least its done and can be adapted to the other based values and lists I have.
Thank you guys again your a wealth of knowledge, and of course if you know a better cleaner way by all means I bow to you, but for now I at least was able to get it done!