Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Mike
 
Posts: n/a
Default progressive select

Looking for help on a function to create of a single column of data by
selecting every 4th cell in a fixed row starting with the second column in
the fixed row.

Example: start with:
a1 b1 c1 d1 e1 f1 g1 h1 i1 j1
mike thom dick vinn joey glen rick dain ryan bill...

end with:
thom
glen
bill
..
..
..

Thanks in advance. Mike


  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Try this:

=OFFSET(B$1,,(ROW(1:1)-1)*4)

Copy down as needed.

Biff

"Mike" wrote in message
...
Looking for help on a function to create of a single column of data by
selecting every 4th cell in a fixed row starting with the second column in
the fixed row.

Example: start with:
a1 b1 c1 d1 e1 f1 g1 h1 i1 j1
mike thom dick vinn joey glen rick dain ryan bill...

end with:
thom
glen
bill
.
.
.

Thanks in advance. Mike




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
I want to select the first blank cell in column A Greegan Excel Worksheet Functions 7 March 13th 05 01:56 PM
In Excel 2000, How do you select the whole of a worksheet (Select. Rascal Excel Discussion (Misc queries) 1 March 5th 05 01:03 AM
In Excel 2000, How do you select the whole of a worksheet (Select. Rascal Excel Discussion (Misc queries) 1 March 5th 05 12:59 AM
Dynamic Formulas with Dynamic Ranges Ralph Howarth Excel Worksheet Functions 5 January 21st 05 09:44 AM
Need help on Select Case Susan Hayes Excel Worksheet Functions 1 November 3rd 04 11:25 PM


All times are GMT +1. The time now is 04:16 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"