RE: $$Excel-Macros$$ Exporting emails in excel

[Amit Desai (MERU)]

My dear friend I tried that...

Simple copy & paste is not giving me all the fields. For today's data it is 
just giving me timing, for yesterday's data (till week end) it gives day & time 
& for previous week's data, it gives day & date.

Best Regards,
Amit

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of in.vaib...@googlemail.com
Sent: 29 August 2012 10:26
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Exporting emails in excel

Hi

Its very simple as long as you dont want body of email, Just select the region 
in Outlook then Ctr + C i.e. copy & paste in excel

Rgds
Vaibhav



On Wed, Aug 29, 2012 at 9:47 AM, Amit Desai (MERU) 
mailto:amit.de...@merucabs.com>> wrote:
Dear Rajan,

Please find attached sample file with required output. Please let me know if 
you can suggest a method to export.

Best Regards,
Amit

From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On 
Behalf Of Rajan_Verma
Sent: 28 August 2012 22:48
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Exporting emails in excel

Where you want to export, How you want to export ?

Will you please elaborate this ?

[cid:image001.jpg@01CD85D2.5B69D020]

:)

Regards
Rajan verma
+91 7838100659 [IM-Gtalk]

From: excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU)
Sent: 28 August 2012 10:36
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Exporting emails in excel

Dear Friends,

Please let me know how we can export the mails & sort each fields like from, 
subject, date, time etc...s

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.
--
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 
excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.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 MAC

$$Excel-Macros$$ OFX to Excel-Reg

[RAJA SEKAR]

Dear All,

Is it Possible to get OFX (Open Financial Exchange) data in to Excel.


-- 
"Making a million friends is not a miracle, the miracle is to make a friend
who will stand by you when a million are against you. "

Have a Smileness Day
With A Smile
Rs.

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ If condition limitation.

[in.vaib...@googlemail.com]

PFA Sample Data, if we can do with formula or vba both option is welcome.
Rgds
Vaibhav
On Tue, Aug 28, 2012 at 11:34 PM,  wrote:

> Hi All
>
> I have a tracker with almost 10 condition to be tasted. All condition is
> shown as header, for case 1 when first event is completed then date of
> completion is put under 1st header and under status for case 1 value to be
> reflected is description of header 1.
>
> When second event is completed then under header 2 date of completion is
> mention and status is replaced with description of header 2 and so on.
>
> So in column A all event name is mentioned, col B is status col.  And from
> column C to column L header 1 to 10 is mentioned.
>
> Eg. Value of cell A2 is Case North Port and now description of column C to
> Z header is START, EMAIL SENT, REPLY recd and so on.
>
> So when case is logged in date is mention under START header i.e. In cell.
> C2 we put date of email sent. So status in Cell B2 will show as START.
>
> Now when email is sent cell D2 will be updated with date of email sent and
> Cell B2 should show status as Email Sent.
>
> I tried applyin if condition since we are using excell 2003 not more than
> 7 nesting of if is used.
>
> Any alternate way out for the same.
>
> Rgds
> Vaibhav.
>
> --
> 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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




TRACKER.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ If condition limitation.

[noorain . ansari]

Dear vaibhav,

Can you share sample worbook with group


Sent from BlackBerry® on Airtel

-Original Message-
From: in.vaib...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Tue, 28 Aug 2012 18:04:01 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If condition limitation.

Hi All

I have a tracker with almost 10 condition to be tasted. All condition is shown 
as header, for case 1 when first event is completed then date of completion is 
put under 1st header and under status for case 1 value to be reflected is 
description of header 1.

When second event is completed then under header 2 date of completion is 
mention and status is replaced with description of header 2 and so on.

So in column A all event name is mentioned, col B is status col.  And from 
column C to column L header 1 to 10 is mentioned.

Eg. Value of cell A2 is Case North Port and now description of column C to Z 
header is START, EMAIL SENT, REPLY recd and so on.

So when case is logged in date is mention under START header i.e. In cell. C2 
we put date of email sent. So status in Cell B2 will show as START.

Now when email is sent cell D2 will be updated with date of email sent and Cell 
B2 should show status as Email Sent.

I tried applyin if condition since we are using excell 2003 not more than 7 
nesting of if is used.

Any alternate way out for the same.

Rgds
Vaibhav.

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Baler Software

[Asa Rossoff]

> Please don't ban me (I won't do it again)

indicates foreknowledge and intent!

 

 

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ If condition limitation.

[dguillett1]

I would do this with a macro. Provide a file to ME along with this msg and 
examples.




Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: in.vaib...@gmail.com

Sent: Tuesday, August 28, 2012 1:04 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ If condition limitation.

Hi All

I have a tracker with almost 10 condition to be tasted. All condition is 
shown as header, for case 1 when first event is completed then date of 
completion is put under 1st header and under status for case 1 value to be 
reflected is description of header 1.


When second event is completed then under header 2 date of completion is 
mention and status is replaced with description of header 2 and so on.


So in column A all event name is mentioned, col B is status col.  And from 
column C to column L header 1 to 10 is mentioned.


Eg. Value of cell A2 is Case North Port and now description of column C to Z 
header is START, EMAIL SENT, REPLY recd and so on.


So when case is logged in date is mention under START header i.e. In cell. 
C2 we put date of email sent. So status in Cell B2 will show as START.


Now when email is sent cell D2 will be updated with date of email sent and 
Cell B2 should show status as Email Sent.


I tried applyin if condition since we are using excell 2003 not more than 7 
nesting of if is used.


Any alternate way out for the same.

Rgds
Vaibhav.

--
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Re: Required a search option in excel file

[dguillett1]

Didn’t anyone see my solution???

Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com

From: Prince Dubey 
Sent: Monday, August 27, 2012 11:22 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Re: Required a search option in excel file

Hi Praveen, 


Please see the attachment hope this will help you.

regards
prince 

On Monday, August 27, 2012 3:02:48 PM UTC+5:30, Pravin Gunjal wrote: 
  Hello Friends, 


  Need a help on the following issue.


  1. I am having a file containing 318 products / rates in it.  (file is 
attached for your reference)
  2. I want to search a particular product or rate by typing it's initial 
letter in the cell : B2.  Need a formula for this...
  3. Once the letter / number is typed in cell B2 then only those search 
results should appear in the following rows instead of all products.
  4. I know this can be done by auto filter option but it is quite difficult 
for me to use this option continuously.  Hence this is the request.


  Hope to hear from you soon.  Thank you.


  Regards
  Pravin Gunjal





-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Time Calculation

[LJ]

Greetings,

 

I need a formula that calculates the amount of time between 7pm and 6pm and 
the entire weekend between 2 dates. Example:

 

A1 = End Date and Time 8/1/2012 12:00:00PM

B1 = Start Date and Time 8/21/2012 4:00:00PM 


I need the result to be in hh:mm:ss.

 

Thanks in advance.

 

J

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ If condition limitation.

[in . vaibhav]

Hi All

I have a tracker with almost 10 condition to be tasted. All condition is shown 
as header, for case 1 when first event is completed then date of completion is 
put under 1st header and under status for case 1 value to be reflected is 
description of header 1.

When second event is completed then under header 2 date of completion is 
mention and status is replaced with description of header 2 and so on.

