date:20151105

$$Excel-Macros$$ MACRO VBA

2015-11-05 Thread ulysse-pacome koudou

hi I am starting with VBA and I'd like to create a macro that group every 
element of a column in another one by giving them a name.

for instance:

Year colour
2015  blue
2014  red
2003 yellow
2011 blue
2006 red

If the year is 2015 or 2011 the given colour have to be blue, if the year 
is 2014 or 2006 the colour have to be red.
and so on.

cheers

-- 
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$$ Pivot Table & Counting Colors w/conditional formatting

2015-11-05 Thread 'Ty' via MS EXCEL AND VBA MACROS



Anyone,


I have a macro for counting colors that works on a normal worksheet.  


Problem:  Clever created Pivot table with colors(Green, Red, Black..etc) 
that have numbers and text when you hover over the color

Example: When cursor is over the Green value = 5(RED = 3) with text for the 
source data column and description
Problem #2:  I was attempting to use the Color Macro for 2 days w/ no luck 
while placing the colors in other blocks outside of the pivot.  It worked 
outside of the pivot table.
Problem after using debug: conditional formatting. It is displaying 
"#VALUE!" in the box.   

Debug.Print CellColor.address
Debug.Print CellColor.Interior.ColorIndex
Stop

Any ideas on why the Color Macro is not working.  The Macro is down below.

What can I do to get this to work?


Thanks,

Ty


Here is the Macro:


Function CountByColor(CellColor As Range, CountRange As Range)
Application.Volatile
Dim ICol As Integer
Dim TCell As Range
ICol = CellColor.Interior.ColorIndex
For Each TCell In CountRange
If ICol = TCell.Interior.ColorIndex Then
CountByColor = CountByColor + 1
End If
Next TCell
End Function

-- 
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$$ Formula to take the value depends upon the two values

2015-11-05 Thread big smile

 Repected Friends  1]  Which formula I should use in E 13 ---  I want the
value depends upon Risk Group & Table As per  B4 :D9 2] First I have to see
the Group which I & II then Table A/B/C/D  It will take depends upon this
two criteria the value  3]  I have to caluculate same way in more raws for
full family. Thanks a lot .

-- 
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.


FORMULA.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ MACRO VBA

2015-11-05 Thread Paul Schreiner

Can you provide a sample file showing what you'd like?Are you looking for 
Conditional Formatting for the column? Are you looking for a macro to highlight 
the date?or even a Change_Event macro to format the 
column?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: ulysse-pacome koudou 
 To: MS EXCEL AND VBA MACROS  
 Sent: Thursday, November 5, 2015 3:21 AM
 Subject: $$Excel-Macros$$ MACRO VBA
   
hi I am starting with VBA and I'd like to create a macro that group every 
element of a column in another one by giving them a name.
for instance:
Year         colour2015      blue2014      red2003     yellow2011     blue2006  
   red
If the year is 2015 or 2011 the given colour have to be blue, if the year is 
2014 or 2006 the colour have to be red.and so on.
cheers-- 
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$$ I need the formula to look up

2015-11-05 Thread Paul Schreiner

What version of Windows are you using?
In Windows 7, under Control Panel, there is a selection called"Region and 
Language"
Selecting this allows you to change the display format for displaying dates and 
Times.
Excel uses THIS setting to determine the default display for dates.
For instance: if you tell Windows that a date is in mm/dd/ format,when you 
enter 10/31/2015, Excel will recognize it as a "date" and actually STORE the 
cell value as: 42308 (the number of days since 1-Jan-1900)
But, if you were to enter the value as 31/10/2015, Excel would NOT see this as 
a valid date and would store the value as TEXT.
Now, no matter WHAT your Windows Default is set to, you can always change a 
cell format to display the data in any manner.
For instance; if you were to enter: 42307 in the cell,you could then change the 
date format (using right-click->format cells..)and change the displayed format 
to a custom display of dd/mm/.Which would display the value of 42307 as 
30/10/2015
The problem here is that, if you were to have your WINDOWS date format set to 
mm-dd-, even though you changed the CELL format to dd-mm-when you enter 
the value as 30-10-2015, Excel doesn't compare it to the CELL format, but only 
the WINDOWS format, and will conclude the value is TEXT.
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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Monday, November 2, 2015 3:31 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
Hi paul how do i change the date to 31/10/2015


On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner  wrote:

Dates should be displayed as the Windows settings dictate.
So, when *I* open it, the date displays as 11/2/2015.
you can change it to 02-Nov-2015 if you want, and the dates should calculate 
correctly.
 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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Monday, November 2, 2015 3:09 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
the date seems to be a problem 
it appears as 2/11/2015 on my computer 
it wont work 


On Mon, Nov 2, 2015 at 12:45 PM, Paul Schreiner  wrote:

Attached, I created a function to locate the most recent occurrence.=Find_Num()

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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Sunday, November 1, 2015 12:09 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
l meant from C8 to H78  I need a formula to look up when balls from 1-59 was 
last drawn and then look at the date this draw occurred and then calculate the 
difference between that date and today's date I dont know if this is possible 
it should look like this below

