“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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