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 am looking to take a excel spreadsheet and if a row doesn't have a duplicate then it red lines it
Solved by I. H. in 14 mins
Automatticaly copy row from Sheet1 to another sheet if cell in certain column from Sheet1 has specific conditional formatting.
Solved by X. L. in 15 mins
I have a row of cells A1 to BL36 (these are all o or a 1, In the next row2 I need a formula that will put in the values 1 to 6 with 1 being where the 1 appears in row 1 and after the 6 is reached it returns zero's or N/A's again
Solved by X. C. in 22 mins
sheet two I need the tip totals at row 22 and column j
Solved by S. Q. in 16 mins
I have two sets of data. One is Projected (Estimates or future data) and one is actual. So what the projected data (in row 16) to come to actual data (in row 43) once the date is in past.
Solved by O. H. in 29 mins
Column B has member introducer list and column F has member list, result require in column J to U as given in excel sheet.
- From Column F need to search member ID in Column B how many times member ID has been used the data in same row in column F need to bring output in Row as given.. hop i tried to explain
Solved by E. Y. in 15 mins
I need to fixed a formula that has been working in the past. Row 17 and 44 in PROJECTED REPORT
Solved by S. H. in 22 mins
Using VB Excel, you will create two new columns- Average Delay and Efficiency. Average Delay is the average of the arrival delay and departure delay, and efficiency column will classify each row as efficient or inefficient. If a flight has more than 14 minutes of “average delay” then classify it as inefficient or else efficient. A command button (named Add Columns) should be used to populate the values of these two columns.
Solved by M. S. in 13 mins
Hi, when I click on a row the row below it gets highlighted instead.
Solved by G. Y. in 11 mins
I have a large spreadsheet with contacts of Real Estate Agents. Each Contact has 3 ROWS of data that need to be MERGED into ONE ROW. I have created open COLUMNS to allow for Data to be MOVED FROM ROWS 2 AND 3 TO ROW ONE so that all information for each Real Estate Agent is on a SINGLE ROW. I have COLOR CODED where CELLS SHOULD MOVE for a reference point. At the completion of the MERGE there will be TWO EMPTY ROWS between EACH Real Estate Agent Contact that will need to be deleted.
Solved by G. J. in 27 mins