I utilized the ROUND function for a total in cell D30. I have another cell referencing D30 in a formula and want it to reference the rounded number in D30 – it is only utilizing the tabulated number. How do I get my new formula to utilize the rounded number instead of the tabulated number?

By: Matt

I have an Excel bulk data, some of the rows including double data, I want to split that data into separate rows.