Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear sir,
 
i dont want to use pivot. i need only formula for offset or index is it 
possible...
On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:

> Hi 
>
> You can do using Pivot Table, see attached file.
>
>  
>1. In the Pivot Table, click the drop down arrow in the RowLabels 
>field heading. 
>2. In the pop-up menu, click Value Filters, then click Top 10 & change 
>it to 5.
>
> You can sort on Descending on Output by going thru More Sort option under 
> filter
>
> Cheers!
>
>
> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee 
> 
> > wrote:
>
>> Dear experts,
>>
>> please help me
>>
>>
>> Thanks & Regards´¨)
>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>
>> P Let us do our best to save nature, save water, plant trees, protect
>> greenery, keep our surroundings clean, reduce usage of plastics, and
>> use renewable energy sources.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Excel formula help need

[Shrinivas Shevde]

Please find attacehd Sheet

-- 
Shrini

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


New Microsoft Excel Worksheet.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Excel formula help need

[Paul Schreiner]

??
That's what sorting does.
 
evidently, you have additional requirements that you've not included.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-


>
> From: Shrinivas Shevde 
>To: excel-macros@googlegroups.com 
>Sent: Tuesday, April 29, 2014 6:41 AM
>Subject: $$Excel-Macros$$ Excel formula help need
>  
>
>
>Please find attacehd Sheet
>
>-- 
>Shrini 
-- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>https://www.facebook.com/discussexcel
> 
>FORUM RULES
> 
>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) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Vlookup get numbers from different table

[amar takale]

Dear friends

I required output through vlookup from different table but it is
possible only for one table.How to get all numbers from each table
with data validation.PFA sheet.

Pls suggest me any idea or other formula.

Thanks

Amar

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

Re: $$Excel-Macros$$ Excel formula help need

[Dileep Kumar]

Dear Shrinivas,

Try using "Select Visible Cells" in customizng Quick Access Toolbar (QAB)
activate it select multipul cells and click on Select Visible Cells button
and then copy and past.

Please revert if it don't work.


On Tue, Apr 29, 2014 at 4:51 PM, Paul Schreiner wrote:

> ??
> That's what sorting does.
>
> evidently, you have additional requirements that you've not included.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Shrinivas Shevde 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, April 29, 2014 6:41 AM
> *Subject:* $$Excel-Macros$$ Excel formula help need
>
> Please find attacehd Sheet
>
> --
> Shrini
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>
>--
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
Regards,
Dileep Kumar Kaza

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need some help to change data format - urgent

[Paul Schreiner]

So... you're asking one or more of us to write the VBA code for you?
 
are you familiar with VBA?
what have you done so far?
 
Is the "base data" exactly how it comes from your timekeeping system?
the "times" are in a mixed format.
some are like:  23:04 (hours, minutes)
where others are like:  6.35
Is that 6.35 hours (6:21) or 6 hours and 35 minutes?

Do you understand how Excel handles date/time?
(the fact that they are numbers, 
April 29, 2014 at 7:35am 
is 41,758.31606 days since midnight of 1/1/1900)

So, basically, if you combine the date and time for in/out and subtract the two,
you get the fraction of a day, multiplied by 24 hrs/day and 60 minutes/hour
you get the number of minutes between the two dates.

However,
some times logged for a specific day are actually on the day BEFORE:

the 23:04 entry for 1/1/2014 is ACTUALLY 12/31/2013 at 23:04.

So, you need a "rule" that says that in-times after... 18:00? will be 
calculated from the previous day.

Also, it looks like your workday is calculated based on 7 hours
(451 is 420 minutes + 31 "extra" minutes)
Is this correct?

What you ask can be done, but assumptions have to be made.

Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-


>
> From: Vikas Agarwal 
>To: excel-macros@googlegroups.com 
>Sent: Monday, April 28, 2014 1:10 PM
>Subject: $$Excel-Macros$$ Need some help to change data format - urgent
>  
>
>
>Hi All,
>
>Need some help on excel calculations:
>
>I have a data of employee attendance (daily in/out time). The extract from 
>timekeeping software does come in format for me to analyse it further, 
>
>Sample file of base data and output required is attached. Request you to pls 
>provide me a solution so that this can be done within seconds/minutes.
>
>
>
>Rgds,
>
>
>Vikas
>
>9820427939 
-- 
>Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>https://www.facebook.com/discussexcel
> 
>FORUM RULES
> 
>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) Jobs posting is not allowed.
>6) Sharing copyrighted material and their links is not allowed.
> 
>NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>email to excel-macros+unsubscr...@googlegroups.com.
>To post to this group, send email to excel-macros@googlegroups.com.
>Visit this group at http://groups.google.com/group/excel-macros.
>For more options, visit https://groups.google.com/d/optout.
>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Need some help to change data format - urgent

[Vaibhav Joshi]

Hi

You can do with formula, check yellow colored area.

Thx


On Mon, Apr 28, 2014 at 10:40 PM, Vikas Agarwal  wrote:

> Hi All,
>
> Need some help on excel calculations:
>
> I have a data of employee attendance (daily in/out time). The extract from
> timekeeping software does come in format for me to analyse it further,
>
> Sample file of base data and output required is attached. Request you to
> pls provide me a solution so that this can be done within seconds/minutes.
>
>
> Rgds,
>
> Vikas
>
> 9820427939
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Date format - in time out time.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[Vaibhav Joshi]

Its not possible to do without any help column.

Another way out is shown in attached file. Ref col E & F.

Thx


On Tue, Apr 29, 2014 at 2:34 PM, renuka chari  wrote:

> Dear sir,
>
> i dont want to use pivot. i need only formula for offset or index is it
> possible...
>
> On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
>
>> Hi
>>
>> You can do using Pivot Table, see attached file.
>>
>>
>>1. In the Pivot Table, click the drop down arrow in the RowLabels
>>field heading.
>>2. In the pop-up menu, click Value Filters, then click Top 10 &
>>change it to 5.
>>
>> You can sort on Descending on Output by going thru More Sort option under
>> filter
>>
>> Cheers!
>>
>>
>> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee wrote:
>>
>>> Dear experts,
>>>
>>> please help me
>>>
>>>
>>> Thanks & Regards´¨)
>>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>>
>>> P Let us do our best to save nature, save water, plant trees, protect
>>> greenery, keep our surroundings clean, reduce usage of plastics, and
>>> use renewable energy sources.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Return Top5.xlsx
Description:

Re: $$Excel-Macros$$ Need some help to change data format - urgent

[Vikas]

Thanks Vabz. It was indeed very helpful and saved my time. Can i ask one 
more thing (i m getting a bit greedy!!!)

