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

Im trying to write in vba ( And failing badly) code that searches (row by row) in column F, for 10 specific phrases ( not all of them will be present) and then return a true or false, If True is found it then needs to go the correct row on a different sheet, and the in a set column colour the corresponding cell.
Solved by C. Q. in 22 mins
I need help with formula in column L please. My intent is that if cell H is blank, then return the value in cell G, if false return nothing.
Solved by F. F. in 19 mins
Separate customer name email and number into its own column
Solved by D. H. in 17 mins
Please separate for me all the numbers and email into their own column it will save me alot of time so please please just do it for me :)
Solved by K. L. in 19 mins
Please separate email and phone number into its own column all the way down. I have had 2 people now not complete it can you please :)
Solved by E. L. in 18 mins
I am creating a spread sheet that will have a column that will have the drop down of yes and no in the next column to the right of this option I want it to auto add. example would be if yes answer is chosen I would want to have 165.00 put in the cell to the right of the answer if no is chosen then it would be a zero. how can I accomplish this?
Solved by F. A. in 27 mins
I have a data series in column of dates and counts. Not all dates have a count. I want to populate/fill in the series with the dates without a count so i can easily aggregate the data by week/month, etc. How can I do this?
Solved by F. W. in 26 mins
I need help. I have a few sheets. I need data from sheet 1 E3 to automatically update on sheet 2. ( Summary Sheet) I have an excel drop down calendar on sheet 1, E1 When May is selected in E1 I need the data is E3 to update on Sheet 2 in the corresponding month column. This is a running summary.
Solved by I. E. in 25 mins
I have a array with three columns and 38 rows. Column 1 has the holes of a golf tournament. (01A, 01B,02A, 02B, etc. through 18B) Column 2 is for the Golfers names and Column 3 the scores. Using VBA I what to search for a hole number and post a score in the third column. I have created a UserForm and ListBoxes to capture golfers names and and the Starting Hole numbers. The uses selects the starting hole number for ListBox1 and the Golfers Name from ListBox2. That codes is done, now I want to use that information to populate the array .I have tired VlookUp to find the Starting hole and locate the cell that I want to enter the Golfer but I haven't found a way to used all that to get the name in the array. Thanking y9ou in advance for any help you can offer.
Solved by A. U. in 11 mins
For the first time, I am using a formula that is about dates. I want a column that calculates the number of days (aging) that have passed between the theoretical "today" and the date a request for quote was received. But here is where the problem comes in. I have another column labeled "quote date". Once that column is filled out, I would like the "aging" to stop counting and instead of looking at "today" look at the "Quote Date" and subtract the "Quote Received" to come up with our turnaround time.
Solved by X. J. in 12 mins