| 0 | 26 |
| 0 | 39 |
| 0 | 41 |
| 0 | 42 |
| 0 | 55 |
| 0 | 56 |
| 0 | 57 |
| 0 | 59 |
| 1 | 36 |
| 1 | 46 |
| 1 | 49 |
| 1 | 52 |
| 2 | 29 |
| 2 | 31 |
| 2 | 43 |
| 2 | 58 |
| 3 | 13 |
| 3 | 14 |
| 3 | 21 |
| 3 | 25 |
| 3 | 51 |
| 3 | 53 |
| 4 | 8 |
| 4 | 30 |
| 4 | 37 |
| 4 | 40 |
| 4 | 50 |
| 5 | 7 |
| 5 | 20 |
| 5 | 27 |
| 6 | 2 |
| 6 | 3 |
| 6 | 16 |
| 6 | 32 |
| 6 | 54 |
| 7 | 5 |
| 7 | 11 |
| 7 | 44 |
| 8 | 9 |
| 8 | 35 |
| 9 | 17 |
| 9 | 45 |
| 10 | 33 |
| 11 | 23 |
| 12 | 28 |
| 13 | 12 |
| 13 | 22 |
| 15 | 6 |
| 15 | 18 |
| 16 | 24 |
| 19 | 4 |
| 20 | 19 |
| 20 | 48 |
| 22 | 10 |
| 23 | 15 |
| 26 | 1 |
| 27 | 47 |
| 31 | 38 |
| 48 | 34 |




On Sun, Nov 1, 2015 at 1:19 PM, ashish koul  wrote:

check this see if it helps

On Sun, Nov 1, 2015 at 6:26 PM, Will Sob  wrote:

I need the formula to look up when forexample ball 33 was last drawn and then 
look at the date this draw occured andthen calculate the difference between 
that date and todays date
I dont know if thisis possible


-- 
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,

Re: $$Excel-Macros$$ I need the formula to look up

2015-11-05 Thread Will Sob

Thanks Paul this is very helpful bless you. Can you help me how do I input
the formula find_num in my function list. My excel doesn't recognize this
On 5 Nov 2015 12:29, "Paul Schreiner"  wrote:

> What version of Windows are you using?
>
> In Windows 7, under Control Panel, there is a selection called
> "Region and Language"
>
> Selecting this allows you to change the display format for displaying
> dates and Times.
>
> Excel uses THIS setting to determine the default display for dates.
>
> For instance: if you tell Windows that a date is in mm/dd/ format,
> when you enter 10/31/2015, Excel will recognize it as a "date" and
> actually STORE the cell value as: 42308 (the number of days since
> 1-Jan-1900)
>
> But, if you were to enter the value as 31/10/2015, Excel would NOT see
> this as a valid date and would store the value as TEXT.
>
> Now, no matter WHAT your Windows Default is set to,
> you can always change a cell format to display the data in any manner.
>
> For instance; if you were to enter: 42307 in the cell,
> you could then change the date format (using right-click->format cells..)
> and change the displayed format to a custom display of dd/mm/.
> Which would display the value of 42307 as 30/10/2015
>
> The problem here is that, if you were to have your WINDOWS date format set
> to mm-dd-,
> even though you changed the CELL format to dd-mm-
> when you enter the value as 30-10-2015, Excel doesn't compare it to the
> CELL format, but only the WINDOWS format, and will conclude the value is
> TEXT.
>
> *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:* Will Sob 
> *To:* "excel-macros@googlegroups.com" 
> *Sent:* Monday, November 2, 2015 3:31 PM
> *Subject:* Re: $$Excel-Macros$$ I need the formula to look up
>
> Hi paul how do i change the date to 31/10/2015
>
>
>
> On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner 
> wrote:
>
> Dates should be displayed as the Windows settings dictate.
>
> So, when *I* open it, the date displays as 11/2/2015.
>
> you can change it to 02-Nov-2015 if you want, and the dates should
> calculate correctly.
>
>
> *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:* Will Sob 
> *To:* "excel-macros@googlegroups.com" 
> *Sent:* Monday, November 2, 2015 3:09 PM
>
> *Subject:* Re: $$Excel-Macros$$ I need the formula to look up
>
> the date seems to be a problem
>
> it appears as 2/11/2015 on my computer
>
> it wont work
>
>
>
> On Mon, Nov 2, 2015 at 12:45 PM, Paul Schreiner 
> wrote:
>
> Attached, I created a function to locate the most recent occurrence.
> =Find_Num()
>
>
> *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:* Will Sob 
> *To:* "excel-macros@googlegroups.com" 
> *Sent:* Sunday, November 1, 2015 12:09 PM
> *Subject:* Re: $$Excel-Macros$$ I need the formula to look up
>
> l meant from C8 to H78  I need a formula to look up when balls from 1-59 was
> last drawn and then look at the date this draw occurred and then calculate
> the difference between that date and today's date
> I dont know if this is possible
>
> it should look like this below
>
> 02603904104205505605705913614614915222923124325831331432132535135348430437
> 4404505752052762636166326547571174489835917945103311231228131213221561518
> 16241942019204822102315261274731384834
>
>
>
> On Sun, Nov 1, 2015 at 1:19 PM, ashish koul  wrote:
>
> check this see if it helps
>
> On Sun, Nov 1, 2015 at 6:26 PM, Will Sob  wrote:
>
> I need the formula to look up when for example ball 33 was last drawn and
> then look at the date this draw occured and then calculate the difference
> between that date and todays date
> I dont know if this is possible
>
>
>
> --
> 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
>
>

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