In the sample file attached the list of employees is small and also dates. 
is there a formula or way where the employee code and then dates would 
automatically get pulled in (because the original data has too many 
employees and spread across 6 months i.e.180 days. So plotting the dates 
manually by each employee and then using this formula will consume 
significant time as well.

Pls suggest.

Rgds,

Vikas Agarwal


On Tuesday, April 29, 2014 5:28:05 PM UTC+5:30, Vabz wrote:
>
> Hi
>
> You can do with formula, check yellow colored area.
>
> Thx
>
>
> On Mon, Apr 28, 2014 at 10:40 PM, Vikas Agarwal 
> 
> > wrote:
>
>> Hi All,
>>
>> Need some help on excel calculations:
>>
>> I have a data of employee attendance (daily in/out time). The extract 
>> from timekeeping software does come in format for me to analyse it further, 
>>
>> Sample file of base data and output required is attached. Request you to 
>> pls provide me a solution so that this can be done within seconds/minutes.
>>
>>
>> Rgds,
>>
>> Vikas
>>
>> 9820427939
>>  
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: find duplicate rows of data between sheets macro

[Eugene Bernard]

Thank you Paul !!!

Regards
Eugene


On Mon, Apr 28, 2014 at 9:31 PM, Paul Schreiner wrote:

> Any place you have:
> Sheets(
>
> add the workbook name:
> Workbooks("Firstfile").Sheets(
>
> For the workbook that contains the code, you can use:
> Thisworkbook.Sheets(
>
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,By all the means you can,In all the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
>*From:* Eugene Bernard 
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, April 28, 2014 11:49 AM
> *Subject:* Re: $$Excel-Macros$$ Re: find duplicate rows of data between
> sheets macro
>
> Hi Paul,
>
> The code given above works well for the sheets in same workbook.
> send me the code for data in two different work books.
>
> Regards
> Eugene
>
>
> On Fri, Apr 25, 2014 at 9:15 PM, Paul Schreiner wrote:
>
> It works perfectly in my workbook.
> Row 6 is unhighlighted in sheet1
> and 6 and 13 are unhighlighted in sheet2.
>
> better check to make sure the macro was copied correctly,
> here it is from my workbook:
>
> Option Explicit
> Public Dict_Data1, Dict_Data2
> Sub Compare()
> Dim Sht1, Sht2
> Dim nRows, r, sData, rArray, inx
> Dim tstart, tstop, TElapsed, TMin, TSec, msg
>
> '-
> Application.ScreenUpdating = False
> '-
> tstart = Timer
> Set Dict_Data1 = CreateObject("Scripting.Dictionary")
> Set Dict_Data2 = CreateObject("Scripting.Dictionary")
> Dict_Data1.RemoveAll
> Dict_Data2.RemoveAll
> '-
> 'Identify sheets to compare
> '-
> Sht1 = "Sheet1"
> Sht2 = "Sheet2"
> '-
> ' Clear Highlighting
> '-
> Sheets(Sht1).Select
> With Cells.Interior
> .Pattern = xlNone
> .TintAndShade = 0
> .PatternTintAndShade = 0
> End With
> Sheets(Sht2).Select
> With Cells.Interior
> .Pattern = xlNone
> .TintAndShade = 0
> .PatternTintAndShade = 0
> End With
> '-
> ' Load data from Sht1 into Dictionary Object
> '-
> nRows = Application.WorksheetFunction.CountA(Sheets(Sht1).Range("A1:A"
> & Sheets(Sht1).Rows.Count))
> For r = 2 To nRows
> If (r Mod 1000 = 0) Then Application.StatusBar = "Loading " & Sht1
> & " row " & r & " of " & nRows
> sData = Trim(Sheets(Sht1).Cells(r, "A").Value)
> sData = sData & "|" & Trim(Sheets(Sht1).Cells(r, "B").Value)
> sData = sData & "|" & Trim(Sheets(Sht1).Cells(r, "C").Value)
> sData = sData & "|" & Trim(Sheets(Sht1).Cells(r, "D").Value)
> sData = sData & "|" & Trim(Sheets(Sht1).Cells(r, "F").Value)
> sData = sData & "|" & Trim(Sheets(Sht1).Cells(r, "H").Value)
> sData = sData & "|" & Trim(Sheets(Sht1).Cells(r, "I").Value)
> If (Not Dict_Data1.exists(sData)) Then
> Dict_Data1.Add sData, r
> '--
> Else '  In case of duplicate rows, collect all row numbers
> '--
> Dict_Data1.Item(sData) = Dict_Data1.Item(sData) & "," & r
> End If
> Next
> '-
> ' Process Sht2 data, compare to sht1
> '-
> nRows = Application.WorksheetFunction.CountA(Sheets(Sht2).Range("A1:A"
> & Sheets(Sht2).Rows.Count))
> For r = 2 To nRows
> If (r Mod 1000 = 0) Then Application.StatusBar = "Processing " &
> Sht2 & " row " & r & " of " & nRows
> sData = Trim(Sheets(Sht2).Cells(r, "A").Value)
> sData = sData & "|" & Trim(Sheets(Sht2).Cells(r, "B").Value)
> sData = sData & "|" & Trim(Sheets(Sht2).Cells(r, "C").Value)
> sData = sData & "|" & Trim(Sheets(Sht2).Cells(r, "D").Value)
> sData = sData & "|" & Trim(Sheets(Sht2).Cells(r, "F").Value)
> sData = sData & "|" & Trim(Sheets(Sht2).Cells(r, "H").Value)
> sData = sData & "|" & Trim(Sheets(Sht2).Cells(r, "I").Value)
> If (Dict_Data1.exists(sData)) Then
> '---
> 'highlight row in sht2
> '---
> Sheets(Sht2).Select
> With Sheets(Sht2).Range(Cells(r, "A"), Cells(r, "I")).Interior
> .Pattern = xlSolid
>   

Re: $$Excel-Macros$$ Vlookup get numbers from different table

[Vaibhav Joshi]

Hi,

PFA

Cheers!!


On Tue, Apr 29, 2014 at 5:01 PM, amar takale  wrote:

> Dear friends
>
> I required output through vlookup from different table but it is
> possible only for one table.How to get all numbers from each table
> with data validation.PFA sheet.
>
> Pls suggest me any idea or other formula.
>
> Thanks
>
> Amar
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


vlookup from dynamic table.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear sir,

Thank you so much for your time and effort into problem.

my dashboard having huge no of sheets and if i make pivot sheet then my 
workbook size is increasing more i was applied your formula earlier itself. 
but i need even better solution. and my dash board data range is not 
constant if this data set count increase or decrease on daily basis. that 
scenario  every time we are going to apply refresh or expand data option 
for PIVOT it is time consuming process  


so kindly think even better output for this problem..

On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote:
>
> Its not possible to do without any help column.
>
> Another way out is shown in attached file. Ref col E & F.
>
> Thx
>
>
> On Tue, Apr 29, 2014 at 2:34 PM, renuka chari 
> > wrote:
>
>> Dear sir,
>>  
>> i dont want to use pivot. i need only formula for offset or index is it 
>> possible...
>>
>> On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
>>
>>> Hi 
>>>
>>> You can do using Pivot Table, see attached file.
>>>
>>>  
>>>1. In the Pivot Table, click the drop down arrow in the RowLabels 
>>>field heading. 
>>>2. In the pop-up menu, click Value Filters, then click Top 10 & 
>>>change it to 5.
>>>
>>> You can sort on Descending on Output by going thru More Sort option 
>>> under filter
>>>
>>> Cheers!
>>>
>>>
>>> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee 
>>> wrote:
>>>
 Dear experts,

 please help me


 Thanks & Regards´¨)
   ¸ •´ ¸.•*´¨)   ¸.•*¨)
  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪

 P Let us do our best to save nature, save water, plant trees, protect
 greenery, keep our surroundings clean, reduce usage of plastics, and
 use renewable energy sources.

 --
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel

 FORUM RULES

 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.

 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>  -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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 sec

$$Excel-Macros$$ Is there any way to change the font with the Forms - ListBox?

[Rob Flott]

For whatever reasons the size of my ActiveX ListBox expands and shrinks on 
an inconsistent basis forcing me to use the Forms ListBox instead.
 
The problem I have with the Forms ListBox is the small font.
 
1. Is there any way to change the font size within the Forms - ListBox?
 
2. If not, is there a way to make a small userform with one ListBox that 
remains on the active worksheet?
 
I have given up on ActiveX controls since they are so inconsistent.
 
Thanks

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear sir,

thank you so much.your given a great help..


On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:
>
> Hi
>
> PFA alternate method using formula & help sheet.
>
> Thanks
>
>
> On Tue, Apr 29, 2014 at 8:57 PM, renuka chari 
> > wrote:
>
>> Dear sir,
>>
>> Thank you so much for your time and effort into problem.
>>
>> my dashboard having huge no of sheets and if i make pivot sheet then my 
>> workbook size is increasing more i was applied your formula earlier itself. 
>> but i need even better solution. and my dash board data range is not 
>> constant if this data set count increase or decrease on daily basis. that 
>> scenario  every time we are going to apply refresh or expand data option 
>> for PIVOT it is time consuming process  
>>
>>
>> so kindly think even better output for this problem..
>>
>>
>> On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote:
>>
>>> Its not possible to do without any help column.
>>>
>>> Another way out is shown in attached file. Ref col E & F.
>>>
>>> Thx
>>>
>>>
>>> On Tue, Apr 29, 2014 at 2:34 PM, renuka chari  wrote:
>>>
 Dear sir,
  
 i dont want to use pivot. i need only formula for offset or index is it 
 possible...

 On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:

> Hi 
>
> You can do using Pivot Table, see attached file.
>
>  
>1. In the Pivot Table, click the drop down arrow in the RowLabels 
>field heading. 
>2. In the pop-up menu, click Value Filters, then click Top 10 & 
>change it to 5.
>
> You can sort on Descending on Output by going thru More Sort option 
> under filter
>
> Cheers!
>
>
> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee  > wrote:
>
>> Dear experts,
>>
>> please help me
>>
>>
>> Thanks & Regards´¨)
>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>
>> P Let us do our best to save nature, save water, plant trees, protect
>> greenery, keep our surroundings clean, reduce usage of plastics, and
>> use renewable energy sources.
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, 
>> send an email to excel-macros...@googlegroups.com.
>> To post to this group, send email to excel-...@googlegroups.com.
>>
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  -- 
 Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
 It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
 https://www.facebook.com/discussexcel
  
 FORUM RULES
  
 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) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.
  
 NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send 
 an email to excel-macros...@googlegroups.com.
 To post to this group, send email to excel-...@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>>  

Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

