$$Excel-Macros$$ *** we provide GC and USC only***
*** we provide GC and USC only*** Hi Partner, Hope you are doing well…. Here is the list of available consultants on my bench for C2C projects. They are very good at communication skills and technical skills and are open to relocate to anywhere in the USA. I am requesting you to share the suitable requirements on *m...@golokglobal.com* * Desk No:9722329938* *Name* *Skills* *Experience* *Relocation* * Availability* Ali Akbar DevOps 8 Years TX Immediate Adnan .NET 8 Years Open Immediate Sushil Pokharel Java developer 8 Years Open Immediate Ashish DevOps 7 Years Open Immediate Atit Shah Dyna CRM 8+ Years Open Immediate Bijay Dhakal DevOps 8+ Years Open Immediate Divya Kovelamudi Java UI 8 Years Open Immediate Dixit DevOps 8 Years Open Immediate Krishna Thallapa QA/Testing 5 Years Open Immediate Mahesh - CRM Dyna CRM 8 Years TX Immediate Mini Kriplani SSBC Admin 8 Years Open Immediate Vishwa Janani BA 8 Years Open Immediate Niharika Reddy Tableau 7 Years Open Immediate Parth Patel .Net 7 Years Open Immediate Pooja Gumaste BA 8 Years WA Immediate Shaqeel BA 8 Years Open Immediate Sunil Salis DevOps 8 Years Open Immediate Sweta Rao SalesForce 8 Years Open Immediate *** we provide GC and USC only*** -- 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.
Re: $$Excel-Macros$$ Formula help needed
On Wed, 2/8/17, storeythomas725 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: excel-macros@googlegroups.com
Date: Wednesday, February 8, 2017, 8:30 PM
On Wed, 2/8/17, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: excel-macros@googlegroups.com
Date: Wednesday, February 8, 2017, 3:01 PM
On Wed, 2/8/17, Paul Schreiner
wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: "excel-macros@googlegroups.com"
Date: Wednesday, February 8, 2017, 2:29 PM
The
Match() function will return the relative column for
the
date matching the header.So:
Your array of data is in E1:AI1 and if you're
looking
for the date in cell C1, you would
use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for
when
you
copy the formulas)
In this case, the function
returns 31, which is the number of columns beginning
from
column E.The index() function starts
with the entire array of data (E1:AI7)and
uses a row,column offset into this array.
In cell C2,
use the
formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1))
the row()
function returns the current row.You
can then copy this function to the rows in column C
and
D.
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
-
On Tuesday, February
7, 2017 10:34 AM, Amit Desai (MERU)
wrote:
#yiv0040706336 #yiv0040706336 --
filtered {font-family:Calibri;panose-1:2 15 5 2
2 2 4 3 2
4;}
#yiv0040706336 filtered
{font-family:Tahoma;panose-1:2 11 6
4 3 5 4 4 2 4;}
#yiv0040706336
p.yiv0040706336MsoNormal, #yiv0040706336
li.yiv0040706336MsoNormal, #yiv0040706336
div.yiv0040706336MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}
#yiv0040706336 a:link, #yiv0040706336
span.yiv0040706336MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv0040706336 a:visited, #yiv0040706336
span.yiv0040706336MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv0040706336 p.yiv0040706336MsoAcetate,
#yiv0040706336
li.yiv0040706336MsoAcetate, #yiv0040706336
div.yiv0040706336MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}
#yiv0040706336 span.yiv0040706336EmailStyle17
{color:windowtext;}
#yiv0040706336 span.yiv0040706336BalloonTextChar
{}
#yiv0040706336 .yiv0040706336MsoChpDefault
{}
#yiv0040706336 filtered {margin:72.0pt 72.0pt
72.0pt
72.0pt;}
#yiv0040706336 div.yiv0040706336WordSection1
{}
#yiv0040706336
Dear Friends,
I am stuck while
preparing a dashboard. I need auto pickup of data
based
(in
cell highlighted yellow) on model & date from
the
right
side. If I change date (from 31-Jan-17 to 27-Jan-17)
the
data should change..
I think Index/Match with
vlookup should work.. but not sure how to use it..
please
help.
Best
Regards,
Amit
Desai
Contact: -
09867232534
Disclaimer: This message and its attachments contain
confidential information and may also contain
legally
privileged information. This message is intended
solely
for
the named addressee. If you are not the addressee
indicated
in this message (or authorized
to receive for addressee), you may not copy or
deliver any
part of this message or its attachments to anyone or
use
any
part of this message or its attachments. Rather, you
should
permanently delete this message and its attachments
(and
all
copies) from your
system and kindly notify the sender by reply e-mail.
Any
content of this message and its attachments that does
not
relate to the official business of Meru Cab Company
Pvt.
Ltd. must be taken not to have been sent or endorsed
by
any
of them. Email communications
are not private and no warranty is made that e-mail
communications are timely, secure or free from
computer
virus or other defect.
--
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
Probl
Re: $$Excel-Macros$$ Formula help needed
On Wed, 2/8/17, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: excel-macros@googlegroups.com
Date: Wednesday, February 8, 2017, 3:01 PM
On Wed, 2/8/17, Paul Schreiner
wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: "excel-macros@googlegroups.com"
Date: Wednesday, February 8, 2017, 2:29 PM
The
Match() function will return the relative column for the
date matching the header.So:
Your array of data is in E1:AI1 and if you're looking
for the date in cell C1, you would
use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for when
you
copy the formulas)
In this case, the function
returns 31, which is the number of columns beginning from
column E.The index() function starts
with the entire array of data (E1:AI7)and
uses a row,column offset into this array.
In cell C2,
use the
formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1))
the row()
function returns the current row.You
can then copy this function to the rows in column C and
D.
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
-
On Tuesday, February
7, 2017 10:34 AM, Amit Desai (MERU)
wrote:
#yiv0040706336 #yiv0040706336 --
filtered {font-family:Calibri;panose-1:2 15 5 2
2 2 4 3 2
4;}
#yiv0040706336 filtered
{font-family:Tahoma;panose-1:2 11 6
4 3 5 4 4 2 4;}
#yiv0040706336
p.yiv0040706336MsoNormal, #yiv0040706336
li.yiv0040706336MsoNormal, #yiv0040706336
div.yiv0040706336MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}
#yiv0040706336 a:link, #yiv0040706336
span.yiv0040706336MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv0040706336 a:visited, #yiv0040706336
span.yiv0040706336MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv0040706336 p.yiv0040706336MsoAcetate,
#yiv0040706336
li.yiv0040706336MsoAcetate, #yiv0040706336
div.yiv0040706336MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}
#yiv0040706336 span.yiv0040706336EmailStyle17
{color:windowtext;}
#yiv0040706336 span.yiv0040706336BalloonTextChar
{}
#yiv0040706336 .yiv0040706336MsoChpDefault
{}
#yiv0040706336 filtered {margin:72.0pt 72.0pt 72.0pt
72.0pt;}
#yiv0040706336 div.yiv0040706336WordSection1
{}
#yiv0040706336
Dear Friends,
I am stuck while
preparing a dashboard. I need auto pickup of data based
(in
cell highlighted yellow) on model & date from the
right
side. If I change date (from 31-Jan-17 to 27-Jan-17) the
data should change..
I think Index/Match with
vlookup should work.. but not sure how to use it.. please
help.
Best
Regards,
Amit
Desai
Contact: -
09867232534
Disclaimer: This message and its attachments contain
confidential information and may also contain legally
privileged information. This message is intended solely
for
the named addressee. If you are not the addressee
indicated
in this message (or authorized
to receive for addressee), you may not copy or
deliver any
part of this message or its attachments to anyone or use
any
part of this message or its attachments. Rather, you
should
permanently delete this message and its attachments (and
all
copies) from your
system and kindly notify the sender by reply e-mail.
Any
content of this message and its attachments that does not
relate to the official business of Meru Cab Company Pvt.
Ltd. must be taken not to have been sent or endorsed by
any
of them. Email communications
are not private and no warranty is made that e-mail
communications are timely, secure or free from computer
virus or other defect.
--
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 i
$$Excel-Macros$$ Technical Lead @ Wallingford, CT
Hello, Hope you are doing great. We have an urgent below *"Technical Lead”* position with one of our client for c2c position at *Wallingford, CT.* If you are interested please share your updated resume along with contact details to govind_ramanu...@visionisys.com *Job Title : Technical Lead* *Location : Wallingford, CT* *Duration : 9 months* *Job Description : * We are looking for a C# developer responsible for enhancing and supporting our C# Windows Forms application. Your primary responsibilities will be to design and develop these change requests and to address client issues by providing timely and accurate resolutions, and to coordinate with the rest of the team working at offshore. Therefore, a commitment to collaborative problem solving, sophisticated design, and quality product is essential. Interact with client on a day-to-day basis. Translate application storyboards and use cases into functional applications Design, build, and maintain efficient, reusable, and reliable C# code Ensure the best possible performance, quality, and responsiveness of application Identify bottlenecks and bugs, and devise solutions to these problems Help maintain code quality, organization, and automatization Proficient in C#, with a good knowledge of its ecosystems Strong understanding of object-oriented programming Skill for writing reusable C# libraries Familiar with various design and architectural patterns Familiarity with SQL concepts. Knowledge of MUMPHS and Intersystems Cache is added advantage Experience with Windows Forms application and web services Knack for writing clean, readable C# code Understanding fundamental design principles behind a scalable application Basic understanding of Common Language Runtime (CLR), its limitations, weaknesses, and workarounds Implementing automated testing platforms and unit tests Proficient understanding of code versioning tools (TFS) Familiarity with continuous integration Prior experience of working in client-facing projects is a must Knowledge of healthcare concepts is required *Govind Ramanujam* Visionisys Inc Direct: 9724531361 Email: govind_ramanu...@visionisys.com || www.visionisys.com *Note* : If you have received this mail in error or prefer not to receive such emails in the future, please reply with "REMOVE" in the subject line and the email id(s) to be removed. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused -- 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$$ Technical Lead @ Wallingford, CT
Hello, Hope you are doing great. We have an urgent below *"Technical Lead”* position with one of our client for c2c position at *Wallingford, CT.* If you are interested please share your updated resume along with contact details to govind_ramanu...@visionisys.com *Job Title : Technical Lead* *Location : Wallingford, CT* *Duration : 9 months* *Job Description : * We are looking for a C# developer responsible for enhancing and supporting our C# Windows Forms application. Your primary responsibilities will be to design and develop these change requests and to address client issues by providing timely and accurate resolutions, and to coordinate with the rest of the team working at offshore. Therefore, a commitment to collaborative problem solving, sophisticated design, and quality product is essential. Interact with client on a day-to-day basis. Translate application storyboards and use cases into functional applications Design, build, and maintain efficient, reusable, and reliable C# code Ensure the best possible performance, quality, and responsiveness of application Identify bottlenecks and bugs, and devise solutions to these problems Help maintain code quality, organization, and automatization Proficient in C#, with a good knowledge of its ecosystems Strong understanding of object-oriented programming Skill for writing reusable C# libraries Familiar with various design and architectural patterns Familiarity with SQL concepts. Knowledge of MUMPHS and Intersystems Cache is added advantage Experience with Windows Forms application and web services Knack for writing clean, readable C# code Understanding fundamental design principles behind a scalable application Basic understanding of Common Language Runtime (CLR), its limitations, weaknesses, and workarounds Implementing automated testing platforms and unit tests Proficient understanding of code versioning tools (TFS) Familiarity with continuous integration Prior experience of working in client-facing projects is a must Knowledge of healthcare concepts is required *Govind Ramanujam* Visionisys Inc Direct: 9724531361 Email: govind_ramanu...@visionisys.com || www.visionisys.com *Note* : If you have received this mail in error or prefer not to receive such emails in the future, please reply with "REMOVE" in the subject line and the email id(s) to be removed. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused -- 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$$ Senior .Net Developer @ Santa Clara, CA
Hello, Hope you are doing great. We have an urgent below *"Senior .Net Developer”* position with one of our client for c2c position at *Santa Clara, CA.* If you are interested please share your updated resume along with contact details to govind_ramanu...@visionisys.com *Job Title : Senior .Net Developer* *Location : Santa Clara, CA* *Duration : 6 months* *Job Description : * .Net developers with WPF knowledge, This developer must be proactive and able to work independently asking questions when required. It's not the right fit if this developer needs a full spec to work and is used to the traditional waterfall approach. C#, .Net, WPF, LinQ, Multi-threading PRISM – Microsoft frame work MVVM – model-view-view-model Nice to have: monitoring applications *Govind Ramanujam* Visionisys Inc Direct: 9724531361 Email: govind_ramanu...@visionisys.com || www.visionisys.com *Note* : If you have received this mail in error or prefer not to receive such emails in the future, please reply with "REMOVE" in the subject line and the email id(s) to be removed. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused -- 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$$ Senior .Net developer2 Santa Clara, CA
Hello, Hope you are doing great. We have an urgent below *"Senior .Net Developer”* position with one of our client for c2c position at *Santa Clara, CA.* If you are interested please share your updated resume along with contact details to govind_ramanu...@visionisys.com *Job Title : Senior .Net Developer* *Location : Santa Clara, CA* *Duration : 6 months* *Job Description : * .Net developers with WPF knowledge, This developer must be proactive and able to work independently asking questions when required. It's not the right fit if this developer needs a full spec to work and is used to the traditional waterfall approach. C#, .Net, WPF, LinQ, Multi-threading PRISM – Microsoft frame work MVVM – model-view-view-model Nice to have: monitoring applications *Govind Ramanujam* Visionisys Inc Direct: 9724531361 Email: govind_ramanu...@visionisys.com || www.visionisys.com *Note* : If you have received this mail in error or prefer not to receive such emails in the future, please reply with "REMOVE" in the subject line and the email id(s) to be removed. All removal requests will be honored ASAP. We sincerely apologize for any inconvenience caused -- 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.
Re: $$Excel-Macros$$ Formula help needed
On Wed, 2/8/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Formula help needed
To: "excel-macros@googlegroups.com"
Date: Wednesday, February 8, 2017, 2:29 PM
The
Match() function will return the relative column for the
date matching the header.So:
Your array of data is in E1:AI1 and if you're looking
for the date in cell C1, you would use:MATCH(C$1,$E$1:$AI$1)(the "$" will be
necessary for when you
copy the formulas)
In this case, the function
returns 31, which is the number of columns beginning from
column E.The index() function starts
with the entire array of data (E1:AI7)and
uses a row,column offset into this array.
In cell C2,
use the formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1))
the row()
function returns the current row.You
can then copy this function to the rows in column C and
D.
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
-
On Tuesday, February
7, 2017 10:34 AM, Amit Desai (MERU)
wrote:
#yiv0040706336 #yiv0040706336 --
filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2
4;}
#yiv0040706336 filtered {font-family:Tahoma;panose-1:2 11 6
4 3 5 4 4 2 4;}
#yiv0040706336
p.yiv0040706336MsoNormal, #yiv0040706336
li.yiv0040706336MsoNormal, #yiv0040706336
div.yiv0040706336MsoNormal
{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;}
#yiv0040706336 a:link, #yiv0040706336
span.yiv0040706336MsoHyperlink
{color:blue;text-decoration:underline;}
#yiv0040706336 a:visited, #yiv0040706336
span.yiv0040706336MsoHyperlinkFollowed
{color:purple;text-decoration:underline;}
#yiv0040706336 p.yiv0040706336MsoAcetate, #yiv0040706336
li.yiv0040706336MsoAcetate, #yiv0040706336
div.yiv0040706336MsoAcetate
{margin:0cm;margin-bottom:.0001pt;font-size:8.0pt;}
#yiv0040706336 span.yiv0040706336EmailStyle17
{color:windowtext;}
#yiv0040706336 span.yiv0040706336BalloonTextChar
{}
#yiv0040706336 .yiv0040706336MsoChpDefault
{}
#yiv0040706336 filtered {margin:72.0pt 72.0pt 72.0pt
72.0pt;}
#yiv0040706336 div.yiv0040706336WordSection1
{}
#yiv0040706336
Dear Friends,
I am stuck while
preparing a dashboard. I need auto pickup of data based (in
cell highlighted yellow) on model & date from the right
side. If I change date (from 31-Jan-17 to 27-Jan-17) the
data should change..
I think Index/Match with
vlookup should work.. but not sure how to use it.. please
help.
Best
Regards,
Amit
Desai
Contact: -
09867232534
Disclaimer: This message and its attachments contain
confidential information and may also contain legally
privileged information. This message is intended solely for
the named addressee. If you are not the addressee indicated
in this message (or authorized
to receive for addressee), you may not copy or deliver any
part of this message or its attachments to anyone or use any
part of this message or its attachments. Rather, you should
permanently delete this message and its attachments (and all
copies) from your
system and kindly notify the sender by reply e-mail. Any
content of this message and its attachments that does not
relate to the official business of Meru Cab Company Pvt.
Ltd. must be taken not to have been sent or endorsed by any
of them. Email communications
are not private and no warranty is made that e-mail
communications are timely, secure or free from computer
virus or other defect.
--
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 gr
Re: $$Excel-Macros$$ Formula help needed
The Match() function will return the relative column for the date matching the header.So: Your array of data is in E1:AI1 and if you're looking for the date in cell C1, you would use:MATCH(C$1,$E$1:$AI$1)(the "$" will be necessary for when you copy the formulas) In this case, the function returns 31, which is the number of columns beginning from column E.The index() function starts with the entire array of data (E1:AI7)and uses a row,column offset into this array. In cell C2, use the formula:=INDEX($E$1:$AI$7,ROW(),MATCH(C$1,$E$1:$AI$1)) the row() function returns the current row.You can then copy this function to the rows in column C and D. 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 - On Tuesday, February 7, 2017 10:34 AM, Amit Desai (MERU) wrote: Dear Friends, I am stuck while preparing a dashboard. I need auto pickup of data based (in cell highlighted yellow) on model & date from the right side. If I change date (from 31-Jan-17 to 27-Jan-17) the data should change.. I think Index/Match with vlookup should work.. but not sure how to use it.. please help. Best Regards, Amit Desai Contact: - 09867232534 Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect.-- 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. -- 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.
Re: $$Excel-Macros$$ about conversion of excel to text file.
On Wed, 2/8/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ about conversion of excel to text file. To: "excel-macros@googlegroups.com" Date: Wednesday, February 8, 2017, 2:13 PM The format .csv is a comma separated field format. (Comma Separated Values) You should be able to use File->Save As->and choose this type. I'm not sure what you're expecting with the "space between all columns and values". If you are expecting a comma AND a space between each column,then you're going to need a VBA macro to accomplish this. 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 - On Tuesday, February 7, 2017 3:50 PM, Pravin Choudhari wrote: I have 10 columns in excel and want to convert into the text file. I tried when saved in the text file it shows a lot of spaces between columns. my requirement is each column and values should be separated by a comma and there should be space between all columns and values. Please help me. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. dunarea electiva a tarii Romanesti era insa dominata de conservatori care detineau 46 din cele 72 mandate de aceea victoria cauzei nationale nu era posibila fara interventia maselor singurele in masura sa produca un deznodamant fericit. -- 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
Re: $$Excel-Macros$$ about conversion of excel to text file.
The format .csv is a comma separated field format. (Comma Separated Values) You should be able to use File->Save As->and choose this type. I'm not sure what you're expecting with the "space between all columns and values". If you are expecting a comma AND a space between each column,then you're going to need a VBA macro to accomplish this. 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 - On Tuesday, February 7, 2017 3:50 PM, Pravin Choudhari wrote: I have 10 columns in excel and want to convert into the text file. I tried when saved in the text file it shows a lot of spaces between columns. my requirement is each column and values should be separated by a comma and there should be space between all columns and values. Please help me.-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
