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

using vlookup, look at the values in column C and Column K and if a match is found, pull match adjacent info from Column J and place the value in column D
Solved by E. E. in 19 mins
I am looking to return a list of data based on an amount of times a value is returned in a column. I then am looking to return that in a different tab. So if a person's name is in Column C of Full List tab, then return a list of names that are also in Column A of Full List tab. Display this in List per CM tab in rows 5 and below. The person's name will be listed in row 2 of List per CM Tab.
Solved by G. D. in 22 mins
Hi, we have a file that has five separate columns that need to combined in one cell. They are each separate bullet points. We tried a formula but that all ended up being one long line of a few sentences. We want every single bullet point which is in a different column to be on a new line once we combine them with a formula. We did try to us enter in the formula but it didn't help. Please Advise Thanks
Solved by K. J. in 15 mins
I have 2 collum. the first column says 100,000 and the second collum says 100. so I want the 3rd collum should say how much % is collum 2 from the first collum
Solved by O. J. in 13 mins
I need to find which 1-3 entries from the DR column added together subtracting the sum of 1-3 CR columns added together will match $0.85.
Solved by A. J. in 28 mins
I need column J through O to count the # of instances of a certain product in column H.
Solved by F. F. in 23 mins
Hello - I am having some trouble with merged cells. In column G I want to delete rows with two merged cells but retain those rows where three or more cells have been merged.
Solved by S. F. in 28 mins
Hi. This is quite hard to explain but hopefully the document will help! I have a s/sheet looking at a five year replacement plan for their PCs. I have a list of Locations (Labs) in a uni that contains the number of machines, how much it will cost to replace and a year that (1-5). At the moment they were populated manually. But if they decide they want to change, for example Lab B from the first year to the 3rd, it then needs to be done manually. What I'd like to be able to do, is, if the year is changed in column E, then the boxes / fields to the right get updated. I know I can do this with multiple pivot tables, but know that it could also be done with formulas. In G5 for Year 1, I have used the Index and Match functions to return Lab B. I'm guessing I might need OFFSET, (which I don't know much about as yet) but before I went ahead and researched it all, thought I would ask. Current formula (in G5) here is: =INDEX($B:$B,MATCH(1,$E:$E,0)) Thank you.
Solved by I. U. in 23 mins
i have a table with tasks on the left column and the client names on the top. i would like to print one client at a time but need the descriptions along with the data.
Solved by S. Q. in 19 mins
I have a 2316 rows in a sheet with 5 relevant columns across. I need to extract all rows there the cell in column A contains a certain phrase. Should be looking at the third sheet titled "2316"
Solved by V. Y. in 18 mins