skipping cells

Hi, I am using an OFFSET formula to pull every second cell in a column into my new workbook however it displays the #VALUE ! error unless the other workbook stays open. I receive a file from my global head office which includes engagement survey scores (lets call it Global). This file...

Hello, forum. I have an excel sheet with time-series data for several items, where each row represents a different year. Something like this: Item Var 1 Var 2 ... A 5 10 A 6 10 A 8 20 B 1 33.7 B 2 29 B 0 24 ...

Hi all. An assay I perform for my lab work gives me 30 sets of data on one sheet. These data are triplicate measurements of a sample and the measurement is repeated every minute over a period of 30 mins (thus the 30 sets of data). Each remeasured value of a triplicate is separated by 10 rows...

Hello, I'm looking to easily drag the sum of certain cells in a different column BUT keeping a specific range, it's hard to explain so i'll show an example... <tbody> A1 A2 A3 A4 A5 A6 A7 A8 B1=SUM(A1:A4) B2=SUM(A4:A7) B3=SUM(A8:A11) And so on... </tbody> Is there any way I can do this by...

Hello, I'm looking to easily drag the sum of certain cells in a different column BUT keeping a specific range, it's hard to explain so i'll show an example... <tbody> A1 A2 A3 A4 A5 A6 A7 A8 B1=SUM(A1:A4) B2=SUM(A4:A7) B3=SUM(A8:A11) And so on... </tbody> Is there any way I can do this by...

Let's say I have someone enter 4 numbers in the range A1:A4. This will look as follows: 1 2 3 4 I have these numbers automatically enter the cells in a separate row. For example, the numbers go into the range D4:G4 to look as follows: 1 2 3 4 Now here's the important part. Can I have the...