Re: addressing

Article View: comp.apps.spreadsheets

Article #387

Back to comp.apps.spreadsheets Previous Next

#387

From: Harlan Grove
Date: Tue, 16 Mar 2004 22:35

22 lines
1770 bytes

"karl gauss" wrote...
>i am using quattro pro. on page A, i have a list of names going down
>from cell A1 to cell A30. 
>
>on page B, i wish to have the name from page A cell A1 go in cell B:A1
>on page C, i wish to have the name from page A cell A2 go in cell C:A1
>on page D, i wish to have the name from page A cell A3 go in cell D:A1
>
>and so on. to achieve this, i have been doing the tedious task of
>typing +A:A1 into cell B:A1 and then typing +A:A2 into cell C:A1 and
>so on. 
>
>is there a fast way to do this?

In cell B:A1, what does the formula

@INDEX($A:$A$1..$A:$A$30,0,@CELL("Sheet",B:A2))

produce?

--
To top-post is human, to bottom-post and snip is sublime.

Technical Details

Message-ID: <HiL5c.6458$_4.363@www.newsranger.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!news.maxwell.syr.edu!news-out1.nntp.be!propagator2-sterling!news-in-sterling.newsfeeds.com!newsranger.com!www.newsranger.com!not-for-mail

References: <40576c95.87924662@news1.sympatico.ca>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 107c76,2118e0862845590a
X-Google-Attributes: gid107c76,public
X-Google-Thread: f75a7,2118e0862845590a
X-Google-Attributes: gidf75a7,public
X-Google-ArrivalTime: 2004-03-16 14:36:10 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!fu-berlin.de!news.maxwell.syr.edu!news-out1.nntp.be!propagator2-sterling!news-in-sterling.newsfeeds.com!newsranger.com!www.newsranger.com!not-for-mail
Newsgroups: comp.apps.spreadsheets,corel.support.wordperfect8suite.quattropro
From: Harlan Grove<hrlngrv@aol.com>
References: <40576c95.87924662@news1.sympatico.ca>
Subject: Re: addressing
Lines: 22
Message-ID: <HiL5c.6458$_4.363@www.newsranger.com>
X-Abuse-Info: When contacting newsranger.com regarding abuse please
X-Abuse-Info: forward the entire news article including headers or
X-Abuse-Info: else we will not be able to process your request
X-Complaints-To: abuse@newsranger.com
NNTP-Posting-Date: Tue, 16 Mar 2004 17:35:19 EST
Organization: http://www.newsranger.com
Date: Tue, 16 Mar 2004 22:35:19 GMT

Reply to Parent Message