2015-11-05 Thread Abhishek Jain

PFA

On Thu, Nov 5, 2015 at 6:20 PM, big smile  wrote:

> Repected Friends  1]  Which formula I should use in E 13 ---  I want the
> value depends upon Risk Group & Table As per  B4 :D9 2] First I have to
> see the Group which I & II then Table A/B/C/D  It will take depends upon
> this two criteria the value  3]  I have to caluculate same way in more
> raws for full family. Thanks a lot .
>
> --
> 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.


FORMULA.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Fwd: Hide column as per option choice. - Attach Sheet..

2015-11-05 Thread Paul Schreiner

The macro is in the VBA sheet module:
Private Sub Worksheet_Change(ByVal Target As Range)
    Dim ColNo
    If ((Target.Address = "$C$3") _
 Or (Target.Address = "$C$4")) Then
    Hide_All
    For ColNo = 4 To 10
    If ((Sheets("Sheet 2").Cells(1, ColNo).Value = 
Sheets("Sheet1").Range("C3").Value) _
 Or (Sheets("Sheet 2").Cells(1, ColNo).Value = 
Sheets("Sheet1").Range("C4").Value)) Then
    Sheets("Sheet 2").Cells(1, ColNo).EntireColumn.Hidden = False
    End If
    Next ColNo
    End If
    Sheets("Sheet 2").Select
End Sub
 If you want to add additional selections, you need to add to the If/or/endif 
section.
If you want it to search another sheet, then you COULD have a pull-down of 
available worksheets that, when selected, would be used in place of the 
'sheets("Sheet 2")'

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: big smile 
 To: excel-macros@googlegroups.com 
 Sent: Wednesday, November 4, 2015 6:28 AM
 Subject: Re: $$Excel-Macros$$ Fwd: Hide column as per option choice. - Attach 
Sheet..
   


I was searching this option from so many days . It work perfectly too.
One query that if i want to compare 3 - 4 columns at a time & not only then 
how to go with that .
If i want to apply in another sheet / file the same formula then 
can u share me the formula too . 

Thanks & take care 


On Mon, Nov 2, 2015 at 5:44 PM, Paul Schreiner  wrote:

I think I understand your requirement.
You want to select the two columns in "Sheet1"and have the macro hide all 
columns except those selected.
The attached file creates a pull-down list in each of the cellsso that they are 
updated with the list of categories.Once selected, the Change Event macro 
updates the displayed columns. 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: big smile 
 To: excel-macros@googlegroups.com 
 Sent: Sunday, November 1, 2015 11:53 PM
 Subject: $$Excel-Macros$$ Fwd: Hide column as per option choice. - Attach 
Sheet..
   


|  | Respected Guru's .. |  |  |  |  |  |
|  |  |  |  |  |  |  |  |
|  | I want to learn the formula so that I get the folllowing results |  |
|  |  |  |  |  |  |  |  |
| 1]  | In the sheet 1 - I am choossing option A & B  |  |  |
|  |  |  |  |  |  |  |  |
|  | I am chossing any two comparision  |  |  |  |
|  |  |  |  |  |  |  |  |
| 2]  | Ex If I choose  |  |  |  |  |  |
|  |  |  |  |  |  |  |  |
|  | Star Comprensive |  |  |  |  |  |
|  | The New India  - FLOTER  |  |  |  |  |
|  |  |  |  |  |  |  |  |
| 3]  | I want the result as follows  |  |  |  |  |
|  | Then auotmatically  |  |  |  |  |  |
|  | My sheet 2 will show as follows  |  |  |  |
|  | Column  A -- Stable  |  |  |  |  |  |
|  | Column  B -- Stable  |  |  |  |  |  |
|  | Column  C -- Stable  |  |  |  |  |  |
|  | Column  D - Change as option  |  |  |  |  |
|  | Column  G - Change as option |  |  |  |  |
|  | & it should hid Column E & F |  |  |  |  |
|  |  |  |  |  |  |  |  |
| 4]  | If I change the  Option same way it change  |  |  |
|  | Column D - E - F - G  |  |  |  |  |  |
|  |  |  |  |  |  |  |  |
| 5]  | Same way if I add more companies in H I J  then it will also work |
|  |  |  |  |  |  |  |  |
| 6]  | If I want  3 option at glance then that also work |  |  |
|  |  |  |  |  |  |  |  |
|  | Thanks a lot in advance .  |  |  |  |  |
|  |  |  |  |  |  |  |  |
|  | Take care of your family & Always be happy. |  |  |
|  |  |  |  |  |  |  |  |

-- 
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

Re: $$Excel-Macros$$ Help with Custom Vlookup

2015-11-05 Thread Paul Schreiner

