|
|
|
|
#1
03-28-2018, 06:33 AM
|
|||
|
|||
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. 
|
|
#2
04-02-2018, 02:31 AM
|
|||
|
|||
Quote:
  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"
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Create Drop Down list to change cell color | bksmith | Excel | 2 | 08-21-2017 02:37 AM |
| Have a cell filled black when blank in dropdown list | Aussie_81 | Excel | 14 | 04-06-2017 04:50 AM |
 Formulato say if cell is blank do this, if not blank do this.
|
mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
| Auto add a list cell if the last list cell is filled | tasuooooo | Excel | 1 | 07-31-2012 08:40 PM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows 8 
Office 2016
Hybrid Mode