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

I'd like to be able to automatically update a formula so that it references a sheet in my workbook. I have attached an example on a much smaller scale. I use this document year to year so some projects don't need to be included every year and therefore get deleted. How can I reference my formula so that it takes that into account. For instance if I have projects numbers 1 thru 10 but then the following year I know longer need to include projects 2, 6 and 7. I then need to re-number my projects. On Summary sheet, can I have formulas in cells B through H that references only cells in Column A to get the appropriate sheet number
Solved by B. F. in 26 mins
I am trying to make a drop-down list for the Operator ID column that displays entries 1,2,3 and 4
Solved by O. F. in 14 mins
I am trying to create a validation rule in the Time Spent column that prevents any vale greater than 3 from being entered and create appropriate input and error messages
Solved by F. Y. in 13 mins
I'm trying to figure out a formula that lets me find the 3rd character of a number within a certain date range and then take the total count and divide it by the total piece count to give me a % which reflects onto another sheet in that workbook. The formula I am using to find the 3rd character is =SUMPRODUCT(--(MID(I18:I500,3,1)="9")) and =SUMPRODUCT(--(MID(I18:I499,3,1)="8")). Here are some pictures that might help. I need the 3rd character in column "I" to be totaled and then divided by the total piece count "B4" to get a percentage that is reflected on Sheet "PDC Dashboard" in B57, C57, etc based on the date range those pieces are in.
Solved by A. A. in 21 mins
I have a text file with lots of data separated by a comma, the issue is when I import it adds the data as a row rather than a column, so I basically need the data to be transposed before being added. Help!
Solved by Z. D. in 12 mins
Hey there. I can't find a easy way to generate a pivot table exactly as i want to see it. I might need some calculated column but i'm never used this feature and i'm not sure.
Solved by M. Y. in 21 mins
Look at Column i it won't pull up the value. Please help. The excel sheet and the google sheet are essentially the same. I prefer excel but i included both
Solved by O. J. in 26 mins
Need to fill multiple columns Red or Gray based on the value of another column.
Solved by C. J. in 12 mins
I need to fill columns B through J with either Red or Gray based on the value entered in Column A. Lines 11 through 14 on the spreadsheet have the logic for the color format. I got disconnected...
Solved by A. D. in 11 mins
Hello, I have try to add the Gross Earnings from my Excel sheet as column in Pivot table, but the totals are false, the sum is not made correctly. I don't understand why. Thanks,
Solved by Z. Y. in 15 mins