hi,
Can you help me to calculate angle of each pie from pie chart image using
vba.
Example image given below:
Regards,
Joseph Camill
--
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
Hi Rajan / vba gurus,
If possible please share this file as I have a similar issue
http://excelpoweruser.wordpress.com/2012/09/29/showing-values-on-angle/
On Sat, Sep 29, 2012 at 5:01 PM, Rajan_Verma
wrote:
>
>
> *Hi *
>
>
>
> *I have make it more suitable , please download from here..*
>
> ht
Power BI is a paid is a graphical tool for dash board graphical
presentation etc. It is paid services from Microsoft. It work like pivot
table and chart.
Pivot table is far better than Power B . If you coud establish connection
to the file in server and user pivot table in excel that is best than
Dear Mr. praveen
In your file some unwanted character which is invisible in the front of
each numbers are hidden. That is the reason the number is considered as
text by excel and you are unable to calculate. This is very small data I
have manually removed the character in each cell. to remove coma
Dear Mr. Paul,
It great to formulate such a amazing formula to calculate such difficult
scenario.
Abi Joseph
On Fri, Sep 29, 2017 at 5:48 PM, Paul Schreiner
wrote:
> This is pretty "convoluted" logic.
> I tried several approaches that soon became extremely complex (as
Hello all ,
I have a conundrum. I have a table that i am using to collate data from
previous years sales. The data is from 2008 thru current year. I have the
table set up as follows:
*Month | 2008 | 2009 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 |
2016 | 2017 | 5year Average*
Unde
I understand that this may not pertain to VBA particularly, but I thought
that I might ask.
I have a spreadsheet that has 4 columns of numbers (simple numbers). A
fifth column has the following equation in it:
=(11.078+1.131*LOG(B2)+0.416*LOG(C2)-0.274*LOG(D2)-0.005*(E2))
I am having issue
Thanks
Abi Joseph
On Sat, Apr 23, 2016 at 6:08 PM, sleek wrote:
> I dont usually use networkdays much, & your site props up ads and offers,
> too.
>
>
> On Monday, 18 April 2016 11:40:43 UTC+3, Melissa James wrote:
>>
>> Hello Guys,
>>
>> Hello G
is useful for your financial calculation,
kindly send a request to this mail kba.jos...@gmail.com for me to send you
the right package that work accurately from April 1, 2016 to March 31, 2017
Regards
Abi Joseph
Mobile : 9677273222
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
;
> It's my mistake :)
>
> Regards
> Ashish
>
> On 29 November 2014 at 15:04, Vaibhav Joshi wrote:
>
>> hi
>>
>> chek this...
>>
>> Cheers!!
>>
>> +
>> *I did not do this for you. God is here working through me for you.*
&g
> *I did not do this for you. God is here working through me for you.*
>
> On Sat, Nov 29, 2014 at 9:49 AM, Ashish Kumar
> wrote:
>
>> Hi Joseph,
>>
>> PFA
>>
>> Regards
>> Ashish
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)
" in row 1 of Raw sheet and
then copies until end of row in that column and pastes back in column A row
5 of Final sheet.
Hope this is clear.
Thanks,
Joseph
On Fri, Nov 28, 2014 at 10:58 PM, Ravi Kumar
wrote:
> Hi,
>
>
>
>
>
> Click on the button and result would be p
Hi,
Please provide VBA code based on the instructions given in the excel file.
Thanks,
Joseph
--
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
login form to excel add-in file
> using this authorized user can use (run) add-ins macro
> add-in name => ctools
> macro names=> get SlNo, Top10, Reports etc
> Sir, pls send code for add in if login success than only add-in macros
> enable else disable
>
> thanks
>
>
Hi Pramod,
None are working.
On Mon, Nov 3, 2014 at 7:18 AM, Pramod Singh wrote:
> User id is 123456
> Password may be 321 or 123 or the
>
> Try in three password. .
>
> Regards
> Pramod
>
> Pramod
> On 3 Nov 2014 02:02, "joseph camill" wrote:
>
&g
t; get SlNo, Top10, Reports etc
> Sir, pls send code for add in if login success than only add-in macros
> enable else disable
>
> thanks
>
> On Sun, Nov 2, 2014 at 6:24 PM, joseph camill
> wrote:
>
>> Hi Pramod,
>>
>> Thank you for the file, but I am unable t
mod
>
> On Sun, Nov 2, 2014 at 4:33 AM, joseph camill
> wrote:
> > Hi experts,
> >
> > With the help of various online help have managed to work on few codes in
> > userform.
> >
> > I need two help:
> > 1. Get error when I "Update password"
have been taken from "
http://www.anychart.com/products/anychart/docs/users-guide/Line-Spline-Step-Line-Chart.html
"
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
Hi experts,
With the help of various online help have managed to work on few codes in
userform.
I need two help:
1. Get error when I "Update password", please help me rectify
2. Please have a look at the code and try to make it more efficient, in
terms of number of lines and also duplication.
fo
Thank you Vaibhav
On Sun, Oct 12, 2014 at 7:04 PM, Vaibhav Joshi wrote:
> Thanks bro...
> On Oct 12, 2014 6:05 PM, "Ashish Kumar" wrote:
>
>> Hi Vaibhav Bhai,
>>
>> Nice Solution. Sheet is working Great.
>>
>>
>> Regards
>> Ashish
>>
>> --
>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
:27 AM, "joseph camill" wrote:
>
>> Hi Vaibhav,
>>
>> Yes, I tried this, and it is working great. I have made one modification.
>> Instead of right click to the workbook, I added a Form control button and
>> have assigned to it.
>>
>> Need to add more
Hi Vaibhav,
Yes, I tried this, and it is working great. I have made one modification.
Instead of right click to the workbook, I added a Form control button and
have assigned to it.
Need to add more sheets and do a final check.
On Fri, Oct 10, 2014 at 12:48 AM, Vaibhav Joshi wrote:
> Jos
Hi Vaibhav,
Thank you for the file and apologies for the late response.
It is working great.
Thanks and regards,
Joseph Camill
On Tue, Oct 7, 2014 at 10:51 AM, Vaibhav Joshi wrote:
> JC
>
> check this,
>
> there is sheet name C, in that mention InputSheet Names in col A &
Hi Vaibhav,
In addition, the format for Std IX and X will change in terms of marks
display.
Regards,
Joseph
On Oct 7, 2014 10:15 AM, "joseph camill" wrote:
> Hi Vaibhav,
>
> Output format remains the same but there is addition / subtraction of
> subjects and off co
Hi Vaibhav,
Output format remains the same but there is addition / subtraction of
subjects and off course student name will change.
Thanks,
Joseph
On Oct 7, 2014 9:53 AM, "Vaibhav Joshi" wrote:
> Are output for individual Std is diff?
>
> +
> *I did not do this for yo
TD_II", etc until "STD_10". So
If i select "STD_1", it will print "Final_STD_I", or if I select "STD_II"
it will print "Final_STD_II".
Thanks,
Joseph Camill
On Mon, Oct 6, 2014 at 8:26 PM, joseph camill
wrote:
> Excellent Vaibhav,
>
Excellent Vaibhav,
Will have a micro level look at it later.
Thank you.
Joseph
On Mon, Oct 6, 2014 at 8:16 PM, Vaibhav Joshi wrote:
> chk this...
>
> Goto main sheet & press button to run macro!
>
> +
> *I did not do this for you. God is here working through me for y
nable you to select sheet names & adapt
> further changes as mentioned by you!!
>
> Cheers!!
>
>
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Oct 6, 2014 at 5:24 PM, joseph camill
> wrote:
>
>> Hi Vaibhav,
hat other requests?
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Oct 6, 2014 at 1:20 PM, joseph camill
> wrote:
>
>> Hi Vaibhav,
>>
>> Thank you for the clarification. Is there any chance to get the other
>&g
Hi Vaibhav,
Thank you for the clarification. Is there any chance to get the other
request, if possible.
Thanks,
Joseph
On Mon, Oct 6, 2014 at 12:04 PM, Vaibhav Joshi wrote:
> Hi,
>
> You have 2 sheets in this excel workbook,
>
>
> I am creating new sheets after sheet 2 for e
STD and then execute. May be a pop-up that asks for the STD and then
picks that sheet.
NOTE: there will be slight variation in the RAW / Final sheet for various
STD and that would be addition/subtraction of subjects and change in Name.
On Mon, Oct 6, 2014 at 12:15 AM, joseph camill
wrote:
&
Hi Vaibhav,
Can you please explain the last loop in the code "For x = 3 …" part.
On Tue, Sep 30, 2014 at 4:04 PM, Vaibhav Joshi wrote:
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Sep 30, 2014 at 4:4
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*
> -
>
>*From:* joseph camill
Hi Vaibhav,
It is working perfect, as per my requirement. Will email if incase I need
any further updates.
Thank you very much, you made my work easy.
On Mon, Sep 29, 2014 at 11:23 PM, Vaibhav Joshi wrote:
> Cheers
> On Sep 29, 2014 9:58 PM, "joseph camill" wrote:
t; will be generated. If you want report for all employees then keep Column U
> as blank.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Sun, Sep 28, 2014 at 9:02 PM, joseph camill
> wrote:
>
>> Hi Vai
quot; and then generate.
On Sun, Sep 28, 2014 at 8:58 PM, joseph camill
wrote:
> Hi Vaibhav,
>
> Thank you for the file. It is very helpful. It creates various PDF as per
> the Name, Is it possible to have just one pdf with all the mark sheet.
>
> On Sun, Sep 28, 2014 at
Hi Vaibhav,
Thank you for the file. It is very helpful. It creates various PDF as per
the Name, Is it possible to have just one pdf with all the mark sheet.
On Sun, Sep 28, 2014 at 7:06 PM, joseph camill
wrote:
> Hi Vaibhav,
>
> Thank you for the solution. I will check it and get ba
Hi Vaibhav,
Thank you for the solution. I will check it and get back to you.
Thanks and regards,
Joseph
On Sep 27, 2014 3:43 PM, "Vaibhav Joshi" wrote:
> Hey
>
> Chek attachment, just click on blue button & folder name Test will be
> created on desktop & report c
e to print it to PDF / printer without having to create number
of sheets?
Thank you in advance.
Regards,
Joseph
--
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 R
thanks for your attention.
please help me.
On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey wrote:
> can you provide please sample file.
>
> Divaker
>
>
> On Wed, Mar 26, 2014 at 5:51 PM, joseph liech wrote:
>
>> hi everyone
>>
>> i have looked around mos
hi everyone
i have looked around most postings here but none was similar to my
situation.
i need help please, or kindly pls suggest me where i can get help.
everyday i received about 100 customers' addresses. it is in 1 row for each
address, but all the address details are lumped into 1 cell.
Any luck with this one
On Oct 6, 2013 3:16 PM, "joseph camill" wrote:
> Hi Ravi,
>
> Pie chart calculates the percentage by its inbuilt feature and is the
> whole pie is equal to 100%.
>
> I just want the first slice to be exactly in the centre to the right as
Hi Ravi,
Pie chart calculates the percentage by its inbuilt feature and is the whole
pie is equal to 100%.
I just want the first slice to be exactly in the centre to the right as I
had ahown in my original example.
Let me know if you need any further clarification.
Thanks,
Joseph
On Oct 5
Hi,
Attached is the file with two examples.
I am looking for a similar output to be done using vba.
Let me know if you need any further clarification on this.
Thanks,
Joseph
On Wed, Oct 2, 2013 at 12:42 PM, ashish koul wrote:
> please share the chart
>
>
> On Wed, Oct 2, 2013
Can anyone help me with a code
On Sep 24, 2013 9:11 PM, "joseph camill" wrote:
> Thanks for your response. I know to do it manually but my charts gets
> updated very often. So I am looking for an automation.
> On Sep 24, 2013 6:54 PM, "Johnnyboy5" wrote:
>
>
quot;option" the just adjust the angle in
> degrees of the first slice
>
>
>
> regards
>
> John
>
> On Thursday, 19 September 2013 18:46:52 UTC+1, Joseph wrote:
>>
>> Hi,
>>
>> I have a two slice pie chart and the first slice should fac
Hi,
I have a two slice pie chart and the first slice should face to the right
centre horizontally.
Can you provide a macro for this.
Thanks for your help in advance.
Regards,
Joseph
--
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
Concatenate(a1,char(10),b1)
On Aug 7, 2013 9:24 AM, "Pankaj" wrote:
>
>
> I have 2 columns in excel - A and B.
>
> I want to merge the contents of a horizontal row one below the other as:
> A
> B
>
> please tell me a formula to do this as the columns contain 900 cells each
> and I cannnot merge t
Hi,
Could you please guide me with certification of MOS and its reference material
to prepare for the exam.
I live in Mumbai, India.
Thanks in advance,
Joseph
Sent on my BlackBerry® from Vodafone
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT
Did you try offset?
Sent on my BlackBerry® from Vodafone
-Original Message-
From: ferreg...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Wed, 6 Mar 2013 09:53:53
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ I need excel to find a value in the next row's
@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Database sort (copy from one sheet to another
sheet in different order)
Hi Joseph
It is certainly possible. I don't really have the time to do it right now.
I am very busy at work but someone else may be
can I get the same in vba
On Sun, Feb 10, 2013 at 5:18 AM, David Grugeon wrote:
> Hi Joseph
>
> Please find attached a solution. (Sheet - Output)
>
> It uses helper columns and rows which you can hide.
>
> To add another region just copy a complete region block (for ex
Hi David,
Any chance to get the solution.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: joseph.cam...@gmail.com
Date: Sun, 3 Feb 2013 10:12:34
To:
Reply-To: joseph.cam...@gmail.com
Subject: Re: $$Excel-Macros$$ Database sort (copy from one sheet to
going to want to do any arithmetic within the report or is it
just a case of reordering the input for each region?
Regards
David Grugeon
On 3 February 2013 17:01, David Grugeon wrote:
> Hi Joseph
>
> There are a number of possible approaches to this. My preference would be
> not t
: $$Excel-Macros$$ Database sort (copy from one sheet to another
sheet in different order)
Any solution friends.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: joseph camill
Sender: excel-macros@googlegroups.com
Date: Fri, 1 Feb 2013 09:56:08
To: excel-macros@googlegroups.com
Any solution friends.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: joseph camill
Sender: excel-macros@googlegroups.com
Date: Fri, 1 Feb 2013 09:56:08
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Database sort
larger than this one.
Thanks,
Joseph
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
Thanks Prince, will go through this and revert incase of any further queries.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Prince
Date: Thu, 3 Jan 2013 19:40:14
To:
Cc:
Subject: Re: $$Excel-Macros$$ Re: VBA or VSTO
Hi Joseph,
I m sharing this link please go through
Hi Joseph,
I guess both the technology has its own advantages and disadvantge.
*1: Easy to Use*
*
*
VBA is very simple and can be used to developed office application i a
quick time where as VSTO is bit tough but not so.
*2:Compatibility*
*
*
An application written is compatible only with
Hi,
What is the best option now, VBA or VSTO? Also can you give me its
advantages/drawbacks over each other.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread
No job post please.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Manish Kaul
Sender: excel-macros@googlegroups.com
Date: Fri, 28 Dec 2012 22:04:40
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Requirement for Oracle R12 General Ledger / Cost
Managem
The donut chart will help
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Christi Jacob
Sender: excel-macros@googlegroups.com
Date: Fri, 14 Dec 2012 23:05:24
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Pie Charts
i think the "radar" used inn
Hi,
Acer is good only for basic home use, but if you need graphics as well then
Acer is the wrong choice.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Manoj Kumar
Sender: excel-macros@googlegroups.com
Date: Tue, 23 Oct 2012 10:54:14
To:
Reply-To: excel-macros@google
Either Dell or Lenovo
Sent on my BlackBerry® from Vodafone
-Original Message-
From: v...@vabs.in
Sender: excel-macros@googlegroups.com
Date: Sat, 20 Oct 2012 12:30:29
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Good Laptop to Buy..
Hi Emerson
Can you pl
Thanks Noorain
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Thu, 27 Sep 2012 12:21:17
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VSTO *
Dear Joseph,
See attached tutorials
Hi,
Does anyone have any VSTO tutorial.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
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
Hi Muneer, could you please share your understanding for my benefit.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Mohammed Muneer"
Sender: excel-macros@googlegroups.com
Date: Mon, 24 Sep 2012 17:19:12
To:
Reply-To: excel-macros@googlegroups.c
MSOffice 2010. I create charts in excel and paste them in PowerPoint
as picture, the resolution of the chart is very poor. This does not happen when
I use 2007 version.
Please help.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
Join official facebook page of this forum @
https
Hi,
I am using MSOffice 2010. I create charts in excel and paste them in PowerPoint
as picture, the resolution of the chart is very poor. This does not happen when
I use 2007 version.
Please help.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
Join official facebook page of this
Hi Rajan,
Could you please elaborate?
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date: Fri, 17 Aug 2012 22:12:08
To:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macro
Thanks Noorain for your effort. Also, thanks to all the people in the group for
your voluntary help.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "Indrajit $nai"
Sender: excel-macros@googlegroups.com
Date: Sat, 4 Aug 2012 20:48:25
To:
Reply-To: excel-macros@googlegrou
Hi Noorain,
Please help me understand, I may be wrong. I do not see Office 2013 on
Microsoft website.
Is this Open Document?
Thanks,
Joseph
On Tue, Jul 31, 2012 at 9:20 AM, NOORAIN ANSARI wrote:
> Dear Pascal,
>
> Yes Brother, below link is safe, I have download 2013 from here
Hi moderators,
Per rule please ban this user.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: "sherry .."
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 21:24:44
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$
Please try paste special format
Sent on my BlackBerry® from Vodafone
-Original Message-
From: pawel lupinski
Sender: excel-macros@googlegroups.com
Date: Mon, 16 Jul 2012 07:38:57
To: excel-macros@googlegroups.com
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ copy col
You can get this done by changing language regional settings of your PC.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Dileep Kumar
Sender: excel-macros@googlegroups.com
Date: Thu, 12 Jul 2012 19:30:18
To:
Reply-To: excel-macros@googlegroups.com
Cc
Thanks Noorain,
Can you give me a formula to retrieve this.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Thu, 12 Jul 2012 11:47:55
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re
Hi experts,
The formulae provided by the members is working fine when I have data in one
column. But if I have to do the same from multiple columns, then how do I do?
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise
Hi Pankaj,
Its an appreciation given to group members for helping.
Correct me Ayush if I am wrong.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: pankaj gmail account
Sender: excel-macros@googlegroups.com
Date: Thu, 5 Jul 2012 09:37:17
To:
Reply-To
Hi Noorain, Maries and Mahesh,
Please explain in detail how each of your formula works.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Maries
Sender: excel-macros@googlegroups.com
Date: Mon, 4 Jun 2012 03:49:32
To:
Reply-To: excel-macros@googlegroups.com
Hi,
I saw a similar thing on another block, wherein the guy warned in his next mail
not to open the link and said it is a spam and has not been sent by him.
How can we protect our mail from such spam?
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN
Hi everyone,
My name is Joseph. I live in Mumbai, age 34 years. I work as a Presentation
Specialist. I work only on PowerPoint, Excel and Word.
Thanks and regards,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: resp...@gmail.com
Sender: excel-macros
@googlegroups.com
Date: Tue, 5 Jun 2012 20:31:55
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: extract data from table
Hi
You can use below formula also...
=IFERROR(INDEX($B$3:$S$3,MATCH(B$19,$B$1:$S$1,0)),"")
On Tue, Jun 5, 2012 at 7:31 PM, NOORAIN ANSARI wrote:
>
: extract data from table
Hi
You can use below formula also...
=IFERROR(INDEX($B$3:$S$3,MATCH(B$19,$B$1:$S$1,0)),"")
On Tue, Jun 5, 2012 at 7:31 PM, NOORAIN ANSARI wrote:
> Dear Joseph,
>
> Please find attached sheet, Hope it will help to you.
>
> for Column Heading
>
&g
Can you also give me an option if my number of rows change.
On Wed, Jun 6, 2012 at 1:18 AM, joseph camill wrote:
> yes, the number of rows and columns will be the same, but the values in it
> may change.
>
>
> On Wed, Jun 6, 2012 at 1:10 AM, Vish wrote:
>
>> Hi,
>>
yes, the number of rows and columns will be the same, but the values in it
may change.
On Wed, Jun 6, 2012 at 1:10 AM, Vish wrote:
> Hi,
>
> Is your table going to be the same? I mean the number of columns and rows
> going to be same??
>
> On Wednesday, June 6, 2012 12:51:31 A
Hi,
I have a table and need to extract data that is non-zero.
Attached is the sample file for your reference.
Thanks,
Joseph
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Also remember, a bubble chart has third variant, that specifies the bubble size.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: David Grugeon
Sender: excel-macros@googlegroups.com
Date: Tue, 5 Jun 2012 10:46:32
To:
Reply-To: excel-macros@googlegroups.com
Please send it to me at josephcam...@yahoo.com
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 29 May 2012 18:26:24
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros
Hi,
I have concatenated two values.
E.g., cell A1 has 12%, and A24 has 1. I want to concatenate both values in cell
A40 as 12% 1, but 12% should be bold and 1 italics.
Please help.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation
Hi Thomas/Sai,
Please do not post job vacancy in this group.
Moderator: please delete this thread.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: sai girish
Sender: excel-macros@googlegroups.com
Date: Thu, 24 May 2012 01:45:42
Reply-To: excel-macros
Good decision Ayush.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Ayush Jain
Sender: excel-macros@googlegroups.com
Date: Sun, 20 May 2012 07:54:03
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.
Hell
On Wed, May 16, 2012 at 1:08 AM, joseph camill wrote:
> Attached is an example
>
>
> On Wed, May 16, 2012 at 12:48 AM, wrote:
>
>> Hi,
>>
>> Is it possible to concatenate two values in one cell and seperate the
>> first value to top left and second
e clearly seperate from
> each other.
>
> Thanks,
> Joseph
> Sent on my BlackBerry® from Vodafone
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Fo
Hi,
Is it possible to concatenate two values in one cell and seperate the first
value to top left and second value to bottom right of the same cell.
For e.g. £25m and €12m both in cell a1. And both are clearly seperate from each
other.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
lot of time formatting the
overlapped numbers.
I need a macro that will move numbers that overlap other numbers in a stacked
chart.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread
Hi,
I create a lot of stacked charts and I spend a lot of time formatting the
overlapped numbers.
I need a macro that will move numbers that overlap other numbers in a stacked
chart.
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
--
FORUM RULES (986+ members already BANNED for
My 2 cents
What I understand is row 8 has data today price minus previous day price.
So in row 7 you can give:
=if(d7<1,"down","up")
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Filip Houdek
Sender: excel-macros@googlegroups.com
Date: Mon, 30 Apr 2012 20:26:18
To:
Rep
Can you attach an example.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Filip Houdek
Sender: excel-macros@googlegroups.com
Date: Sun, 29 Apr 2012 21:58:39
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Find column # of first value greater than sp
Thanks everyone.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Kris
Sender: excel-macros@googlegroups.com
Date: Sun, 8 Apr 2012 06:34:59
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Order by Rank
The formula should be
=RANK(A2,$A$2:$A$9)+CO
cel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Order by Rank
Hi,
I want to reorder products by rank in a particular order. It works fine when
the rank is unique. But when there are two products of same rank then it
does not. Please help.
I reorder using index formula.
Thanks in advance,
Jose
1 - 100 of 122 matches
Mail list logo
