foranpower
New Member
- Joined
- Nov 4, 2019
- Messages
- 8
- Office Version
- 2021
- Platform
- Windows
based on this thread, vstack seems to be able to create a column of unique values in a date range:
The goal is highest total value and the champion of the person with the highest sum in the date range. So whoever knocks down the most pins during the competition.
Here Wilma would win because during March she had the most pins kocked down, and dino would not show up because he did not bowl during the month.
Tried this formula based on the other post, but get a #name error.
=TOCOL(IF((B2:B5>=E2)*(B2:B5<=F2)*(A2:A5<>""),A2:A5,1/0),3,1)
VSTACK values based on a selected date range
On sheet A I have columns containing names which are created using SPILL formulas. The header for each column is a date. 2/5/23 2/12/23 2/19/23 2/26/23 3/5/23 Petr Blincko Avram Lukas Erinna Fossord Juana Cater Forrest Spencers Myrle Cossar Ashlen Tremonte...
www.mrexcel.com
The goal is highest total value and the champion of the person with the highest sum in the date range. So whoever knocks down the most pins during the competition.
| date | pins | start date | end date | stacked unique names | total pins | |||
fred |
| 7 | 3/1/2024 | 3/29/2024 | wilma (if possible first named based on having the most bowling pins knocked down) | 9 = (5+4) | |||
wilma |
| 5 | fred | 7 | |||||
wilma |
| 4 | |||||||
dino |
| 3 | |||||||
Here Wilma would win because during March she had the most pins kocked down, and dino would not show up because he did not bowl during the month.
Tried this formula based on the other post, but get a #name error.
=TOCOL(IF((B2:B5>=E2)*(B2:B5<=F2)*(A2:A5<>""),A2:A5,1/0),3,1)