Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 02-08-2021, 01:34 AM
ArviLaanemets ArviLaanemets is offline Formula to deal with Number and Text Fields. Windows 8 Formula to deal with Number and Text Fields. Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

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!
Attached Files
File Type: xlsx CountingTableExample.xlsx (12.6 KB, 9 views)
Reply With Quote
 



Similar Threads
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
Formula to deal with Number and Text Fields. Formula, Compare two cell's text and based on results output a number Offrddrver Excel 4 03-23-2016 11:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:53 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft