![]() |
#2
|
|||
|
|||
![]()
Why do you need 2 columns for "Del" and "ADD"?
When for every row you use only one, then those values can be in same column. When you are using both of them in same row, then taking into account they add and delete 1, which results in no change at all, so you can left both of those sells empty with exactly same result. And use tables for data entry - enter table header at top, and data into according rows below header row. This helps you to keep your data organized, and when you look at then after a couple of months later, you'll know what it is about. An even more advanced approach is to define the data organized in this way as a Table. Then you can use Table syntax formulas, which are expanding automatically whenever you enter new data into defined Table. Another advice is never enter any initializing values (1000 in your example) directly into table. This can mess up with your formulas, and this isn't obvious at first glance, from where this value is gotten. Added is an example! |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reliable way to convert text to number with a formula | levraininjaneer | Excel | 8 | 12-22-2019 04:47 PM |
Formula to populate column with text prefix then next number (ascending) | SerenityNetworks | Excel | 4 | 02-05-2019 07:22 AM |
VBA to deal with Open/Replace/Save as Text file .txt | nouking | Excel Programming | 1 | 09-12-2017 12:00 AM |
Number and Text Formula Trouble Shooting | Haha88 | Excel | 1 | 12-06-2016 11:25 PM |
![]() |
Offrddrver | Excel | 4 | 03-23-2016 11:32 PM |