Dear Friends,
I have excel book with 70 to 90 sheets, each sheet has formulas.
For consolidation purpose i need to copy paste each sheet as values.
Is there any way to automate this copy paste.
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna
ion for your reference. I hope this is what your are looking for.
>
> Regards,
> Swapnil Suresh Palande.
>
> On Fri, Mar 24, 2017 at 7:41 PM, Sundarvelan N wrote:
>
>>
>> Hi,
>>
>> PFA, file for your reference.
>>
>> I have found the way, but p
Dear Friends,
Please help how to dynamically change the criteria range.
That is
=COUNTIFS(Sheet1!$AA:$AA,Sheet3!B$2)
=COUNTIFS(Sheet1!$AB:$AB,Sheet3!B$2)
=COUNTIFS(Sheet1!$AC:$AC,Sheet3!B$2)
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be
t;
> Thanks & regards,
>
> www.MrExcel4U.com <http://mrexcel4u.blogspot.com/>
>
> On Fri, Aug 19, 2016 at 1:10 PM, Sundarvelan N wrote:
>
>> Dear Friends,
>>
>> I'm trying to learn VBA,
>>
>> PFA, i'm trying to add data from userfor
Dear Friends,
I'm trying to learn VBA,
PFA, i'm trying to add data from userform text to excel table.
Please help
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
ht
Dear Experts,
Please help me to extract EMP ID.
I have the below sentence in D2 Cell, and i need to extract the EMP ID
which starts with L
D2 = Cash paid to L986529 - RAMESH KUMAR K towards Accomdation Charges on
09.05.2016 to 11.05.2016 amount:4100-- for Corporate Approved by Mr.Arvind
Thanks
Dear Friends,
Does any one having "Free Excel Template for Garments/Apparels Inventory
Management"
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.faceboo
Thanks Abhishek.
Thanks
N.Sundarvelan
9600160150
On Mon, Jun 29, 2015 at 2:23 PM, Abhishek Jain
wrote:
> Plz see attached
>
> On Mon, Jun 29, 2015 at 2:08 PM, Sundarvelan N wrote:
>
>> Dear Friends,
>>
>> My attached excel should update the current time when t
Dear Friends,
My attached excel should update the current time when the status column
updated as Closed.
11
Please Help
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Dear Friends,
Is there option to remove xml tags in excel
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use c
Dear Friends,
Please help me to insert blank/new row under each row using any macro.
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discusse
:58:27 PM UTC+5:30, Sundarvelan wrote:
>>
>> Sorry,
>>
>> Im getting the attached error.
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> On Wed, May 27, 2015 at 6:44 PM, Mandeep Baluja
>> wrote:
>>
>>> check this o
set the date
> as per your requirement basically what the code is doing to fetch details
> of mails of last two days.
>
> On Wednesday, May 27, 2015 at 4:53:57 PM UTC+5:30, Sundarvelan wrote:
>>
>> I'm using this code in Outlook
>>
>> Thanks
>> N.Sunda
I'm using this code in Outlook
Thanks
N.Sundarvelan
9600160150
On Wed, May 27, 2015 at 4:19 PM, Mandeep Baluja
wrote:
> send me the file with this code then I can understand the problem.
>
> Regards,
> Mandeep Baluja
>
>
>
>
> On Wednesday, May 27, 2015 at
But I want Macro Excel File that will auto update all mail details in excel
periodically.
Please help!!!
Thanks
N.Sundarvelan
9600160150
On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N wrote:
> Thanks Mandeep!!!
>
> Thanks
> N.Sundarvelan
> 9600160150
>
> On Mon, May
ay 18, 2015 at 10:47:24 AM UTC+5:30, Sundarvelan wrote:
>>
>> Dear Friends,
>>
>> Is there any possibilities copy, Subject, From Name with email Address,
>> Body of the mail and attachements.
>>
>> with customized From Date - To Date
>>
>>
>
Dear Friends,
Is there any possibilities copy, Subject, From Name with email Address,
Body of the mail and attachements.
with customized From Date - To Date
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join
:
> which cells you want to unmerge ??? Please clear that on which column you
> need to check your physician Text. ??? Elaborate your query please as my
> macro works for column 1
>
> On Wednesday, May 6, 2015 at 11:44:50 AM UTC+5:30, Sundarvelan wrote:
>>
>> Please find
12 AM UTC+5:30, Sundarvelan wrote:
>>
>> Thanks Mandeep,
>>
>> But the given solution is not working.
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>> On Tue, May 5, 2015 at 4:16 PM, Mandeep Baluja
>> wrote:
>>
>>> Sub Sea
Thanks Mandeep,
But the given solution is not working.
Thanks
N.Sundarvelan
9600160150
On Tue, May 5, 2015 at 4:16 PM, Mandeep Baluja
wrote:
> Sub Search()
>>
>> Dim FirstAddress As String
>>
>> With ActiveSheet.Range("A:A")
>> Set Rng = .Find(What:="physician", After:=.Cells(.Cells.Count),
>>
Dear Friends,
Please help me to repeat/Continue the below action till it reach error OR
not found .
Cells.Find(What:="physician", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).A
,"IT","",1))
>>
>> Try kro bhai
>> On Oct 9, 2014 6:25 PM, "Sundarvelan N" wrote:
>>
>>> Dear Friends,
>>>
>>> Please help me in finding the maximum value in a non numeric column,
>>> example below
>>>
Dear Friends,
Please help me in finding the maximum value in a non numeric column,
example below
Answer needed is IT20140010
IT20140001 IT20140002 IT20140003 IT20140004 IT20140005 IT20140006
IT20140007 IT20140008 IT20140009 IT20140010
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP
I need,
2 Jan to 1 Feb
Thanks
N.Sundarvelan
9600160150
On Tue, Feb 11, 2014 at 2:44 PM, DILIPandey wrote:
> Hi Kathirvelan,
>
> You need dates between 2Jan to 1 Feb
> or, 2 Jan to 3 Feb ?
>
>
>
> On Tue, Feb 11, 2014 at 12:44 PM, KATHIRVELAN N wrote:
>
>> Dear Friends,
>>
>> I need to calcu
Dear Friends,
Please share any training material with sylabus (Basic, Intermediate &
Advanced) to train new students.
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Dear Friends,
Suddenly my excel language (font) changed from english to urdu. What is the
short cut please.
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://ww
Dear Friends,
Thanks all for your support it helped me great.
Thanks,
Sundarvelan. N
Thanks
N.Sundarvelan
9600160150
On Tue, Jun 18, 2013 at 1:32 PM, P.VIJAYKUMAR wrote:
> Respected Preethiji,
>
> Where and how did u learn these advanced excel formulas and also VBA.How
&g
Dear Friends,
Please help me capturing the attendance from multiple sheet.
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Dear Friends,
Please help me to convert amount in words
1500 = thousand five hundred
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discuss
Thankyou so much Friends.
Simply your great people.
Thanks
N.Sundarvelan
9600160150
On Thu, Mar 28, 2013 at 11:32 AM, NOORAIN ANSARI
wrote:
> Dear Sundar,
>
>
> Please see attachment , Hope it will help to you.
>
>
> On Thu, Mar 28, 2013 at 11:18 AM, Sundarvelan N wro
Dear Freinds,
Please help me to combine ignoring the blank cells
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
quot; Excel functions.
>>> We can create a function that looks in the Sheets() array for the
>>> current sheet name,
>>> then determines the name of the sheet with the "previous" array index...
>>>
>>>
>>>
>>> *Paul*
>>>
>>> ---
Dear Friends,
Please help me to get the previous sheet name using formula
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Dear Friends,
Please help me in using the cell address in offset.
=IF((IF('TNCMCHIS_CALC-2'!$R8=1,'TNCMCHIS_CALC-2'!$A8,OFFSET('TNCMCHIS_CALC-2'!$R8,0,-17,1,1)))=$A6,OFFSET(
'TNCMCHIS_CALC-2'!$A6,('TNCMCHIS_CALC-2'!$R6),0,1,1),"CONTINUE")
I want to use the below output in the above highlighted
Thaks for your reply
But i need 6 for July
Unique value.
Thanks
N.Sundarvelan
9600160150
On Fri, Dec 7, 2012 at 5:48 PM, Born to Win wrote:
> PFA
>
>
> Thanks,
>
>
>
>
>
> On Fri, Dec 7, 2012 at 3:45 AM, Sundarvelan N wrote:
>
>> Dear Gurus,
>>
Dear Gurus,
Please help me to count no of students for each month
For example :
july 6 students
Thanks
N.Sundarvelan
9600160150
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like P
Dear Gurus,
Please help me how to/where to apply for excel expert certification.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles
Dear Gurus,
I have a file which has the values like 6 - 11
7 - 20
2 - 27
which is automatically changing to date format but it should display the
same 6 - 11
7 - 20
2 - 27
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
asad.kam...@imrbint.com> wrote:
>
>> Hi Sundarvelan,
>>
>>
>> PFA…done with conditional formatting.
>>
>> ** **
>>
>> Regards,
>>
>> Prasad K
>>
>> *From:* excel-macros@googlegroups.com [mailto:
>> excel
Dear Gurus,
Please help me to Count the no of Red colored cells and green colored cells.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate threa
Dear Gurus,
Please help me on the attached excel query.
If greater than EOT then the cell color should be red elase green
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violat
Dear Gurus,
Please help me to highlight the row based on the location of the cursor.
This should be applied default to all the excel file im opening.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members
Hi Gurus,
Please help me in this formula
increase the sheet number in formula
=IF(IF(ISNUMBER(SEARCH(C$2,*Sheet1*!$B1)),"TRUE",0)="TRUE",TRIM(RIGHT(*
Sheet1*!$B1,LEN(*Sheet1*!$B1)-FIND(":",SUBSTITUTE(*Sheet1*!$B1," ",":",LEN(*
Sheet1*!$B1)-LEN(SUBSTITUTE(*Sheet1*!$B1," ","")),0)
I would lik
.
>
> let me know if you need help creating a selectionChange event macro.
>
>
> *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 a
Dear Gurus,
Please help me in repeating the macro for each cursor move.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor th
uot;,"6","7","8","9"},A1&"0123456789"))-1)
>
> Rgds
> Karan Singh
>
>
>
>
> On Mon, Sep 17, 2012 at 2:47 PM, Sundarvelan N wrote:
>
>> Hi Friednds,
>>
>> Please help me to extract only text from alphanu
Hi Friednds,
Please help me to extract only text from alphanumeric word for example
NT2 = *NT*
SUB123= *SUB*
WELC90= *WELC*
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violat
Hi Friends,
Help me in find the Starting Date Based on Week Number in a year.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. P
Dear Friends,
Please help me to find the latest date of a student.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Dear Friends,
Help me to find the circle and area. Please find the attached file for your
reference.
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, ac
ul wrote:
> http://spreadsheetpage.com/index.php/tip/a_formula_to_calculate_a_ratio/
> http://www.dailydoseofexcel.com/archives/2004/04/29/formatting-ratios/
>
>
> On Sun, Sep 2, 2012 at 3:33 PM, Sundarvelan N wrote:
>
>> Dear Friends,
>>
>> Help me in calculating the ratio.
Dear Friends,
Help me in calculating the ratio.
*MALE* *FEMALE* *RATIO* 967 6961376 9901602 12391545 1155
1377 10571220 9141003 708
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (
Please find the attached file for your reference.
Thanks
N.Sundarvelan
9600160150
On Fri, Aug 17, 2012 at 3:13 PM, Manoj Kumar wrote:
> Hi Sundarvelan,
>
> Tri it..
>
> =Text(a1,"ddd")
>
> Regard
> Manoj
>
>
> On Fri, Aug 17, 2012 at 3:12 PM,
Dear friends,
I need to find is the date in the cell is sunday
8/3/2012 10:30 8/3/2012 11:47 8/3/2012 10:26 8/3/2012 10:03 8/3/2012
11:09 8/3/2012 10:55 8/4/2012 10:57 8/3/2012 16:17 8/3/2012
14:21 8/3/2012
11:29 8/3/2012 11:28 8/3/2012 11:53 8/3/2012 14:33
Thanks
N.Sundarvelan
Dear Friends,
Please help me, after i updated the cell C17 the cursor should go to the
update button so that i dont use mouse to update please please help me
Thanks
N.Sundarvelan
9600160150
On Mon, Aug 13, 2012 at 3:46 PM, Sundarvelan N wrote:
> Hello Friends,
>
> Some how i fi
cific aspect
> that is causing you problems.
>
>
> On 11 August 2012 20:10, Sundarvelan N wrote:
>
>> Brothers please help me
>>
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>
>>
>> -- Forwarded message ---
Brothers please help me
Thanks
N.Sundarvelan
9600160150
-- Forwarded message --
From: Sundarvelan N
Date: Wed, Aug 8, 2012 at 2:32 PM
Subject: Data Entry - Need insert rows when i press enter button
To: excel-macros@googlegroups.com
Hello Friends,
I need to complete a
:00 P.M","")
>
>
>
>
>
> On Fri, Aug 10, 2012 at 2:34 PM, Sundarvelan N wrote:
>
>> Please find the attached file
>>
>>
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>
>>
>> On Fri, Aug 10, 2012 at 2:26
Dear Excel Gurus,
Please help me in calculating greater than 5:00 P.M
the input will be in this format - 6/1/2012 10:06:20 AM
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for v
Hello Friends,
I need to complete a projec. The requirement as follows
1. When i press ENTER button in the INPUT sheet the data should add in
the DATA sheet
2. The cursor should automatically go to the next tex box when i hit
enter button
I would be thankfull if it is done as soon a
Hi Friends,
Can any body share me forecasing templates in excel file.
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and N
Hi Friends,
Please help me in calculating the TAT
If my registration is 9 A.M
and the despatch time is 10 A.M - Met the TAT
IF the despatch time is 3 P.M - Not Me the TAT
Thanks
N.Sundarvelan
9600160150
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate th
Hi Friends,
Could you please help in counting the name in a column.
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Nee
Hi Experts,
Could you please tell me what is shortcut key like excel Ctrl+Shift+:in
OPENOFFICE.
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pro
Friends help me on this help.
Thanks
N.Sundarvelan
9600160150
-- Forwarded message --
From: Sundarvelan N
Date: Fri, Mar 2, 2012 at 11:52 AM
Subject: $$Excel-Macros$$ Sumproduct accross multiple sheets
To: excel-macros@googlegroups.com
Hi Friends,
Help me in achieving this
pe this helps.
>
> *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 c
Thank you verymuch my dear friends
Thanks
N.Sundarvelan
9600160150
On Thu, Mar 1, 2012 at 4:49 AM, Haseeb Avarakkan wrote:
> Hello Sundarvelan,
>
> Assume your sheet name always be in dd-mmm-yy format, if so see the
> attached.
>
> In Summary B1 & B2, enter the Start &a
Hi Friends,
Help me in achieving this task.
sumproduct across multiple sheets
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Pro
quot;).Value = Sheets("Summary").Cells(3,
>> "B").Value + Application.WorksheetFunction.CountIf(Sh.Range("C:C"),
>> "Driver") + Application.WorksheetFunction.CountIf(Sh.Range("C:C"),
>> "Sweeper")
>> End If
>> c = c + 1
>
Hi Freinds,
help me to achieve this task.
COUNT OF TOTAL EMPLOYEES 168 COUNT OF DRIVER AND SWEEPER 56
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help
Hi Friends,
I need a help in my project. I have excel file in which template sheet is
constant. When i open that file in the morning it should copy the template
sheet and rename the sheet with todays date. In the same day i will be
closing and opening that file many times but it should not insert
Thank you very much my dear friends, for yours quick reply.
Thanks
N.Sundarvelan
9600160150
On Wed, Jan 4, 2012 at 12:12 PM, NOORAIN ANSARI wrote:
> Dear Sundarvelan,
>
> The -- is used as an unary operator to convert a boolean value ie,
> TRUE/FALSE in to 1/0.
>
> So to n
Hi Friends,
Could you please explain why are we using -- in this formula.
=IF(ISNA(OFFSET($A$1,MATCH(0,MMULT(--
TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),ROW(INDIRECT("1:"&ROW()-1))/ROW(INDIRECT("1:"&ROW()-1))),0)-1,0,1,1)),"",OFFSET($A$1,MATCH(0,MMULT(
--
TRANSPOSE(TRANSPOSE($A$1:$A$13)=B$1:B1),RO
Hi,
Just convert the cell to date format
Thanks
N.Sundarvelan
9600160150
On Fri, Nov 25, 2011 at 11:18 AM, wrote:
> All,
>
> Is there a formula which converts text to date?
>
> PFA the sample file which I am trying to convert..
>
> Thanks in advance
>
> Best regards!
>
> --
> FORUM RULES (934
Asish Thankyou so much!
Very Very Thanks
Thanks
N.Sundarvelan
9600160150
On Tue, Nov 1, 2011 at 12:37 PM, ashish koul wrote:
> check if it helps
>
>
> On Tue, Nov 1, 2011 at 12:03 PM, Sundarvelan N wrote:
>
>> Hi Frineds,
>>
>> Please find the at
Hi Frineds,
Please find the attached file for your reference. I need to concatinate /
Consolidate based on condition.
FORMULA or by MACRO
Thanks
N.Sundarvelan
9600160150
--
FORUM RULES (925+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please refere the attached file.
Thanks
N.Sundarvelan
9600160150
On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar wrote:
> Dear All
>
> ** **
>
> Please suggest a formula of Sumproducts
>
> ** **
>
> Thanking u
>
> --
>
> --
ginal Message- From: XLS S
>> Sent: Wednesday, August 10, 2011 1:19 PM
>>
>> To: excel-macros@googlegroups.com
>> Subject: Re: $$Excel-Macros$$ Please help
>>
>>
>> Hey Sundaryelan,
>>
>> Please find the attachment
>>
>> .
>
Hi Friends,
I applied this formula it doesn't work for me.
Thanks
N.Sundarvelan
9600160150
On Thu, Aug 18, 2011 at 12:00 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hi Sundarvelan,
>
> Since you are dealing with valid numbers use SMALL function.
>
>
2:00 AM, Haseeb Avarakkan
> wrote:
> > Hi Sundarvelan,
> >
> > Since you are dealing with valid numbers use SMALL function.
> >
> > in G3 enter,
> >
> > =MIN(B:D)
> >
> > G4, copy down.
> >
> > =IFERROR(SMALL(B:D,COUNTIF(B:D,"&
Hi Freinds,
Please help me to get the uniques values.
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
Hi Friends,
I need one help.
I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
should pop up. Please help me.
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Fo
How to reduce the file size
--
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN g
Hello Friends,
Tomorrow i'm going to attend the Excel handling job intervew. I have been
informed that this is going to happen over phone interview also it will be
a technical round.
Friends could any body shoot the questions which can shoot me tomorrow.
Thanks in Advance!!!
--
Thanks
Check if mine is ok for you
Thanks,
Sundarvelan,
9600160150
On Mon, Feb 14, 2011 at 8:08 PM, ashish koul wrote:
> see if it helps
>
>
> On Mon, Feb 14, 2011 at 5:15 PM, Nemi Gandhi wrote:
>
>> attached herewith rashi querry sheet. Please provide me formula and help.
&g
Thanks Ashish but blank cell is coming in the middle of the column.
On Tue, Jan 11, 2011 at 10:57 AM, ashish koul wrote:
> check the attachment see if it helps
>
>
> On Tue, Jan 11, 2011 at 12:19 AM, Sundarvelan N wrote:
>
>> Hello Friends,
>>
>> Can anybody hel
Hi Rohan,
Thanks for your reply, but i dont want to edit my original excel file. I
need to get the agents name under corresponding TL names like wise TL names
under manager name.
Thanks,
Sundarvelan
9600160150
On Fri, Dec 24, 2010 at 3:43 PM, Rohan Young wrote:
> Hi,
>
> Please
I need to protect cell # B1 and cel # C1
if we enter NO in cell # A1
please help me
--
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links
Hi Firiends,
I need to reduce the Excel File size, my file went beyond 30 MB. Please help
me.
--
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks a
Hi Abhishek,
Please help to proceed with ur idea.
Thanks,
Sundarvelan
On Fri, Aug 6, 2010 at 1:27 PM, Abhishek Jain wrote:
> Dear Sundar,
>
> There are two things -
>
> First -
>
> If you want to put all unique values (the existing ones and the newly
> added) in those
Hi Friends,
Please help me to solve the below issue.
While i try to use the below code it says "Ambiguous name detected :W028M"
Private Sub CommandButton1_Click()
Dim fn As String
fn = Trim(TextBox1.Text)
If fn = "W001M" Then
Call W001M
TextBox1.Text = ""
ElseIf fn = "W002BW" Then
Call W002BW
Te
Hi Friends,
Please give the VBA code to find the date of previous day (yesterday).
Thanks,
N.Sundarvelan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
.*
**
*Please help me*
Thanks,
Sundarvelan
On Thu, May 13, 2010 at 6:56 AM, siti Vi wrote:
> I think, removing VPageBreaks and HPageBreaks can be done
> by setting FitToPage /Wide/Tall properties to : 1
>
> Sub ClearPgBreasks()
> With ActiveSheet.PageSetup
>
Hello Friends,
Can anyone help me to remove Page Breaks in Excel sheets Using VBA code.
Thanks,
N.Sundarvelan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://t
Hello Friends,
I need to do this using VBA Coding. Please help me
Thanks,
Sundarvelan
On Sun, May 9, 2010 at 8:38 PM, deepak kumar wrote:
> Hi Sundar,
>
> You can do it with conditional formatting, I've attached a work to show you
> how to do it, you just need to che
Hi Friends,
Can any one help me to solve the below condition
*"HIGHLIGHT ANYTHING OVER 30 DAYS SINCE LAST ACTION FILL IN COLOR YELLOW"*
Thanks,
N.Sundarvelan
--
--
Some important links for excel users:
1. Follow us
Hi Siti,
Thank you very much
Thanks,
Sundarvelan
On Fri, May 7, 2010 at 1:44 PM, siti Vi wrote:
> Assuming that :
> * YOUR LIST OF DATE are in a Range
> * "to delete" means to clear the content of a cell containing Date
> data
>
> Sub DoSomething()
> Dim
Hi Friends,
Please help me to delete the date which are older than last week wednesday.
Also i need a code to remove page breaks except the below recoded code
ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
Thanks
N.Sundarvelan
--
-
Hi friends,
Please help.
How to automatically set the range to clear the pagebreaks in different
data.
Thanks,
Sundarvelan
On Wed, May 5, 2010 at 5:42 AM, siti Vi wrote:
> try:
>
> Sheets("MySheet").UsedRange.PageBreak = xlPageBreakNone
>
>
> ---
Hi Friends,
Please help me to solve the final step of my project.
I need to remove the page break lines to the end of the column upto which
the data is available.
Thanks,
N.Sundarvelan
--
--
Some important links fo
1 - 100 of 114 matches
Mail list logo