2 Issues: Excel unable to delete columns & Excel IF Function

Question

I have 2 issues that I can't seem to figure out.

Issue 1: Excel Unable to Delete Columns

Details: I've removed details from a table and the different rows in that table that don't have information in them are still colored by row. I saw a recent video that describes how to make information into a table but that isn't helping me with removing those columns. I keep trying to remove them and it won't even give me the delete option.

Issue 2: Excel IF Function

Details: I'm trying to figure out a formula. Basically, For each person, there are 3 columns that i'm tracking as a yes/no kind of thing they are getting. I wanted to just put in an "X" in the box if they are getting and leave it empty if they aren't. The 4th column I want to look at the first 3 and if it sees 1 "X", it displays 33% in this 4th box. If it sees 2 "Xs" from 2 columns, it should display 66% in that 4th box, and if all 3 have an "X", it should say 100%. I'm not sure why no matter what formula, if function, array, or count formula it won't work. This is just a specific question, I can't seem to find the answer online either....Please help. Thanks

Answer 1

Hello,

to delete a column in a spreadsheet, right-click the column heading, where you see the column letter. This should open a context menu where you see the "Delete" command. If the delete command is grayed out, the worksheet may be protected and you need to unprotect it first via Review ribbon > Unprotect Sheet.

For the formula:

=COUNTA(A1:C1)*0.333333

Format the result as percentage. Note that due to rounding it will probably show 67% than 66%.

Answer 2

Take the delete issue to a new question. You have merged cells, which pose all kinds of problems. 

The #Ref! error means the formula is referring to a cell that does not exist. 

To rename a table, select a cell in the table and click into the Table Tools ribbon. The name of the table can be edited in a text box at the very left of that ribbon. 

From now on, please try to stick to one issue per question. Otherwise it's hard to mark a question as solved.

Answer 3

Hi April,

As the formula question is answered, you may post a new thread for the "cannot delete issue". So, community members and our engineers can focus on that issue with you in the new thread. It will also help users who have the same formula question find answer in this thread easier.

Thanks for your understanding.

Tim