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
submitted sheet have one of sheet.is name is QAD inspection sheet. Date of Last replacement is one machines parts replacement details enter columns. its dates came from Replacements of the Canvass sheet. that sheet maintaining by manually..The formulas in Date of last replacement columns created by some got it friend..I need it simplify and explaining it how they created..ok
Solved by X. L. in 30 mins
I need help fixing a spreadsheet with mismatched data and repeated names in the columns.
Solved by X. U. in 16 mins
I need that in cell K5 look at the number that appears in K4 and throw back that number of columns. For example, if K4 says the number 4, subtract 4 columns and put the value of G2.
Solved by D. W. in 24 mins
I need columns to populate based on information for a specific series
Solved by Z. C. in 14 mins
Is it possible to clean data in columns that contains e-mails and other data, so that only e-mails remain?
Solved by I. J. in 15 mins
how can calculate 3 type of value(example A,B,C shift) shown in columns with time range(Example 07:00 AM to 15:00PM with A shift, 15:00PM to 23:00PM with B shift & 23:00PM to 07:00AM with A shift
Solved by S. B. in 21 mins
My columns have always been shown as letters (A, B, C....) while the rows are numbers. However, now the columns are shown as numbers as well. This creates havoc with cell addresses in links, which I rely on heavily. I'm sure I've hit a wrong button(s) by accident, but don't know how to reverse it. Thanks for any help you can offer....Scott.
Solved by K. J. in 26 mins
Not able to delete Pivot table using office interop plugin. Receiving the following error when trying to change pivot cache . "The PivotTable field name is not valid. To create a PivotTable report, you must use data that is organized as a list with labeled columns. If you are changing the name of a PivotTable field, you must type a new name for the field"
Solved by Z. S. in 25 mins
submitted sheet have one of sheet.Its name is QAD inspection sheet. Date of Last replacement is one machines parts( Call Canvass) replacement details enter columns. its dates came from Replacements of the Canvass sheet. that sheet maintaining by manually..The formulas in Date of last replacement columns created by some got it friend..I need it simplify and explaining it how they created..ok
Solved by Z. W. in 19 mins
trying to break down a list by values using countif, also trying to use countif to separate non-numerical values ( i.e. car makes), is that possible? also how do I take those result and break them from a list of 120 values into their own columns? thanks
Solved by Z. J. in 12 mins