Quote:
Originally Posted by ArviLaanemets
I designed some additional sheets to demonstrate, how I would start with such task. Maybe you get some ideas.
In general - all data entry is done in tables. When you want to display it otherwise, you create a report. P.e. your sheet 2017 would be something like ReportProjectsYearly, where you select a year number, and all projects active in selected year are displayed. Having data entry in tables makes writing formulas much easier.
|
I got totally confused ...
I was hoping that I can get something easy such as the attached file TEST
I found these equations which I feel they might work for me somehow if modified by experts....
If you fill up Column A even with leaving blank cell it reflects in order in Column C with No Blanks ...
Is there a way to modify my first request with this method in file attached "TEST"