The speed of the worksheet is due to the fact that this UDF would execute for 
EACH row/cell where you've placed it.and update each time a sheet 
calculates(which occurs whenever you change a value)
This function, run 50,000 times would indeed be slow!
I'd suggest creating an alternative.
Can I get a sample file (sent directly to me)?
Even if you need to change some names to remove personal data.
I routinely have macros load Public "dictionary" objects that are used to 
contain keywords that can then be located quickly.
a couple of my workbooks contain over 100,000 rows of 70+ columns.So I often 
have to manage large amounts of data.
If you can give me a sample, I'd be glad to take a look at it. 
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: Abhishek Jain 
 To: MS EXCEL AND VBA MACROS  
Cc: Paul Schreiner  
 Sent: Tuesday, November 3, 2015 2:56 AM
 Subject: $$Excel-Macros$$ Help with Custom Vlookup
   
Hi All,
I intend to use this piece of UDF I found on internet for my requirement -
Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long)Dim r As 
RangeDim result As Stringresult = ""For Each r In lookuprange    If r = 
lookupval Then        result = result & " " & r.Offset(0, indexcol - 1)    End 
IfNext rMYVLOOKUP = resultEnd Function
Formula =MYVLOOKUP(lookup_value,lookup_range,return_column_no.)
It does join all the matches of the lookup in one cell (results separated by a 
space) and this fulfils my purpose.
The problem is, it is terribly slow. I couldn't manage to get results for a 
5 rows data with around 11000 lookup values despite waiting of 2-3 hours 
and eventually had to raise hands in despair.
Any ideas to (considerably) speed it up??
PS: My data is in Table format and changing its format doesn't change much. I 
can provide a sample file, if need be.
Many thanks in advance.
Best regards,
Abhishek-- 
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$$ I need the formula to look up

2015-11-05 Thread Paul Schreiner

can you send me your file so I can locate the issue? 
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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Monday, November 2, 2015 4:21 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
Paul 
I dont seem to understand these formulas given when l change the data the 
formula does not change


On Mon, Nov 2, 2015 at 8:51 PM, Will Sob  wrote:

i keep getting #Name result
On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner  wrote:

Dates should be displayed as the Windows settings dictate.
So, when *I* open it, the date displays as 11/2/2015.
you can change it to 02-Nov-2015 if you want, and the dates should calculate 
correctly.
 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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Monday, November 2, 2015 3:09 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
the date seems to be a problem 
it appears as 2/11/2015 on my computer 
it wont work 


On Mon, Nov 2, 2015 at 12:45 PM, Paul Schreiner  wrote:

Attached, I created a function to locate the most recent occurrence.=Find_Num()

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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Sunday, November 1, 2015 12:09 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
l meant from C8 to H78  I need a formula to look up when balls from 1-59 was 
last drawn and then look at the date this draw occurred and then calculate the 
difference between that date and today's date I dont know if this is possible 
it should look like this below

| 0 | 26 |
| 0 | 39 |
| 0 | 41 |
| 0 | 42 |
| 0 | 55 |
| 0 | 56 |
| 0 | 57 |
| 0 | 59 |
| 1 | 36 |
| 1 | 46 |
| 1 | 49 |
| 1 | 52 |
| 2 | 29 |
| 2 | 31 |
| 2 | 43 |
| 2 | 58 |
| 3 | 13 |
| 3 | 14 |
| 3 | 21 |
| 3 | 25 |
| 3 | 51 |
| 3 | 53 |
| 4 | 8 |
| 4 | 30 |
| 4 | 37 |
| 4 | 40 |
| 4 | 50 |
| 5 | 7 |
| 5 | 20 |
| 5 | 27 |
| 6 | 2 |
| 6 | 3 |
| 6 | 16 |
| 6 | 32 |
| 6 | 54 |
| 7 | 5 |
| 7 | 11 |
| 7 | 44 |
| 8 | 9 |
| 8 | 35 |
| 9 | 17 |
| 9 | 45 |
| 10 | 33 |
| 11 | 23 |
| 12 | 28 |
| 13 | 12 |
| 13 | 22 |
| 15 | 6 |
| 15 | 18 |
| 16 | 24 |
| 19 | 4 |
| 20 | 19 |
| 20 | 48 |
| 22 | 10 |
| 23 | 15 |
| 26 | 1 |
| 27 | 47 |
| 31 | 38 |
| 48 | 34 |




On Sun, Nov 1, 2015 at 1:19 PM, ashish koul  wrote:

check this see if it helps

On Sun, Nov 1, 2015 at 6:26 PM, Will Sob  wrote:

I need the formula to look up when forexample ball 33 was last drawn and then 
look at the date this draw occured andthen calculate the difference between 
that date and todays date
I dont know if thisis possible


-- 
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

Re: $$Excel-Macros$$ Help with Custom Vlookup

2015-11-05 Thread Abhishek Jain

Paul,

You are a real genius.

For around 42000 rows and 15000 look up values,* it took less than a
minute.*

Can't be better than that!

Thank you so much.

Best regards,

Abhishek


On Thu, Nov 5, 2015 at 9:53 PM, Paul Schreiner 
wrote:

> Here's my solution.
>
> It'll be interesting to see how it runs on a large data set!
>
> Here's the technique:
>
> If the Dictionary object is not defined, or has less than 10 entries, it
> loads the table into the dictionaries.
>
> So, for the FIRST iteration, the data is loaded.
>
> For each subsequent lookup, the dictionaries are used.
>
> let me know how it works for you!
>
> *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:* Abhishek Jain 
> *To:* Paul Schreiner 
> *Sent:* Thursday, November 5, 2015 7:25 AM
> *Subject:* Re: $$Excel-Macros$$ Help with Custom Vlookup
>
> Thanks Paul for your generous reply.
>
> I have attached herewith a sample file.
>
> Best regards,
>
> Abhishek
>
>
>
> On Thu, Nov 5, 2015 at 5:44 PM, Paul Schreiner 
> wrote:
>
> The speed of the worksheet is due to the fact that this UDF would execute
> for EACH row/cell where you've placed it.
> and update each time a sheet calculates
> (which occurs whenever you change a value)
>
> This function, run 50,000 times would indeed be slow!
>
> I'd suggest creating an alternative.
>
> Can I get a sample file (sent directly to me)?
>
> Even if you need to change some names to remove personal data.
>
> I routinely have macros load Public "dictionary" objects that are used to
> contain keywords that can then be located quickly.
>
> a couple of my workbooks contain over 100,000 rows of 70+ columns.
> So I often have to manage large amounts of data.
>
> If you can give me a sample, I'd be glad to take a look at it.
>
> *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:* Abhishek Jain 
> *To:* MS EXCEL AND VBA MACROS 
> *Cc:* Paul Schreiner 
> *Sent:* Tuesday, November 3, 2015 2:56 AM
> *Subject:* $$Excel-Macros$$ Help with Custom Vlookup
>
> Hi All,
>
> I intend to use this piece of UDF I found on internet for my requirement -
>
> Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long)
> Dim r As Range
> Dim result As String
> result = ""
> For Each r In lookuprange
> If r = lookupval Then
> result = result & " " & r.Offset(0, indexcol - 1)
> End If
> Next r
> MYVLOOKUP = result
> End Function
>
> Formula *=MYVLOOKUP(lookup_value,lookup_range,return_column_no.)*
>
> It does join all the matches of the lookup in one cell (results separated
> by a space) and this fulfils my purpose.
>
> The problem is, it is terribly slow. I couldn't manage to get results for
> a 5 rows data with around 11000 lookup values despite waiting of 2-3
> hours and eventually had to raise hands in despair.
>
> Any ideas to (considerably) speed it up??
>
> PS: My data is in Table format and changing its format doesn't change
> much. I can provide a sample file, if need be.
>
> Many thanks in advance.
>
> Best regards,
>
> Abhishek
> --
> 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

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

2015-11-05 Thread Abhishek Jain

It works on all criteria at my end. Please see that you are entering
characters without any spaces (before or after).

Try copy pasting the characters for understanding.

On Thu, Nov 5, 2015 at 7:01 PM, big smile  wrote:

> If i put 1A instead of A then it works
>
> On Thu, Nov 5, 2015 at 6:55 PM, big smile  wrote:
>
>> Thanks  a lot
>>
>> But if i put Table A then it shows 0 only. For Table A -- Both Risk Group
>> I /II not work..
>>
>> On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain 
>> wrote:
>>
>>> PFA
>>>
>>> On Thu, Nov 5, 2015 at 6:20 PM, big smile  wrote:
>>>
 Repected Friends  1]  Which formula I should use in E 13 ---  I want
 the value depends upon Risk Group & Table As per  B4 :D9 2] First I
 have to see the Group which I & II then Table A/B/C/D  It will take
 depends upon this two criteria the value  3]  I have to caluculate
 same way in more raws for full family. Thanks a lot .

 --
 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

$$Excel-Macros$$ Client in Houston need ClickView Softwarer with Reporting Module

2015-11-05 Thread MADHU-GenuineItLlc

Hi Partner,

Hope you are doing great ….

Please send me resume to ma...@genuineitllc.com



*Title : ClickView Softwarer*

*Location :Houston, TX*



*JD:-*

· Creation of reports against the data that has been captured using
ClickView software.

· Must have knowledge about using ClickView software and
familiarity with Reporting module







---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
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$$ Urgent need SR.NET Developer(Client Server ) -Oakland, CA--LOCAL preferred

2015-11-05 Thread MADHU-GenuineItLlc

Hi Partner,

Hope you are doing great ….

Please send me resume to ma...@genuineitllc.com



*Title : SR.NET  Developer(Client Server)*

*Location : Oakland, CA*

*Duration : 6 months*





Duties to Include:

ü  •Responsible for designing, programming and supporting various
applications written in VB.NET & ASP.NET that integrates with existing
technologies and applications with Microsoft SQL server as backend database
and integrated Business Objects reporting components.

ü  •Programmer typically is involved in maintenance (including production
support), enhancement and development work. Programmer should have a range
of skills and knowledge of the technologies used and applications supported
by the iACT. The Programmer will work with the lead systems architect on an
as needed basis to ensure that design and code meets customer requirements.



Minimum Requirements

ü  Bachelor of Science in Computer Programming, Computer Science,
Statistics, Mathematics or equivalent.

