# 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

After a selection is made from my drop down list, I would like that choice to not be available in the next row.
Solved by B. J. in 28 mins
Hello, I want to create a formula where: If (AND) 3 cells in the same row are less than 3 specifics numbers then it will show 100 If Else (AND) 3 cells in the same row are less than 3 specifics numbers then it will show 80 60 40 20
Solved by E. D. in 27 mins
Hello, I would like to know how to set up a formula to "look for a given row and pick up the last cell value and copy it to a another nominated cell". Could you please help with this request?
Solved by G. D. in 16 mins
I have a Master drawing list that I made in excel. I need to separate it into discipline lists so I can link it into AutoCAD. The problem is that when I insert a new row into the MasterList tab the new row doesn't appear in the Mech LIST tab. I tried Pivot Table but I couldn't get it to work. I just need Column A and B. The rest of the table will used for another list.
Solved by X. W. in 18 mins
use of solver To best match the group with meeting room, each group listed their preferences from 1 (the most desirable) to 10 (the least desirable). Your job is to allocate the rooms so the sum of the preference scores is minimised but also ensuring that each group receives no worse than their 6th best choice. Two groups have specific needs and have requested a particular room – ProjD Investigation needs to use the Velocity Room, and External: Open Data Meetup needs to use the Refactor Room. To complete this task, you should use Solver. The sheet you have for this contains two tables. The first table indicates each group’s preferences for the ten meeting rooms. The second table indicates the assignment of the room to the group. A value of 1 in the table indicates that the meeting room has been assigned to the client. A value of 0 indicates that the room has not been assigned. Only one meeting room can be assigned to each group and each group can only reserve one room; this each row and column of the table will have one cell containing the value 1 and the rest of the cells will contain the value 0. The values in the preference value column should be no greater than 6 indicating each group will receive no worse than their 6th best choice. The preference total cell is the sum of these scores.
Solved by S. C. in 27 mins
Hi, I made up a job list with a montly calendar from a template and an annual calendar. My job list is automaticly inserted in both calendars with an index. I would like to had a frequency to my calendar. In other words, I would like to make a job happen every X week. I added the row in my pivot table, but I can't figure it out how to make it to my calendar. Thanks
Solved by V. S. in 21 mins
I have 6 total worksheets with all the same columns of information. one of the worksheets is labeled MASTER. I would like all the other 5 worksheets to automatically add rows to the master as i had to the other individual worksheets. and i would like them to add chronologically in to the master. for example if i add a row to the Carrollton tab and then add two rows to the Greenville tab i would like them to automatically add to the master in that order. Also i have them color codded and would like the color of the cell to also transfer over to the MASTER tab. Thank you in advance!
Solved by K. H. in 21 mins
I've created an excel file to calculate pricing for picture framing. What I would like to do is create a button which would copy selected cells (customer name and email address) and paste this in to a new row on a new spreadsheet (or to a text file or whatever is easiest) to allow us to collate customer emails. I would also want to do something similar with the moulding ID and lengths needed from sheet2)
Solved by D. D. in 28 mins
I am trying to remove duplicates in column A and add the data from the duplicates in column B and compress it all into one row.
Solved by K. H. in 12 mins
Hi there, I'd like to be able to paste the values from one column in a worksheet to a set group of cell in another. In this instance, I have a column of 27 cells in sheet 1, and I'd like to paste one cell every 27th row in teh data tab. So, the value in Sheet1 - A1 would paste to Data tab - E3, Sheet1 - A2 would paste to Data -E29 etc.
Solved by O. Q. in 17 mins