date:20170427

$$Excel-Macros$$ how to process parallel ranges with 'for each'

2017-04-27 Thread Raymond Jerome



I want to take 2 ranges, 1 dim each, can be 2 rows or 2 columns, but I need 
to take a cell from one range and do something with it's 'parallel' cell in 
the other range.
for example, something like a root mean square deviation. One column is 
data values, other column is expected values and the loop sums 
(data(i)-expect(i))^2...
here is how I understand doing something like this on one column or row, 
very simple, no error checking...

Function rms(ByVal Target As Range) As Double
'root mean squared. quadratic mean
Dim Cell As Range
Dim summand As Double
Dim tot As Integer
tot = 0
summand = 0#
For Each Cell In Target.Cells
If IsNumeric(Cell) Then
tot = tot + 1
summand = summand + Cell ^ 2
End If
Next Cell
rms = Math.Sqr(summand / tot)
End Function

what i do not understand or can't figure is how to do tghis kind of thing 
on 2 ranges where a cell from one and a similar cell from the other are co 
processed. Perhaps using .address or .row or .col mixed and matched or 
split out... But is there some simpler way?
thank you

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Urgent java developer NJ

2017-04-27 Thread Lisa Ray



Hi


One of our  client is urgently looking *Java Developer, *below is the Job 
description, please feel free to call me back at 732 659 8650


Pls send the resume on l...@techpunditsinc.com


SURE INTERVIEW

RATE REQUIRED IN $50/- ON C2C

 

*Sr. Core Java Developer*

*Location - New jersey*

*Duration: Long Term*

*Type: Contract*

 

*Skills - Core Java, Strong Multithreading, Spring, SQL front end .*




Thanks & Regards

Lisa

l...@techpunditsinc.com

732 659 8650

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Need :: Senior Java Lead/ Developer :: Baltimore, MD :: 8 Months

2017-04-27 Thread Vijay Narayana

Hi,

We have *Immediate interview Slots with HCL *for the below position. Please
let me know if you are interested.



*Role: Senior Java Lead/ Developer*


*Location: Baltimore, MD*

*Duration: 8 Months*

*Interview:   Initially Skype*

*Final round for Face to Face*



*Job Description:*

*Skills:*"Strong  Development"" experience.

Experience in Financial Services, Data laws, preferably Wealth Management

Social skills, persistence and backbone to work with difficult
stakeholders"





The position is for an experienced Senior Java Lead to work within the
Wealth Management Global Technology Team, supporting the Client OnBoarding
US program

The successful candidate needs to be self motivated and a good team player.

• Participate in the analysis and design of applications with the System
Architect and Business Users (including business model, security model and
Business components);

• Must have 10+ years hands on development experience in J2EE applications

• Translate business model and user requirements into software
specifications;

• Make recommendations towards the development of new code and or reuse of
existing code;

• Deliver documentation (eg. High Leve Architecture, Low Level Design
Documents) during various stages of the project and upon completion of the
project;

• Support testing (Unit, SIT, UAT);




*Skill Summary*:

"*Following skills are REQUIRED in the prospective candidate:-*

• 7 to 8 years of relevant work experience: experience in large/complex IT
architecture environments and experience as a solution or application
architect on large-scale development projects

• Ability to work independently and as part of a team

• Ability to interact with both Business and Technology colleagues

• Strong problem solving and analytical skills demonstrated by the ability
to assimilate new information, understand complex topics and arrive at
sound analysis and judgment

• Proven working knowledge of J2EE, JSF,Tomcat, Spring, Web Services,
Oracle and related technologies

• Strong analysis and design skills, including requirements analysis,
Object Oriented design patterns, and UML

• Demonstrated knowledge and competence in project management principles

• Excellent verbal communication, writing and presentation skills

• Speaks directly and to the point

Following skills are PREFERRED in the prospective candidate:-

• Experience with Wealth Management client onboarding and new account
opening processes, including Know Your Client (KYC) requirements

• Familiarity with Appway platform
















Thanks and Regards

*Vijay Valiveti*

Ph: 901-203-2883|| Email: vijay_valiv...@visionisys.com

*Visionisys Inc*|| www.visionisys.com

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Fluxtek Solutions Updated & Available Hot-List

2017-04-27 Thread Venkat j



Hi,

 

Hope you are doing great!.

 

This is *venkat* from Fluxtek Solutions. 

Below are my available consultants Hotlist. Kindly send the suitable 
requirements and also add me in your mailing list. We do have additional

consultants available as well. Please send your requirements only to 
venkat.re...@fluxteksol.com  You can reach me at Direct : 8008692710.  Ph : 
8325582010 
EXT 113


*NAME*

*TECHNOLOGY*

*LOCATION*

*STATUS*

*RELOCATION*

*KARTHIK*

*COGNOS*

*TEXAS*

*EAD*

*OPEN*

*R VIJAY*

