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 have a conditional formatting that is =LEN($W$2:$W$24)<15 , what I'm trying to do is highlight those cells that have more than 15 characters which could be text or numbers. Help the formula above highlight in excel.
Solved by K. S. in 14 mins
I want the first 4 digits of column AC, AD and M to match. if not highlight all three cells in red if not matching. (note: first 4 digits only)
Solved by E. Q. in 12 mins
need to create if formula for values in column A to multiply column h and produce result in column I
example
if ($A$2:$A$244=5, $H2:$H$244*65)
Solved by V. E. in 24 mins
yesterday i was told to use a formula =2&right(a1,6) to create number sequence from 1.12.13 to 2.13.14 basically creating same list from left to the next column on the right . i was wondering if you could explain how the sequence of numbers is created using all 2's .
Solved by V. U. in 29 mins
WE HAVE A SORT FUNCTION IN A CELL FOR A COLUMN THIS FUNCTION WORKS ON MULTIPLE COMPUTERS BUT NOT ON 1 COMPUTER
Solved by F. J. in 27 mins
I would like to add my inventor total into one column and total them up based on each product name
Solved by T. S. in 26 mins
Currently the formula is populated by a trigger from Zapier. I'm trying to copy a formula currently sat in C2 to be applicable to all of column C when new information is entered. I know I need to use an Array formula however unsure of the syntax. Currently the formula in there pulls the email address only from Column B
Solved by V. J. in 14 mins
I would like to highlight cells that are past their arrival date. The highlighted cell will be in a different column so i am not very sure how to make a formula in the following column for when it is past due.
Solved by X. W. in 29 mins
in column a i want to input 1 2, 1 3, and then drag down to get 1 4, 1 5, 1 6,,.....and so on. I want to do the same for 2 3, 2 4.
Solved by Z. C. in 27 mins
This may be an issue with Excel 2016 that's not fixable right now, but I'm very frustrated with a deadline.
I can't print my excel worksheet on one page. I know how to use print area, printer tools like print all columns on one page and I've tried dozens of tricks. The print preview on the print tab always looks fine, but it always defaults to "100%" size. I say that in quotes because I have no idea why the supposed 100% size should be so many inches long; I've checked column sizes and it doesn't add up.
Solved by F. A. in 24 mins