You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Convert List of Numbers into Contiguous Range- A Range Maker Excel Tool

in General Ledger & Intercompany 1 comment

In Oracle Cloud ERP Financials, there are several use cases where an implementation consultant is required to convert list of numbers to range. Below are some use cases:

  • Cross Validation Rules setup- ADFDI/ FBDI
  • COA Values Hierarchies setup (range- based)
  • Analyze gaps in list of values e.g. find missing values etc.

I have built an MS Excel tool to easily convert list of numbers to range with adjustable gaps between any two values. Please use this tool and provide feedback/comment on this tool, if any. 🙂

Click here to download👇

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!