take every nth value from column

[arrowmaker]

I want to take the value from cell AV1031 and put into another cell eg C3

then cell AV1056 into D3, and AV1081 into E3

and every 25th cell eg AV1106, AV1131

I know its using the OFFSET function, OFFSET(AV1031,(COLUMN()-1*25,0)

Would the formula copy across as well ?

[Olly]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[arrowmaker]

sheet 1 is a timesheet, at the end of it, AV AW AX AY the hours are broken down into basic hours, bank holiday, holiday and sick.

I want to take these values into sheet 2 for each employee

AV4 in sheet 1 would go to E3 in sheet 2

AV 29 would go to E4

AV 54 would go to E5

and every 25th value.

p.s hope the attachments have attached.

[JeteMc]

Looking at the layout for Sheet 2 it would appear that the values should go into cells E3, F3 and G3...
That being the case one way to do this would be pasting the following formula into E3 and copying across:

Please Login or Register  to view this content.

Note: change the 500 in $AV500 so that it will include the desired range for your actual data.
Note: cells E3:G3 need to be formatted [h]:mm
Let us know if you have any questions.

[arrowmaker]

thanks for that, it does work.
I did get it working about an hour ago with INDEX rather than OFFSET but the above is a bit tidier.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.