LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,593
Default Jumping five steps

What about your other post, do you want that in Swedish?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" wrote in message
...
yes! Thanks alot bob! It works like clockwork now! Thanks!

"Bob Phillips" skrev:

Is it Swedish?

=INDEX(B:B;(RAD(A1)-1)*5+1)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" wrote in

message
...
Hi Bob! Yes you are right, I want to jump five steps. However I do not

seem
to get your code to work. I really dont know what is wrong and I have

some
foregin version of excel so i cannot understand the help function. I

just
get
the text #NAME? in the cells in column A. Please help me out! Thanks

very
much!!

"Bob Phillips" skrev:

Do you really want B1, B5, B10, or B1,B6,B11?

Assuming the second

=INDEX(B:B,(ROW(A1)-1)*5+1)


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Arne Hegefors" wrote in

message
...
I have two lists in excel say column A and B. In cell A1 I want to

show
the
value found in B1. In A2 I want to show the value found in B5, in

A3 I
want
to show the value found in B10, in A4 B15 etc. How do you do this

in
Excel? I
usually work with vba so i have completely forgotten!








 
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
VLOOKUP 1 stop Answer: 3 steps: count dup's, compare dif's, merg nastech Excel Discussion (Misc queries) 2 February 12th 06 01:26 PM
Complex Macro to perform an operation as it steps down cells? Jeni Q Excel Worksheet Functions 0 August 25th 05 04:38 PM
How do I stop the input cell from jumping to the mouse cursor? JMorris Excel Discussion (Misc queries) 1 August 13th 05 12:35 AM
Clean Up Code - consolidate steps Frantic Excel-er Excel Discussion (Misc queries) 6 June 30th 05 03:40 PM
Is there away to keep "auto save" from jumping to the first work sheet in the work book? Marc New Users to Excel 2 April 21st 05 01:27 AM


All times are GMT +1. The time now is 12:16 AM.

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

About Us

"It's about Microsoft Excel"