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
Spreadsheet previously modified by Got It Pro.
Rows 1 - 11,841 are correct.
I've color coded an EXAMPLE of how 3 ROWS for EACH REAL ESTATE CONTACT Need to ALL MERGE INTO ROW 1 of 3. This will require Formulas and Mapping Fields as done before by a PREVIOUS TECH. LOOK at ROWS 11,843 - 11,848 to see the COLOR CODED EXAMPLE. Then MODIFY THE SPREADSHEET and DELETE ALL ROWS THAT are now EMPTY because the ROWS have been CONSOLIDATED FROM 3 TO 1.
Solved by E. E. in 26 mins
sheet three I need a row where it says "hourly rate" and I need the hourly tip rate calculation for each day. I think two of the total rows currently do the same function so feel free to use one of those
Solved by E. J. in 22 mins
Please help with column j on sheet 3.
I need each row to have the total for the week.
Each day I need the sheet to take the hourly rate multiplied by hours worked for that employee for the day and the total for all days would be column j
Solved by X. H. in 19 mins
For each row, I want to add the values in columns 3, 4 &5, and enter the result in column 6.
I also want to calculate a running total of the values in column 6 for each row and enter the result in column 7.
Solved by B. Y. in 22 mins
I need a formula to lookup values from each row in a specific column and paste into another set of cells if the matching criteria is met
Solved by K. H. in 12 mins
How can i get a particular cell to change colour once the row is completed?
Solved by K. F. in 29 mins
Hi, I would like to align to unalike lists by item code number. for example, a list from 0-1000 with all numbers and a second list to align but the second list has 500 item's not in a row
Solved by G. J. in 23 mins
I want to deduct L33 and L34 from L35 (highlighted row / green cells). Thank you for your assistance. Please see attached excel workbook. thanks.
Solved by C. F. in 21 mins
Sheet Tab "The Calculator"
Row 28 Column G
It seems to do the correct math but just displays "#####"
Can we remove row 26 and move row 27 & 29 up one?
I don't know how to do any excel stuff without messing everything up haha
Solved by G. F. in 11 mins
I am trying to list out how many weeks are in a list of dates, so that if there are two weeks, in a column there is "Week 1" in one row and "Week 2" on the next row.
Solved by A. U. in 22 mins