Re: $$Excel-Macros$$ Extract desired data

[Maries]

Hi,

Try below array formula,

=MAX(IFERROR(RIGHT(C2,{1,2,3,4,5,6,7,8,9,10})*1,""))

Apply with Ctrl + Shift + Enter.

Regards,

MARIES

On Wed, Apr 4, 2012 at 10:21 AM, Waseem Saifi  wrote:

> please check attached file.
>
>
> On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote:
>
>> Dear Group,
>>
>> How to extract 6 digit numbers from right if its number & convert this to
>> numbers by formula. See the attached file.
>>
>> Regards,
>>
>> Aamir Shahzad
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Extract desired data

[Waseem Saifi]

please check attached file.


On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote:

> Dear Group,
>
> How to extract 6 digit numbers from right if its number & convert this to
> numbers by formula. See the attached file.
>
> Regards,
>
> Aamir Shahzad
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

Re: $$Excel-Macros$$ Re: Exact names Find

[Deba Ranjan]

*Dear Expert


  Can you please explain me the following :-
*=INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,3,4,5,6,7,8,9,10})&"*",SUBSTITUTE(C$6:C$47,"
",""),0),"")))

There i find -C$6:C$47, i mean $ symbol is there . can you please tell
me how the $ symbol arise.



Thanks & Regards,*
*

*Deba Ranjan P***


On Tue, Apr 3, 2012 at 2:41 PM, CoRe  wrote:

>
> Hello Bhaity,
>
> PFA.
>
> I used Trim in first instance to loose all the spaces, 2nd thing ID
> collumn has been sort as ascending for a better match. (descending problem
> , haven't figured out).
>
>
> good luck & hope it helps
>
>
> On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote:
>>
>> Dear Expert,
>>
>>   Please find the attached file. i just want the exact and match name to
>> find in another columns. please help me in urgent basis dear experts.
>>
>>
>>
>>
>> Thanks & Regards,*
>> *
>>
>> *Deba Ranjan P***
>>
>>
> On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote:
>>
>> Dear Expert,
>>
>>   Please find the attached file. i just want the exact and match name to
>> find in another columns. please help me in urgent basis dear experts.
>>
>>
>>
>>
>> Thanks & Regards,*
>> *
>>
>> *Deba Ranjan P***
>>
>>   --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

[Darwin Chan]

Dear Pawel,

yes, this is what i m looking for, thanks for your help~[?]



2012/4/3 pawel lupinski 

> I realy don't know what are you looking for so check if this is what you
> are looking for.
>
> Regards,
>
> Pawel
>
>   *From:* Darwin Chan 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, April 3, 2012 12:02 PM
> *Subject:* $$Excel-Macros$$ To calculate the maximum and minimum
> appearance in Staff Roster Plan
>
> Dear all,
>
> I have a roster with staff allocated on different roster plan, i.e.
> different working hours. I have a task to analyse the maximum and minimum
> of staff who would appear at concurrent period.
>
> However, volume of data is huge and formula is needed for assistance in
> analysis. I have attached one file for simplicity.
>
> Any help would be appreciated.
>
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Best Regards,
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<<332.gif>>

Re: $$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates.

[Maries]

Hi,

PFA. Use below Array formula,

=IFERROR(INDEX($B$4:$E$4,MATCH(B$9,OFFSET($A$4,MATCH($A10,$A$5:$A$7,0),1,1,4),0)),"")

Regards,

MARIES.

On Wed, Apr 4, 2012 at 7:16 AM, rekha siri  wrote:

>  Hi I need assistance in finding the right formula to substitute the value
> to dates in 
> [image: Alexei De Guzman][image: Just Joined]
> *Alexei De Guzman * Apr
> 3, 2012 9:03 PM
>
> Hi,
>
>
>
> I am trying to come up with the formula to pull up dates from a tracker
> for each individual. Example:
>
>
>  *Name
> * *April 1
> * *April 2
> * *April 3* *April 4
> * Alexei de Guzman VL   Joseph Roxas  SL  Kelly Furio H
>
>
>  *Name* *VL* *H* *SL*  Alexei de Guzman April 1  Joseph Roxas  April 3
>
>
>
> So I am making a summary tracker that will break it down by dates for each
> name. I have tried using Countif for a particular value but I have been
> looking for a formula to come up to pull it up by dates.
>
>
>
> I hope someone already knows the answer.
>
>
>
> Thank you very much.
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

$$Excel-Macros$$ Need assistance in finding formula to substitute the values to dates.

[rekha siri]

Hi I need assistance in finding the right formula to substitute the value
to dates in 
[image: Alexei De Guzman][image: Just Joined]
*Alexei De Guzman * Apr
3, 2012 9:03 PM

Hi,



I am trying to come up with the formula to pull up dates from a tracker for
each individual. Example:


*Name
**April 1
**April 2
**April 3**April 4
*Alexei de GuzmanVLJoseph RoxasSLKelly FurioH


*Name**VL**H**SL*Alexei de GuzmanApril 1Joseph RoxasApril 3



So I am making a summary tracker that will break it down by dates for each
name. I have tried using Countif for a particular value but I have been
looking for a formula to come up to pull it up by dates.



I hope someone already knows the answer.



Thank you very much.

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need Power point code help

[rekha siri]

Hi Ashish,

Thanks alot i Just referenced the Sheet name and decreased the size.

i am able to get the desired result.

Thanks for your help.

Regards,
Rekha

On Mon, Apr 2, 2012 at 9:15 PM, ashish koul  wrote:

> check this make change as per your requirement
>
>
>
> On Mon, Apr 2, 2012 at 10:27 AM, rekha siri wrote:
>
>> hi Ashish,
>>
>> Thanks for your link however i am unable to download macro file it is
>> stating
>>
>> Macro file not found.
>>
>> Can you please forward that macro file.
>>
>> Thanks,
>> Rekha
>>
>>
>> On Sun, Apr 1, 2012 at 6:33 PM, ashish koul wrote:
>>
>>> http://www.excelvbamacros.com/2011/06/excel-to-powerpoint-6.html
>>>
>>>
>>> On Sun, Apr 1, 2012 at 3:04 PM, rekha siri wrote:
>>>
 hi Experts,

 i am attaching a macro which copies the two charts from excel and
 pastes in ppt.

 but can some one help to modify this code to paste two charts in one
 slide instead of two slides.


 Thanks,
 Rekha

 --
 FORUM RULES (986+ 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.

 NOTE : Don't ever post personal or confidential data in a workbook.
 Forum owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com

>>>
>>>
>>>
>>> --
>>> *Regards*
>>> * *
>>> *Ashish Koul*
>>> *http://www.excelvbamacros.com/*
>>> *http://www.accessvbamacros.com/* 
>>>
>>>
>>> P Before printing, think about the environment.
>>>
>>>
>>>  --
>>> FORUM RULES (986+ 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.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>  --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *http://www.excelvbamacros.com/*
> *http://www.accessvbamacros.com/* 
>
>
> P Before printing, think about the environment.
>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> 

$$Excel-Macros$$ VBA Classes

[NRao Mynampati]

HI Team,

Gnanainfo will conducting Weekend VBA Classes at Hyderabad on 07-04-2012 &
08-04-2012 ,14-04-2012 & 15-04-2012.


For more details you can reach :

gnanainfo@gmail.com

09703091552.



Thanks and Regards
Simha

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Prefix a pic in the userform caption

[santosh subudhi]

Hi Group,

I want to prefix a picture in the userform caption in excel.

Would request to help me with that.
-- 
Regards
Santosh
santoshkumar.subu...@gmail.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Exact names Find

[ChilExcel]

Great job Haseeb  !!!
 thank you


chilexcel


2012/4/3 Aamir Shahzad 

> Haseeb,
>
> Can you breif your formula if I want to understand the logic.
>
> Regards,
>
> Aamir Shahzad
>
> On Tue, Apr 3, 2012 at 11:44 PM, Haseeb A wrote:
>
>> Hello Deba,
>>
>> Try this in E6 with *CTRL+SHIFT+ENTER*, rather than just ENTER
>>
>> =INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,3,4,5,6,7,8,9,10})&"*",SUBSTITUTE(C$6:C$47,"
>> ",""),0),"")))
>>
>> Then drag down
>>
>> ___
>> HTH, Haseeb
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
>
> Regards,
>
> Aamir Shahzad
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Extract desired data

[Jaysheel Bhasme]

Hi Aaamir,

Please find the attached data. please check and let me know is this your
requirement.

Regards,
Jaysheel Bhasme

On Wed, Apr 4, 2012 at 1:17 AM, Aamir Shahzad wrote:

> Dear Group,
>
> How to extract 6 digit numbers from right if its number & convert this to
> numbers by formula. See the attached file.
>
> Regards,
>
> Aamir Shahzad
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

$$Excel-Macros$$ Extract desired data

[Aamir Shahzad]

Dear Group,

How to extract 6 digit numbers from right if its number & convert this to
numbers by formula. See the attached file.

Regards,

Aamir Shahzad

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

Re: $$Excel-Macros$$ Re: Exact names Find

[Aamir Shahzad]

Haseeb,

Can you breif your formula if I want to understand the logic.

Regards,

Aamir Shahzad

On Tue, Apr 3, 2012 at 11:44 PM, Haseeb A wrote:

> Hello Deba,
>
> Try this in E6 with *CTRL+SHIFT+ENTER*, rather than just ENTER
>
> =INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,3,4,5,6,7,8,9,10})&"*",SUBSTITUTE(C$6:C$47,"
> ",""),0),"")))
>
> Then drag down
>
> ___
> HTH, Haseeb
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

Regards,

Aamir Shahzad

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Exact names Find

[Haseeb A]

Hello Deba,

Try this in E6 with *CTRL+SHIFT+ENTER*, rather than just ENTER

=INDEX(C$6:C$47,MAX(IFERROR(MATCH("*"&LEFT(MID(TRIM(D6),2,10),{1,2,3,4,5,6,7,8,9,10})&"*",SUBSTITUTE(C$6:C$47,"
 
",""),0),"")))

Then drag down

___
HTH, Haseeb

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Add-in creation in excel 2007

[Raj Mahapatra]

thanks sam links are very helpful

can i use the same ribbon in all excel files..

Thanks

Rajesh Mahapatra


On Tue, Apr 3, 2012 at 1:21 AM, Sam Mathai Chacko wrote:

> This link will tell you how to add a tab in Excel
>
>
> http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/?highlight=ribbon
>
> Regards,
> Sam Mathai Chacko
>
>
> On Mon, Apr 2, 2012 at 11:40 PM, Rajan_Verma wrote:
>
>> I think u should create custom menu to display that in Ribbon
>>
>> ** **
>>
>> Rajan
>>
>> ** **
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *On Behalf Of *Raj Mahapatra
>> *Sent:* Apr/Mon/2012 11:30
>>
>> *To:* excel-macros@googlegroups.com
>> *Subject:* Re: $$Excel-Macros$$ Add-in creation in excel 2007
>>
>> ** **
>>
>> ** **
>>
>> sam, how would i get that add in as a tab in ms excel
>>
>> Thanks & Regards
>>
>> ** **
>>
>> Rajesh Mahapatra
>>
>> ** **
>>
>> ** **
>>
>> On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko 
>> wrote:
>>
>> Add-ins are designed to run in the background, and hence the file will
>> not be visible when you open it. If you go to the VBE window, you could
>> actually see that the vba project for your add-in is shown.
>> Sam Mathai Chacko
>>
>> ** **
>>
>> On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra 
>> wrote:
>>
>> hi group,
>>
>> ** **
>>
>> i wants to create addin in excel.  i have created a addin using below
>> steps, but it is not working.
>>
>> ** **
>>
>> 1.  in new workbook, i have insert a module and macro codes in it.
>>
>> 2.  then saved the same workbook using ".xlam" extension.
>>
>> 3. when i opens the same add in  in new excel.  it does not open.
>>
>> ** **
>>
>> appreciation for your assistance.
>>
>> ** **
>>
>> thanks & regards
>>
>> ** **
>>
>> Rajesh Mahapatra
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>>
>>
>> 
>>
>> --
>> Sam Mathai Chacko
>>
>> ** **
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> ** **
>>
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (986+ 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 t

$$Excel-Macros$$ Test Mail

[Rajan_Verma]

 

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Re: Exact names Find

[Rajan_Verma]

You can try this :

 

=VLOOKUP("*" &D6 &"*",$C$6:$C$47,1,0)

 

Rajan.

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of CoRe
Sent: Apr/Tue/2012 02:41
To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI
Subject: $$Excel-Macros$$ Re: Exact names Find

 


Hello Bhaity,

 

PFA.

 

I used Trim in first instance to loose all the spaces, 2nd thing ID collumn
has been sort as ascending for a better match. (descending problem , haven't
figured out).

 

 

good luck & hope it helps

 


On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote:

Dear Expert,

  Please find the attached file. i just want the exact and match name to
find in another columns. please help me in urgent basis dear experts.



 

Thanks & Regards,

Deba Ranjan P

 


On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote:

Dear Expert,

  Please find the attached file. i just want the exact and match name to
find in another columns. please help me in urgent basis dear experts.



 

Thanks & Regards,

Deba Ranjan P

 

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Last Visit Invoice Details with formula

[Amit Desai (MERU)]

Dear All,

Could you please help me with a formula?

Attached is a sample file where in I need in column (W, X & Y) Invoice date, 
Invoice Number & Inv. Amount for each cab's previous last visit. Similarly I 
need in column (Z, AA & AB) Invoice date, Invoice Number & Inv. Amount for each 
cab's previous 2nd last visit.

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.

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Invoice Tracker for Web.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Looking for Excel/Access vba job with 6 years of experience

[Sam Mathai Chacko]

Kavita, I am looking for such a person. I'm sure you remember me from good
old days.

Regards,
Sam

On Tue, Apr 3, 2012 at 6:35 PM, kavita ahuja wrote:

> Hi Friends,
>
> I am looking for a job in excel/Access vba with 6 years experience in
> gurgaon.
> Please contact me if you know about any opening in gurgaon.
>
> Would appreciate your help.
>
>
>
> Many thanks ,
> Kavita
>
> --
> FORUM RULES (986+ 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.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Exact names Find

[Deba Ranjan]

Hi expert,

   Please it is not working. will you please do it in the excel itself.



Regards
deba

On Tue, Apr 3, 2012 at 1:29 PM, Deba Ranjan  wrote:

> Dear Expert,
>
>   Please find the attached file. i just want the exact and match name to
> find in another columns. please help me in urgent basis dear experts.
>
>
>
>
> Thanks & Regards,*
> *
>
> *Deba Ranjan P***
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 

*
THANKS & REGARDS

DEBARANJAN PEGU *

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Count formula

[Rajender Soni]

Dear Shrinivas

Try the below mentioned formulae also:

*=COUNTIFS(D7:D955,">=05/01/2012",D7:D955,"<07/01/2012")*


Regards,
Rajender Soni | +91 750 322 55 50

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Looking for Excel/Access vba job with 6 years of experience

[kavita ahuja]

Hi Friends,

I am looking for a job in excel/Access vba with 6 years experience in gurgaon.
Please contact me if you know about any opening in gurgaon.

Would appreciate your help.



Many thanks ,
Kavita

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

[pawel lupinski]

I realy don't know what are you looking for so check if this is what you are 
looking for.
 
Regards,
 
Pawel



From: Darwin Chan 
To: excel-macros@googlegroups.com 
Sent: Tuesday, April 3, 2012 12:02 PM
Subject: $$Excel-Macros$$ To calculate the maximum and minimum appearance in 
Staff Roster Plan


Dear all, 

I have a roster with staff allocated on different roster plan, i.e. different 
working hours. I have a task to analyse the maximum and minimum of staff who 
would appear at concurrent period. 

However, volume of data is huge and formula is needed for assistance in 
analysis. I have attached one file for simplicity.

Any help would be appreciated.

-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Analysis%20on%20roster%20plan(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

[anil panchal]

Dear Darwin,

Please find the attached file.

{I am not understant exact wt you want in from time & please revert me with
sample like count or sum total working hours )



Thanks & Regards
Anil Kumar
113784

On Tue, Apr 3, 2012 at 4:32 PM, Darwin Chan wrote:

> Dear all,
>
> I have a roster with staff allocated on different roster plan, i.e.
> different working hours. I have a task to analyse the maximum and minimum
> of staff who would appear at concurrent period.
>
> However, volume of data is huge and formula is needed for assistance in
> analysis. I have attached one file for simplicity.
>
> Any help would be appreciated.
>
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 



Thanks & Regards
Anil Kumar

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Analysis on roster plan.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ To calculate the maximum and minimum appearance in Staff Roster Plan

[Darwin Chan]

Dear all,

I have a roster with staff allocated on different roster plan, i.e. 
different working hours. I have a task to analyse the maximum and minimum 
of staff who would appear at concurrent period. 

However, volume of data is huge and formula is needed for assistance in 
analysis. I have attached one file for simplicity.

Any help would be appreciated.


-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Analysis on roster plan.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Re: Exact names Find

[Deba Ranjan]

*Hi All,

   Thank you very much experts.  Once again thanks.
*


Thanks & Regards,*
*


On Tue, Apr 3, 2012 at 2:41 PM, CoRe  wrote:

>
> Hello Bhaity,
>
> PFA.
>
> I used Trim in first instance to loose all the spaces, 2nd thing ID
> collumn has been sort as ascending for a better match. (descending problem
> , haven't figured out).
>
>
> good luck & hope it helps
>
>
> On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote:
>>
>> Dear Expert,
>>
>>   Please find the attached file. i just want the exact and match name to
>> find in another columns. please help me in urgent basis dear experts.
>>
>>
>>
>>
>> Thanks & Regards,*
>> *
>>
>> *Deba Ranjan P***
>>
>>
> On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote:
>>
>> Dear Expert,
>>
>>   Please find the attached file. i just want the exact and match name to
>> find in another columns. please help me in urgent basis dear experts.
>>
>>
>>
>>
>> Thanks & Regards,*
>> *
>>
>> *Deba Ranjan P***
>>
>>   --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Re: Exact names Find

[CoRe]

Hello Bhaity,

PFA.

I used Trim in first instance to loose all the spaces, 2nd thing ID collumn 
has been sort as ascending for a better match. (descending problem , 
haven't figured out).


good luck & hope it helps


On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote:
>
> Dear Expert,
>
>   Please find the attached file. i just want the exact and match name to 
> find in another columns. please help me in urgent basis dear experts.
>
>
>  
>  
> Thanks & Regards,*
> *
>
> *Deba Ranjan P***
>
>  
On Tuesday, April 3, 2012 10:59:22 AM UTC+3, Bhaity wrote:
>
> Dear Expert,
>
>   Please find the attached file. i just want the exact and match name to 
> find in another columns. please help me in urgent basis dear experts.
>
>
>  
>  
> Thanks & Regards,*
> *
>
> *Deba Ranjan P***
>
>  

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


NAMES+LIST(core-solved).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Re: Count formula

[Shrinivas Shevde]

Dear Haseeb

Very Very thanks

Regards
Shrinivas

On Tue, Apr 3, 2012 at 5:44 AM, Haseeb A  wrote:

> Hello Shrini,
>
> =COUNTIF(D:D,">="&StartDate)-COUNTIF(D:D,">="&EndDate+1)
>
> Or,
>
> =SUMPRODUCT(COUNTIF(D:D,">="&IF({1,0},StartDate,EndDate+1))*{1,-1})
>
> this way able to use whole column reference in SUMPRODUCT
>
> Change StartDate & EndDate to cell reference
>
> ___
> HTH, Haseeb
>
> --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Shrini

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Count formula

[Shrinivas Shevde]

Dear Laxmanand Dear Marie
Very Very thanks for the solution

Regards
Shrinivas



On Tue, Apr 3, 2012 at 3:08 AM, Maries  wrote:

> Hi,
>
> Try, below shown Array formula. (Apply with CSE)
>
> =SUM((--INT(D7:D955)>=H13)*--(INT(D7:D955)<=H14))
>
> Conditions, H13-Start Date & H14-End Date
>
> Regards,
>
> MARIES
>
>
> On Mon, Apr 2, 2012 at 11:47 AM, LAKSHMAN PRASAD 
> wrote:
>
>>  Dear Shrini**
>> Plz find out solve attach file.
>> Regards
>> LAKSHMAN
>>
>>
>>   *From:* Shrinivas Shevde 
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Monday, April 2, 2012 12:44 PM
>> *Subject:* $$Excel-Macros$$ Count formula
>>
>>  Dear all ,
>> I have a software which takes the reading for temp.
>> I can take that in excel
>> I want to count the no of reading taken in particular day or in period
>> Please find atached sheet
>> Please let me know How I can count the no of reading
>>
>> Thanks in advance
>>
>>
>> --
>> Shrini
>> --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>>
>>   --
>> FORUM RULES (986+ 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.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>  --
> FORUM RULES (986+ 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.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Shrini

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Exact names Find

[LAKSHMAN PRASAD]

use after trim   
 
 
VLOOKUP(D6,C6:C47,1,FALSE)
 
 
 



From: Deba Ranjan 
To: excel-macros@googlegroups.com; NOORAIN ANSARI  
Sent: Tuesday, April 3, 2012 1:29 PM
Subject: $$Excel-Macros$$ Exact names Find


Dear Expert,

  Please find the attached file. i just want the exact and match name to find 
in another columns. please help me in urgent basis dear experts.




Thanks & Regards,

Deba Ranjan P
-- 
FORUM RULES (986+ 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. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Exact names Find

[Deba Ranjan]

Dear Expert,

  Please find the attached file. i just want the exact and match name to
find in another columns. please help me in urgent basis dear experts.




Thanks & Regards,*
*

*Deba Ranjan P***

-- 
FORUM RULES (986+ 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. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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