Forum Discussion
Excel
Jul 12, 2021Iron Contributor
Set in a whole number with the help of formulas
Hello Everyone,
if there are numbers in a column like [1, 2, 3, 23, 43, 54, 34 +1, 45 - 1, 42 *2 , 34, 98] how to make this a list of whole numbers or how do we calculate in between if there is a large dataset?
Please help..???
Here is a attach file..
It would be very complicated without VBA.
12 Replies
See the attached version (now a macro-enabled workbook since it contains a custom VBA function).
- ExcelIron ContributorSir, is this possible to solve only function?
- SergeiBaklanDiamond Contributor
Exactly the same if you define in name manager named function as
but the file also shall be saved as macro-enabled workbook.