So in column A all event name is mentioned, col B is status col.  And from 
column C to column L header 1 to 10 is mentioned.

Eg. Value of cell A2 is Case North Port and now description of column C to Z 
header is START, EMAIL SENT, REPLY recd and so on.

So when case is logged in date is mention under START header i.e. In cell. C2 
we put date of email sent. So status in Cell B2 will show as START.

Now when email is sent cell D2 will be updated with date of email sent and Cell 
B2 should show status as Email Sent.

I tried applyin if condition since we are using excell 2003 not more than 7 
nesting of if is used.

Any alternate way out for the same.

Rgds
Vaibhav.

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Formula request - amount of time between 7pm and 6pm between 2 dates

[LJ]

I need the result in *hh:mm:ss* format. 

On Tuesday, August 28, 2012 1:40:40 PM UTC-4, Rajan_Verma wrote:
>
> *What amount you want.*
>
> *I mean in week, Day, Hour,Minute,Seconds or anything else?*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-...@googlegroups.com  [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *LJ
> *Sent:* 28 August 2012 11:08
> *To:* excel-...@googlegroups.com 
> *Subject:* $$Excel-Macros$$ Formula request - amount of time between 7pm 
> and 6pm between 2 dates
>
>  
>
> Greetings,
>
>  
>
> I need a formula that calculates the amount of time between 7pm and 6pm 
> between 2 dates. Example:
>
>  
>
> A1 = End Date and Time 8/1/2012 12:00:00PM
>
> B1 = Start Date and Time 8/21/2012 4:00:00PM 
>
>  
>
> Thanks in advance.
>
>  
>
> J
>
> -- 
> 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 excel-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: Formula request - amount of time between 7pm and 6pm between 2 dates

[LJ]

I need the result in *hh:mm:ss* format.

On Tuesday, August 28, 2012 1:37:31 PM UTC-4, LJ wrote:
>
> Greetings,
>
> I need a formula that calculates the amount of time between 7pm and 6pm 
> between 2 dates. Example:
>
> A1 = End Date and Time 8/1/2012 12:00:00PM
> B1 = Start Date and Time 8/21/2012 4:00:00PM 
>
> Thanks in advance.
>
> J
>

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

RE: $$Excel-Macros$$ Formula request - amount of time between 7pm and 6pm between 2 dates

[Rajan_Verma]

What amount you want.

I mean in week, Day, Hour,Minute,Seconds or anything else?

 

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of LJ
Sent: 28 August 2012 11:08
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Formula request - amount of time between 7pm and
6pm between 2 dates

 

Greetings,

 

I need a formula that calculates the amount of time between 7pm and 6pm
between 2 dates. Example:

 

A1 = End Date and Time 8/1/2012 12:00:00PM

B1 = Start Date and Time 8/21/2012 4:00:00PM 

 

Thanks in advance.

 

J

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Formula request - amount of time between 7pm and 6pm between 2 dates

[LJ]

Greetings,

I need a formula that calculates the amount of time between 7pm and 6pm 
between 2 dates. Example:

A1 = End Date and Time 8/1/2012 12:00:00PM
B1 = Start Date and Time 8/21/2012 4:00:00PM 

Thanks in advance.

J

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Exporting emails in excel

[Ashish Pradhan]

Apologies for not "adding" to this thread. But could not help but smile 
at the image after the question by Rajan. :-) :-)


Thanks

Ashish Pradhan

On 28-08-2012 22:48, Rajan_Verma wrote:


*Where you want to export, How you want to export ?*

**

*Will you please elaborate this ?*

**

*Description: 
http://t2.gstatic.com/images?q=tbn:ANd9GcSUnzYbrl2H90NE5PREupCJIjQmzZBwRvBNibEG_Ydd5M14PMrazw&t=1***


**

*J***

**

*Regards*

*Rajan verma*

*+91 7838100659 [IM-Gtalk]*

**

*From:*excel-macros@googlegroups.com 
[mailto:excel-macros@googlegroups.com] *On Behalf Of *Amit Desai (MERU)

*Sent:* 28 August 2012 10:36
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Exporting emails in excel

Dear Friends,

Please let me know how we can export the mails & sort each fields like 
from, subject, date, time etc...s


Best Regards,

Amit



Disclaimer: This message and its attachments contain confidential 
information and may also contain legally privileged information. This 
message is intended solely for the named addressee. If you are not the 
addressee indicated in this message (or authorized to receive for 
addressee), you may not copy or deliver any part of this message or 
its attachments to anyone or use any part of this message or its 
attachments. Rather, you should permanently delete this message and 
its attachments (and all copies) from your system and kindly notify 
the sender by reply e-mail. Any content of this message and its 
attachments that does not relate to the official business of Meru Cab 
Company Pvt. Ltd. must be taken not to have been sent or endorsed by 
any of them. Email communications are not private and no warranty is 
made that e-mail communications are timely, secure or free from 
computer virus or other defect.


--
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 excel-macros@googlegroups.com 
.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.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 

RE: $$Excel-Macros$$ Exporting emails in excel

[Rajan_Verma]

Where you want to export, How you want to export ?

 

Will you please elaborate this ?

 

Description:
http://t2.gstatic.com/images?q=tbn:ANd9GcSUnzYbrl2H90NE5PREupCJIjQmzZBwRvBNi
bEG_Ydd5M14PMrazw&t=1

 

J

 

Regards

Rajan verma

+91 7838100659 [IM-Gtalk]

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: 28 August 2012 10:36
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Exporting emails in excel

 

Dear Friends,

 

Please let me know how we can export the mails & sort each fields like from,
subject, date, time etc...s

 

Best Regards,

Amit

 

 

  _  

Disclaimer: This message and its attachments contain confidential
information and may also contain legally privileged information. This
message is intended solely for the named addressee. If you are not the
addressee indicated in this message (or authorized to receive for
addressee), you may not copy or deliver any part of this message or its
attachments to anyone or use any part of this message or its attachments.
Rather, you should permanently delete this message and its attachments (and
all copies) from your system and kindly notify the sender by reply e-mail.
Any content of this message and its attachments that does not relate to the
official business of Meru Cab Company Pvt. Ltd. must be taken not to have
been sent or endorsed by any of them. Email communications are not private
and no warranty is made that e-mail communications are timely, secure or
free from computer virus or other defect.

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to
excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.


<>

$$Excel-Macros$$ Exporting emails in excel

[Amit Desai (MERU)]

Dear Friends,

Please let me know how we can export the mails & sort each fields like from, 
subject, date, time etc...s

Best Regards,
Amit



Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ please help with array formula

[maksood alam]

Thanks Noorain bhai.. its solved my qurey..

On Tue, Aug 28, 2012 at 8:35 PM, NOORAIN ANSARI wrote:

> See attachment for more clarity
>
>  On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote:
>
>> Hi experts,
>>
>> I have data in once sheet in two colums like *NAME*(colum A) and 
>> *Marks*(colum
>> B). In 2nd sheet i want a formula if i enter 20 its should show me the name
>> of all the candidate who has 40 marks in 1st sheet. can it done with array
>> forumla. please help.
>>
>>
>> *Name* *Marks CT-1* SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
>> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
>> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
>> SENSENBRENNER,
>> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
>>40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
>> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
>> ROMEO,
>> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G
>> 100
>>
>>
>>
>>*Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>>
>>
>> --
>> 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 excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send em

