Jump to content

Calculated column

J Dulan

Recommended Posts

Using a list of 2 digit numbers in a single column of data, how can you create a new column of data whereby the Total Count of one number (ex: 33)is reduced by a specific percentage ( ex. 15%) The new column will need to include the reduced number (of 33's) all the other numbers from the original column for further calculations.
Link to comment
Share on other sites

The original data is one single column -  a list of thousands of random  2 digit numbers between  20 - 70.   


In that orgiinal list maybe there are 400 total count for the number 33. 


I want to reduce the total count of the '33's' by 15% and show the total count in the new column  - hear meaning the new column total count for '33' would be 340 along with the rest of the numbers from the orginal list for further calculations. 


 still need the tabluar file to help   

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...