Posted to microsoft.public.excel.worksheet.functions

[email protected] craiglittleperth@aol.com is offline

external usenet poster

Posts: 14

Nested if help....

Hi All,

I have the following data.

Column A Column B
AAAAA BBBBBB
AAAAA
AAAAA
AAAAA
AAAAA CCCCCCCC
AAAAA
AAAAA
AAAAA

What i need to do is fill the blanks in column A when there is a value
to return.

i.e. every line cell in column B needs a value from above??

does that makes sense? i have been looking at this for 4 hours now and
don't konw myself what day it is!!! :(

thanks again.

Craig

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
Nested IF	Annie	Excel Worksheet Functions	4	March 16th 07 08:35 PM
nested if based on nested if in seperate sheet. how?	scouserabbit	Excel Worksheet Functions	5	March 2nd 07 04:03 PM
More than 16 nested IFs!!!!	Meltad	Excel Worksheet Functions	11	October 6th 06 09:49 AM
nested if	Ash	Excel Worksheet Functions	1	May 31st 06 09:29 AM
Nested IF	James Hamilton	Excel Discussion (Misc queries)	12	September 30th 05 03:43 PM

All times are GMT +1. The time now is 01:35 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us