Hello Group and Ayush,
Over the last few days, I have been missing some emails especially from
Noorain.
I use Thunderbird and all the emails from Noorain come marked with a
"Suspected Scam" warning. Result is that Thunderbird automatically
transfers such emails to the Trash Folder (These settings are at my
end). I have not specified any particular email to be marked as
"Suspected Scam". I have been using the same Thunderbird Settings for a
long time now and perhaps there are some external changes in the way
emails are being received. (Does not seem likely though).
Any idea anyone what could be the reason. I do not actively participate
in the resolution of queries (limited knowledge) but try and look at the
questions and the solutions provided by the experts to enhance my
limited knowledge. I do not want to miss out on some of the wonderful
solutions provided by Noorain and many other experts.
Any suggestions?
Thanks
Ashish Pradhan
On 14-08-2012 17:57, NOORAIN ANSARI wrote:
Dear Kenil,
Without using ctrl+shfit+enter
You can also use..
=SUMPRODUCT(MIN(($D2:$G2>0)*($D2:$G2)))
=SUMPRODUCT(MAX(($D2:$G2>0)*($D2:$G2)))
On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA
<[email protected] <mailto:[email protected]>> wrote:
On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA
<[email protected] <mailto:[email protected]>> wrote:
Hi kenil,
Pls change accordg to your data.
=MAX(IF(B1:B7>0,B1:B7))
=MIN(IF(A1:A7>0,A1:A7))
On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala <[email protected]
<mailto:[email protected]>> wrote:
hi all,
i have a query for finding maximum and minimum values.
i have written my query in the excel sheet attached. pls
help me solve my query.
Thanks and Regards,
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
titles, like Please Help, Urgent, Need Help, Formula
Problem, Code Problem, and Need Advice will not get quick
attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing
any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to
this forum in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links
is not allowed.
NOTE : Don't ever post personal or confidential data in a
workbook. Forum owners and members are not responsible for
any loss.
---
You received this message because you are subscribed to
the Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to
[email protected]
<mailto:[email protected]>.
To unsubscribe from this group, send email to
[email protected]
<mailto:excel-macros%[email protected]>.
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any
security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this
forum in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not
allowed.
NOTE : Don't ever post personal or confidential data in a
workbook. Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
To unsubscribe from this group, send email to
[email protected]
<mailto:excel-macros%[email protected]>.
--
With Regards,
Noorain Ansari
http:// <http://www.noorainansari.com>noorainansari.com
<http://www.noorainansari.com>
http:// <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com
<http://www.excelvbaclinic.blogspot.com>
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please Help, Urgent, Need Help, Formula Problem, Code Problem, and
Need Advice will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum
in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook.
Forum owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google
Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited.
6) Jobs posting is not allowed.
7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
