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,
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/
-
>
>
>
>
>
>
>
> *“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*
> --------
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
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
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,
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
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 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 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 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,
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,
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
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
>
>
>
>
> -
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.”
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
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
>
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
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
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
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,
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 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,
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,
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
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
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.
>
>
; 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
>>
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
-
>
>
>
>
>
>
>
> *“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*
> ---
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
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
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
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
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*
> -
>
> --
> *
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
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
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,
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
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
, 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
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
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
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,
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 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 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,
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 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,
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
,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
>
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
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
; 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 ,
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
> 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,
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
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
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,
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
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
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
. 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,
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
---
>
>
>
>
>
>
>
> *“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*
>
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
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,
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
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
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
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
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
>
> On Wed, Feb 12, 2014 at 5:43 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hi,
>>
>> am trying to put borders using vba but am getting error while running it.
>> please find attached files and let me know how to solve it.
>>
>>
>
> =SUMPRODUCT((--(A1:A4={"a","b"})*B1:B4))/SUMPRODUCT(--(A1:A4={"a","b"}))
>
>
> Hope this is what you want.
>
> Regards,
>
> Swapnil.
>
>
> On Fri, Jan 31, 2014 at 8:04 PM, Chandra Shekar <
> chandrashekarb@
Hi,
am getting incorrect answer.
Regards,
Chandru
On Fri, Jan 31, 2014 at 5:03 PM, Aamir Shahzad wrote:
> Try this
>
> =SUMPRODUCT(($A$1:$A$4=A1)*($B$1:$B$4)/COUNTIF($A$1:$A$4,A1))
>
>
> On Fri, Jan 31, 2014 at 3:33 PM, Chandra Shekar <
> chandrashekarb@gmai
Hello,
Could you please help me in attached file to find average using sumproduct.
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/disc
Hello,
Am trying filter data by date range suppose if date as two
different months(30/11/2013 - 01/12/2013) data is not getting filtered out.
Could you please let me know what is the issue in the code.
Thanks in advance.
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
o 1 & for false it will convert to 0.
>
> * means multiply
>
> Regards,
> Cartik
>
>
> On Mon, Nov 25, 2013 at 1:34 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> What is the difference between ),-- and *-- in sump
Hello,
What is the difference between ),-- and *-- in sumproduct function.
=SUMPRODUCT(--(Sheet1!$AK$2:$AK$5=P$7)*--(Sheet1!$J$2:$J$5=$B$7))
=SUMPRODUCT(--(Sheet1!$AK$2:$AK$5=P$7),(--(Sheet1!$J$2:$J$5=$B$7)))
Regards,
Chandru
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
Hello Ashish,
still its showing total for visible cell also that is 6 in this case. Is
there any function relate to pivot table?
Thanks in advance.
Regards,
Chandru
On Fri, Nov 22, 2013 at 7:39 PM, ashish koul wrote:
> =SUBTOTAL(3,F:F)
>
>
> On Thu, Nov 21, 2013 at 12:49 PM, Ch
Hello,
How to count visible cell in pivot?
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, accurate thread titl
End Sub
>
>
>
> On Mon, Nov 18, 2013 at 1:38 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> Is there anyway to get cell reference of shapes please find sampe excel.
>>
>> Thanks in advance.
>>
>> Regards,
>
Hello,
Is there anyway to get cell reference of shapes please find sampe excel.
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/discuss
Hello,
How to get count of visible cells in Pivot tables where as below line gives
us entire count of pivot field Name.
Thanks in advance.
pitmcnt_nm = pvt_tbl.PivotFields("nm").PivotItems.Count
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=
Hi,
Okay...thank you :)
Regards,
Chandra
On Thu, Oct 3, 2013 at 7:48 PM, ashish koul wrote:
> if data is sorted then u can use index match
>
>
> On Thu, Oct 3, 2013 at 5:51 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>>
ups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Tuesday, October 01, 2013 7:58 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Min based on condtions
>
> ** **
>
> Hello,
>
>
>
> am trying to get lowest date based on condtion pleas
Hello Asish,
I tried it and its working fine but I need to know is there any other way
to get this result.
Regards,
Chandra
On Wed, Oct 2, 2013 at 12:31 PM, ashish koul wrote:
> y dont u try pivot table
>
>
> On Wed, Oct 2, 2013 at 12:28 PM, Chandra Shekar <
> chandrashe
Hello,
am trying to get lowest date based on condtion please find attached file
for the same. Is there anyway to get this without using =min(if(...).
Regards,
Chandra
--
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
see this
>
> http://excelpoweruser.wordpress.com/?s=Unique+list
>
>
>
>
> On Wed, Sep 25, 2013 at 8:32 AM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello,
>>
>> Am trying to extract unique values using array but am not getting correct
>>
Hello,
Am trying to extract unique values using array but am not getting correct
count. I have attached the excel in Sheet1 there is main data, in sheet2 am
getting values after running macros and in sheet3 colored cells is the
orginal value and in Column C I have put countif formula which is not
:B15,B2:B15)*IF(A2:A15=C2,1,0)),0) with
> ctrl+shift+enter.
>
> ** **
>
> ** **
>
> ** **
>
> *Regards,*
>
> *Excel Beginner*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *C
A$2:$A$15))*1)
> WITH CSE
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Wednesday, September 18, 2013 4:13 PM
> *To:* excel-macros@googlegroups.com
> *Cc:* ashish koul
>
> *Subject:* R
,1))
>
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Tuesday, September 17, 2013 6:00 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Formula: Count
>
> *
Hello,
I need formula to count no of points based on condtion please find attached
file.
Thanks,
Chandra
--
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
rds,*
>
> *Ravi Kumar.*
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Chandra Shekar
> *Sent:* Friday, September 13, 2013 4:21 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Su
Hi,
I have a problem with Sumproduct function please find attached file for the
same where from E1, F1 & G1 are condtions based on it I need sum up Column
D.
Thanks in advance.
Regards,
Chandra
--
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) !
low
>
> =SERIES(,Sheet2!$E$3:$N$3,Sheet2!$E$16:$N$16,3)
>
> now replace all starting from $ with name range
>
> =SERIES(,Sheet2!namerange1,Sheet2!namerange2,3)
>
> see if it works
>
>
>
> On Wed, Sep 11, 2013 at 7:10 PM, Chandra Shekar <
> chandrashekarb@gmail
Hi,
Am trying to plot dyanamic chart but am having problem with name range if I
try to select correct reference its changing to other reference. Could you
please check attach file and let me know where its going wrong.
Thanks in advance.
Regards,
Chandra
--
Are you =EXP(E:RT) or =NOT(EXP(E:R
njoy
> Team XLS
>
>
>
> On Thu, Sep 5, 2013 at 1:06 PM, Chandra Shekar <
> chandrashekarb@gmail.com> wrote:
>
>> Hello Ashish,
>>
>> Could you please let me know why Chart disapperars while saving the file,
>> everything is working
Hi,
Got the solution for this problem I have declared variable to integer then
I changed it to Long. Now macro is working fine.
Thanks,
Chandra
On Wed, Aug 14, 2013 at 10:25 AM, Lalit Mohan Pandey <
mohan.pande...@gmail.com> wrote:
> Instead of sharing Screen shot it would be nice if you can s
1 - 100 of 261 matches
Mail list logo
