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

I'm trying to fill data from once tab in a workbook to another. I would like to be able to drag to the right and have the ROW number increase incrementally but keep the column the same.
Solved by F. S. in 17 mins
I am trying to categorise some deliveries by drop 1 or drop 2. any item (row in excel) to the same postcode on the same day that are larger than 2 hours apart on the last scan need to be shown as a separate delivery (drop 2). I need help creating the "drop that day" column. many thanks
Solved by B. L. in 30 mins
How do I use an Excel function to derive the column’s value for each row based on different rules?
Solved by Z. L. in 17 mins
example is seperated by a blank row. I need the values in A and E transferred to every unique value in B & C. D is constant
Solved by B. H. in 16 mins
Sheet 1, Column A is blank. Sheet 1, Column B (B2 through B30450) has random school names. (Example: Breakfast Point School). Row 1 has headers. Sheet 2, Column A (A2 through A58) is filled with four-digit numbers (school numbers). Row 1 also has headers. Sheet 2, Column B is filled with school names (Bay High School, Breakfast Point School, etc.) I want Sheet 1, A2, to look for the correct school number in Sheet 2. How do I proceed?
Solved by E. A. in 20 mins
Hi I have a spread sheet, containing 2 sheets. On sheet 1, I have a column filled with text and numbers "BH140" for example. On sheet 2 I want to reference that cell so for example: Sheet2A2=Sheet1A2 I want to increment linearly every second row on sheet 2 for example: Sheet2A2=Sheet1A2 Sheet2A3=Sheet1A2 Sheet2A4=Sheet1A3 Sheet2A5=Sheet1A3 Can you please help me?
Solved by X. Y. in 29 mins
I have two Excel sheets, SHEETA and sheetB, in SHEETA I have a column A (Policy) which has more than one row of data (ERRORS)COLUMNC that belongs to the same policies, Now I want to copy all these errors in one cell in sheetB, where one of the column IN SHEETB has the same policy = sheetA column A E.G. Formula logic. IF COLUMN A OF SHEETA = COLUMNA OF SHEETB THEN COPY AND PASTE DATA FROM SHEETA COLUMNC INTO SHEETB COLUMNC
Solved by G. D. in 26 mins
Task - Identify the drops where the locations (postcodes) were visited for a 2nd time that day as drop 2. Data in sheet1 is sorted By B then By G 1 row = 1 item each drop can have many items Items to the same postcode (B) with the same last scan date (G) that are WITHIN 2 hours of each other (G) = drop 1 Items to the same postcode (B) with the same last scan date (G) that are MORE THAN 2 hours appart from each other (G) = drop 2 Drop1 = first drop to that postcode (B) that day (G) Drop 2 = 2nd drop to that postcode (B) that day (G) Each item has ATLEAST 1 drop Broken formula is in (AG) rows 9,12,20 & 26 should be drop 2 (highlighted in orange)
Solved by F. B. in 19 mins
I need help on formula to combine column letter and a cell from row to get its value
Solved by Z. H. in 14 mins
in coloum d for exp 1 a 2 bank 3 b 4 blank i want caopy in row 2 is a i want caopy in row 3 is b automaticaly i have somany data pls help
Solved by F. J. in 12 mins