[renuka chari]

Dear Sir,

countif function creating more violation for huge data range. is there any 
possible to overcome or use any other function. 

please guide me...

thanks...



On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote:
>
> Dear sir,
>
> thank you so much.your given a great help..
>
>
> On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote:
>>
>> Hi
>>
>> PFA alternate method using formula & help sheet.
>>
>> Thanks
>>
>>
>> On Tue, Apr 29, 2014 at 8:57 PM, renuka chari  wrote:
>>
>>> Dear sir,
>>>
>>> Thank you so much for your time and effort into problem.
>>>
>>> my dashboard having huge no of sheets and if i make pivot sheet then my 
>>> workbook size is increasing more i was applied your formula earlier itself. 
>>> but i need even better solution. and my dash board data range is not 
>>> constant if this data set count increase or decrease on daily basis. that 
>>> scenario  every time we are going to apply refresh or expand data option 
>>> for PIVOT it is time consuming process  
>>>
>>>
>>> so kindly think even better output for this problem..
>>>
>>>
>>> On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote:
>>>
 Its not possible to do without any help column.

 Another way out is shown in attached file. Ref col E & F.

 Thx


 On Tue, Apr 29, 2014 at 2:34 PM, renuka chari wrote:

> Dear sir,
>  
> i dont want to use pivot. i need only formula for offset or index is 
> it possible...
>
> On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote:
>
>> Hi 
>>
>> You can do using Pivot Table, see attached file.
>>
>>  
>>1. In the Pivot Table, click the drop down arrow in the RowLabels 
>>field heading. 
>>2. In the pop-up menu, click Value Filters, then click Top 10 & 
>>change it to 5.
>>
>> You can sort on Descending on Output by going thru More Sort option 
>> under filter
>>
>> Cheers!
>>
>>
>> On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee <
>> jva@gmail.com> wrote:
>>
>>> Dear experts,
>>>
>>> please help me
>>>
>>>
>>> Thanks & Regards´¨)
>>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
>>>
>>> P Let us do our best to save nature, save water, plant trees, protect
>>> greenery, keep our surroundings clean, reduce usage of plastics, and
>>> use renewable energy sources.
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, 
>>> send an email to excel-macros...@googlegroups.com.
>>> To post to this group, send email to excel-...@googlegroups.com.
>>>
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  -- 
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? 
> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
> https://www.facebook.com/discussexcel
>  
> FORUM RULES
>  
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>  
> NOTE : Don't ever post 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 G

