Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VLOOKUP 1 stop Answer: 3 steps: count dup's, compare dif's, merg | Excel Discussion (Misc queries) | |||
Complex Macro to perform an operation as it steps down cells? | Excel Worksheet Functions | |||
How do I stop the input cell from jumping to the mouse cursor? | Excel Discussion (Misc queries) | |||
Clean Up Code - consolidate steps | Excel Discussion (Misc queries) | |||
Is there away to keep "auto save" from jumping to the first work sheet in the work book? | New Users to Excel |