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!”
Here are some problems that our users have asked and received explanations on
I am trying to move the item numbers in column P to Row 1. For example.... P8 to P1, P9 to Q1, P10 to R1.. etc..... is there an easier way to do this other than copy and paste?
Solved by M. J. in 20 mins
I have a sheet that is Column A-F. I have an amount in column E that I want to be hidden until a number is entered in column C
Solved by E. E. in 19 mins
in the commission worksheet, i am trying to create a one variable data table excel using cells a4:b14 to determine how much that commission may be. the column input cell is a4.
Solved by O. B. in 15 mins
In the status column there are multiple statuses separated by a line break. I want column C to populate with the status that happens the most for each cell in column B. For example, of a cell in column B says Spam Spam Spam Incorrect Subject Tag Spam, then I want the next cell in column C to say Spam only because that status occured the most.
Solved by X. U. in 12 mins
need to find values in sheet1 for columns D, E F from sheet2. There are no unique values. Need to lookup using column B and column C from sheet1 and match with sheet2.
Solved by S. B. in 28 mins
I want to have a drop down list in a column populate a list of employees from a different table based on the column adjacent the first column. The first table has these columns: Project name, Team, Assignments, and so on. The second table has People and Team. I want the list to grab only the people that exist in the team as specified on the first table.
Solved by X. B. in 18 mins
I have a directory in excel with AD column for university. I want show the location of the university in column AE . I have a separate Tab with a list of universities (column A) and locations (column B). What is the correct formula? I think it is an If function.
Solved by S. S. in 16 mins
How to create a name lookup for the spreadsheet. On my worksheet column g has the first name and Column h has there last name. How can I reference it to my main sick report worksheet in column A
Solved by O. J. in 29 mins
Im trying to find a formula that updates the TOTAL TIME (column E) in a more efficient way!
Solved by E. H. in 28 mins
I have 3 columns of information. How do I sort to put into alpha order so the adjacent columns move appropriately with the first column's name
Solved by C. E. in 26 mins