QuestionBaker
Board Regular
- Joined
- Apr 12, 2019
- Messages
- 106
- Office Version
- 365
- Platform
- Windows
I wish to prepare Gannt chart from a sheet where bunch of projects are listed.
I am unable to find oldest date after filtering the relevant project.
I've tried min (K3 to N1770) (data is there till row 1770) but it gives an answer as Sep 2016, so I know I am making a mistake.
How do I find min and max in a filtered range
my data looks as follows
I am unable to find oldest date after filtering the relevant project.
I've tried min (K3 to N1770) (data is there till row 1770) but it gives an answer as Sep 2016, so I know I am making a mistake.
How do I find min and max in a filtered range
my data looks as follows