Prev: Alt-F6
Next: Count max consecutive cells
From: User on 6 Apr 2010 08:36
can anyone please help me out with a formula wherein i have some 100s of
records in an excel sheet,with coloums as below

S.No item No. issue date expiry date amount extension date E1 E2 E3

the said item nos. will be depening on the requirement keep on extending the
dates in the corresponding item no in the coloums E1, E2, E3....and those
dates are recorded.

i want some technique wherein i can get the required record whose extending
dates (E1,E2,E3..) come under a specifc date range

if i want the extending dates record whose dates fall under 01/04/10 to
30/04/10
pls suggest
From: Don Guillett on 6 Apr 2010 08:52
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett(a)gmail.com
"User" <User(a)discussions.microsoft.com> wrote in message
news:C8B2C6A2-E3C5-4355-89B7-C55FEE14EE3E(a)microsoft.com...
> can anyone please help me out with a formula wherein i have some 100s of
> records in an excel sheet,with coloums as below
>
> S.No item No. issue date expiry date amount extension date E1 E2 E3
>
> the said item nos. will be depening on the requirement keep on extending
> the
> dates in the corresponding item no in the coloums E1, E2, E3....and those
> dates are recorded.
>
> i want some technique wherein i can get the required record whose
> extending
> dates (E1,E2,E3..) come under a specifc date range
>
> if i want the extending dates record whose dates fall under 01/04/10 to
> 30/04/10
> pls suggest

From: stanleydgromjr on 6 Apr 2010 08:55

User,

Please attach your workbook.

Click on the *Reply* button, then scroll down and see *Manage
Attachments*.



Have a great day,
Stan


--
stanleydgromjr
------------------------------------------------------------------------
stanleydgromjr's Profile: 503
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=193275

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Alt-F6
Next: Count max consecutive cells