Seprate cell same row
Dear Sir,
thanks alot for your continues help, need some more .
i have one sheet wher two information invoice number and item codes in colomn A and in colom b it have item description and customer name
i need to bring all in one row please find the attach file.
Last edited by mubeenff; 06-12-2011 at 07:03 AM.
Hi
In cell F2
=IF(AND(C1<>"",C2<>""),F1,IF(C2="","",A1))
In cell G2
=IF(F2="","",VLOOKUP(F2,A:B,2,0))
Copy down as far as required
--
Regards
Roger Govier
Microsoft Excel MVP
worked like a dream thanks a lot god bless u
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks