Please find attachd as required by you, I have used "IF", let m know if it was useful
On Thu, Apr 9, 2009 at 11:51 AM, Harmeet Singh <harmeet.hew...@gmail.com>wrote: > Try attached file > > On Wed, Apr 8, 2009 at 9:06 PM, anish....@gmail.com > <anish....@gmail.com>wrote: > >> >> Hello Experts, >> >> I have been a silent member of this group and learnt so many >> things...But now I am facing a new problem....I hope anyone of you can >> help me out..Problem is as below... >> >> I have 2 lists in Column "A" and "B" (as u can see below) and I have >> validated them in Column C and D. >> Now what I need is if I select "2" in column C then Column D should >> list only 2 or more than 2 numbers. we dont need 1 there. Same goes >> for each number. Whatever we select in Column C, Column D should list >> only dat number or numbers more than that. I hope I was clear in what >> I need. It's quite urgent so would expect some urgent response from >> you. >> >> >> A B C D >> 1 1 2 >> 2 2 >> 3 3 >> 4 4 >> 5 5 >> 6 6 >> 7 7 >> 8 8 >> 9 9 >> 10 10 >> >> >> > > > -- > Thanks & Regards, > > Harmeet Singh > > > > -- Ganesh Babu K --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Book1(1).xls
Description: MS-Excel spreadsheet