Get instant live Excel expert help with ROW Functions

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.

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

How do I use an Excel function to derive the column’s value for each row based on different rules?

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

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?

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?

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

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)

I need help on formula to combine column letter and a cell from row to get its value

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