Haseeb,
Can you help me to modify this slightly? I still need to use the date
range as specified in A2 and A4, but instead of doing the whole
substitution, I would like for it to either return the actual line to
the C column if it contains a remark+date in valid range, or a blank
line if it
For the actual text, rather than SUBSTITUTE, one way is, C7 copy down.
=IF(ISNA(remark
LOOKUP(2,MATCH(*TEXT(ROW(CurrPeriod),mm/dd/)*,A7,0),ROW(CurrPeriod))),,A7)
Haseeb
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Ok, I figured out how to set it to a blank line by changing the first
value in the CHOOSE function to instead of A7. I would still
really like a plain text explanation of the formula for my own
education. I think I have a basic understanding of it, but I doubt I
could recreate this, or
Wow, that is really great. I have two further requests... can you
walk me through the formula used in column C so I can learn? I
haven't ever seen or used a few of those functions (lookup, as opposed
to vlookup or hlookup, or Choose).
Also, as I don't understand the logic yet, how can I modify
Hello Zeunasc;
I am not good in to explain something. Here is an attempt. Hope this would
help you.
A2 = Start Date, here 10/20/2011
A4 = End Date, here 10/25/2011
Basically 10/20/2011 is 40836 (40836 days after 1/1/1900)
10/25/2011 is 40841 (40841 days after 1/1/1900). If you change the
Hi,
Try this:
=REPLACE(A1, FIND(remark 10/19/2011, A1), LEN(remark 10/19/2011), )
Regards,
Swapnil.
On Thu, Oct 20, 2011 at 12:43 AM, Zeunasc timothy.ry...@gmail.com wrote:
I know that this is relatively easy, but it has been years since I
have done any Excel VBA. I am parsing out some
Dear Zeunasc,
Another Solution..
=SUBSTITUTE(A1,remark 10/19/2011, )
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/
On Thu, Oct 20, 2011 at 12:43 AM,
Both of these solutions work great... should have paid more attention
to the built in functions! Thank you both!
On Oct 20, 4:23 am, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Zeunasc,
Another Solution..
=SUBSTITUTE(A1,remark 10/19/2011, )
--
Thanks regards,
Noorain Ansari
As a follow up question, I have to do this review once a quarter, and
the remark dates will change. How would I, programmatically, parse
out the date string, then use that in an if/then... say, if this line
contains a date between 10/01/2011 and 12/31/2011.
I know that the values are strings, so
Hello Zeunasc;
Try the attached.
Enter a start date in A2, End date in A4.
HTH
Haseeb
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
I know that this is relatively easy, but it has been years since I
have done any Excel VBA. I am parsing out some firewall rules, and in
order to compare lines, I need to remove a section of text from within
a string.
The strings will look like this:
access-list BldA-I line 5 remark 10/19/2011
11 matches
Mail list logo