manipulate

I am looking for a formula that can manipulate a column of numbers to add up to 100.0% even though the actual sum is 99.9% Any assistance would be greatly appreciated. Thank you!

Hi, I want to manipulate the value in column 1 based on the adjacent column. Col-A Col-B 1 1 1 2 1 2 2 3 2 3 2 3 1 2 1 2 If you see last two value in col-B, this 2 report to 1 which is on the...

I am mired with Likert Data: 9, 3, 5, 4, 14. I can show a bar chart of the raw data: But I'd like to combine the Likes and Dislikes, without having to manipulate the data too much, if possible: And my Friday night brain has locked up. Help! Please.

I have a spreadsheet that shows information about each office location, the different departments in that department and various attributes about that department. Using this information, i need to create a table for each office location with each department as a row. There will be 4 required...

Hi all, I have a data set which is in a weird format whereby instead of names being in a column at the side of that person's relative data to make a flat database their names are in a row above their data much like a header. each name will have various rows of data below until the next name...