Forum Discussion

Iron Contributor

Jul 12, 2021

Solved

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 ...

Book1.xlsx14 KB

excel

Formulas and Functions

HansVogelaar
Jul 12, 2021
Excel

It would be very complicated without VBA.

HansVogelaar

MVP

Jul 12, 2021

Excel

See the attached version (now a macro-enabled workbook since it contains a custom VBA function).

Book1.xlsm13 KB

Excel
Iron Contributor
Jul 12, 2021
Sir, is this possible to solve only function?
- SergeiBaklan
  Diamond Contributor
  Jul 12, 2021
  Excel
  
  Exactly the same if you define in name manager named function as
  
  but the file also shall be saved as macro-enabled workbook.
- HansVogelaar
  MVP
  Jul 12, 2021
  Excel
  
  It would be very complicated without VBA.
  - Excel
    Iron Contributor
    Jul 12, 2021
    Ok, Thank you so much sir