ü  Expert level of programming in *ASP.NET  4.5 and VB.NET
 and LINQ. *

ü  Intermediate level of programming in either T-SQL– must have in-depth
experience in writing complex query structure and general knowledge of
database management for either Oracle or Microsoft SQL, Oracle is
preferred.

ü  Experience with business intelligence tools – Business Objects or Cognos
preferred.

ü  Strong ability to apply analytic and critical thinking skills, writing
skills, communication skills, consulting skills, and ability to work within
a team. Must be an independent self-starter.



*Top 3 - 5 Daily responsibilities *

Responsible for designing, programming and supporting various applications
written in VB.NET & ASP.NET that integrates with existing technologies and
applications with Microsoft SQL server as backend database and integrated
Business Objects reporting components. Programmer typically is involved in
maintenance (including production support), enhancement and development
work. Programmer should have a range of skills and knowledge of the
technologies used and applications supported by the iACT. The Programmer
will work with the lead systems architect on an as needed basis to ensure
that design and code meets customer requirements.





*Top 3 - 5 Required Skills *

ü  Expert level of programming in ASP.NET 4.0 and VB.NET and LINQ.

ü  Intermediate level of programming in either T-SQL– must have in-depth
experience in writing complex query structure and general knowledge of
database management for either Oracle or Microsoft SQL, Oracle is
preferred.

ü  Experience with business intelligence tools – Business Objects or Cognos
preferred.



*Soft Skills:- *

Strong ability to apply analytic and critical thinking skills, writing
skills, communication skills, consulting skills, and ability to work within
a team. Must be an independent self-starter?



*Minimum educational requirement:* (per client Compliance this needs to be
atleast the same minimum requirements as a FTE in the same role)

Bachelor of Science in Computer Programming, Computer Science, Statistics,
Mathematics or equivalent.

Years of exp 6+

---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail

-- 
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

$$Excel-Macros$$ Search Numbers or Characters in Excel (as in Word)

2015-11-05 Thread kannan ramanathan



In MS Word, I can 
 search for any letter using ^$
 search for any number using ^#
Is there an equivalent in Excel?
e.g., if I want to find a number followed by a - (hyphen), is there a way 
to do this?

Thank you.

Kannan

-- 
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$$ Re: Search Numbers or Characters in Excel (as in Word)

2015-11-05 Thread Mandeep Baluja

Try This -([0-9]) in find box check the wild card characters.

Regards, 
Mandeep baluja

On Friday, November 6, 2015 at 6:25:46 AM UTC+5:30, kannan ramanathan wrote:
>
>
>
> In MS Word, I can 
>  search for any letter using ^$
>  search for any number using ^#
> Is there an equivalent in Excel?
> e.g., if I want to find a number followed by a - (hyphen), is there a way 
> to do this?
>
> Thank you.
>
> Kannan
>

-- 
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$$ Help with Custom Vlookup

2015-11-05 Thread Mandeep Baluja

Hi Paul, 

Kindly post the answer for this Query So That we can learn that trick too.

On Thursday, November 5, 2015 at 10:33:47 PM UTC+5:30, Abhi wrote:
>
> Paul, 
>
> You are a real genius.
>
> For around 42000 rows and 15000 look up values,* it took less than a 
> minute.*
>
> Can't be better than that!
>
> Thank you so much.
>
> Best regards,
>
> Abhishek
>
>
> On Thu, Nov 5, 2015 at 9:53 PM, Paul Schreiner  > wrote:
>
>> Here's my solution.
>>
>> It'll be interesting to see how it runs on a large data set!
>>
>> Here's the technique:
>>
>> If the Dictionary object is not defined, or has less than 10 entries, it 
>> loads the table into the dictionaries.
>>
>> So, for the FIRST iteration, the data is loaded.
>>
>> For each subsequent lookup, the dictionaries are used.
>>
>> let me know how it works for you!
>>
>> *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:* Abhishek Jain 
>> *To:* Paul Schreiner  
>> *Sent:* Thursday, November 5, 2015 7:25 AM
>> *Subject:* Re: $$Excel-Macros$$ Help with Custom Vlookup
>>
>> Thanks Paul for your generous reply.
>>
>> I have attached herewith a sample file.
>>
>> Best regards,
>>
>> Abhishek
>>
>>
>>
>> On Thu, Nov 5, 2015 at 5:44 PM, Paul Schreiner > > wrote:
>>
>> The speed of the worksheet is due to the fact that this UDF would execute 
>> for EACH row/cell where you've placed it.
>> and update each time a sheet calculates
>> (which occurs whenever you change a value)
>>
>> This function, run 50,000 times would indeed be slow!
>>
>> I'd suggest creating an alternative.
>>
>> Can I get a sample file (sent directly to me)?
>>
>> Even if you need to change some names to remove personal data.
>>
>> I routinely have macros load Public "dictionary" objects that are used to 
>> contain keywords that can then be located quickly.
>>
>> a couple of my workbooks contain over 100,000 rows of 70+ columns.
>> So I often have to manage large amounts of data.
>>
>> If you can give me a sample, I'd be glad to take a look at it.
>>  
>> *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:* Abhishek Jain 
>> *To:* MS EXCEL AND VBA MACROS  
>> *Cc:* Paul Schreiner  
>> *Sent:* Tuesday, November 3, 2015 2:56 AM
>> *Subject:* $$Excel-Macros$$ Help with Custom Vlookup
>>
>> Hi All,
>>
>> I intend to use this piece of UDF I found on internet for my requirement -
>>
>> Function MYVLOOKUP(lookupval, lookuprange As Range, indexcol As Long)
>> Dim r As Range
>> Dim result As String
>> result = ""
>> For Each r In lookuprange
>> If r = lookupval Then
>> result = result & " " & r.Offset(0, indexcol - 1)
>> End If
>> Next r
>> MYVLOOKUP = result
>> End Function
>>
>> Formula *=MYVLOOKUP(lookup_value,lookup_range,return_column_no.)*
>>
>> It does join all the matches of the lookup in one cell (results separated 
>> by a space) and this fulfils my purpose.
>>
>> The problem is, it is terribly slow. I couldn't manage to get results for 
>> a 5 rows data with around 11000 lookup values despite waiting of 2-3 
>> hours and eventually had to raise hands in despair.
>>
>> Any ideas to (considerably) speed it up??
>>
>> PS: My data is in Table format and changing its format doesn't change 
>> much. I can provide a sample file, if need be.
>>
>> Many thanks in advance.
>>
>> Best regards,
>>
>> Abhishek
>> -- 
>> 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

