Hi,
Am trying to do dashboard here If I click on Radio button automatically
graph need to get change. Could you please help me on this.
Thanks,
Chandru
--
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
In the attached file when I click on scroll bar for each 5 row data should
change. Could you please let me know how do it?
Thanks,
Chandru
--
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
Thank you Ravinder :)
On Wed, Mar 12, 2014 at 5:07 PM, Ravinder wrote:
> PFA
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Wednesday, March 12, 2014 5:03 PM
> *To:* excel-macros@goo
s@googlegroups.com] *On Behalf Of *Vaibhav Joshi
> *Sent:* 05-Mon-2014 19:43
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ PivotTable_Calculated Field
>
>
>
> Hi
>
>
>
> Refer: http://www.contextures.com/excel-pivot-table-calculated-field.ht
Hi,
am trying to refresh pivot every one minute but its running first time and
its not enter there after may I know what is problem in the code.
Thanks in advance.
Sub PivotsRefresh()
Dim sh As Worksheet
Dim pt As PivotTable
MsgBox "Enter..."
For Each sh In ActiveWorkbook.Sheets
'sh1 = sh.Na
l Ontime_PivotRefresh
>>
>>
>> Cheers!!
>>
>>
>> On Mon, Aug 11, 2014 at 7:48 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hi,
>>>
>>> am trying to refresh pivot every one minute but its
Hi,
One of my colleague went for an interview and they asked How many types of
variables are there in VBA?
Could you please let me know answer to this question and can anyone share
VBA questionaries for interview?
Thanks in advance.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) i
---
>
>
>
>
>
>
>
> *“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*
>
Hello,
Could you please let me know what is the issue with sumproduct formula
where result should be 3 but its giving as 7.
Thanks in advance.
Regards,
Chandru
--
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
. God is here working through me for you.*
>
> On Thu, Sep 11, 2014 at 8:23 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> Could you please let me know what is the issue with sumproduct formula
>> where result should be 3 but its giv
Hello,
How to get unique values based on two conditions. Could you help me in the
attached file.
Thanks in advance
Regards,
Chandru
--
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.face
Thanks a lot
On Fri, Sep 12, 2014 at 3:06 PM, Vaibhav Joshi wrote:
> Chk this..
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Fri, Sep 12, 2014 at 12:19 PM, Chandra Shekar <
> chandrashekarb@gmail.com> w
gt;> Cheers!!
>>
>> +
>> *I did not do this for you. God is here working through me for you.*
>>
>> On Fri, Sep 12, 2014 at 2:34 PM, Chandra Shekar <
>> chandrashekarb@gmail.com> wrote:
>>
>>> Hello,
>>>
>>> Ho
e for you.*
>
> On Fri, Sep 12, 2014 at 7:53 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Thanks a lot. but its there any single formula to do this?
>>
>> Regards,
>>
>> Chandra
>>
>> On Fri, Sep 12, 2014 at 5:31 PM,
Thanks Vaibhav
On Wed, Sep 17, 2014 at 5:22 PM, Vaibhav Joshi wrote:
> Hi,
>
> No posts since morning thought of sharing amazing excel formulas by Bill
> Jelen aka Mr. Excel.
>
> Cheers!!
> +
> *I did not do this for you. God is here working through me for you.*
>
> --
> Are you =EXP(E:RT) o
Hello,
What is the difference between Stacked Line with Markers & Stacked line
with Markers.
Thanks in advance.
Regards,
Chandru
--
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
> Hope this helps.
> Thanks,
>
> Joseph
>
> On Thu, Oct 30, 2014 at 8:11 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> What is the difference between Stacked Line with Markers & Stacked line
>> with Markers.
Hello ,
I need to display value as percentage could you please help me on attached
file.
Thank you,
Chandru
--
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
FO
; 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*
> -
>
>*From:* Chandra Shekar
> *To:* excel-macros@googlegroups.com
> *Sent:* Monday, November 24, 2014 7:11 AM
Hello All,
Thanks all for your help. :)
On Mon, Nov 24, 2014 at 10:51 PM, Paul Schreiner
wrote:
> Do you understand what it MEANS to calculate a percent?
>
> 10% means 10 out of 100 or 10/100 .10
> 50% is 50 out of 100 or 50/100 or .50
>
> so, you CANNOT display 1 as 1% because 1% isn't 1, it's
Hello Team,
Is there anyway to add Date & Time picker in Excel 2010 in both 32 & 64 bit
system.
I tried in 32 bit system its working fine but not same with 64 bit system.
Can someone help me out on this.
Regards,
Chandrashekar B
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
Hello,
Needed difference between times(Including and excluding weekends with
Business hours from 9AM to 8PM)
Could you help me on this attachment.
Regards,
Chandru
--
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
art or End date
> is one of the listed holidays.
> Nor does it account for any time outside of the core "Business Hours".
>
> Hope this helps.
>
> *Paul*
> -
>
>
>
>
>
>
>
> *“Do all the good you can,B
How to change Header using VBA code?
1. Name = Any Name
2. =Previous Month
Regards,
Chandrashekar B
--
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
FO
Hello Team,
Any help on this?
Regards,
Chandru
On Mon, Mar 27, 2017 at 7:40 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> How to change Header using VBA code?
>
> 1. Name = Any Name
> 2. =Previous Month
>
> Regards,
>
> Chandrashekar B
>
Hello Team,
Could you please help me in attached week formula.
Regards,
Chandru
--
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, a
Week 1 = first 7 days
> Week 2 = Second 7 days
> etc.
>
> *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.”
x27;Hopkins Ruben' via
> MS
> EXCEL AND VBA MACROS
> wrote:
>
>Subject: Re: $$Excel-Macros$$
> Help on
> Week Formula
>To: excel-macros@googlegroups.com
>Date: Sunday, July 30, 2017,
> 3:31 PM
>
>
>
>
> -
Hello,
Could you let me know how to get pivot values using VBA in the attached
files.
For Ex: I need to get value for the month Sep-17 i.e
A, AAA & 1
Regards,
Chandru
--
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 pag
Hello,
Can I get result in attached using Pivot.
Thanks in advance.
Regards,
Chandru
--
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 conc
Hello Saleem,
Is it possible to get field one after another. that is Accp then Accp %.
Can you explain in steps how to do it. Thanks in advance.
Regards,
Chandru
On Thu, Jan 25, 2018 at 12:09 PM, Saleem Ansari
wrote:
> Please check & revert
>
> On Wed, Jan 24, 2018 at 7:4
Hello Saleem,
There is a small change in the data have attached same.
Regards,
Chandru
On Thu, Jan 25, 2018 at 4:53 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello Saleem,
>
> Is it possible to get field one after another. that is Accp then Accp %.
>
&g
Hello Ankur,
Thanks will check & revert :)
Regards,
Chandru
On Sun, Jun 24, 2018 at 12:20 AM, ankur wrote:
> Chandru
>
> please check this solution
>
>
>
>
>
> *With Regards:*
>
> *CMA** Ankur Pandey*
> *B.Com (H), C.M.A *
> * Mob: :- +919532513513*
>
>
> *P* Please don't print this e-mai
Hello Ankur,
Its working fine. thanks a lot.
Regards,
Chandru
On Tue, Apr 3, 2018 at 7:46 PM, chandrashekarb.xls <
chandrashekarb@gmail.com> wrote:
> Hello,
>
> How to know no. Of sundays between dates?
>
> Regards,
> Chandru
>
>
>
> Sent from my Samsung Galaxy smartphone.
>
> --
> Are you
Hello,
Need formula which should check Column A and B For Ex: If CPI have both A &
B then its Yes. IF CPI has only A or B then it should be No.
Regards,
Chandru
--
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 t
t all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -----
>
>
> On Wednesday, July 25, 2018 7:59 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>
> Hello,
>
> Need formula which should check Column A and
Hello,
Is there any way to prevent from deletion based on condition but without
using protecting sheet.
For ex: Prevent user to delete row lesser than 8 but still he can able to
edit it.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,D
gt;
>
>
>
> *“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 Sund
-
>
>
>
>
>
>
>
> *“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*
> --------
Hello,
am getting this error while saving attachment from Outlook 365.
How to resolve this issue?
Regards,
Chandrashekar B
--
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/
Hello,
How to save attachments from Outlook(Particular Folder not under Inbox) to
local drive.
Regards,
Chandru
--
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
Hello,
How to remove duplicates within a cell using VBA?
Please find attached sample file for the same.
Regards,
Chandru
--
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/di
,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*
> -
>
>*From:* Chandra Shekar
> *To:* excel-macros@googlegroups.com
> *Sent:* Tuesday, February 24, 2015 5:16 AM
>
Hi,
Correct Paul it should be f, g, a, b. if possible please provide solution
for both.
Regards,
Chandru
On Wed, Feb 25, 2015 at 11:51 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> Thanks for your reply. If possible both the steps Macro as well u
Hello Michael,
Thanks for the solution.
Regards,
Chandru
On Tue, Feb 24, 2015 at 11:35 PM, michael vinoth
wrote:
> Hi Chandru,
>
> Please find the attached macro files for Removing Duplicates within the
> cell.
>
> Kindly let me know, if you have any queries.
>
> Regards,
> MV
>
> On Tuesday,
Hello,
PFA file and am trying to get counts based on merged cells. I have given
comments in Column G. Could you help me on this.
Regards,
Chandru
--
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 @
htt
Hello Mandeep,
Thanks for the formula. is there any way we can work on merged cells?
On Tue, Apr 14, 2015 at 4:00 PM, Mandeep Baluja
wrote:
> unmerge your cells and Fill it down to create a helper and use this
> formula.
>
> Regards,
> Mandeep Baluja
>
>
> On Tuesday, April 14, 2015 at 2:21:19
Hello Mandeep,
Formula does not work when Column B is General Field(Mix of Text & Number
format). Please find attached sheet.
Regards,
Chandru
On Tue, Apr 14, 2015 at 4:08 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello Mandeep,
>
> Thanks for the formul
Hello,
Thanks much :-)
On Tue, Apr 14, 2015 at 8:34 PM, Vaibhav Joshi wrote:
> Check this...
>
> Add two helper column & see formula in Green, i have tested for both of
> sample data given by you & its working..
>
>
> Cheers!!
>
> On Tue, Apr
Hello,
Could you please help me in attached excel file am getting error in
diaFolder.Filters.Add "Excel", "*.xls", 1 line.
Regards,
Chandru
--
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://w
Hello,
Its working now may I know what is different between
msoFileDialogFilePicker and msoFileDialogFolderPicker.
Thanks in advance.
Regards,
Chandru
On Thu, Aug 20, 2015 at 2:54 PM, Mandeep Baluja
wrote:
> use this line
>
> Set diaFolder = Application.FileDialog(msoFileDialogFilePicker
mes you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> ---------
>
> --
> *From:* Chandra Shekar
> *To:* excel-macros@googlegroups.com
> *Sent:* Friday, August 21, 2015 12:55 AM
> *Subject:* Re: $$Ex
, Aug 28, 2015 at 12:27 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello,
> I need to select folder and wat ever excel files are there in that folder
> I need to work on it.
>
> Is there any way to do this?
> Regards,
> Chandru
>
>
>
> On Wed, A
Hello,
Am trying to find out student name who scored min marks using index & min
function but its giving error. Could you please find attached workbook and
let me know where its wrong.
Thanks,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N
Hi,
How to send range in outlook. Could anyone help me with VBA code?
Thanks,
Chandru
--
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 con
ore Microsoft Outlook ? Object Library*
> *Where ? is the Outlook version number*
>
>
> and -> http://www.rondebruin.nl/win/s1/outlook/bmail4.htm
>
>
>
>
>
>
>
> Em sexta-feira, 9 de outubro de 2015 08:43:54 UTC-3, Chandra Shekar
> escreveu:
>>
>
Hi,
I need a OUTLOOK code to save attachments in folder (Not excel code) based
on subject line.
Regards,
Chandru
--
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/discussexc
Hello,
Is it possible to schedule task in windows which will oepn at 10 AM and
ends at 6:00 PM(Office working hours) but not using onkey in VBA.
Regards,
Chandru
--
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
t;
>
>
>
> *“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*
> -
>
> --
> *
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*
> -
>
> --
> *From:* Chandra Shekar
> *To:* excel-macros@goo
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*
> -
>
> --
> *From:* Chandra Shekar
> *To:* excel-macros@googlegroups.com
> *Sent:* T
Hello,
Am running excel(Macro Based) in server but its always getting Read only
error even nobody is using that file. Could you please let me know what is
the issue in it or need to change some setting in server.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you w
e
> you can,As long as ever you can.” - John Wesley*
> ---------
>
> --
> *From:* Chandra Shekar
> *To:* excel-macros@googlegroups.com
> *Sent:* Thursday, October 29, 2015 8:09 AM
> *Subject:* $$Excel-Macros$$ Read Only
-
>
>
>
>
>
>
>
> *“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*
> ---
ning message?
>
>
> *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
; On Tue, Nov 3, 2015 at 12:22 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> Am trying to run macro from task scheduler which will send mails from
>> outlook but its working fine when I run it manually but if I schedule it
>>
Hi,
PFA report and am getting this error only while running from TASK SCHEDULER.
Regards,
Chandru
On Tue, Nov 3, 2015 at 2:14 PM, Chandra Shekar wrote:
> Hi,
>
> Its confidential document cannot able to share it can you please let me
> know solution for it.
>
>
Hi All,
Issue got resolved as its a security issue.
Regards,
Chandru
On Wed, Nov 4, 2015 at 9:11 AM, sahemur khan wrote:
> Dear Sir,
>
>make changes in your macro as per below mention in blue
>
> Set OutApp = CreateObject("Outlook.Application.14") TO *Set OutApp =
>> CreateObject("Outloo
Hello,
I have created new gmail now I need to move old gmail account to new gmail
account.
Is there any way to do this?
Regards
Chandru
--
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
Hello,
I need a code in word where it opens excel document and paste graphs in a
particular postion.
Is there any way to do it and also need a book where it as multiple
examples like this.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,
Hello Team,
Any help on this?
Regards,
Chandru
-- Forwarded message --
From: Chandra Shekar
Date: Fri, Nov 20, 2015 at 10:32 AM
Subject: Moving mail within Gmail Account
To: excel-macros@googlegroups.com
Hello,
I have created new gmail now I need to move old gmail account
Hello,
Could you please help in sorting pivot based on month?
Thanks in advance
Regards,
Chandru
--
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
Hello,
Could you please let me know how to remove hyperlinks linked to graphical
objects (Its nearly 1000 objects)
Thanks in advance.
Regards,
Chandra Shekar B
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please
Hello,
Thanks for the reply. I have nearly 1000 graphical object in the work
sheet. Macro is taking lot of time to get run some times it hangs also. I
have a good processor & ram speed.
Could you please suggest on this.
Thanks in advance.
Regards,
Chandra Shekar B
On Fri, Mar 2, 2012 at
).PivotCache.Refresh
*Application.DisplayAlerts = True
End Sub
Regards,
Chandra Shekar B
--
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 Need Advice
Hello Rajan,
Yes Pivot name is correct.
Regards,
Chandra Shekar B
On Tue, Mar 6, 2012 at 1:48 PM, Rajan_Verma wrote:
> Is pivot name “BP” correct?
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
Hello,
Please let me know is there any soultion for this kind of issues.
Regards,
Chandra Shekar B
On Tue, Mar 6, 2012 at 1:58 PM, Chandra Shekar wrote:
> Hello Rajan,
>
> Yes Pivot name is correct.
>
> Regards,
>
> Chandra Shekar B
>
> On Tue, Mar 6, 2012 at
Hello,
I would like to have multi combo box on every row (1000 rows). Could you
please help me out on this.
Thanks in advance.
Regards,
Chandra Shekar B
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Hello,
Could you please help me on the attached file. Thanks in advance.
Regards,
Chandra Shekar B
On Tue, May 1, 2012 at 3:39 PM, Rajan_Verma wrote:
> *HI Chandru,*
>
> * *
>
> *File size will be very larege with 1000 controlls on worksheet.. I
> suggest to use List Valid
Hello,
Thanks all.
Regards,
Chandra Shekar B
On Wed, May 2, 2012 at 6:56 PM, Bé Trần Văn wrote:
>
>
> 2012/5/2 Rajan_Verma
>
>> Hi Chandru
>>
>> Please find the attached sheet, you can use list validation for that..***
>> *
>>
>> *
Hello,
Could you please help me in the formula. Please find attached file.
Thanks in advacne.
Regards,
Chandra Shekar B
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hello,
Thank you very much.
On Tue, May 15, 2012 at 4:14 PM, Krishna Kumar wrote:
> Hi
>
> In G1: 3
>
> In H2 and copied down,
>
> =IF(ROWS(H$2:H2)<=$G$1,LARGE($E$2:$E$7,ROWS(H$2:H2)),"")
>
> In I2 and copied down,
>
>
> =IF(N(H2),INDEX($A$2:$A$7,SMALL(IF($E$2:$E$7=H2,ROW($E$2:$E$7)-ROW($E$2)+1)
Hello,
Can you please help me with attached excel.
Thanks in advance.
Regards,
Chandra Shekar B
--
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
Hello,
Thanks all for your reply. Formula is not working if we have difference in
date. Please find attached excel for the same.
Thanks in advance.
Regards,
Chandra Shekar B
On Tue, Jun 12, 2012 at 5:15 PM, ankur wrote:
> Dear Chandra,
> Try this one
>
>
>
>
>
>
&
Hello Ankur,
Can you please send solved excel file.
Thanks,
Chandra Shekar B
On Wed, Jun 13, 2012 at 5:51 PM, wrote:
> hi chandra
>
> try this
>
> TEXT(B2-A2,"[h]:mm:ss") for Formula2(hr:mm:ss)
>
> On , Chandra Shekar wrote:
> > Hello,
> >
> &
Hi,
In sheet1 I have 5 pivot table and source in sheet2. Here I need macro which
refresh pivot table when I paste new data.
Thanks in Advance.
Regards,
Chandra Shekar B
9845976015
--
--
Some important links for
Hi Daniel,
Thank you very much. :)
Regards,
Chandra Shekar B
On Wed, Apr 27, 2011 at 8:37 PM, Daniel wrote:
> Hi,
>
> Paste the following macro in Sheet1 module :
>
>
>
> Private Sub Worksheet_Change(ByVal Target As Range)
>
> 'A1:F10 is data for pivot table
Hi,
I want Min Max and Average by using Sumproduct. My problem is I want a
formula which should be based on Date and Title as shown on Column D, E & F
and based on Column C I need Average, Min & Max Values. If I confusing pls
let me know.
Thanks
Chandra
Hi Asish,
Thanks for your reply, but I did'nt get the desired result i.e. in MAX, MIN
& AVG for first record should be 100, 50 & avergage should be 87.5.
Can we use sumproduct for all the formulas instead of array formulas. Thanks
in advanc.
Regards,
Chandra Shekar B
On Mon, May
Hi Ashish,
Please find attached file.
Thanks,
Chanra Shekar B
On Tue, May 17, 2011 at 6:09 PM, ashish koul wrote:
> i have made changes in the data may be because of that can you attach the
> sample file back
>
>
> On Tue, May 17, 2011 at 12:06 PM, Chandra Shekar <
Hi,
Thanks for the reply. Can we do this without using array function.
Regards,
Chandra Shekar B
On Thu, May 19, 2011 at 11:16 AM, Anil Bhange <
anil.bha...@tatacommunications.com> wrote:
> HI Chandra,
>
>
>
> See if it helps…
>
>
>
> Regards,Anil Bhan
Hi,
Is there any way to recover corrupted excel file.
Thanks,
Chandra Shekar B
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2
Hi,
You are using array formula
i.e.=MIN(IF($A$2:$A$12>=E2;IF($A$2:$A$12<=F2;IF($B$2:$B$12=D2;$C$2:$C$12;""
&
=AVERAGE(IF($A$2:$A$12>=E2;IF($A$2:$A$12<=F2;IF($B$2:$B$12=D2;$C$2:$C$12;"".
Is there any way to do this without using array formula.
Thanks
Hi can u expalin briefly in steps.
Thanks,
Chandra Shekar B
On Fri, May 20, 2011 at 5:02 PM, rajan verma wrote:
> Use a Function Like this
>
> ='C:\Users\Xl_Lover\Desktop\[Book2[Sheet1]]Index'!A1
>
>
>
> On Fri, May 20, 2011 at 4:00 PM, Chandra Shekar <
>
Hi,
This I tried but still I could not able to recover the file. Let me know is
there any other way to recover file.
Thanks,
Chandra Shekar B
On Sat, May 21, 2011 at 10:11 AM, ashish koul wrote:
>
> http://office.microsoft.com/en-us/excel-help/repairing-corrupted-files-in-excel-HA001
Hi,
Its a confidential file. I cannot send the file. Please let me know if there
a way to recover the file.
Regards,
Chandra Shekar B
On Tue, May 24, 2011 at 2:35 PM, Rajan_Verma wrote:
> Send your File..
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macro
Hi,
How to extract data from a pivot item. In the example I need pivot items(1)
data in the same worksheet. Thanks!
With pvt_tbl
pvt_tbl.PivotFields("Priority").PivotItems(1).Visible = True
pvt_tbl.PivotFields("Priority").PivotItems(2).Visible = False
pvt_tbl.PivotFields("Priority").P
Hi,
Any help regarding this. Thanks!!!.
Regards,
Chandra Shekar B
On Tue, May 24, 2011 at 6:37 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> How to extract data from a pivot item. In the example I need pivot items(1)
> data in the same worksheet. Thanks
Hi Asish,
Please find attached excel file. I have given instruction in the macro
itself. Thanks!
Regards,
Chandra Shekar B
On Wed, May 25, 2011 at 4:02 PM, ashish koul wrote:
> can you attch the worksheet
>
> On Wed, May 25, 2011 at 11:55 AM, Chandra Shekar <
> chandrashekar
result.
Regards,
Chandra Shekar B
On Wed, May 25, 2011 at 7:39 PM, ashish koul wrote:
>
> Sub filter_pivot()
>
>
> Application.ScreenUpdating = False
> Application.EnableEvents = False
>
> Dim pi1 As PivotItem
> For Each pi1 In
> Sheets(2).PivotTables(&qu
1 - 100 of 261 matches
Mail list logo