| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using list of data in another worksheet
Ok. I think I got it. Again, use your standard formula to retrieve the first name from Sheet1! in B3. In B5 use: =IF(ISEVEN(ROW()),"",OFFSET(Sheet1!$B$1,COUNTBLANK ($B$3:B4),0)&", "&OFFSET(Sheet1!$A$1,COUNTBLANK($B$3:B4),0)) You can then drag this down and it will only populate the next name in every other row so in this case B7, B9, B11 and so on down the line. Does that work for you? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=520195 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Convert PivotTable data into a worksheet list | Excel Worksheet Functions | |||
Hybrid Mode