Re: $$Excel-Macros$$ Is there any way to change the font with the Forms - ListBox?

[ashish koul]

Hi

Try this way
http://www.jkp-ads.com/articles/Excel2007FileFormat01.asp

Regards
Ashish Koul


On Tue, Apr 29, 2014 at 9:32 PM, Rob Flott  wrote:

> For whatever reasons the size of my ActiveX ListBox expands and shrinks on
> an inconsistent basis forcing me to use the Forms ListBox instead.
>
> The problem I have with the Forms ListBox is the small font.
>
> 1. Is there any way to change the font size within the Forms - ListBox?
>
> 2. If not, is there a way to make a small userform with one ListBox that
> remains on the active worksheet?
>
> I have given up on ActiveX controls since they are so inconsistent.
>
> Thanks
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>



-- 
*Regards*

*Ashish Koul*


*Visit*
http://www.excelvbamacros.in
Like Us on Facebook 
Join Us on Facebook 


P Before printing, think about the environment.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Doubt in Duplicates

[Kannan Excel]

Dear Friends,

Please find the attached file of excel, I have a doubt in that excel.

I checked the excel there is no formula and VBA coding but it is showing
duplicates.

How to do this in other excel... Please help me

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


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

$$Excel-Macros$$ Re: Doubt in Duplicates

