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!”

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

excel formula to calculate if any in this column equal x then add the corresponding row value in column y together.
Solved by F. C. in 22 mins
excel formula to calculate if any values in column z equal x then add the values in corresponding row from column y together
Solved by E. E. in 19 mins
this is a Google Sheet assignment. I have multiple sheets. One master sheet called team alpha. This is a project planning sheet. I can assign tasks to different team members. When I assign the task, the task (row) copies into their own sheet - for example madsejstrup. The idea is, that the participant in his own sheet adds the amount of hours spend on the task. They do this from column Q to KJ. The numbers automatically accumulate in column P. The value here, has to be copied to the master doc called teamalpha - some of them in K, others in L, or in M. This has to be scripted. Is there someone who can do this for me?
Solved by B. J. in 20 mins
I have a macro enabled excel file I created for my company. Essentially, it's a huge dump of all parts our company handles and the plan for those parts (PFEP - Plan For Every Part). I programmed 8 macro buttons that, when a part number cell is selected and a button is pressed, it automatically parses all information for that part into a hidden sheet containing a label template, then auto-prints that sheet and rehides it. In our part list, there are multiples of part numbers (for the purpose that we use that specific part at multiple locations - need different plans for them). Right now it is set up so that when one of the duplicates is selected, it only gives the location information for the first part it finds on the way down. It would be really convenient (for those who didn't participate in creating this document) if there was a way it could grab, word-wrap, and concatinate the locations for all duplicates listed into that one cell. I have pictures of file and code for an example sub in vba, and a copy of file ready on hand I could share for a reference for you. Thanks for your help! Basically where it says "1.2 CS" in the picture uploaded, it needs to list all locations. not just the one for in that row selected. I have more pictures. File size limit restricts uploading spreadsheet.
Solved by A. A. in 29 mins
Write a formulas if cell is less than 100, copy entire row on summary sheet - I'm building an open items task list off my gantt worksheets.
Solved by T. L. in 26 mins
I would like to be able to enter a move out date and the entire row for that cell to change color, indicating completion.
Solved by V. C. in 25 mins
Given "2012-August", "2012-January", "2012-May", etc., I need to find out how to (in another row) calculate which month an order occurred in
Solved by O. S. in 16 mins
I need to know which items occurs the most in each row.
Solved by E. W. in 25 mins
This sheet has a list of songs, with a unique identifier labeled ISRC. I'd like to create a deduplicated list of unique songs, with a field on each row that counts the instances of each unique ISRC in the original list. The timestamp field is irrelevant.
Solved by Z. J. in 20 mins
I crearted a spreadsheet and although it looks good in the Preview, it reduces the row height on some of the rows when I print it. I tried Auto Fit but that didn't fix it. Thank you in advance.
Solved by V. W. in 23 mins