J Dulan Posted September 19, 2019 Share Posted September 19, 2019 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 More sharing options...
Shashank Gurnalkar Posted September 19, 2019 Share Posted September 19, 2019 Hello, an example of your use case in a tabular format would help us to know your use case better. Link to comment Share on other sites More sharing options...
J Dulan Posted September 19, 2019 Author Share Posted September 19, 2019 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 More sharing options...
Kirsten Smith (she/her) Posted September 23, 2019 Share Posted September 23, 2019 How are you removing the numbers Blanking out that row Or creating a shorter column Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now