[Prince]

so do you want to remove duplicates ? 

On Wednesday, 30 April 2014 11:27:23 UTC+5:30, pappu wrote:
>
> Dear Friends,
>
> Please find the attached file of excel, I have a doubt in that excel. 
>
> I checked the excel there is no formula and VBA coding but it is showing 
> duplicates.
>
> How to do this in other excel... Please help me
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Doubt in Duplicates

[Ganesh N]

HI Kannan,

There is In-build option in excel to show the duplicates. Please find the
below steps.

Home->conditional formatting->highlight cells rules->Duplicate value (you
can create whatever format u want to show the duplicate values)

Thanks & Regards,
Ganesh N


On Wed, Apr 30, 2014 at 11:27 AM, Kannan Excel wrote:

> Dear Friends,
>
> Please find the attached file of excel, I have a doubt in that excel.
>
> I checked the excel there is no formula and VBA coding but it is showing
> duplicates.
>
> How to do this in other excel... Please help me
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Doubt in Duplicates

[Prince]

I think Ganesh reply is correct if you just want to show the duplicates.

On Wednesday, 30 April 2014 11:33:55 UTC+5:30, Ganesh N wrote:
>
> HI Kannan,
>
> There is In-build option in excel to show the duplicates. Please find the 
> below steps.
>
> Home->conditional formatting->highlight cells rules->Duplicate value (you 
> can create whatever format u want to show the duplicate values)
>
> Thanks & Regards,
> Ganesh N
>
>
> On Wed, Apr 30, 2014 at 11:27 AM, Kannan Excel 
> 
> > wrote:
>
>> Dear Friends,
>>
>> Please find the attached file of excel, I have a doubt in that excel. 
>>
>> I checked the excel there is no formula and VBA coding but it is showing 
>> duplicates.
>>
>> How to do this in other excel... Please help me
>>
>> -- 
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
>> https://www.facebook.com/discussexcel
>>  
>> FORUM RULES
>>  
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>  
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an 
>> email to excel-macros...@googlegroups.com .
>> To post to this group, send email to excel-...@googlegroups.com
>> .
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Doubt in Duplicates

[Kannan Excel]

Dear Ganesh,

Thank you...

Now i understood...



On Wed, Apr 30, 2014 at 11:33 AM, Ganesh N  wrote:

> HI Kannan,
>
> There is In-build option in excel to show the duplicates. Please find the
> below steps.
>
> Home->conditional formatting->highlight cells rules->Duplicate value (you
> can create whatever format u want to show the duplicate values)
>
> Thanks & Regards,
> Ganesh N
>
>
> On Wed, Apr 30, 2014 at 11:27 AM, Kannan Excel wrote:
>
>> Dear Friends,
>>
>> Please find the attached file of excel, I have a doubt in that excel.
>>
>> I checked the excel there is no formula and VBA coding but it is showing
>> duplicates.
>>
>> How to do this in other excel... Please help me
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ please help for consolidate in excel

