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

The Pit # column was formatted into a 4 digit number to maintain the leading zeros (all pit numbers are 4 digit numbers). However the data needs to be manipulated to combine columns pit number and pit name (as seen in A32 on SA1 workbook). Is there an easy way to convert pit number column into text while maintaining the leading zeros?
Solved by T. C. in 25 mins
Trying to populate a column in Excel via VLOOKUP but not generating
Solved by Z. B. in 21 mins
I need to sort one column with text based information based off the sorting of a column with values
Solved by I. A. in 16 mins
I am trying to see if the items in column A are also included in column B.
Solved by A. U. in 12 mins
Calculating 10% then reducing a column of numbers by that calculated number
Solved by D. A. in 29 mins
I need to take the amount due from subtotal column then multiply by .1 which is 10% then divide by 12 to get the interest due per month. Then multiply by the number of months then add to subtotal to get the total due.
Solved by T. J. in 25 mins
need help suming certain data from a particular column.
Solved by E. U. in 18 mins
I would like column E2 to sumif based on the sales rep in column D and the date range in Column A based on date in Column C
Solved by O. E. in 20 mins
Im trying to make a formula stating if a cell within A:A equals a date in january AND if a cell in column E:E equals "X" ,count.
Solved by S. J. in 11 mins
I have a data with 4 columns I want to put two conditions on two different columns( Column1 and column2) and if this both conditions met then need their corresponding columns(column 3& column 4) values. using excel functions only (not using sort&filter tab) is there any way to do? enter image description here IF in column1( BAC US ) and in column2(B) it should give 444 in c3 and 9.825 in c4 same for 4th row
Solved by G. U. in 22 mins