Hi Kalyan,
PFA the file updated with formula . I use index and Match Function to get
the results.
thanks,
Sarva
Thanks & Regards,
*Saravanan Raju*
Mob: +91 8807708842
+91 9449716334
On Tue, Nov 15, 2016 at 4:24 PM, Kal xcel wrote:
> Dear Experts,
>
> Please help me
the "2016" row and change Year to 2017
2> Also the row & Column range should be dynamic
Thanks in advance!
Thanks & Regards,
*Saravanan Raju*
Mob: +91 8807708842
+91 9449716334
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:
Bvhcgh you are yycyucbdb
--
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 Hel
Bvhcgh you are yycyucbd
--
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
Hello Experts,
Please provide me the sites for excel VBA 2013 books.
Thanks & Regards,
*Saravanan Raju*
Mob: +91 8807708842
+91 9449716334
--
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 f
On 28-Sep-2015 11:50 am, "saravanan R" wrote:
> Hi Experts,
>
> I need your help on plotting an chart for HArd disc space utility.
> Please find the scenario below,
> I have 2 servers, each server as 3 drives and details of Space utilization
> of ech drive is give
condition and also which type of Chart
will be meaningful to report.
Thanks & Regards,
*Saravanan Raju*
Mob: +91 8807708842
+91 9449716334
--
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 f
Hi Paul,
I found macros to export all the sheets to PDF, but I need to select only
the specified sheets into PDF. If you have any references please share. It
will be very useful for me to make this task bit easier.
Thanks,
Saravanan R
On 13-Aug-2015 7:44 pm, "Paul Schreiner" wrote:
advance.
Thanks & Regards,
*Saravanan Raju*
Mob: +91 8807708842
+91 9449716334
--
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)
able and
chart, i need macro to automate these task.
thanks in advance.
Thanks & Regards,
*Saravanan Raju*
Mob: +91 8807708842
+91 9449716334
--
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
able and
chart, i need macro to automate these task.
thanks in advance.
Thanks & Regards,
*Saravanan Raju*
Mob: +91 8807708842
+91 9449716334
--
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 th
On Wed, Mar 18, 2015 at 5:31 PM, saravanan R wrote:
> Hi Mandeep,
>
> Thanks a Million.
>
> I have one more query related to the same file, is it possible to split
> the file based on "Status" OK wrt to each Coleague.
> and file name should be QueryDup-FK &
015 at 5:25 PM, Mandeep baluja
wrote:
> Try this ..
>
>
> Regards,
> MandeepBaluja
> Learningzmypassion.
> https://www.facebook.com/VBAEXCELSQL?ref=hl
> https://www.linkedin.com/profile/view?id=312532939
>
> On Wednesday, 18 March 2015 16:59:17 UTC+5:30, saravanan R wr
o for this
colleague only. If the DOC no. is Duplicating then Update Status as "OK",
if it is Unique then update as "NOT OK"
thanks in advance,
Saravanan R
+91 8807708842
+91 9449716334
--
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)
Reason behind is,
I am Working on a multiple manual task in one report, like already
enquired, pulling data from Text file, changing data formats, based on this
data pull information from other source, clean up templates. etc
regards,
saravanan R
On Tue, Dec 30, 2014 at 12:33 PM, Mandeep Baluja
i am looking for VBA Macro for this , reference file to opened by browse
option then select the range.
thanks & regards,
Saravanan
On Mon, Dec 29, 2014 at 6:45 PM, saravanan R wrote:
> Hi Team,
>
> Please help me on Vlookup function where I will need to refer the file(by
> b
e to select from otherfile.
thanks & regards,
Saravanan
--
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 titl
Hi Team,
I have an query on replace "." with "/" in the Data pulled from SAP .
Actually Format is,
01.12.2014 17.12.2014 WHen I Do Manually Find & Replace,
It show me as ,
1/Dec/14
17/Dec/14.
But when I do through VBA COde,
I replace as,
12/Jan/14
"INVALID DATE FORMAT)
Can You please check in
Hi Mandeep,
Thanks For your quick response, This is what actually i needed.
Thanks a Lot
Regrads,
Saravanan
On Mon, Dec 29, 2014 at 11:35 AM, Mandeep Baluja
wrote:
> Sub Macro1()
>>
>> Dim fName As String
>>
>> fName = Application.GetOpenFilename("Text Fi
Hi Mandeep,
This what I needed, but through VBA code. Because i Have to get this
imported Data into other excel Template.
Can you please share how we can proceed through VBA.
thanks & regards,
Saravanan R
On Fri, Dec 26, 2014 at 5:28 PM, Mandeep Baluja
wrote:
> Want this result ?
&g
here it is
On Fri, Dec 26, 2014 at 4:55 PM, Mandeep Baluja
wrote:
> send file
>
> On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote:
>>
>> Hi Team,
>>
>> I have an query on Importing text file , delimit by "Seperator" and make
>
Hi Team,
I have an query on Importing text file , delimit by "Seperator" and make
particular column to be text, and import the same data into excel update
those data from Row 2.
thanks & regards,
saravanan R
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be?
Hi,
I hope you are looking for the column "M". Please change the formula
reference as "M:M" instead of "A".
Regards,
Saravanan R.
On Wednesday, 13 February 2013 21:40:01 UTC+5:30, hilary lomotey wrote:
>
>
> Hello
>
>
> Pls see attache
Hi Excelites,
I am need of Macro, I already have an Macro for Extracting Dimensions of
teh Image. but not able to get the Resolution Details.
Please advice me is there any Property to extract the Image Resoultion(dpi)
from the Folder (Horizontal Resolution & Vertical Resolution) using VBA
code.
t
Hi Frnds,
Any Idea for the given below Reuqest?
*Thanks & Regards,*
*Saravanan R*
*BDI India Private Limited*
“Shreeshyla”, Doddakallasandra,
Kanakapura Road, Bangalore 560 062 INDIA
Ph: 91-80-22560418/19
Fax: 91-80-22560420
Cell: +919449716334
sarava...
Dear Noorain,
Thank you very much for the interview questions.
Regards,
Saravanan R.
On Thursday, 10 May 2012 16:49:25 UTC+5:30, NOORAIN ANSARI wrote:
>
> Dear Group,
>
> Please find attached Interview questions and answers for MS Excel+VBA+MS
> Access+SQL Server.
>
Hi xlts,
I need your help on is there any macro /function to compare 2 adjacent
columns(cells) and extract the characters which makes difference in the next
column
Coloumn1. Column2. (required o/p)
Abc1 Abc1x X
Thanks & regards,
Saravanan R
--
Join offi
Hi Friends,
I have some knowledge in MIS Reporting and I am learning myself about
advanced excel formulas and concepts. I need some real time MIS Reporting
samples for my reference. Please send the files to my mail id -
saravananw...@gmail.com.
Thank You,
Saravanan R.
--
Join official
Hi Xlts,
Thanks for all your Inputs and suggestions.
Finally I could able to Sort it Out by Countif and Vlookup Function.
Please refer the file attached.
thanks,
Saravanan
On Thu, Oct 25, 2012 at 10:11 AM, अनिल नारायण गवली
wrote:
> Pl Share a sample sheet with us
>
>
> On Thu, Oct
Hi
I need this because need to know which are all the items belongs to one value.
By this values I can assign the items need to work.
Thanks,
Saravanan.
On Oct 25, 2012, at 12:13 AM, Paul Schreiner wrote:
> Are you saying that your VLookup Value occurs in multiple rows in your table?
&
Hi xlts,
Please help me, on how to get the all the associated items In the range where
it as more than 1 lookupvalue.
Thanks,
Saravanan
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
Hi,
Put one single quote and then paste the value. (it is applied only past
value one by one only)
If you want bulk paste:
1. make the format of the cell as 'text'
2. Past special - text.
Regards
Sara
On Tue, Aug 21, 2012 at 4:19 PM, Karan Singh wrote:
> Dear All,
>
> I need your assistance
Keep it up noorain.
Regards
Saravanan A R
On Fri, Aug 3, 2012 at 11:10 PM, Ayush Jain wrote:
> Dear members,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> July'12. He has posted 143 posts in July 2012 and helped many forum
Hi Excelates,
I need an Urgent help on disabling the Sort in the filter dropdown.
Is there a way to disable only the short cut key i.e only the letter s
& a in the Filter Drop down list.(available in the Excell 2007)
thanks & regards,
S
Try =proper() command
Regards
Saravanan A R
On Wed, Jun 24, 2009 at 1:40 PM, Subu wrote:
>
> Dear List members and XL Gurus
>
> I have an XL sheet with a column that looks something like
>
> Name_One
> nAme_two
> NAME_THREE
> name_four
> name_fIVe
> name
Hi,
See the attached file. I will help i think.
Regards
On Wed, May 20, 2009 at 10:40 AM, Deepak Rawat wrote:
> Hi all! i have attached a file, there is 5 fields in the file
> my requirement is, as i put city name in city field, then all the field
> should fill accordingly
> like as i put Mumb
Hai
Use the below formula in Summary Sheet B2 Cell:
=Sheet1!B2+Sheet2!B2+Sheet3!B2
Regards
On Tue, May 19, 2009 at 11:02 PM, Vandana Vallam wrote:
> Dear Friends, Can someone help me to run a macro to calculate the sum of a
> cell across sheets...for Example
>
> Sheet 1 B2, Sheet 2 B2 and Shee
?
Password is 1
On Mon, Mar 9, 2009 at 9:05 AM, saravanan wrote:
Hi All,
Please help me with below mail
Thanks
C.Saravanan
_
From: saravanan [mailto:encubus101...@gmail.com]
Sent: Friday, March 06, 2009 9:52 AM
To: 'excel-macros@googlegroups.com'
Subject:
Hi All,
Please help me with below mail
Thanks
C.Saravanan
_
From: saravanan [mailto:encubus101...@gmail.com]
Sent: Friday, March 06, 2009 9:52 AM
To: 'excel-macros@googlegroups.com'
Subject: VBA Addin password recovery
Hi,
I am into designing VBA macr
Hi All,
Please help me with below mail
Thanks
C.Saravanan
_
From: saravanan [mailto:encubus101...@gmail.com]
Sent: Friday, March 06, 2009 9:52 AM
To: 'excel-macros@googlegroups.com'
Subject: VBA Addin password recovery
Hi,
I am into designing VBA macr
Hi Santosh,
The attached example would be helpful to you.
Thanks
Saravanan
_
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of santosh subudhi
Sent: Sunday, March 08, 2009 6:12 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros
Hi,
You can also use the below code
Sub del()
ro = 1 'Starting Row
Col = "A" 'Column in which the extra word contains
While Range(Col & ro).Value <> ""
If Range(Col & ro).Value = "Extra" Then
Range(Col & ro).EntireRow.Delete
ro = ro - 1
End If
ro = ro + 1
Wend
End Sub
Thanks
Hai,
Try this
=NOW()-WEEKDAY(NOW(),1)+2
it will help you i think,
Regards
Saravanan A R
On Sat, Feb 21, 2009 at 8:25 PM, Harmeet Singh wrote:
> Hi,
>
>
> Below is the formula-
>
>
> =IF(TEXT(TODAY(),"ddd")="Sun",TODAY()-6,IF(TEXT(TODAY(),"ddd
Hai puneet
It is possible with bseindia website with vlookup method.
send me your sample data i will create the link with bseindia and send back
to you.
Regards
Saravanan A R
On Thu, Feb 19, 2009 at 10:59 AM, Puneet Jain wrote:
> Dear all
>
> Not recieved any reply for the
I doubt whether you have defined the Sub procedure as Private. If so remove
the Private key word.
C.Saravanan
On Thu, Nov 20, 2008 at 9:16 PM, macrogirl wrote:
>
> I have a sub procedure written under another procedure. When I press
> F5 to run the procedure, it is not listed in the drop down me
Hai Vinu,
In a2 type
=TEXT(A1,"dd/mm/")
in a3 type
=TEXT(A1,"hh:MM:ss")
it will useful to you i think,
Regards
Saravanan A R
On Tue, Nov 4, 2008 at 5:54 PM, vinu <[EMAIL PROTECTED]> wrote:
>
> Hi All,
>
> I have a data like this in a single c
46 matches
Mail list logo
