Hi,
This is not complete, but you could use a nested IF Statement.
Something like this in cell P6....

=IF(LEN(N6)>0,N6,IF(LEN(M6)>0,M6,IF(LEN(L6)>0,L6,K6)))

On Jan 14, 11:40 pm, ankur <ankurpande...@gmail.com> wrote:
> hi Gurmeet
>  can i  have sample file,then  it will be  easy
> Have A Nice Time & Enjoy Life
>
> Regards:
> CMA Ankur Pandey
> (Someone Different)
>
> I'm not the best but i'm not like the rest~~
>
> On Thu, Jan 14, 2010 at 2:19 PM, Gurmeet Singh
>
>
>
> <gurmeetsingh.meh...@gmail.com> wrote:
> > Hi,
>
> > Current Situation:
> > I am currently using a charting software which enables the livepricequotes
> > to be seen in excel, live.
>
> > Solution Required:
> > I need to tabulate this data on a real time basis, in time spans of 1 min, 5
> > min, 30 min, 60 min...so that I can see the progressive data based on the
> > time
>
> > 10:01 <high> <low>
> > 10:02 <high> <low>
> > etc
> > etc
>
> > Can someone help me with this.
>
> > Thank you
> > Gurmeet, mumbai
> > 9920893592
>
> > ________________________________
> > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> > On Behalf Of excel-macros+nore...@googlegroups.com
> > Sent: 12 January 2010 05:05
> > To: Digest Recipients
> > Subject: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 20
> > Messages in 10 Topics
>
> >   Today's Topic Summary
>
> > Group:http://groups.google.com/group/excel-macros/topics
>
> > Vlookup-Dates [2 Updates]
> > Dependent Lists [1 Update]
> > HOW CAN I WORK IN ONE WORKBOOK IN MULTIPLE LOCATION [8 Updates]
> > altering excel lookup tables [1 Update]
> > Using macro move sheets from one work book to another work book [2 Updates]
> > Excel Solver [1 Update]
> > Export from word to excel [2 Updates]
> > Code User Laval [1 Update]
> > Password crecker for Excel workbbok [1 Update]
> > printing page numbers of worksheets [1 Update]
>
> >  Topic: Vlookup-Dates
>
> > Sachin Gohil <sachin.go...@hotmail.com> Jan 11 09:28PM +0530 ^
>
> > Its very simple data. For every date I want Mon-Sun for that date.
> > File 1: Date Week15-Jan-09 =vlookup(A2,File2,2,0) which gives #N/A
> > File 2:Date Week11-Jan-09 11-Jan to 17-Jan12-Jan-09 11-Jan to 17-Jan
> > 13-Jan-09 11-Jan to 17-Jan14-Jan-09 11-Jan to 17-Jan15-Jan-09 11-Jan to
> > 17-Jan16-Jan-09 11-Jan to 17-Jan17-Jan-09 11-Jan to 17-Jan18-Jan-09 18-Jan
> > to 24-Jan19-Jan-09 18-Jan to 24-Jan
> > Date: Sun, 10 Jan 2010 09:10:23 -0800
> > From: alokeshwar.tiw...@yahoo.com
> > Subject: Re: $$Excel-Macros$$ Vlookup-Dates
> > To: excel-macros@googlegroups.com
>
> > Please share the workbook?
>
> > ___________________________________________________________________________­______________________
> > "There are known knowns. These are things we know that we know. There are
> > known unknowns. That is to say, there are things that we know we don't know.
> > But there are also unknown unknowns. There are things we don't know we don't
> > know."
>
> > From: Sachin Gohil <sachin.go...@hotmail.com>
> > To: excel-macros@googlegroups.com
> > Sent: Sun, 10 January, 2010 7:00:44 PM
> > Subject: $$Excel-Macros$$ Vlookup-Dates
>
> > Dear All,
>
> > I did a vlookup of dates, but Im getting #N/A. The reason is every date in
> > excel is tored as serial no. Tried using Date/Date value but it doesnt
> > work..
>
> > New Windows 7: Find the right PC for you. Learn more. --
> > ---------------------------------------------------------------------------­-------
> > Some important links for excel users:
> > 1. Follow us in TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >http://www.excelitems.com
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,500 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
> > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> > _________________________________________________________________
> > Windows 7: Find the right PC for you. Learn more.
> >http://windows.microsoft.com/shop
>
> > Alokeshwar Tiwary <alokeshwar.tiw...@yahoo.com> Jan 11 08:42AM -0800 ^
>
> >  you can use following function to get date range instead of a vlookup:
>
> > Function GetDateRange(Day1 As Date, CurrentDay As Date) As String
> > Dim i As Integer, LeftRange As Date, RightRange As Date
> > If Day1 > CurrentDay Then
> >     DateRange = "#INVALID#"
> >     Exit Function
> > End If
> > i = Application.WorksheetFunction.RoundDown((CurrentDay - Day1) / 7, 0)
> > LeftRange = 7 * (i) + (Day1)
> > RightRange = 7 * (i + 1) + (Day1 - 1)
> > GetDateRange = Format(LeftRange, "dd-mmm") & " to " & Format(RightRange,
> > "dd-mmm")
> > End Function
>
> > If you want to convert date into Day names, use Text function =
> > TEXT(YourDate,"ddd")
>
> > ___________________________________________________________________________­______________________
> > "There are known knowns. These are things we know that we know. There are
> > known unknowns. That is to say, there are things that we know we don't know.
> > But there are also unknown unknowns. There are things we don't know we don't
> > know."
>
> > ________________________________
> > From: Sachin Gohil <sachin.go...@hotmail.com>
> > To: excel-macros@googlegroups.com
> > Sent: Mon, 11 January, 2010 9:28:00 PM
> > Subject: RE: $$Excel-Macros$$ Vlookup-Dates
>
> > Its very simple data. For every date I want Mon-Sun for that date.
>
> > File 1:
> > Date           Week
> > 15-Jan-09   =vlookup(A2,File2,2,0) which gives #N/A
>
> > File 2:
> > Date          Week
> > 11-Jan-09  11-Jan to 17-Jan
> > 12-Jan-09  11-Jan to 17-Jan
> > 13-Jan-09  11-Jan to 17-Jan
> > 14-Jan-09  11-Jan to 17-Jan
> > 15-Jan-09  11-Jan to 17-Jan
> > 16-Jan-09  11-Jan to 17-Jan
> > 17-Jan-09  11-Jan to 17-Jan
> > 18-Jan-09  18-Jan to 24-Jan
> > 19-Jan-09  18-Jan to 24-Jan
>
> > ________________________________
> > Date: Sun, 10 Jan 2010 09:10:23 -0800
> > From: alokeshwar.tiw...@yahoo.com
> > Subject: Re: $$Excel-Macros$$ Vlookup-Dates
> > To: excel-macros@googlegroups.com
>
> > Please share the workbook?
>
> > ___________________________________________________________________________­______________________
> > "There are known knowns. These are things we know that we know. There are
> > known unknowns. That is to say, there are things that we know we don't know.
> > But there are also unknown unknowns. There are things we don't know we don't
> > know."
>
> > ________________________________
> > From: Sachin Gohil <sachin.go...@hotmail.com>
> > To: excel-macros@googlegroups.com
> > Sent: Sun, 10 January, 2010 7:00:44 PM
> > Subject: $$Excel-Macros$$ Vlookup-Dates
>
> > Dear All,
>
> > I did a vlookup of dates, but Im getting #N/A. The reason is every date in
> > excel is tored as serial no. Tried using Date/Date value but it doesnt
> > work..
>
> > ________________________________
> > New Windows 7: Find the right PC for you. Learn more. --
> > ---------------------------------------------------------------------------­-------
> > Some important links for excel users:
> > 1. Follow us in TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >http://www.excelitems.com
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,500 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
> > ________________________________
> > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> > ________________________________
> > Windows 7: Find the right PC for you. Learn more. --
> > ---------------------------------------------------------------------------­-------
> > Some important links for excel users:
> > 1. Follow us in TWITTER for tips tricks and links :
> >http://twitter.com/exceldailytip
> > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> >http://www.excelitems.com
> > 3. Excel tutorials athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 6,500 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
> > The INTERNET now has a personality. YOURS! See your Yahoo! Homepage.
> >http://in.yahoo.com/
>
> >  Topic: Dependent Lists
>
> > capt edgar <capted...@googlemail.com> Jan 11 07:31AM -0800 ^
>
> > Hi there
>
> > I have attached a small excel sheet called TESTTHEM which i'm testing
> > and learning excel simultaneously. On the attached sheet
>
> > under the type column, i have created a dropdown list with some values
> > in it. If i select a value from the dropdown list say for ex:
> > Pictures, is it possible to auto-populate certain rows after this
> > choice i.e. Pictures has been selected.
>
> > The Columns relevent to this row which needs populatng are Test, UAT,
> > Stage1, Prod1, Prod2, Test Server, UAT Server, Stage1 Server, Prod1
>
> ...
>
> read more »- Hide quoted text -
>
> - Show quoted text -

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe

Reply via email to