| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Returning list values
I have a list of names on sheet 2 of a worksheet that extends from A1 to
A249. I want to return name 1 on sheet 1 in A6, name 2 in A17, name 3 in A28, etc. What formula can I use to do this? I figured out how to do it with offset when i'm copying and pasting for each line (A1, A2, A3, A4, etc.), but not for every 11 rows without it skipping to the 11th name on the list? Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Min values in a list of numbers | Excel Worksheet Functions | |||
| Returning all values from a lookup - not just the first/last one | Excel Worksheet Functions | |||
| Returning an answer in an if fuction between two values | Excel Worksheet Functions | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
| Selecting data from a list based on entered values | Excel Discussion (Misc queries) | |||
Threaded Mode