Re: $$Excel-Macros$$ Bullet graphs

[NOORAIN ANSARI]

Dear santosh,

please visit here
http://peltiertech.com/WordPress/how-to-make-horizontal-bullet-graphs-in-excel/

On Sat, Aug 25, 2012 at 4:21 PM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:

> Hi,
>
> What are bullet graphs,would request to share some examples with me.
> --
> Regards
> Santosh
> santoshkumar.subu...@gmail.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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Re: Required a search option in excel file

[Prince Dubey]

Hi Pravin, 
Plz see the attachment hope this time it will make some sense for you.

regards
prince

On Tuesday, August 28, 2012 2:35:16 PM UTC+5:30, Pravin Gunjal wrote:
>
> Dear Prince
>
> It's working good. But this is not helpful for me.  As we can not type the 
> full letters to search the data..
>
> If we type  few letters and hit the *Filter *button then we should get 
> the result  *OR  *if we type any rate mentioned therein the result should 
> appear.
>
> *For example :-*
>
> 1. If I type *BRUN *then we should get the following result...
>
> [image: Inline image 1]
>
> 2. If I type *52.06** *then we should get the following result... 
>  
> [image: Inline image 2]
>
> Hope the requirement is understood by you.  Kindly look in to this and do 
> the needful.  Thank you.
>
> *REGARDS,*
> *PRAVIN GUNJAL*
>   
> -- Forwarded message --
> From: Prince Dubey >
> Date: Mon, Aug 27, 2012 at 9:52 PM
> Subject: $$Excel-Macros$$ Re: Required a search option in excel file
> To: excel-...@googlegroups.com 
>
>
> Hi Praveen,
>
> Please see the attachment hope this will help you.
>
> regards
> prince 
>
> On Monday, August 27, 2012 3:02:48 PM UTC+5:30, Pravin Gunjal wrote:
>>
>> Hello Friends,
>>
>> Need a help on the following issue.
>>
>> 1. I am having a file containing 318 products / rates in it.  (file is 
>> attached for your reference)
>> 2. I want to search a particular *product* or *rate* by typing it's 
>> initial letter in the cell : *B2*.  Need a formula for this...
>> 3. Once the letter / number is typed in cell B2 then only those search 
>> results should appear in the following rows instead of all products.
>> 4. I know this can be done by auto filter option but it is quite 
>> difficult for me to use this option continuously.  Hence this is the 
>> request.
>>
>> Hope to hear from you soon.  Thank you.
>>
>> Regards
>> Pravin Gunjal
>>
>>
>>
>>  -- 
> 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 excel-...@googlegroups.com
> .
> To unsubscribe from this group, send email to 
> excel-macros...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Book1_Solved.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

$$Excel-Macros$$ Re: Required a search option in excel file

[NOORAIN ANSARI]

Dear Pravin,

I think, Prince's code is correct, please try it once again..

rng.AutoFilter Field:=1, Criteria1:=*"*" & .Range("B2").Value & "*"


*
On Tue, Aug 28, 2012 at 6:42 PM, Pravin Gunjal  wrote:

> *Dear Noorain - Could you pl. help me our on this issue.*
>
> -- Forwarded message --
> From: Pravin Gunjal 
> Date: Tue, Aug 28, 2012 at 2:34 PM
> Subject: $$Excel-Macros$$ Required a search option in excel file
> To: Prince Kumar - Excel ,
> excel-macros@googlegroups.com
>
>
> Dear Prince
>
> It's working good. But this is not helpful for me.  As we can not type the
> full letters to search the data..
>
> If we type  few letters and hit the *Filter *button then we should get
> the result  *OR  *if we type any rate mentioned therein the result should
> appear.
>
> *For example :-*
>
> 1. If I type *BRUN *then we should get the following result...
>
> [image: Inline image 1]
>
> 2. If I type *52.06** *then we should get the following result...
>
> [image: Inline image 2]
>
> Hope the requirement is understood by you.  Kindly look in to this and do
> the needful.  Thank you.
>
> *REGARDS,*
> *PRAVIN GUNJAL*
>
> -- Forwarded message --
> From: Prince Dubey 
> Date: Mon, Aug 27, 2012 at 9:52 PM
> Subject: $$Excel-Macros$$ Re: Required a search option in excel file
> To: excel-macros@googlegroups.com
>
>
> Hi Praveen,
>
> Please see the attachment hope this will help you.
>
> regards
> prince
>
> On Monday, August 27, 2012 3:02:48 PM UTC+5:30, Pravin Gunjal wrote:
>>
>> Hello Friends,
>>
>> Need a help on the following issue.
>>
>> 1. I am having a file containing 318 products / rates in it.  (file is
>> attached for your reference)
>> 2. I want to search a particular *product* or *rate* by typing it's
>> initial letter in the cell : *B2*.  Need a formula for this...
>> 3. Once the letter / number is typed in cell B2 then only those search
>> results should appear in the following rows instead of all products.
>> 4. I know this can be done by auto filter option but it is quite
>> difficult for me to use this option continuously.  Hence this is the
>> request.
>>
>> Hope to hear from you soon.  Thank you.
>>
>> Regards
>> Pravin Gunjal
>>
>>
>>
>>  --
> 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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>
>


-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.com

-- 
Join official facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES (1120+ members a

Re: $$Excel-Macros$$ please help with array formula

[NOORAIN ANSARI]

See attachment for more clarity

On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote:

> Hi experts,
>
> I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
> B). In 2nd sheet i want a formula if i enter 20 its should show me the name
> of all the candidate who has 40 marks in 1st sheet. can it done with array
> forumla. please help.
>
>
> *Name* *Marks CT-1*  SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
> SENSENBRENNER,
> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
> 40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
> ROMEO,
> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100
>
>
>
> *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>
>
> --
> 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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Maksood(Solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ please help with array formula

[NOORAIN ANSARI]

Dear Maksood,

Please try it..

=IFERROR(INDEX($B$5:$B$29,SMALL(IF($C$5:$C$29=$G$6,ROW($C$5:$C$29),""),ROW(B1))-4),"--")

On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote:

> Hi experts,
>
> I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
> B). In 2nd sheet i want a formula if i enter 20 its should show me the name
> of all the candidate who has 40 marks in 1st sheet. can it done with array
> forumla. please help.
>
>
> *Name* *Marks CT-1*  SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
> SENSENBRENNER,
> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
> 40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
> ROMEO,
> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100
>
>
>
> *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>
>
> --
> 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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ please help with array formula

[maksood alam]

cannot send any attchment due to system restrictions.

On Tue, Aug 28, 2012 at 8:20 PM, ashish koul  wrote:

> can you send us the attachment
>
>
> On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com>wrote:
>
>> Hi experts,
>>
>> I have data in once sheet in two colums like *NAME*(colum A) and 
>> *Marks*(colum
>> B). In 2nd sheet i want a formula if i enter 20 its should show me the name
>> of all the candidate who has 40 marks in 1st sheet. can it done with array
>> forumla. please help.
>>
>>
>> *Name* *Marks CT-1* SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
>> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
>> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
>> SENSENBRENNER,
>> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
>>40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
>> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
>> ROMEO,
>> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G
>> 100
>>
>>
>>
>>*Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>>
>>
>> --
>> 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 excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
>
>
>  *Visit*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/*
>
> P Before printing, think about the environment.
>
>
>
> --
> 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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ please help with array formula

[ashish koul]

can you send us the attachment

On Tue, Aug 28, 2012 at 8:08 PM, maksood alam <786maks...@gmail.com> wrote:

> Hi experts,
>
> I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
> B). In 2nd sheet i want a formula if i enter 20 its should show me the name
> of all the candidate who has 40 marks in 1st sheet. can it done with array
> forumla. please help.
>
>
> *Name* *Marks CT-1*  SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
> SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
> WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L 35 
> SENSENBRENNER,
> SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
> 40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
> SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 
> ROMEO,
> CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100
>
>
>
> *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*
>
>
> --
> 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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.com.
>
>
>



-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ please help with array formula

[maksood alam]

Hi experts,

I have data in once sheet in two colums like *NAME*(colum A) and *Marks*(colum
B). In 2nd sheet i want a formula if i enter 20 its should show me the name
of all the candidate who has 40 marks in 1st sheet. can it done with array
forumla. please help.


*Name* *Marks CT-1* SOMERSET, CHERRYL A 40 WILSON, BARBARA P 40 BLECKLEY,
SUSAN L 40 DOW, DONALD L 40 MONTE, NANCY P 40 MADEIROS, EMERY C 35 KEACH,
WALTER F 35 MADEIROS, DEBORAH MARIE 35 PAUL, RICHARD A 35 PAUL, JOAN L
35 SENSENBRENNER,
SUSAN   35 BELOTTI, TIMOTHY V 35 BENNING, MALCOLM J 35 BENNING, VIRGINIA
40 ROLLINS, ANNETTE   40 CRATTY, CYNTHIA   40 RYAN, PHYLLIS   100 SPENCER,
SUSAN   100 VANALSTYNE, DAVID E 75 LINN, DANIEL B 100 BENSMAN, SUE B 100 ROMEO,
CONNIE R 75 GREENHOLZ, MICHAEL J 75 LINN, CAROL   100 RYMSKI, JOSEPH G 100



   *Marks on CT-1* *40* *List the Name of CT-1 Paper as per Scores*

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

$$Excel-Macros$$ Need Help with a MAX NETWORKDAYS Formula

[LJ]

Greetings!

I have been using the formula below to calculate the time between a start 
and end date and time during the work hours of 6AM and 7PM. The format for 
the results are hh:mm:ss.

=MAX(0,TIME(19,0,0)-MAX(MOD(*O2*,1),TIME(6,0,0)))+
MAX(0,(NETWORKDAYS(INT(*O2*)+1,INT(*N2*)-1)))*13/24+
MAX(0,MIN(MOD(*N2*,1),TIME(19,0,0))-TIME(6,0,0))

N2 = End Time
O2 = Start Time

I have been using the NETWORKDAYS to factor-out all other times of the day 
and the weekends. However, there are instances where work is completed 
between 7PM and 6AM, and the results of the work completed after hours are 
either 13:00:00 or 26:00:00.  I need a result of 00:00:00 to appear in 
these instances. 


-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

[vijayajith VA]

Hi Zibrean,,

Please use below formula

=TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("@",A4))-1)," ",REPT("
",99)),99))

On Tue, Aug 28, 2012 at 2:50 PM, Zibraan  wrote:

>
> Hi Team,
>
> I am looking for a formula to separate Company's name and email address
> from IDs.
>
> Please refer the snap shot below
>
>
>
>   IDS Company Email Address  Accord Soft asiapaci...@accord-soft.com 
> 
>  Accord
> Soft
> asiapaci...@accord-soft.com   ALIT h...@alit.soft.net 
> 
> ALIT
> h...@alit.soft.net  Amadee myj...@amadee.de 
> INTERNET
>  Amadee
> INTERNET
> myj...@amadee.de  AMBER india_j...@ambernetworks.com Networking 
> 
> AMBER 
> Networking
> india_j...@ambernetworks.com  American Data
> Solutions ads...@gafri.com 
> Bangalore
>  American
> Data Solutions 
> Bangalore
> ads...@gafri.com  APCC - 
> irecr...@apcc.com
>  Aptech 
> corporate...@aptech.co.in
>  AQUILA h...@aquila.soft.net Graphics , EBusiness 
> 
>  Aspect Dev j...@india.aspectdv.com Ecom 
> Bangalore
>  AUTODESK crv...@vsnl.com 
> 
>  Bharti Telesoft 
> care...@bhartitelesoft.com
>  BOSCALLEO h...@boscalleo.com 
> Ecomm
>  BPL Innovision - j...@bplinnovision.com 
> 
>  car...@sonata-software.com 
> 
>  Cerebra 
> j...@cerebracomputers.com
>  CGSmith - 
> res...@cgs.cgsmith.soft.net
>  CIRRUS LOGIC 
> h...@cirrus.stpp.soft.net
>  CIS hrtele...@cisindia.com 
> 
>  CISCO india_j...@cisco.com 
> Networking
>
>
> Regards,
> Lucky
>
> --
> 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

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

[Kuldeep Singh]

Woh...

Great Noorain Sir.

Regards,
Kuldeep Singh

On Tue, Aug 28, 2012 at 3:53 PM, NOORAIN ANSARI wrote:

> Dear Kuldeep,
>
> We can also use below alternative solution in pivot table..
>
> Manually Create a Union Query
>
> If you can't combine your data on a single worksheet, another solution is
> to create named ranges in an Excel file, and use MS Query to combine the
> data. There are sample files here:
> http://www.contextures.com/excelfiles.html#PT0007
>
> Then, use the Union query result as the pivot table's source data.
>
> [image: pivot union query]
>
> With this solution, you’ll end up with a normal pivot table, with none of
> the limitations. However, it’s a bit tedious to set up, especially if you
> have more than a couple of tables.
> Use a Macro to Create a Union Query
>
> Instead of manually setting up a union query, you can use the code in a
> sample file from Excel MVPs, Kirill 
> Lapin(KL), with amendments 
> by Héctor
> Miguel Orozco Diaz .
>
> Before you use the sample code, replace the sample sheet names with the
> sheet names in your workbook.
>
> For example, if your sheet names are "East" and "West", change this line
> of code:
>
> arrSheets = Array ("Ontario", "Alberta")
>
> to this
>
> arrSheets = Array ("East", "West")
>
> [image: pivot multiple sheets code]
>
> In the code, you can also change the location where the pivot table will
> be added. In the sample file, the TableDestination is set for the active
> sheet, in range A1.
>
> [image: pivot multiple sheets location]
>
> Then, after you make those small changes, click the button on the
> worksheet, and a summary pivot table is automatically created.
>
> To download the sample file from Kirill and Héctor, click here: Pivot
> Table From Multiple 
> Sheets
> .
>
>
> On Tue, Aug 28, 2012 at 3:39 PM, Kuldeep Singh wrote:
>
>>
>> Yes Noorain Sir,
>>
>> Pivot Table is great solution for this query.
>>
>>Code 16-08-12 17-08-12 18-08-12  4656113 7402 8231 7231
>> 4656114 7403 8232 7232  4656115 7404 8233 7233  4656116 7405
>> 8234 7234  4656117 7406 8235 7235  4656118 7407 8236 7236
>> 4656119 7408 8237 7237  4656120 7409 8238 7238  4656121 7410
>> 8239 7239  4656122 7411 8240 7240  4656123 7412 8241 7241
>> 4656124 7413 8242 7242  4656125 7414 8243 7243  Grand Total
>> Regards,
>> Kuldeep Singh
>>
>> On Tue, Aug 28, 2012 at 3:28 PM, NOORAIN ANSARI > > wrote:
>>
>>> Dear Sagar,
>>>
>>> without macro you can use this option in Pivot table
>>>
>>>
>>>
>>> On Fri, Aug 17, 2012 at 7:41 PM, SAGAR KASANGOTTUWAR <
>>> sagarkasangottu...@gmail.com> wrote:
>>>
 Dear Friends,

 I want combine the data from other worksheets to one specific worksheet
 so kindly give me the fastest way to do same task.

 Note. I HAVE NEAR ABOUT 200 worksheets which I WANT to combine.


 THANKS IN ADVANCE,

 Regards,

 CA KSAGAR

 --
 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 excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.com.



>>>
>>>
>>>
>>> --
>>> With Regards,
>>> Noorain Ansari
>>> http:// 
>>> noorainansari.com
>>> http:// 
>>> excelvbaclinic.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, 

$$Excel-Macros$$ Re: time hours formula help

[bpascal123]

Try with ROUNDDOWN rounddown excel function to convert this into real 
number respective of positive or negative values (i sent you the file 
previously but you deleted my sheet...)

On Tuesday, August 28, 2012 12:06:30 PM UTC+1, padsin bawa wrote:
>
> Hi,
>
> I have a workbook that requires a specific time formula that can show 
> negative time offset as well as positive.
>
> I first would like negative offset to appear as negative offset (see 
> yellow highlight)
>
> Then I would like if the formula can do this, to have other time show with 
> + for positive time difference.
>
> Please look expected results column on worksheet
> Thanks
> Pad
>

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

[Zibraan]

but it has more than 130 email addresses it is not possible manually...



On Tue, Aug 28, 2012 at 5:28 PM, SAGAR KASANGOTTUWAR <
sagarkasangottu...@gmail.com> wrote:

> Hi Lucky,
>
> You can use text to column fuction and put delimited from @. Then you can
> manually replace com/net etc.
>
> Please seperate the if two mail addresses in one cell.
>
> Regards,
> KSAGAR
>
> On Tue, Aug 28, 2012 at 4:40 PM, David Grugeon wrote:
>
>> Hi Noorain
>>
>> It seems easy enough to create a UDF which finds the @ and then steps
>> back until it finds a space.  This will define the point to split the
>> string.  No time to do it at the moment.
>>
>>
>> On 28 August 2012 20:39, Zibraan  wrote:
>>
>>>
>>> PFA...
>>>
>>>
>>> On Tue, Aug 28, 2012 at 4:08 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Sure zibraan,

 Can you share a sample sheet.


 On Tue, Aug 28, 2012 at 3:47 PM, Zibraan  wrote:

> ok atleast can we extract email address
>
>
>
> On Tue, Aug 28, 2012 at 3:01 PM, NOORAIN ANSARI <
> noorain.ans...@gmail.com> wrote:
>
>> Dear Zibraan,
>>
>> I think it is very difficult to separate company Name and ID. because
>> criteria is changing with word by word.
>> Excel Function can't recognize company name.
>>
>> If you provide specific criteria then it can be done.
>>
>>
>>
>>
>>
>> On Tue, Aug 28, 2012 at 2:50 PM, Zibraan wrote:
>>
>>>
>>> Hi Team,
>>>
>>> I am looking for a formula to separate Company's name and email
>>> address from IDs.
>>>
>>> Please refer the snap shot below
>>>
>>>
>>>
>>>   IDS Company Email Address  Accord
>>> Soft asiapaci...@accord-soft.com 
>>> 
>>>  Accord
>>> Soft
>>> asiapaci...@accord-soft.com   ALIT h...@alit.soft.net 
>>> 
>>> ALIT
>>> h...@alit.soft.net  Amadee myj...@amadee.de 
>>> INTERNET
>>>  Amadee
>>> INTERNET
>>> myj...@amadee.de  AMBER india_j...@ambernetworks.com Networking 
>>> 
>>> AMBER 
>>> Networking
>>> india_j...@ambernetworks.com  American Data
>>> Solutions ads...@gafri.com 
>>> Bangalore
>>>  American
>>> Data Solutions 
>>> Bangalore
>>> ads...@gafri.com  APCC - 
>>> irecr...@apcc.com
>>>  Aptech 
>>> corporate...@aptech.co.in
>>>  AQUILA h...@aquila.soft.net Graphics , EBusiness 
>>> 
>>>  Aspect Dev j...@india.aspectdv.com Ecom 
>>> Bangalore
>>>  AUTODESK crv...@vsnl.com 
>>> 
>>>  Bharti Telesoft 
>>> care...@bhartitelesoft.com
>>>  BOSCALLEO h...@boscalleo.com 
>>> Ecomm
>>>  BPL Innovision - j...@bplinnovision.com 
>>> 
>>>  car...@sonata-software.com 
>>> 
>>>  Cerebra 
>>> j...@cerebracomputers.com

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

[SAGAR KASANGOTTUWAR]

Hi Lucky,

You can use text to column fuction and put delimited from @. Then you can
manually replace com/net etc.

Please seperate the if two mail addresses in one cell.

Regards,
KSAGAR

On Tue, Aug 28, 2012 at 4:40 PM, David Grugeon  wrote:

> Hi Noorain
>
> It seems easy enough to create a UDF which finds the @ and then steps back
> until it finds a space.  This will define the point to split the string.
>  No time to do it at the moment.
>
>
> On 28 August 2012 20:39, Zibraan  wrote:
>
>>
>> PFA...
>>
>>
>> On Tue, Aug 28, 2012 at 4:08 PM, NOORAIN ANSARI > > wrote:
>>
>>> Sure zibraan,
>>>
>>> Can you share a sample sheet.
>>>
>>>
>>> On Tue, Aug 28, 2012 at 3:47 PM, Zibraan  wrote:
>>>
 ok atleast can we extract email address



 On Tue, Aug 28, 2012 at 3:01 PM, NOORAIN ANSARI <
 noorain.ans...@gmail.com> wrote:

> Dear Zibraan,
>
> I think it is very difficult to separate company Name and ID. because
> criteria is changing with word by word.
> Excel Function can't recognize company name.
>
> If you provide specific criteria then it can be done.
>
>
>
>
>
> On Tue, Aug 28, 2012 at 2:50 PM, Zibraan  wrote:
>
>>
>> Hi Team,
>>
>> I am looking for a formula to separate Company's name and email
>> address from IDs.
>>
>> Please refer the snap shot below
>>
>>
>>
>>   IDS Company Email Address  Accord Soft asiapaci...@accord-soft.com 
>> 
>>  Accord
>> Soft
>> asiapaci...@accord-soft.com   ALIT h...@alit.soft.net 
>> 
>> ALIT
>> h...@alit.soft.net  Amadee myj...@amadee.de 
>> INTERNET
>>  Amadee
>> INTERNET
>> myj...@amadee.de  AMBER india_j...@ambernetworks.com Networking 
>> 
>> AMBER 
>> Networking
>> india_j...@ambernetworks.com  American Data
>> Solutions ads...@gafri.com 
>> Bangalore
>>  American
>> Data Solutions 
>> Bangalore
>> ads...@gafri.com  APCC - 
>> irecr...@apcc.com
>>  Aptech 
>> corporate...@aptech.co.in
>>  AQUILA h...@aquila.soft.net Graphics , EBusiness 
>> 
>>  Aspect Dev j...@india.aspectdv.com Ecom 
>> Bangalore
>>  AUTODESK crv...@vsnl.com 
>> 
>>  Bharti Telesoft 
>> care...@bhartitelesoft.com
>>  BOSCALLEO h...@boscalleo.com 
>> Ecomm
>>  BPL Innovision - j...@bplinnovision.com 
>> 
>>  car...@sonata-software.com 
>> 
>>  Cerebra 
>> j...@cerebracomputers.com
>>  CGSmith - 
>> res...@cgs.cgsmith.soft.net
>>  CIRRUS LOGIC 
>> h...@cirrus.stpp.soft.net

Re: $$Excel-Macros$$ Q&A for Excel, Word & PPT

[NOORAIN ANSARI]

Hi Krishna,

Very useful Q&A, thanks for sharing with us.

On Tue, Aug 28, 2012 at 4:45 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:

> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
> and may also be privileged. If you are not the intended recipient of this
> e-mail you may not copy, forward, disclose or otherwise use it or any part
> of it in any form whatsoever. If you are not the intended recipient please
> telephone or e-mail the sender and delete this message and any attachment
> from your system."
>



-- 
With Regards,
Noorain Ansari
http:// 
noorainansari.com
http:// 
excelvbaclinic.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

[SAGAR KASANGOTTUWAR]

Thanks a lot Hilary...

On Tue, Aug 28, 2012 at 2:25 PM, NOORAIN ANSARI wrote:

> Dear Sagar,
>
> Please use attached study material to create Dashboard.
> Hope it will help you.
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.com
>
>
> On Tue, Aug 28, 2012 at 10:01 AM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear Hilary,
>>
>> I want to make dashboard for share accounting and calculations for income
>> tax.
>>
>> Kindly help me for the same.
>>
>>
>> Thanks & Regards,
>>
>> KSAGAR
>>
>>
>> On Mon, Aug 27, 2012 at 5:40 PM, NOORAIN ANSARI > > wrote:
>>
>>> Nice Creativity HilaryThanks to sharing with us.
>>>
>>> On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey wrote:
>>>
 Hi Guys,

 i just completed an upgrade of my stock market dashboard, pls use as
 you will. cheers

 --
 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 excel-macros@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> 

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

[David Grugeon]

Hi Noorain

It seems easy enough to create a UDF which finds the @ and then steps back
until it finds a space.  This will define the point to split the string.
 No time to do it at the moment.

On 28 August 2012 20:39, Zibraan  wrote:

>
> PFA...
>
>
> On Tue, Aug 28, 2012 at 4:08 PM, NOORAIN ANSARI 
> wrote:
>
>> Sure zibraan,
>>
>> Can you share a sample sheet.
>>
>>
>> On Tue, Aug 28, 2012 at 3:47 PM, Zibraan  wrote:
>>
>>> ok atleast can we extract email address
>>>
>>>
>>>
>>> On Tue, Aug 28, 2012 at 3:01 PM, NOORAIN ANSARI <
>>> noorain.ans...@gmail.com> wrote:
>>>
 Dear Zibraan,

 I think it is very difficult to separate company Name and ID. because
 criteria is changing with word by word.
 Excel Function can't recognize company name.

 If you provide specific criteria then it can be done.





 On Tue, Aug 28, 2012 at 2:50 PM, Zibraan  wrote:

>
> Hi Team,
>
> I am looking for a formula to separate Company's name and email
> address from IDs.
>
> Please refer the snap shot below
>
>
>
>   IDS Company Email Address  Accord Soft asiapaci...@accord-soft.com 
> 
>  Accord
> Soft
> asiapaci...@accord-soft.com   ALIT h...@alit.soft.net 
> 
> ALIT
> h...@alit.soft.net  Amadee myj...@amadee.de 
> INTERNET
>  Amadee
> INTERNET
> myj...@amadee.de  AMBER india_j...@ambernetworks.com Networking 
> 
> AMBER 
> Networking
> india_j...@ambernetworks.com  American Data
> Solutions ads...@gafri.com 
> Bangalore
>  American
> Data Solutions 
> Bangalore
> ads...@gafri.com  APCC - 
> irecr...@apcc.com
>  Aptech 
> corporate...@aptech.co.in
>  AQUILA h...@aquila.soft.net Graphics , EBusiness 
> 
>  Aspect Dev j...@india.aspectdv.com Ecom 
> Bangalore
>  AUTODESK crv...@vsnl.com 
> 
>  Bharti Telesoft 
> care...@bhartitelesoft.com
>  BOSCALLEO h...@boscalleo.com 
> Ecomm
>  BPL Innovision - j...@bplinnovision.com 
> 
>  car...@sonata-software.com 
> 
>  Cerebra 
> j...@cerebracomputers.com
>  CGSmith - 
> res...@cgs.cgsmith.soft.net
>  CIRRUS LOGIC 
> h...@cirrus.stpp.soft.net
>  CIS hrtele...@cisindia.com 
> 
>  CISCO india_j...@cisco.com 
> Networking

$$Excel-Macros$$ time hours formula help

[padsin bawa]

Hi,

I have a workbook that requires a specific time formula that can show 
negative time offset as well as positive.

I first would like negative offset to appear as negative offset (see yellow 
highlight)

Then I would like if the formula can do this, to have other time show with 
+ for positive time difference.

Please look expected results column on worksheet
Thanks
Pad

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Timezone.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

[NOORAIN ANSARI]

Sure zibraan,

Can you share a sample sheet.

On Tue, Aug 28, 2012 at 3:47 PM, Zibraan  wrote:

> ok atleast can we extract email address
>
>
>
> On Tue, Aug 28, 2012 at 3:01 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Zibraan,
>>
>> I think it is very difficult to separate company Name and ID. because
>> criteria is changing with word by word.
>> Excel Function can't recognize company name.
>>
>> If you provide specific criteria then it can be done.
>>
>>
>>
>>
>>
>> On Tue, Aug 28, 2012 at 2:50 PM, Zibraan  wrote:
>>
>>>
>>> Hi Team,
>>>
>>> I am looking for a formula to separate Company's name and email address
>>> from IDs.
>>>
>>> Please refer the snap shot below
>>>
>>>
>>>
>>>   IDS Company Email Address  Accord Soft asiapaci...@accord-soft.com 
>>> 
>>>  Accord
>>> Soft
>>> asiapaci...@accord-soft.com   ALIT h...@alit.soft.net 
>>> 
>>> ALIT
>>> h...@alit.soft.net  Amadee myj...@amadee.de 
>>> INTERNET
>>>  Amadee
>>> INTERNET
>>> myj...@amadee.de  AMBER india_j...@ambernetworks.com Networking 
>>> 
>>> AMBER 
>>> Networking
>>> india_j...@ambernetworks.com  American Data
>>> Solutions ads...@gafri.com 
>>> Bangalore
>>>  American
>>> Data Solutions 
>>> Bangalore
>>> ads...@gafri.com  APCC - 
>>> irecr...@apcc.com
>>>  Aptech 
>>> corporate...@aptech.co.in
>>>  AQUILA h...@aquila.soft.net Graphics , EBusiness 
>>> 
>>>  Aspect Dev j...@india.aspectdv.com Ecom 
>>> Bangalore
>>>  AUTODESK crv...@vsnl.com 
>>> 
>>>  Bharti Telesoft 
>>> care...@bhartitelesoft.com
>>>  BOSCALLEO h...@boscalleo.com 
>>> Ecomm
>>>  BPL Innovision - j...@bplinnovision.com 
>>> 
>>>  car...@sonata-software.com 
>>> 
>>>  Cerebra 
>>> j...@cerebracomputers.com
>>>  CGSmith - 
>>> res...@cgs.cgsmith.soft.net
>>>  CIRRUS LOGIC 
>>> h...@cirrus.stpp.soft.net
>>>  CIS hrtele...@cisindia.com 
>>> 
>>>  CISCO india_j...@cisco.com 
>>> Networking
>>>
>>>
>>> Regards,
>>> Lucky
>>>
>>> --
>>> 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 quest

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

[NOORAIN ANSARI]

Dear Kuldeep,

We can also use below alternative solution in pivot table..

Manually Create a Union Query

If you can't combine your data on a single worksheet, another solution is
to create named ranges in an Excel file, and use MS Query to combine the
data. There are sample files here:
http://www.contextures.com/excelfiles.html#PT0007

Then, use the Union query result as the pivot table's source data.

[image: pivot union query]

With this solution, you’ll end up with a normal pivot table, with none of
the limitations. However, it’s a bit tedious to set up, especially if you
have more than a couple of tables.
Use a Macro to Create a Union Query

Instead of manually setting up a union query, you can use the code in a
sample file from Excel MVPs, Kirill
Lapin(KL), with
amendments by Héctor
Miguel Orozco Diaz .

Before you use the sample code, replace the sample sheet names with the
sheet names in your workbook.

For example, if your sheet names are "East" and "West", change this line of
code:

arrSheets = Array ("Ontario", "Alberta")

to this

arrSheets = Array ("East", "West")

[image: pivot multiple sheets code]

In the code, you can also change the location where the pivot table will be
added. In the sample file, the TableDestination is set for the active
sheet, in range A1.

[image: pivot multiple sheets location]

Then, after you make those small changes, click the button on the
worksheet, and a summary pivot table is automatically created.

To download the sample file from Kirill and Héctor, click here: Pivot Table
>From Multiple Sheets 
.


On Tue, Aug 28, 2012 at 3:39 PM, Kuldeep Singh wrote:

>
> Yes Noorain Sir,
>
> Pivot Table is great solution for this query.
>
>   Code 16-08-12 17-08-12 18-08-12  4656113 7402 8231 7231
> 4656114 7403 8232 7232  4656115 7404 8233 7233  4656116 7405
> 8234 7234  4656117 7406 8235 7235  4656118 7407 8236 7236
> 4656119 7408 8237 7237  4656120 7409 8238 7238  4656121 7410
> 8239 7239  4656122 7411 8240 7240  4656123 7412 8241 7241
> 4656124 7413 8242 7242  4656125 7414 8243 7243  Grand Total
> Regards,
> Kuldeep Singh
>
> On Tue, Aug 28, 2012 at 3:28 PM, NOORAIN ANSARI 
> wrote:
>
>> Dear Sagar,
>>
>> without macro you can use this option in Pivot table
>>
>>
>>
>> On Fri, Aug 17, 2012 at 7:41 PM, SAGAR KASANGOTTUWAR <
>> sagarkasangottu...@gmail.com> wrote:
>>
>>> Dear Friends,
>>>
>>> I want combine the data from other worksheets to one specific worksheet
>>> so kindly give me the fastest way to do same task.
>>>
>>> Note. I HAVE NEAR ABOUT 200 worksheets which I WANT to combine.
>>>
>>>
>>> THANKS IN ADVANCE,
>>>
>>> Regards,
>>>
>>> CA KSAGAR
>>>
>>> --
>>> 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 excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.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.
>

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

[Kuldeep Singh]

Yes Noorain Sir,

Pivot Table is great solution for this query.

  Code 16-08-12 17-08-12 18-08-12  4656113 7402 8231 7231
4656114 7403 8232 7232  4656115 7404 8233 7233  4656116 7405
8234 7234  4656117 7406 8235 7235  4656118 7407 8236 7236
4656119 7408 8237 7237  4656120 7409 8238 7238  4656121 7410
8239 7239  4656122 7411 8240 7240  4656123 7412 8241 7241
4656124 7413 8242 7242  4656125 7414 8243 7243  Grand Total
Regards,
Kuldeep Singh

On Tue, Aug 28, 2012 at 3:28 PM, NOORAIN ANSARI wrote:

> Dear Sagar,
>
> without macro you can use this option in Pivot table
>
>
>
> On Fri, Aug 17, 2012 at 7:41 PM, SAGAR KASANGOTTUWAR <
> sagarkasangottu...@gmail.com> wrote:
>
>> Dear Friends,
>>
>> I want combine the data from other worksheets to one specific worksheet
>> so kindly give me the fastest way to do same task.
>>
>> Note. I HAVE NEAR ABOUT 200 worksheets which I WANT to combine.
>>
>>
>> THANKS IN ADVANCE,
>>
>> Regards,
>>
>> CA KSAGAR
>>
>> --
>> 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 excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.

Re: $$Excel-Macros$$ Formula to Separate Company name and Email Address

[NOORAIN ANSARI]

Dear Zibraan,

I think it is very difficult to separate company Name and ID. because
criteria is changing with word by word.
Excel Function can't recognize company name.

If you provide specific criteria then it can be done.




On Tue, Aug 28, 2012 at 2:50 PM, Zibraan  wrote:

>
> Hi Team,
>
> I am looking for a formula to separate Company's name and email address
> from IDs.
>
> Please refer the snap shot below
>
>
>
>   IDS Company Email Address  Accord Soft asiapaci...@accord-soft.com 
> 
>  Accord
> Soft
> asiapaci...@accord-soft.com   ALIT h...@alit.soft.net 
> 
> ALIT
> h...@alit.soft.net  Amadee myj...@amadee.de 
> INTERNET
>  Amadee
> INTERNET
> myj...@amadee.de  AMBER india_j...@ambernetworks.com Networking 
> 
> AMBER 
> Networking
> india_j...@ambernetworks.com  American Data
> Solutions ads...@gafri.com 
> Bangalore
>  American
> Data Solutions 
> Bangalore
> ads...@gafri.com  APCC - 
> irecr...@apcc.com
>  Aptech 
> corporate...@aptech.co.in
>  AQUILA h...@aquila.soft.net Graphics , EBusiness 
> 
>  Aspect Dev j...@india.aspectdv.com Ecom 
> Bangalore
>  AUTODESK crv...@vsnl.com 
> 
>  Bharti Telesoft 
> care...@bhartitelesoft.com
>  BOSCALLEO h...@boscalleo.com 
> Ecomm
>  BPL Innovision - j...@bplinnovision.com 
> 
>  car...@sonata-software.com 
> 
>  Cerebra 
> j...@cerebracomputers.com
>  CGSmith - 
> res...@cgs.cgsmith.soft.net
>  CIRRUS LOGIC 
> h...@cirrus.stpp.soft.net
>  CIS hrtele...@cisindia.com 
> 
>  CISCO india_j...@cisco.com 
> Networking
>
>
> Regards,
> Lucky
>
> --
> 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 

$$Excel-Macros$$ Formula to Separate Company name and Email Address

[Zibraan]

Hi Team,

I am looking for a formula to separate Company's name and email address
from IDs.

Please refer the snap shot below



  IDS Company Email Address  Accord Soft asiapaci...@accord-soft.com

Accord
Soft
asiapaci...@accord-soft.com   ALIT h...@alit.soft.net

ALIT
h...@alit.soft.net  Amadee myj...@amadee.de
INTERNET
Amadee
INTERNET
myj...@amadee.de  AMBER india_j...@ambernetworks.com Networking

AMBER 
Networking
india_j...@ambernetworks.com  American Data
Solutions ads...@gafri.com
Bangalore
American
Data Solutions 
Bangalore
ads...@gafri.com  APCC -
irecr...@apcc.com
 Aptech 
corporate...@aptech.co.in
 AQUILA h...@aquila.soft.net Graphics , EBusiness

 Aspect Dev j...@india.aspectdv.com Ecom
Bangalore
 AUTODESK crv...@vsnl.com

 Bharti Telesoft
care...@bhartitelesoft.com
 BOSCALLEO h...@boscalleo.com
Ecomm
 BPL Innovision - j...@bplinnovision.com

 car...@sonata-software.com

 Cerebra 
j...@cerebracomputers.com
 CGSmith - 
res...@cgs.cgsmith.soft.net
 CIRRUS LOGIC
h...@cirrus.stpp.soft.net
 CIS hrtele...@cisindia.com

 CISCO india_j...@cisco.com
Networking


Regards,
Lucky

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.




Book1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

[respuzy]

You asked of DB for share accounting and calculations for income tax. That is 
the domain area am referrin to
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: SAGAR KASANGOTTUWAR 
Sender: excel-macros@googlegroups.com
Date: Tue, 28 Aug 2012 13:20:24 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Dear Hilary,

Can you give some material for understanding DOMAIN area.?

That will help me a lot...

Thanks & Regards,
Sagar Kasangottuwar



On Tue, Aug 28, 2012 at 1:13 PM,  wrote:

> **
> Hi KSAGAR
>
> If one doesn't have an understanding of the domain area you can't design a
> dashboard for it. I don't hv much operating knowledge of what you are
> describing.
> Thnks
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * SAGAR KASANGOTTUWAR 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 28 Aug 2012 10:01:08 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD
>
> Dear Hilary,
>
> I want to make dashboard for share accounting and calculations for income
> tax.
>
> Kindly help me for the same.
>
>
> Thanks & Regards,
>
> KSAGAR
>
>
> On Mon, Aug 27, 2012 at 5:40 PM, NOORAIN ANSARI 
> wrote:
>
>> Nice Creativity HilaryThanks to sharing with us.
>>
>> On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey wrote:
>>
>>> Hi Guys,
>>>
>>> i just completed an upgrade of my stock market dashboard, pls use as you
>>> will. cheers
>>>
>>> --
>>> 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 excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.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 excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.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, o

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

[SAGAR KASANGOTTUWAR]

Dear Hilary,

Can you give some material for understanding DOMAIN area.?

That will help me a lot...

Thanks & Regards,
Sagar Kasangottuwar



On Tue, Aug 28, 2012 at 1:13 PM,  wrote:

> **
> Hi KSAGAR
>
> If one doesn't have an understanding of the domain area you can't design a
> dashboard for it. I don't hv much operating knowledge of what you are
> describing.
> Thnks
> Sent from my BlackBerry® smartphone from Airtel Ghana
> --
> *From: * SAGAR KASANGOTTUWAR 
> *Sender: * excel-macros@googlegroups.com
> *Date: *Tue, 28 Aug 2012 10:01:08 +0530
> *To: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD
>
> Dear Hilary,
>
> I want to make dashboard for share accounting and calculations for income
> tax.
>
> Kindly help me for the same.
>
>
> Thanks & Regards,
>
> KSAGAR
>
>
> On Mon, Aug 27, 2012 at 5:40 PM, NOORAIN ANSARI 
> wrote:
>
>> Nice Creativity HilaryThanks to sharing with us.
>>
>> On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey wrote:
>>
>>> Hi Guys,
>>>
>>> i just completed an upgrade of my stock market dashboard, pls use as you
>>> will. cheers
>>>
>>> --
>>> 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 excel-macros@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> excel-macros+unsubscr...@googlegroups.com.
>>>
>>>
>>>
>>
>>
>>
>> --
>> With Regards,
>> Noorain Ansari
>> http:// 
>> noorainansari.com
>> http:// 
>> excelvbaclinic.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 excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.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
> "M

Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

[respuzy]

Hi KSAGAR

If one doesn't  have an understanding of the domain area you can't design a 
dashboard for it. I don't hv much operating knowledge of what you are 
describing. 
Thnks
Sent from my BlackBerry® smartphone from Airtel Ghana

-Original Message-
From: SAGAR KASANGOTTUWAR 
Sender: excel-macros@googlegroups.com
Date: Tue, 28 Aug 2012 10:01:08 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD

Dear Hilary,

I want to make dashboard for share accounting and calculations for income
tax.

Kindly help me for the same.


Thanks & Regards,

KSAGAR


On Mon, Aug 27, 2012 at 5:40 PM, NOORAIN ANSARI wrote:

> Nice Creativity HilaryThanks to sharing with us.
>
> On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey  wrote:
>
>> Hi Guys,
>>
>> i just completed an upgrade of my stock market dashboard, pls use as you
>> will. cheers
>>
>> --
>> 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 excel-macros@googlegroups.com.
>> To unsubscribe from this group, send email to
>> excel-macros+unsubscr...@googlegroups.com.
>>
>>
>>
>
>
>
> --
> With Regards,
> Noorain Ansari
> http:// 
> noorainansari.com
> http:// 
> excelvbaclinic.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 excel-macros@googlegroups.com.
> To unsubscribe from this group, send email to
> excel-macros+unsubscr...@googlegroups.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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.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 title

$$Excel-Macros$$ Need MS Office 2010

[Suman]

Dear Group!!
Can any one provide me full setup for MS Office 10?

Regards,
@Suman
Send on the move with Galexy y.

-- 
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 excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.