$$Excel-Macros$$ Re: How to keep variables constant in a procedure

2015-11-05 Thread Mandeep Baluja

Kindly Provide the Full code for better understanding as this code doesn't 
seems to work as per your requirement . Difficult to figure Out where the 
Num Sell is using as input. 

Regards,
Mandeep 

-- 
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$$ Imm Need: Cronacle Architect -TX - 4 M

2015-11-05 Thread MADHU-GenuineItLlc

Hi,

I have below requirement for one of our client, let me know if you are
comfortable.



*Job Title: Cronacle Architect*

*Location: Houston TX*

*Duration:4 Months*



*Job Description:*

· Technical skills, Communication and Business knowledge
(preferred)

Senior Functional Consultant: Supervises business diagnosis and planning
activities.

· Define the security architecture, ensuring that it meets
the business requirements and performance goals.

· UNIX scripting.

· *Working experience on Cronacle is nice to have.*

Resource has worked on *IBM Redwood, HP Tivoli, Scheduling*  and used these
tools for job scheduling we can consider those resources as well.



---

*With Warm Regards *

*Madhu Roy*

GenuineIT LLC *Certified Women Owned Business*

Making IT Happen…

Ph: 832 539 3475

Fax: 281-605-5969

*E-Mail* :ma...@genuineitllc.com

*Gmail *: *nandimadhu74 , madhu.genuineitllc*

*YM  *: madhu_recruiter



Looking ahead to work with you for better Business prospects



According to Bill S.1618 Title III passed by the 105th US Congress, this
message is not considered as "Spam" as we have included the contact
information. If you wish to be removed from our mailing list, please
respond with "remove" in the subject field. We apologize for any
inconvenience caused.

Please consider the environment before printing this e-mail



·

-- 
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$$ Formula to take the value depends upon the two values

2015-11-05 Thread big smile

Thanks  a lot

But if i put Table A then it shows 0 only. For Table A -- Both Risk Group I
/II not work..

On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain 
wrote:

> PFA
>
> On Thu, Nov 5, 2015 at 6:20 PM, big smile  wrote:
>
>> Repected Friends  1]  Which formula I should use in E 13 ---  I want the
>> value depends upon Risk Group & Table As per  B4 :D9 2] First I have to
>> see the Group which I & II then Table A/B/C/D  It will take depends upon
>> this two criteria the value  3]  I have to caluculate same way in more
>> raws for full family. Thanks a lot .
>>
>> --
>> 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$$ Formula to take the value depends upon the two values

2015-11-05 Thread big smile

If i put 1A instead of A then it works

On Thu, Nov 5, 2015 at 6:55 PM, big smile  wrote:

> Thanks  a lot
>
> But if i put Table A then it shows 0 only. For Table A -- Both Risk Group
> I /II not work..
>
> On Thu, Nov 5, 2015 at 6:49 PM, Abhishek Jain 
> wrote:
>
>> PFA
>>
>> On Thu, Nov 5, 2015 at 6:20 PM, big smile  wrote:
>>
>>> Repected Friends  1]  Which formula I should use in E 13 ---  I want
>>> the value depends upon Risk Group & Table As per  B4 :D9 2] First I
>>> have to see the Group which I & II then Table A/B/C/D  It will take
>>> depends upon this two criteria the value  3]  I have to caluculate same
>>> way in more raws for full family. Thanks a lot .
>>>
>>> --
>>> 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$$ I need the formula to look up

2015-11-05 Thread Paul Schreiner

Did you open the file I attached?(here it is again) The find_Num function is in 
Module1
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: Will Sob 
 To: excel-macros@googlegroups.com 
 Sent: Thursday, November 5, 2015 7:46 AM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
