*Hi,*
*Greetings.,*
This is *Praveen Kumar* from *AuroPro Systems*. One of our client is
looking for * Sr. Full Stack .Net Developer W/ AngularJS and Azure Cloud.
*Please
send your resume, contact details and rate to *prav...@auropro.com
*or call me at *609 964 0577.*
*Job Title :Sr
*Title: Sr Big Data Hadoop Developer (9-10+ years)**Location: Irving
TX**Duration:
Long Term*
*Interview Process: Skype/WebEx Hire*
*Visa Type : H1,GC, USC only*
*Top Three skills:*
*1) Must Have 3+ years of experience developing in a Big data Environment*
*2) Must have exp with Spark*
*3) Must
*Title: QA Automation Engineer(UFT)**Location: Irvine CA**Duration: 6+
Months**Interview Process: Phone + Skype**Visa Type : H1,GC, USC only**Job
Description:*
We are looking for a Test Automation Engineer with* 8+ of experience* in
creating and maintaining functionality of automation scripts u
*Hi,*
*Greetings.,*
This is *Praveen Kumar* from *AuroPro Systems*. One of our client is
looking for * Business Analyst W/ Process Modeler Experience at Groton,
CT. *Please send your resume, contact details and rate to *prav...@auropro.com
*or call me at *609 964 0577.*
*Job tile
Hi,
Greetings…
This is *Praveen Kumar* from *AuroPro Systems*. My client is looking for *Sr.
**Node/Angular Developer Lehi UT. *Please send your resume, contact details
and rate to *prav...@auropro.com *or call me at *609
964 0577 *
*Job Title: Sr. **Node/Angular Developer
Hi,
Greetings…
This is *Praveen Kumar* from *AuroPro Systems*. My client is looking for
*Microsoft Dynamics
CRM Developer at Trenton, NJ. *Please send your resume, contact details and
rate to *prav...@auropro.com *or call me at *609 964
0577.*
*Job Title: Microsoft Dynamics CRM
Hi,
Greetings…
This is *Praveen Kumar* from *AuroPro Systems*. My client is looking for *Java
Developer with AWS* ,*Linthicum, MD**. *Please send your resume, contact
details and rate to *prav...@auropro.com *or call me
at *609 964 0577.*
*Job Title: Java Developer with AWS
experience
Highly desired
Thank you.
*__*
*Praveen kumar*
Senior Technical Recruiter, *AuroPro Systems Inc*
609 897-1024 X 205 609 964 0577 609 897-1025
666, Plainsboro Road, Suite 220, Plainsboro, NJ
experience
Highly desired
Thank you.
*__*
*Praveen kumar*
Senior Technical Recruiter, *AuroPro Systems Inc*
609 897-1024 X 205 609 964 0577 609 897-1025
666, Plainsboro Road, Suite 220, Plainsboro, NJ
desired
Open Text BI Query experience
Highly desired
Thank you.
*__*
*Praveen kumar*
Senior Technical Recruiter, *AuroPro Systems Inc*
609 897-1024 X 205 609 964 0577 609 897-1025
666
desired
Open Text BI Query experience
Highly desired
Thank you.
*__*
*Praveen kumar*
Senior Technical Recruiter, *AuroPro Systems Inc*
609 897-1024 X 205 609 964 0577 609 897-1025
666
k you.
*__*
*Praveen kumar*
Senior Technical Recruiter, *AuroPro Systems Inc*
609 897-1024 X 205 609 964 0577 609 897-1025
666, Plainsboro Road, Suite 220, Plainsboro, NJ 08536
www.auropro.comprav...@auropro.com
.
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
Please unsubscribe
On Wed, Jan 2, 2013 at 10:25 AM, Praveen Golash wrote:
> Please do the needful.
>
> --
> Regards,
>
> Praveen Golash
>
>
--
Regards,
Praveen Golash
KPMG Advisory Services Pvt. Ltd.
Mobile: +91- 9711302259
--
Join official Facebook pag
Please do the needful.
--
Regards,
Praveen Golash
--
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
Dear Ayush
Please send me advance excel formulas right now.
Regards
Praveen
On Saturday, August 4, 2012 11:58:51 PM UTC+5:30, Ayush Jain wrote:
>
> Dear members,
>
> I am happy to share that this forum is available at www.discussexcel.comas a
>
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
com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes
about the learning and suppo
-- 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
o this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 subscribers worldwide and receive many nice
ver 7000 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
Regards,
praveen
--
-
---
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://
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
w
he right can use mid & other
formula to get the numbers separately.
I hope this will makes you clear about my objective.
Also let me if there is any other way to do the same.
Thanks in advance
On Fri, Jul 2, 2010 at 9:38 PM, krishna mummina wrote:
> Hi praveen,
>
> we can find t
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
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 s
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
file explains it in detail...
pls help
thanks and regards
Praveen
the attached sheet explains it
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
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 lik
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
> e
someone help me in creating one.
Thanks in advance!!
Regards,
Praveen
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA
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
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,
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 concatenat
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.
Regard
,
Praveen
On Mon, Jan 18, 2010 at 7:33 PM, dailem wrote:
> I'm relatively new to VBA programming, but what I want to do is go
> through a range starting at a10 through the last record listed (varies
> in # of records, but always together). If the field in column a =
> "
You are welcome Mark!!
You can try doing that and let us know if you have any issues.
Regards,
Praveen
On Mon, Jan 18, 2010 at 3:41 AM, Markkim wrote:
> Thank you very much Praveen!!
>
> I would also like to do the same thing from the first sheet.. get
> infor from the second s
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
You are welcome Robin..
On Fri, Jan 8, 2010 at 1:30 PM, Robinson Boreh wrote:
> *Hi Praveen,*
> **
> *Thanks. That's what I needed, only I do not know how to go about in in
> pivot tables.*
> *Regards*
> *Boreh*
>
> --
> *From
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!
>
You are welcome Anish. Will keep up the good Work!!
Regards,
Praveen
On Thu, Jan 7, 2010 at 1:53 PM, Anish Shrivastava wrote:
> Hey Praveen,
>
> Thanks a lot Man,, this is what I was looking for now I can select
> those cells and cut, paste in a new column instead of popula
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
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
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
You are welcome Mahesh!!
On Sun, Dec 27, 2009 at 8:33 PM, mahesh parab wrote:
> Hi Alokeshwar
>
> Thank you so much for your help, Can you explain if condition if you can !
> it will enhance my knowledge
>
>
>
> Hi Praveen
>
> Again, Thank you so much for your hel
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 a
first and then the movecontants.
Let me know if this helps!!
Regards,
Praveen
*Sub mergecontents()
' Coded by Praveen
' This code sets up the CC into D column into the last row of the email id
pattern
last_row = Range("B65536").End(xlUp).Row 'To Retrieve the last Row in co
helps!!
Regards,
Praveen
On Sun, Dec 27, 2009 at 3:55 PM, Abdul Rasheed wrote:
>
>
> Can some body tell me that how can we avoid duplication of any *Number *or
> *Alpha-numeric* data in any column of excel file.
>
> Waiting for an early response.
>
> --
> Regards,
> Abdu
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
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
t
'Range("B4").Activate
Selection.Copy
Windows("paybill.xls").Activate
Range("A2:A3").Select
ActiveSheet.Paste
Range("A2:A3").Select
End Sub*
Can you debug once and let me know at which line you are getting the error.
It is working
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
;report(2).xls").Activate
Rows("4:17").Select
'Range("B4").Activate
Selection.Copy
Windows("paybill.xls").Activate
Range("A2:A3").Select
ActiveSheet.Paste
Range("A2:A3").Select
End Sub*
Regards,
Praveen
On T
Hi,
I meant it this way
.HTMLBody = strbody & vbNewLine & RangetoHTML(rng) & Signature
On Thu, Dec 24, 2009 at 12:27 PM, Vinod N wrote:
> Hi Praveen,
>
> Do you mean .htmlbody should read as below:
>
> .HTMLBody = Please clarify the following:" & vbNewL
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
formula *=checkthis(E2,F:F) *
This should give you the desired result.
Let me know if this helps
Regards,
Praveen
On Wed, Dec 23, 2009 at 11:09 PM, mahesh parab wrote:
> Dear All
>
> i need help to modify below mention user define function. i got this code
> on below mention link.
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
>
>
at u want, u might wanna read my previous reply again else
> team would surely help u.
>
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
> On Wed, Dec 23, 2009 at 2:53 AM, Vinod N wrote:
>
>> Hi Harmeet and Praveen,
>>
>
*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
per unit needs to be selected.( as seen in 05th oct)
attachd the xl sheet,Kindly help
thanx in advance
reg
Praveen
--
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
workbook is closed.
Can anyone please figure out why StopTimer() is not working?
Regards
Praveen
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials
Thanks a lot Paul for your effort to explain in great detail. It
certainly helped me to solve the problem.
Best Wishes
Praveen Khunte
Lead Engineer
E praveen.khu...@gmail.com <mailto:praveen.khu...@power.alstom.com>
Alstom Projects Ind
Thanks a lot Dilip
It worked out and solved my problem. I was in dilemma that the cell
needs to be displayed in TIME format. Anyways thanks to the TEXT feature
and YOU.
Best Regards
Praveen Khunte
Lead Engineer
E praveen.khu...@gmail.com <mailto:praveen.khu...@power.alstom.
dynamic date but fixed time in single cell. I hope you
understand my requirement.
Thanks
Best Regards
Praveen Khunte
Dilip Pandey wrote:
> Hi Praveen,
>
> Try below formula:-
>
> =IF(AND(HOUR(NOW())>=10,MINUTE(NOW())>=0,
> SECOND(NOW())>0),TODAY()+1,TODAY())
>
>
Praveen
>
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Ex
eet Singh
>
> Sent via BlackBerry Wireless
>
>
> On Sun, Oct 11, 2009 at 7:37 AM, Praveen Khunte
> wrote:
>
>>
>> I have a requirement where date needs to be in uppercase. Please reply
>> how to convert a cell which is displays today's date to upperc
Hi Everyone
There is a specific requirement I came across while developing a tool
in excel. I am using 40 different links of the same website to extract
data in a single sheet of excel through feature "External Data from
Web". Now the problem is the link changes when month changes.
For example fo
I have a requirement where date needs to be in uppercase. Please reply
how to convert a cell which is displays today's date to uppercase. For
example 11 Oct 2009 to 11 OCT 2009. Using Upper function didn't help
me.
--~--~-~--~~~---~--~~
e)
If Length <> Len(Value) Then Cell = Value
End If
Next Cell
End Sub
Best Regards
Praveen Khunte
Dave Bonallack wrote:
> Hi,
> If you don't need any merged cells in your sheet, try putting these
> lines at the beginning of your pres
A macro which automatically merges all the cells of
the worksheet (if possible-entire workbook).
Warm Regards
Praveen
Khunte
cro that can do all the things I am
> currently doing one macro at a time.
> I can provide examples i.e. the "raw" data from import and the code
> from the macros I currently use but I do not know how to upload these
> files into this posting.
>
> Please
/",YEAR(A1)," ",HOUR(A1),":",MINUTE
> (A1),SECOND(A1)," ",(B1))
>
> Please can anyone give me the formula to concatenate, so that i get AM
> or PM
ant to retain
> whatever is there after total charge. Thanks
>
> >
>
--
Regards,
Praveen KVC
Member of Peepal Tree
--~--~-~--~~~---~--~~
-
Some important links for
> 7 8 9 5 ca4 ca1 ca2
>
>
> 4 6 7 6 ca1 ca2 ca4
>
>
>
> rankings are based on the minimium values. but i need to get the name
> of the column under the ranking fields. for example in the first row
> min value is 1 but i need the name of
difficulties in excel.
Best Regards
Praveen Khunte
On Fri, May 1, 2009 at 1:54 PM, Dilip Pandey wrote:
> Hi Praveen,
>
> You can use following function:-
>
>
> =IF(TEXT(B3+F3-1,"DDD")="Sat",B3+F3-1+2,IF(TEXT(B3+F3-1,"DDD")="Sun",B3+F3-1+1,B3+F3-
Hi All Excel Lovers
I have attached the excel sheet with the problem description.
Hope to get solution.
Praveen Khunte
--~--~-~--~~~---~--~~
-
Some important links for excel users
Hello Dollar Chande
You can use software called Passware which finds the password for most
of the applications like Outlook, Acrobat including Office. It is easily
available.. just google it.
Regards
Praveen Khunte
DOLLAR CHANDE wrote:
> Dear All,
>
> I have reduced the size of
Thanks a lot Vinu
That solves my problem.
Happy Ugadi to you too.
I have few more queries which I have put in the attached excel sheet. Hope
to get the answer.
Thanks in advance.
Praveen Khunte
On Sat, Mar 28, 2009 at 7:51 PM, Vinu wrote:
> Hello Praveen,
> I hope you are doing well,
macros. I am a novice to Macros.
Praveen Khunte
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
Hi Ajit,
a) convert both the number in date format...
b) Substract the dates and divide by 365/366 as the case be.
I hope that solves your problem.
On 9/22/08, AJIT NAVRE <[EMAIL PROTECTED]> wrote:
>
> Use the formula,
>
>
> =IF(A1>DATE(2004,3,31),0,IF(YEAR(DATE(2004,3,31))-YEAR(A1)=0,1,YEAR
94 matches
Mail list logo