[Kannan Excel]

Dear Ganesh & Ravinder,

I am also have this issue.
I saw your attachments, i don't know how to use this...

Kindly give a brief explanation.




On Sun, Apr 27, 2014 at 11:48 AM, Ganesh N  wrote:

> Hi Yadav,
>
> you can also use this. Just put the data files in separate folder and put
> the path in cell "J2".
>
> Thanks & Regards,
> Ganesh N
>
>
> On Sun, Apr 27, 2014 at 11:16 AM, Vaibhav Joshi  wrote:
>
>> Hi,
>>
>> You can try this excellent codes share by Ashish earlier this month:
>>
>> Sub merge()
>>
>> Dim fld As Object, fil As Object, fso As Object, fldpath
>> With Application.FileDialog(msoFileDialogFolderPicker)
>> .Title = "Choose the folder"
>> .Show
>> End With
>> On Error Resume Next
>> fldpath = 
>> Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1)
>> & "\"
>> If fldpath = False Then
>> MsgBox "Folder Not Selected"
>> Exit Sub
>> End If
>>
>> Set fso = CreateObject("scripting.filesystemobject")
>> Set fld = fso.getfolder(fldpath)
>> Application.DisplayAlerts = False
>> Application.ScreenUpdating = False
>> For Each fil In fld.Files
>> If Right(fil.Name, 4) = ".xls" And fil.Name <> ThisWorkbook.Name
>> Then Call import_data(fil.Path)
>> Next
>> Application.DisplayAlerts = True
>> Application.ScreenUpdating = True
>>
>> End Sub
>>
>>
>>
>> Sub import_data(filename As String)
>> Dim wkb As Workbook
>> Dim lastrow As Long
>> lastrow = ThisWorkbook.Sheets("Sheet1").Range("a65356").End(xlUp).Row
>> + 1
>> Set wkb = Workbooks.Open(filename)
>> wkb.Sheets("Summary Sheet").Range("e2:j2").Copy
>> Destination:=ThisWorkbook.Sheets("Sheet1").Range("a" & lastrow)
>> wkb.Sheets("Summary Sheet").Range("b13:f13").Copy
>> Destination:=ThisWorkbook.Sheets("Sheet1").Range("g" & lastrow)
>> wkb.Close
>>
>> End Sub
>>
>> Thanks
>>
>>
>> On Sun, Apr 27, 2014 at 9:44 AM, Jitendra Yadav wrote:
>>
>>> Hi All,
>>>
>>> I have some data for date wise but I want all excel file in one sheet
>>> through macro.
>>>
>>>
>>>
>>> Example.
>>>
>>>
>>>
>>>
>>> Regards,
>>> Jitendra//9650449202
>>>
>>> --
>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
>>> It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>>> https://www.facebook.com/discussexcel
>>>
>>> FORUM RULES
>>>
>>> 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) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at http://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>  --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>  --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FO

Re: $$Excel-Macros$$ Vlookup get numbers from different table

[amar takale]

Dear Vabs Brother

Its really cool formula which you have sent me… There was a glow in my face

Thanks very very muchfor helping excel enthusiasts
voluntarily !!

Regards
Amar


On Tue, Apr 29, 2014 at 8:56 PM, Vaibhav Joshi  wrote:
> Hi,
>
> PFA
>
> Cheers!!
>
>
> On Tue, Apr 29, 2014 at 5:01 PM, amar takale  wrote:
>>
>> Dear friends
>>
>> I required output through vlookup from different table but it is
>> possible only for one table.How to get all numbers from each table
>> with data validation.PFA sheet.
>>
>> Pls suggest me any idea or other formula.
>>
>> Thanks
>>
>> Amar
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
>> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
>> https://www.facebook.com/discussexcel
>>
>> FORUM RULES
>>
>> 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) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at http://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RULES
>
> 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) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.