Posted to microsoft.public.excel.misc

kraway

external usenet poster

Posts: 14

referencing the data in a cell

I have a column of data, say column A. I want to show the value of every 5th
row in column A in column C. This means cell C1 will reference cell A1, cell
C2 will reference cell A6, cell C3 will reference cell A11, etc. Is there a
formula that I can drag down column C to produce this result?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data referencing	DeadpanDad	Excel Worksheet Functions	2	June 8th 07 05:05 PM
Referencing Data	chad	Excel Worksheet Functions	1	August 24th 06 05:17 PM
referencing data from a table	arbutus	Excel Worksheet Functions	2	March 24th 06 05:29 AM
Prevent equation from skipping data when referencing import data?	lybrt98	Excel Discussion (Misc queries)	0	August 30th 05 05:01 PM
referencing a sheet named in a cell then using data from that sheet	gbeard	Excel Worksheet Functions	4	April 15th 05 08:42 AM

All times are GMT +1. The time now is 07:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us