Data extraction to new column from one column based on another column values
Please Help
I need to extract the datas from one column to new column based on its right side column value
for example
A B C
A1100MS 0
A1200MS 2 A1200MS
A1300MS 0
A1400MS 2
A1900MS 0
A1960MS
A0511MS 2
A1001MS 2
A1009MS 0
From above table I want to extract COLUMN A values to column C based on Column B values that is if it is 2 and also column C values should be continous without blank cells
Please help me ,Ineed formula or VBA code
-navanee
Hi navanee !
Welcome to the Forum.
Try this array formula in C2. Since this is an array formula so remember to confirm it with Ctrl+Shift+Enter (i.e. hold down Ctrl and Shift and then press Enter)
And then drag down.
Please Login or Register to view this content.
Is this what you want?
Last edited by sktneer; 03-22-2014 at 08:33 AM.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi sktneer
Your formula works well and good , great thanks for your help!!! since I was searching for long time.
-Navanee
Glad to help you. Thanks for the feedback.
Since you are new to forum, let me tell you that if that takes care of your question, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks