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

Please seperate customer name and number into its own row
Solved by E. E. in 22 mins
I am trying to move the item numbers in column P to Row 1. For example.... P8 to P1, P9 to Q1, P10 to R1.. etc..... is there an easier way to do this other than copy and paste?
Solved by M. J. in 20 mins
Im trying to write in vba ( And failing badly) code that searches (row by row) in column F, for 10 specific phrases ( not all of them will be present) and then return a true or false, If True is found it then needs to go the correct row on a different sheet, and the in a set column colour the corresponding cell.
Solved by C. Q. in 22 mins
I would like to make it so that when I select any given cell That Excel Highlights the entire row that cell is in? Is this possible?
Solved by O. E. in 30 mins
I'm using the clipboard to copy and paste multiple selected rows. When I go to paste the rows the empty cells in the row disappear, wrecking my format and columns.
Solved by F. C. in 27 mins
looking to find 3 formula's, 1) colum C =average across several fields within that row D to W excluding R and U.(all cells contain only 1 letter - either I,L,U or O). 2) auto format a cell depending on the contents from 2 other (all text) Cell1 = Colum C, cell2= Colum S and cell3 = Colum X cell1= o cell2=o auto format cell3=Q cell1=o cell2=u auto format cell3=c cell1=u cell2=o auto format cell3=c any blank cell or containing I or L then auto format cell3 = Blank 3) the newly created auto format cell3 (Q or C) auto populates to a single cell on an other worksheet within the same workbook. populate to relevant filed (with same name) in RRF worksheet
Solved by F. C. in 30 mins
I would like to know a formula for adding up the number of entries in a row of cells. The cells may contain two entries. For example Cell 26 has 1 entry, Cell 27 has 1, Cell 28 has 2, Cell 29 has 2. Cell 31 has the Total of the entries, in this example, of 6. What would the formula read?
Solved by T. F. in 28 mins
I am trying to take a master list of employee information and break it down in to other spread sheets. I need to break it down based on information in one of two columns, by department - column F and by job title column E. I have tried numerous macros and looking up coding online with not luck. I keep getting errors or it simply doesn't do anything. Should the cell in column F say ATS or ATS/CSS I need that row to be automatically updated in the ATS sheet. Should it say ATS/CSS or CSS I need that row to be updated in the CSS sheet. For column E I need RSS to auto update the RSS sheet, RN - RN sheet, LPN - LPN sheet, and so on. I would like to make a code that will allow me to update the master sheet and automatically update the subsheets. Due to the nature of this information I had to remove most of the document but left enough information for assistance.
Solved by D. E. in 27 mins
I want to create a sheet where the cell sizes are more consistant and easy to read. My google sheet is all jumbled up and every cell and row is in a different size.
Solved by O. H. in 23 mins
After i had choose "AB12/AB08 WHITE HIGH VOLTAGE" in the column I, there are only left four row of data. I want to sort the data by date in Column O. (either new to old, or old to new). However, come out with "Operation require the merged cells to be identically size". I had do some research online but there are only suitable for fixed data(no add data anymore.) Since I need to add more data in the lower row, I need to find a easier ways to settle this. Are there any solution? Thanks for your help
Solved by Z. F. in 17 mins