# 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

SPREADSHEET SOFTWARE USED: Microsoft Excel 97-2004 (.xls) MY QUESTION IS ABOUT: IF STATEMENT DESCRIPTION: 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 V. S. in 21 mins
Trying to open an excel document I didn't know had issues as it has saved fine before. However now I get this error message appearing and the one tab that had the most work done on it is empty: "Replaced Part: /xl/worksheets/sheet7.xml part with XML error. Illegal qualified name character. Line 2, column 341633. Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)"
Solved by I. J. in 29 mins
I am trying to figure out the formula to use that would take the net price (column B) multiply it by 1.285 and then replace the final two digits with ".95". I want every list price to end in .95, but
Solved by B. Q. in 29 mins
Help! I can't figure out what I'm doing wrong! I need to check a column from worksheet 1 for specific text. If it is true, I need to copy the line of cells to worksheet 2
Solved by E. D. in 23 mins
Making a table for inventory: and its auto filling the whole column instead of just the cell
Solved by Z. B. in 20 mins
I have a 2 worksheet workbook. Sheet1 is the start. i want the data in columns "A" and "B" to copy and paste into columns "B" and "C" in the first available row on Sheet2 if "Yes" is entered into Column "F" in Sheet1. The macro should search all of Sheet1 and repeat the process until all occurrences of "Yes" are moved to Sheet2. The macro should also delete the entire row on Sheet1 is "No" is entered into column "F". Lastly, once the "Yes" data is copied to Sheet2 the row on Sheet1 should be deleted.
Solved by I. H. in 15 mins
I am trying to get a column of percentage (GRADES) using the COUNTIF function to excel count cells with value or text, then SUM only those cells. Here's the formula I have so far, but it is not working; =COUNTIFS(C8:C41,"<>"&"",F8:F41,"AVERAGE")
Solved by M. E. in 30 mins
I need a formula that will search column B for a given ID number and then find the most common text associated with that ID number that occurs in column E
Solved by K. D. in 28 mins
I'm making a spreadsheet for some pricing things for work. I wanted one column to be the price, the next column to be the quantity, and the third column to be the total price. Is there an easy way to accomplish this?
Solved by V. S. in 24 mins
In column S if there's data that is bring back the value of 0 (as opposed to it just being blank) would like to bring back a value such as "0 - revised qty". several cells are looked at to obtain that qty
Solved by D. W. in 28 mins