Get instant live Excel expert help with ROW Functions
“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 file with items in every other column with a corresponding number in the cell to the immediate right of the item. I need to use something like a countif to add up the number of times each is mentioned per row. It would make more sense it I sent you my mock spreadsheet.
Solved by O. J. in 19 mins
I have uploaded a workbook that needs Column AA to be filled in the First sheet . The Column J breaks out into country and job profile so Every row + one is Job profile and the other is country needs to be filled Under Column AA.
Solved by M. Q. in 19 mins
I need a formula to combine a number that reoccurs on several rows together on one row
Solved by G. U. in 12 mins
I need to my row 1 print on every page Not sure why it changed
Solved by E. D. in 17 mins
I have an Excel file where I have added Data Validation to a column, I need that column to also have Drop Down in each row
Solved by Z. L. in 29 mins
I have multiple columns in my spreadsheet, each with a different drop down list. If I want to insert a row across the spreadsheet I am not able to do so. I am not able to insert a row across all of the columns with drop down lists, and I am not able to insert a cell in a single column with a drop down list. Can rows or cells not be added in the middle of a spreadsheet when drop down lists have been created?
Solved by G. J. in 13 mins
I need a formula for budgeting. Specifically, i put all my bills in different rows and summed them up at the bottom of the column they were in. I'm looking for a formula that states if I put in a "Y" in the next column for that bill on the same row indicating that yes it has been paid, that it subtracts the amount paid from the total amount. This will allow me to budget how money is left for other bills and other expenses.
Solved by D. C. in 25 mins
I need some help with a formula making sheet. I need to insert row functions on my worksheet.
Solved by D. C. in 23 mins
the Data worksheet:
a. Create an Excel table with the recently imported
data.
b. Pick a style with the styles group to format the table
(choose a style that shows banded rows, i.e., rows
that alternate between 2 colors).
c. The style must highlight the field names in the first
row. These are your table headers.
d. Ensure NO blank cells are part of the specified data
range.
e. Ensure that Header Row and Banded Rows are
selected in the Table Style Options Group Box. Do
NOT check the Total Row.
Solved by C. L. in 12 mins
Is there a way to have a row of data automatically move to another sheet within the same workbook if a specific criteria is met?
Solved by M. C. in 18 mins