I have a column of numbers. I want an automated way to generate a new column of numbers based on that existing column. Here is how i want the conversion to take place:
If the value is $450 - $499.99, I want it to just copy the value (keep it the same). Same thing (just copy) if the value is $950- $999.99, $1450- $1499.99, $1950-$1999.99, $2450-$2499.99, $2950-$2999.99, $3450- $3499.99, $[url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], 6950-6999.99.
If the value is $500 - $550, I want it put a value of 500. Same thing (round down to nearest multiple of 50) if the value is $1000-1050, $1500- $1550, $2000-2050, $2500-2550, $3000-3050, $3500- $3550,
Then, switch gears a little bit: $4000-4075 (note that the increment is changing from this point forward to 75 "unit" ranges), 4500-4575 , 5000-5075, 5500-5575, 6000-6075, 6500- 6575, 7000-7075.
Hello, I can do this tonight if you'd like. I don't know if you would like just a new worksheet or to modify one of your existing but I can do either.
9 freelancers are bidding on average $25 for this job
Dear sir. I can complete your requirement, please check my win projects and their reviews. [url removed, login to view] Waiting for your reply. Thank you
Hi, I am available 5 days a week and 9-10 hrs in a day and have good internet speed as well as typing of 55 wpm. I am working as a data analysts. Looking for a project, Durga
100% job satisfaction. i am expert in excel i am doing this work since 2011 on diffrent site. I know the time is so important, i will do my work in time. payment after work. thanks let discuss it in pv
I am a Computer Science and Engineering student who is good with Ms Office package. Also I hold a Microsoft Office Certificate. I hope I would be the best candidate for this project. Thank you.
Hello I do understand how you want the new column to be generated. Using my Excel skills , I can accomplish this task for you within a day. I am available for any talks. Thank you.