.
Thanks and Best Regards,
Praveen Kumar
SRI Tech Solutions Inc.
prav...@sritechsolutions.com
(T) 1-813-423-6500 X Ext: 149 (M) 813-440-2778 (F) 813.423.6520
Certified Minority Business Enterprise | An E-Verify Employer
SRI Tech Solutions is an equal opportunity employer and does not
Application Lifecycle
Management
· Strong written and verbal communication skills
· Candidate should be responsible for Designing and implement
solutions in Azure cloud platform and related technologies
Thanks and Best Regards,
Praveen Kumar
SRI Tech Solutions Inc.
prav
ven, Ant,
- OS - RHEL, Centos
- Scripting: BASH, Python, Perl
- *Config Mgmt: Ansible, Puppet, Chef*
- Prototyping: Vagrant, VMWare Workstation/Fusion
- Front End Development using JavaScript, AngularJS etc. *(NICE TO HAVE)*
Thanks and Best Regards,
Praveen Kumar
SRI Te
· Strong written and verbal communication skills
· Candidate should be responsible for Designing and implement
solutions in Azure cloud platform and related technologies
-
Thanks and Best Regards,
Praveen Kumar
SRI Tech Solutions Inc.
prav...@sritechsolutions.com
(T) 1-813-423-6500
thon, Perl
· *Config Mgmt:* *Ansible, Puppet, Chef*
· Prototyping: Vagrant, VMWare Workstation/Fusion
· Front End Development using JavaScript, AngularJS etc. *(NICE
TO HAVE)*
Thanks and Best Regards,
Praveen Kumar
SRI Tech Solutions Inc.
and Best Regards,
Praveen Kumar
SRI Tech Solutions Inc.
*prav...@sritechsolutions.com *
(T) 1-813-423-6500 X Ext: 149 (M) 813-440-2778 (F) 813.423.6520
Certified Minority Business Enterprise | An E-Verify Employer
SRI Tech Solutions is an equal opportunity employer and does not
discriminate
· Strong written and verbal communication skills
· Candidate should be responsible for Designing and implement
solutions in Azure cloud platform and related technologies
Thanks and Best Regards,
Praveen Kumar
SRI Tech Solutions Inc.
prav...@sritechsolutions.com
(T) 1-813-423-6500 X
,
Praveen Kumar
SRI Tech Solutions Inc.
prav...@sritechsolutions.com
(T) 1-813-423-6500 X Ext: 149 (M) 813-440-2778 (F) 813.423.6520
Certified Minority Business Enterprise | An E-Verify Employer
SRI Tech Solutions is an equal opportunity employer and does not
discriminate on the basis of race
. Tabular modeling (at least SSAS Cubes development)
2. Fluent in DAX (but could have experience with MDX)
3. Data warehouse - modeling concepts
4. PowerBI
5. SQL
Thanks and Best Regards,
Praveen Kumar
SRI Tech Solutions Inc.
*prav...@sritechsolutions.com
hello
Dear Sir,
this is praveen
i have some problem's please sort out my problem's
i want use in v lookup function isna,iserror,isblank,and if, and
nested if
how can i
please help me
--
--
Some important links for e
Hi Dilip,
I am also having same problem but slightly different from the below
even i was also following same logic for getting the count of unique
values, but the problem is have 5 pivots one down the other when i
refresh every month it will give some popup "asking do you want to
replace the conte
-- Forwarded message --
From: praveen kumar
Date: Thu, Aug 5, 2010 at 7:47 PM
Subject: Help needed - Count Unique Values based on matching criteria
To: mac...@googlegroups.com
Hi Group,
Help me to get this done.
--
Regards,
praveen
--
Regards,
praveen
Hi,
Solution for your query will be available in the below link.
http://www.ozgrid.com/VBA/ExtractNum.htm
On Wed, Aug 4, 2010 at 3:26 PM, Venkatesan c wrote:
> Dear Group,
>
> Find Below data Requirement.I Want to extract numbers post (_ )Only.
> Raw Data Required
>
> Best Regards,
> Venkat
>
>
Hi Venkatesh,
Solution for your problem.
Right click on pivot - Pivot Table option - Display - classic pivot
table option(check this option).
Let me know if it works
On Tue, Jul 27, 2010 at 6:32 PM, Venkatesh Narla wrote:
> Dear All,
> I have problem in 2007 Excel Pivot table
> Pls find the P
Hi,
I think this formula may be useful for your requirement.
=MID(B4,(FIND("-",B4)+1),(LEN(B4)-(FIND("-",B4
Let me know if it works
On Tue, Jul 6, 2010 at 4:28 PM, Ankit Chandna wrote:
> Dear,
>
> Can u plz tell me exact procedure.i do hv ASAP utilities.
>
> --- On *Tue, 6/7/10, Mahesh *
Hi All,
=LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1," ",CHAR(1),LEN(TRIM(A1))-
> LEN(SUBSTITUTE(A1," ",""
The above formula works for me.
Thanks a lot for all your efforts in helping me to solve this issue.
On Sat, Jul 3, 2010 at 8:44 AM, ju...@thepepeshow.com
wrote:
> Dave, I think Praveen was
he position and could you please tell me why you need it.
>
> Bye
>
> On 7/2/10, praveen kumar wrote:
>> Hi Friends,
>>
>> Is there any way to find the position of the space in a word from right
>> side.
>>
>> Ex: United States of America - here the pos
Hi Friends,
Is there any way to find the position of the space in a word from right side.
Ex: United States of America - here the position of the space from
right side is 8.
--
Regards,
praveen
--
--
Some importa
dear Paul,
the macro is not giving the result
it just shows a message that " Done at 7094th row"
pls help
thx and reg
Praveen
On Sun, 11 Apr 2010 20:31:58 +0530 wrote
>
Hi Praveen,
Siti's formulae for column D and E are fine and should be applied
first. But then I suggest to run this mac
hi shashank,
thts wrong dude..
you just put vlookup...
but the data has got townwise, datewise rateswhich differs
reg
Praveen
On Sat, 10 Apr 2010 15:04:10 +0530 wrote
>HI Praveen
Please find the Sorted data
>
>--- On Sat, 10/4/10, Praveen kumar wrote:
>
>From
dear all,,,
need an urgent help frm u guys...
There are 10 diff towns, and the invoice price for all the towns on various
dates are as per the table attached.(date ranges across the towns)
Now I need to check, whether the datewise, townwise invoice price generated is
correct.
the attached file
You are welcome Ashish!!!
Regards,
Praveen
On Sat, Feb 6, 2010 at 3:21 PM, ashish koul wrote:
>
> thanks a lot praveen
>
>>
>>
>> -- Forwarded message --
>> From: kvc praveen kumar
>> Date: Sat, Feb 6, 2010 at 11:11 AM
>> Subj
Check the attached file.
Praveen
On Fri, Feb 5, 2010 at 11:27 AM, ashish koul wrote:
> any help
> On Thu, Feb 4, 2010 at 8:46 PM, ashish koul wrote:
>
>> hi
>>
>> i have a input in sheet 1 and its not limited
>>
>> and want result in sheet2 like in col1
>>
>>
>> regards
>>
>> ashish
>>
>
> -
Hi Wibur,
In Excel 2007 go to Excel options -> Advanced -> uncheck the After Pressing
enter move Selection.
This would suffice.
Regards,
Praveen
On Tue, Jan 26, 2010 at 5:08 AM, Wilbur Kush wrote:
>
>
> I have a scale that inputs data into excel via rskey, a keyboard
> emulator that comes wit
Hello All,
I came to know yesterday that Excel 2003 has limitation to chart more than
32000 rows/data points.
However, this could be overcome with the creation of two separate
dataseries. I want to know if it is possibleto create an add-in for
implementing the same.
If it is possible, Can someon
You are welcome Mahesh!!
Have a nice day!!
Regards,
Praveen
On Thu, Jan 21, 2010 at 9:03 AM, mahesh parab wrote:
> Hi Praveen,Ankur,Dave
>
> thank you all of you !
>
>
> On 1/20/10, Dave Bonallack wrote:
>
>> Hi,
>> Have a look at the attached. Let me know if it's what you need.
>> Regards -
Hello Mahesh,
Attached is the shhet with your requirement.
I used
=SUMPRODUCT(COUNTIFS(INDIRECT("'"&D8&"'!E:E"),$E$7,INDIRECT("'"&D8&"'!C:C"),C8))
to implement your reqmnt.
Let me know if you have any issues.
Regards,
Praveen
On Wed, Jan 20, 2010 at 10:59 AM, mahesh parab wrote:
> Dear All
>
HI Ganesh,
I observed in the sheet that you have written the concatenate spelling wrong
for the function.
I hope that was the reason for #Name error. You can correct and check once.
Regards,
Praveen
On Wed, Jan 20, 2010 at 12:27 PM, ganesh gw wrote:
> hi guys,
> i want to concatenate date with
Hi Abhishek,
Did you try giving the complete path to the cell references directly?
like ='C:\DOCUME~1\PKARAN~1\LOCALS~1\Temp\notes327EC1\[Training
curriculum.xls]Sheet3'!$A$82
You can give the complete pathto the location of your masterfile directly.
Let me know if this works.
Regards,
Praveen
Hello dailey,
Can you share a sample workbook with your exact requirement. I went through
your code.. But was unable to get what exactly you are looking for. If you
share a workbook and explain the result you want..probably it would be easy
for this group members to respond.
Thank you!!
Regards,
heet and the third sheet.. (sorry the idea
> coming up as I think through).. but I will try it myself.. after
> studying your code.
>
> Thanks again..
>
> Have a nice day!!!
>
> On Jan 17, 6:17 pm, kvc praveen kumar wrote:
> > Hello Mark,
> >
> > Please fi
Thanks Vinod.. Glad that it was helpful!!
On Thu, Jan 14, 2010 at 5:51 PM, vinod rao wrote:
> Hello Praveen,
>
> Excellent!!! this was really great.
> With Regards,
> Vin
> On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar
> wrote:
>
>> Hello Vinod,
>>
&
>
> On Wed, Jan 13, 2010 at 11:44 AM, kvc praveen kumar > wrote:
>
>> Hello Allen,
>>
>> I guess the excel from which you are getting thadates from is in 1904 date
>> system. and yours is in 1900 date system. All you need to do is to uncheck
>> the "
Hello Allen,
I guess the excel from which you are getting thadates from is in 1904 date
system. and yours is in 1900 date system. All you need to do is to uncheck
the "use 1904 data system" in your source excel - excel options.
This is my first thought. let me know if it helps.
On Wed, Jan 13, 2
:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *kvc praveen kumar
> *Sent:* Thursday, January 07, 2010 8:47 PM
>
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Help needed
>
> Hi Robin,
>
> You can check the atta
Thanks Dave!!
Just Thought Ascii values would do the trick and it worked well.
On Thu, Jan 7, 2010 at 3:23 PM, Dave Bonallack wrote:
> Hey Praveen, Good solution. I didn't think of doing it by macro. Pretty
> silly when this is a macro group!
> Regards - Dave.
>
> --
t;
>
>
>
> On Thu, Jan 7, 2010 at 12:36 PM, kvc praveen kumar wrote:
>
>> Hello Anish,
>>
>> Please check the attached file and let me know if this is what you were
>> looking for.
>>
>> run the macro testmulti()
>> You should get a true for all
Hi Sajid,
As per my knowledge Countif doesnt work in 3 dimensions.
As an alternative you can try this:
*List the sheet names in H1:H5*
and then write this formula
*=SUMPRODUCT(COUNTIF(INDIRECT("'"&H1:H5&"'!A1"),">97%"))*
This will work. let me know if you have any queries.
Regards,
Praveen
On
Hi Doki,
Please check the attached workbook and let me know if this is what you were
expecting.
Please run macro1
Regards,
Praveen
On Mon, Jan 4, 2010 at 9:38 AM, Doki wrote:
> Im stuck with one problem..I guess togather we can solve it..
>
> Prob is:
>
> I want a Dropdown (may be "Yes" n "No"
Hi Ashish,
I have not gone thru ur issue completely. But i thought this could help you.
Did you try inserting this statement
ON ERROR RESUME NEXT in the sub procedure defintion like this:
*Sub Macro7()
On Error Resume Next*
I guess this would be sufficient.
Regards,
Praveen
On Tue, Dec 29, 200
p & better explanation of your code.
>
>
> On Sun, Dec 27, 2009 at 6:37 PM, kvc praveen kumar wrote:
>
>> Hi,
>>
>> You can try the following code:
>>
>> I wrote two macros: Mergecontents and move contents.
>> Mergecontents will merge teh contents
Hi Tushar,
If you do not want to select the sheet to implement your code try to prefix
the cells also with the worksheet reference like this:
Worksheets("sheet1").Cells(3, 25)
This should fix the issue probably..
Let me know if this helps!!
Regards,
Praveen
On Sun, Dec 27, 2009 at 11:39 AM, tu
Hi,
You can try the following code:
I wrote two macros: Mergecontents and move contents.
Mergecontents will merge teh contents into the d column of your last row of
the email pattern
movecontents can be used to move the result to the first row of your email
pattern
Execute the mergecontents firs
Hi Abdul
Follow these steps:
Select your column first and then click on Data->DataValidation
Choose Custom from the drop down menu.
Enter the formula as *=IF(COUNTIF(E:E,E1)>1,FALSE,TRUE)*
(I chose Column E)
This will restrict all duplicate values in your column
Let me know if this helps!!
Rega
Hi Rafique,
You need not worry about the autonumbers. Just keep filling your names,
After you are done select cells containing 1,2 in S# column and then double
click the fill handle. Excel will automatically genearate the sequence for
you.
Let me know if this helps!!
Regards,
Praveen KVC
On Sat
No Problem Karthik!!
On Fri, Dec 25, 2009 at 3:35 PM, grlinks-karthik wrote:
> Thank you praveen
>
> its working fine, you done greate help for me , thanks once again
>
> On Fri, Dec 25, 2009 at 11:02 AM, kvc praveen kumar > wrote:
>
>> I made a small change to t
so you specified row no in the macro, but i donot know
> how many rows will be in report(2) sheet, sample purpose i have mention
> 15rows, actuallay it will be 50 or 100 rows
>
> kindly help me
> On Thu, Dec 24, 2009 at 11:19 PM, kvc praveen kumar
> wrote:
>
>> Hi Grlinks,
&
You are welcome Karthik!!
On Fri, Dec 25, 2009 at 10:24 AM, grlinks-karthik wrote:
> Thank you praveen,
>
>
>
>
> On Thu, Dec 24, 2009 at 11:19 PM, kvc praveen kumar
> wrote:
>
>> Hi Grlinks,
>>
>> Attach this macro for Report(2) sheet and run th
You are Welcome Mahesh!!
On Thu, Dec 24, 2009 at 8:27 PM, mahesh parab wrote:
> Hi Praveen
>
> Thank you so much ! it's amazing , i appreciate your knowledge & help.
>
> On Thu, Dec 24, 2009 at 11:19 AM, kvc praveen kumar > wrote:
>
>> Hi Mahesh,
&g
ll sheet as required format
>
> problem both the sheet not in same workbook , both are in diffirent sheets,
>
>
> I need code for that, these are sample sheets, based on your code i need to
> my modification , Please do the needful ASAP
>
> Regards
> grlinks
>
> On W
ine & RangetoHTML(rng) &
> Signature
>
> or
>
> .HTMLBody = strbody & vbNewLine & RangetoHTML(rng) & Signature
>
> If not, please make the necessary changes in macro in the attachment...
>
> Thanks in advance
>
> Vinod N
>
> On Thu, Dec 24, 20
Do You want to Use specific VBA coding or else You can use this formula from
Dilip directly like this in VBA:
Activecell.formula = "=IF(AND(A2="abcdCust",LEN(B2)=
>
> 6),0&B2,IF(AND(A2="xyzzCust",LEN(B2)=8),LEFT(B2,4)&"-"&RIGHT(B2,4),""))"
On Thu, Dec 24, 2009 at 12:44 AM, mike wrote:
> Well
Hi Mahesh,
Use this function along with the Exactwordinstring function.
Function checkthis(Text As String, rng As Range)
For Each entry In rng
result = ExactWordInString(Text, entry.Value)
If result Then
checkthis = entry.Offset(0, 1).Value
End If
Next
End Function
Now in cell h2 write the formu
Hi Vinod,
Can you try using vbnewline in .htmlbody directly instead of using it in
strbody?
On Wed, Dec 23, 2009 at 10:29 PM, Vinod N wrote:
> Hi Excel Gurus,
>
> In the attached file, the following string is not working
>
> strbody = "Please clarify the following:" & vbNewLine
>
> Initially, t
Hi Karthik,
What is the data that you want to copy and into which shet you want to copy.
On Wed, Dec 23, 2009 at 12:07 PM, grlinks-karthik wrote:
> Hi
> any can help me , I need to copy the data from report2.xls to paybill.xls
> sheet , How to do with VBA, Could any help , ITs very urgent
>
>
Hi Vinod,
I was expecting the same output as Harmeet does.
Can you send us an example file with the problem and the output you require
in case the above doesnt help you.
On Wed, Dec 23, 2009 at 8:27 AM, Harmeet Singh wrote:
> Hi Vinod,
>
> Attaching a sample file.
> If this is what u want, u migh
*Hi,*
*Please go through the below article. It will help you on how to unprotect
only few cells using three different ways.
*
*Let me know if you find any issues.*
*Regards,*
*Excel King*
The easiest and most common way of barring people from playing with your
formulas is to protect your works
Hi Sharat,
Thanks for the code. I was able to run it to get the sheet unprotected.
What should I do to break VBA password.
If I run the button2_click only the sheet's passowrd is broken. But VBA is
still passowrd protected.
Can you please guide me.
Thanks in Advance!!
On Sat, Dec 19, 2009 at 1:2
dear all
need a help..
A similar product in sold to different customers on the same day at different
prices.
I need to select the Unit Price at which the product has sold Maximum units on
any particular day.
and if there is a tie in the maximum units sold, then the higher of the rate
per
Hi,
>From your mail box, send message with attachments to
excel-macros@googlegroups.com
This way you can send your files.
Regarding using only one macro:
Turn the *Sub macro1 ... END Sub*
in your macros to *Function macro1 END Function*
Write a separate macro as
*Sub callingall3*
*'call al
Just try =A1&B1 in C1.
On Tue, May 12, 2009 at 1:27 PM, wrote:
>
> Hello,
>
> I have a problem in displaying AM or PM, when i try to concatenate to
> cells. Below is the reference -
>
> Column A Column B Column C
>
> 4/16/2009 9:00 AM CDT 4/16/2009 9:00
Hi,
Use this formula:
=MID(A1,15,LEN(A1)-15)
if ur cell is in A1
Let me know if this helps.
On Tue, May 12, 2009 at 10:20 AM, subs wrote:
>
> hi
>
> i have data like this in the column of the excel table
>
> total charge: apl total charge:ppg total
> charge:uia
>
>
> The
Hi,
I wrote this formula for ur purpose.
=IF(RANK($A2,$A2:$D2,1)=F$1,$A$1,IF(RANK($B2,$A2:$D2,1)=F$1,$B$1,IF(RANK($C2,$A2:$D2,1)=F$1,$C$1,$D$1)))
See the attached sheet for reference.
Let me know if this helps.
On Sat, May 9, 2009 at 8:53 PM, subs wrote:
>
> ca1 ca2 ca3 ca4
>
>
> 12 123 1 2
63 matches
Mail list logo
