JMata806
New Member
- Joined
- May 26, 2021
- Messages
- 12
- Office Version
- 365
- 2019
- 2016
- 2013
- Platform
- Windows
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! ^_^
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! ^_^