Posted to microsoft.public.excel.misc

Jambruins

external usenet poster

Posts: 65

Formula question...I belive row is the answer...but need help

I have text in columns B and C from row 1 to 170. The formula in cell H1 is
=B1 so it displays the text from B1. The formula in cell H2 is =C1 so it
displays the text from C1. I would like to copy this all the way down but it
skips row 2 and pulls the text from cells B3 and C3. I would like to use a
formula in cell H3 to find the text in cell B2 and a formula in cell H4 to
find the text in cell C2. Then I want to be able to copy this down the whole
sheet. Thanks.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Repeating Formula Question	THSaldivar	Excel Discussion (Misc queries)	1	July 3rd 06 03:36 PM
I have a question regarding countif formula.	Fahad Farid Ansari	Excel Worksheet Functions	6	October 1st 05 11:57 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 07:48 PM
Formula checking multiple worksheets	sonic-the-mouse	Excel Worksheet Functions	2	June 5th 05 03:28 AM
formula question	Pam Coleman	Excel Worksheet Functions	9	April 11th 05 08:51 AM

All times are GMT +1. The time now is 01:38 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us