*JAVA/ J2EE*

*CONNECTICUT*

*H1B*

*OPEN*

*SAHITHI*

*.NET DEVELOPER*

HOUSTON

*EAD*

*NO*

*SIDDARDHA*

*SFDC*

*ATLANTA GA*

*EAD*

*OPEN*



Thanks and Regards,
venkat,
*Fluxtek Solutions Inc.*

Ph:8325582010 ext 113

Email: *venkat.re...@fluxteksol.com* 
*www.fluxteksol.com *

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Need :: Business Analyst with Mobile & E-commerce @ Bellevue, WA / Deerfield, IL :: 6+ Months

2017-04-27 Thread Vijay Narayana

Hi,

We have *Immediate Interview Slots* for the below position with *Photon*.
Please let me know if you are interested.



*Role: Business Analyst with Mobile & E-commerce *

*Locations:**Bellevue, WA** / Deer field, IL*

*Duration: 6+ Months *



*Job Description:*

*Primary : Mobile experience with E-commerce/ Retail.*



*Must haves:*

Required *7+ years minimum experience as a technical analyst* in the
Retail/financial industry and *with E-commerce & Retail*



As a Technical Analyst in Digital Business and Data Services, you will have
responsibilities that include technical analysis, writing
functional/technical stories, producing interface specifications and
testing related to the middleware component of Digital initiatives. You
will interface with members of your scrum team as well as business analysts
from other teams to deliver digital solutions across retail and investment
(asset management, brokerage) banking areas.



*Qualifications:*

*Specific Technical and Business Skills*

· Required 7+ years minimum experience as a technical analyst in
the Retail industry

· Strong functional understanding of retail banking and/or
investment domains

· Ability to work with product, business and application teams to
define and document functional requirements for a SOA/services/messaging  team
to build services

· Strong written and verbal communication skills

· Strong interpersonal skills and time management skills

· Strong analytical and troubleshooting skills

· Strong experience with Agile development methodologies

· Strong SQL skills to analyze existing data and identify gaps/data
quality issues

· Ability to write technical stories in JIRA using industry
standard notations (like Gherkin)

· Experience working with XML, JSON message formats

· Prior experience working in large, complex data environments

· Prior experience working on large and medium scale software
projects

· Thorough knowledge of SDLC (Software Development Life Cycle)

· Demonstrated teamwork and ability to work with diversified
multi-location team



*Preferred Knowledge and Experience:*

Prior experience working in a shared services/enterprise level organization.







Thanks and Regards

*Vijay Valiveti*

Ph: 901-203-2883|| Email: vijay_valiv...@visionisys.com
*Visionisys Inc*

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: automate copy paste

2017-04-27 Thread Mandeep baluja

Sub T()
 For Each sht In ActiveWorkbook.Sheets
 sht.UsedRange.Value = sht.UsedRange.Value

Next
End Sub

Try this 

Mandeep baluja 







On Wednesday, 29 March 2017 12:54:31 UTC+5:30, Sundarvelan wrote:
>
> Dear Friends,
>
> I have excel book with 70 to 90 sheets, each sheet has formulas.
>
> For consolidation purpose i need to copy paste each sheet as values.
>
> Is there any way to automate this copy paste.
>
> Thanks
> N.Sundarvelan
> 9600160150
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: If 2 conditions matches then give alert -- already exit

2017-04-27 Thread Mandeep baluja

Apply data validation in D4:D100 with Custom 
formula =COUNTIFS($D$4:$D$30,D9,$A$4:$A$30,A9)=1

Regards
Mandeep baluja 




On Monday, 17 April 2017 09:46:30 UTC+5:30, big smile wrote:
>
>
> Hello Friends 
>
> I want  that Column A & Column D this both contains if matches 
> With the same entry again then it should show me the error 
> That It is already exit in the Raw  _  which matches the same 
>
> Ex 
> If I have already had one entry in Raw 6 – Where written RAVI + Shop
> I am doing one entry again in Raw 8 
> Like this --- Ravi --  Borivlai – Direct – Shop- 50 
> Then  -- Ravi + Shop both alreay have in the raw 6 .
> So while doing new entry in raw 8 – it should show me that it is there in 
> Raw 6 .
>
>

-- 
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 https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ how to process parallel ranges with 'for each'

$$Excel-Macros$$ Urgent java developer NJ

$$Excel-Macros$$ Need :: Senior Java Lead/ Developer :: Baltimore, MD :: 8 Months

$$Excel-Macros$$ Fluxtek Solutions Updated & Available Hot-List

$$Excel-Macros$$ Need :: Business Analyst with Mobile & E-commerce @ Bellevue, WA / Deerfield, IL :: 6+ Months

$$Excel-Macros$$ Re: automate copy paste

$$Excel-Macros$$ Re: If 2 conditions matches then give alert -- already exit

7 matches

Site Navigation

Mail list logo

Footer information