Thanks Paul this is very helpful bless you. Can you help me how do I input the 
formula find_num in my function list. My excel doesn't recognize this

On 5 Nov 2015 12:29, "Paul Schreiner"  wrote:

What version of Windows are you using?
In Windows 7, under Control Panel, there is a selection called"Region and 
Language"
Selecting this allows you to change the display format for displaying dates and 
Times.
Excel uses THIS setting to determine the default display for dates.
For instance: if you tell Windows that a date is in mm/dd/ format,when you 
enter 10/31/2015, Excel will recognize it as a "date" and actually STORE the 
cell value as: 42308 (the number of days since 1-Jan-1900)
But, if you were to enter the value as 31/10/2015, Excel would NOT see this as 
a valid date and would store the value as TEXT.
Now, no matter WHAT your Windows Default is set to, you can always change a 
cell format to display the data in any manner.
For instance; if you were to enter: 42307 in the cell,you could then change the 
date format (using right-click->format cells..)and change the displayed format 
to a custom display of dd/mm/.Which would display the value of 42307 as 
30/10/2015
The problem here is that, if you were to have your WINDOWS date format set to 
mm-dd-, even though you changed the CELL format to dd-mm-when you enter 
the value as 30-10-2015, Excel doesn't compare it to the CELL format, but only 
the WINDOWS format, and will conclude the value is TEXT.
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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Monday, November 2, 2015 3:31 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
Hi paul how do i change the date to 31/10/2015


On Mon, Nov 2, 2015 at 8:28 PM, Paul Schreiner  wrote:

Dates should be displayed as the Windows settings dictate.
So, when *I* open it, the date displays as 11/2/2015.
you can change it to 02-Nov-2015 if you want, and the dates should calculate 
correctly.
 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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Monday, November 2, 2015 3:09 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
the date seems to be a problem 
it appears as 2/11/2015 on my computer 
it wont work 


On Mon, Nov 2, 2015 at 12:45 PM, Paul Schreiner  wrote:

Attached, I created a function to locate the most recent occurrence.=Find_Num()

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: Will Sob 
 To: "excel-macros@googlegroups.com"  
 Sent: Sunday, November 1, 2015 12:09 PM
 Subject: Re: $$Excel-Macros$$ I need the formula to look up
   
l meant from C8 to H78  I need a formula to look up when balls from 1-59 was 
last drawn and then look at the date this draw occurred and then calculate the 
difference between that date and today's date I dont know if this is possible 
it should look like this below

| 0 | 26 |
| 0 | 39 |
| 0 | 41 |
| 0 | 42 |
| 0 | 55 |
| 0 | 56 |
| 0 | 57 |
| 0 | 59 |
| 1 | 36 |
| 1 | 46 |
| 1 | 49 |
| 1 | 52 |
| 2 | 29 |
| 2 | 31 |
| 2 | 43 |
| 2 | 58 |
| 3 | 13 |
| 3 | 14 |
| 3 | 21 |
| 3 | 25 |
| 3 | 51 |
| 3 | 53 |
| 4 | 8 |
| 4 | 30 |
| 4 | 37 |
| 4 | 40 |
| 4 | 50 |
| 5 | 7 |
| 5 | 20 |
| 5 | 27 |
| 6 | 2 |
| 6 | 3 |
| 6 | 16 |
| 6 | 32 |
| 6 | 54 |
| 7 | 5 |
| 7 | 11 |
| 7 | 44 |
| 8 | 9 |
| 8 | 35 |
| 9 | 17 |
| 9 | 45 |
| 10 | 33 |
| 11 | 23 |
| 12 | 28 |
| 13 | 12 |
| 13 | 22 |
| 15 | 6 |
| 15 | 18 |
| 16 | 24 |
|

$$Excel-Macros$$ MACRO VBA

$$Excel-Macros$$ Pivot Table & Counting Colors w/conditional formatting

$$Excel-Macros$$ Formula to take the value depends upon the two values

Re: $$Excel-Macros$$ MACRO VBA

Re: $$Excel-Macros$$ I need the formula to look up

Re: $$Excel-Macros$$ I need the formula to look up

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

Re: $$Excel-Macros$$ Fwd: Hide column as per option choice. - Attach Sheet..

Re: $$Excel-Macros$$ Help with Custom Vlookup

Re: $$Excel-Macros$$ I need the formula to look up

Re: $$Excel-Macros$$ Help with Custom Vlookup

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

$$Excel-Macros$$ Client in Houston need ClickView Softwarer with Reporting Module

$$Excel-Macros$$ Urgent need SR.NET Developer(Client Server ) -Oakland, CA--LOCAL preferred

$$Excel-Macros$$ Search Numbers or Characters in Excel (as in Word)

$$Excel-Macros$$ Re: Search Numbers or Characters in Excel (as in Word)

Re: $$Excel-Macros$$ Help with Custom Vlookup

$$Excel-Macros$$ Re: How to keep variables constant in a procedure

$$Excel-Macros$$ Imm Need: Cronacle Architect -TX - 4 M

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

Re: $$Excel-Macros$$ Formula to take the value depends upon the two values

Re: $$Excel-Macros$$ I need the formula to look up

22 matches

Site Navigation

Mail list logo

Footer information