Get instant live Excel expert help with COLUMNS Function

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

We interviewed four people and asked them to identify in 7 fields what their favourite food was. We imported the data from our survey into excel. In our spreadsheet he names of the people were listed in the first column and 7 columns to the right identified their favourite food in each of the seven columns. We would like to know how many times cake, cookies, and other identified foods showed up in our survey.
Solved by Z. H. in 11 mins
I need a formula that will check the position (B1) and if this position is found on the range (C17:C36), it types the players name on "B2", "B3", etc., ordering by pick. For example Column D (TE) must show Engram (D2), Njoku (D3) Legget (D4). Is that possible ?
Solved by X. Q. in 26 mins
I have an issue with a formula. I have cells 65:68 in columns D and E, the sum of D needs to subtract the sum of E. Sometimes column D is blank. My formula isn't working =If((OR(D65:D68="")),sum(e65:e68),if(sum(d65:d68>0),sum(d65:d68)-sum(e65:e68))) cell R17
Solved by F. Q. in 22 mins
Hi - I need to maximize installs while staying within a $3,500,000 budget. In other words, I need to find the highest sum of a combination of cells in column F while the sum of the cells in the same row in column G is less than $3,500,000
Solved by D. E. in 16 mins
I'm stuck. I need a formula that will find the contents of cell A! in sheet1 in column C of sheet 2. If there's match then put in the contents of column A of the same row, into A3 on sheet1. Then to do the same for column B on sheet 1. Etc.
Solved by C. U. in 14 mins
I am a novice to Macros and I am coming up against a problem that has been troubling me for weeks. I require a macro that will read column a on multiple tabs, of my choosing, and from A2 downwards. Then return the unique text from those cells to a "master tab" in column A from a2 downwards. When the macro runs it should only clear the data in "master tab" from cells A2 down and not all the data, neither should it create a new tab. Not sure this makes sense, I have found multiple ways of merging the data by deleting and recreating the "master tab" but I have formulas in the rest of the sheet so this cannot happen. I have attached something in its simplest format as my workbook is far too big to up load and quite sensitive too. You help is appreciated! Regards Lost Soul
Solved by I. W. in 13 mins
i need to check one cell if it is not null and has a certain format, ov12345 - if not, it should be shipped and go to the next cell in the same column, D(x+1). if ok, I need cell Ax to be populated with that value written between '', simple quotes, and if the next cell of the same column, D(x+1) is not null, then it has to be followed by , (comma). increase the cell row number D(x+1) until I hit a cell with null content. can you help? thank you very much!
Solved by E. H. in 12 mins
I am trying to work how I can create a conditional formatting on a selected cell when a previous cell has been selected as a certain icon in a list. For Example: When I select my category 'RTW' from the choices in my list in column B, I want it to pick up on column C if I have not entered the right amount of figures in the cell (it needs to be exactly 12 digits). If it is incorrect I need it to highlight red.
Solved by M. H. in 27 mins
I have a database which has been competed vertically and I am trying to turn it into a horizontal one. I need to copy details and then delete them once information is in the correct column. I thougt I had resolved it, but when I deleted the origianl information, it deleted it from the new cell as well.
Solved by M. L. in 21 mins
I am trying to use the vlookup and or match /index formula on sheet two to get the code column filled out using the company name and city as a criteria and keep getting an error. Can you please help
Solved by T. Q. in 20 mins