wa284sj

Posts: n/a

Hi Bran,

put the data you have in column A into column C and enter the following
formula in A1

=IF(B1="","",C1)

copy it down to A2 & A3

Stuart

--
wa284sj
------------------------------------------------------------------------
wa284sj's Profile: http://www.excelforum.com/member.php...o&userid=22941
View this thread: http://www.excelforum.com/showthread...hreadid=375853

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
Lookup Lookup Lookup	MR	Excel Worksheet Functions	2	March 10th 05 01:59 AM
Lookup Function Problem	seve	Excel Discussion (Misc queries)	9	February 28th 05 02:46 AM
Lookup function w/Text and Year	Josh O.	Excel Worksheet Functions	1	February 12th 05 11:27 PM
Excel Lookup Functions	Paul Adams	Excel Worksheet Functions	1	November 10th 04 02:40 PM
double lookup, nest, or macro?	Josef.angel	Excel Worksheet Functions	1	October 29th 04 09:50 AM

All times are GMT +1. The time now is 09:46 PM.

About Us

"It's about Microsoft Excel"