how to select half of the cells in a row........

[drniranjan]

Hi,
Say, I have data sets like.....
12 32 33 45 13 33 12 22 12 32 33 45 13 33 12 22

like this thousands of rows are there and every row has even number of cells having values........

I need to select the 1st half of the cells of every row for some computation.........

I shall be thankful and oblised if someone can help me out......

Best, N

 

[MrKowz]

What kind of computation are you performing on them (ie What formula do you want to use)? That would affect how we refer to these cells.

 

[jim may]

A simple Example... maybe too simple...

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L
1	12	24	36	48	60	72	84	96	108	120	132	144
2
3	252
Sheet1

Excel 2007

Cell Formulas
Range	Formula
A3	=SUM(OFFSET($A$1,0,0,1,COUNT(1:1)/2))