# 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