yes, you can play with operators (+,-,/,*) with predefined fields to create
new one of your choice.
On Wed, Oct 30, 2013 at 11:15 AM, Sandeep Kumar Chhajer <
chhajersand...@gmail.com> wrote:
> **
> Thanks Anup for your response.
> One more thing I want to ask is there any way I can use two colum
Hi Sandeep,
Anoop's earlier suggestion will help you in this also. There is two options
in Options>formula>Calculated Field & Calculated Item by using these two
options you can create your own formula in pivot table and resulting field
will also be a part of pivot table.
On Wed, Oct 30, 2013 at
Dear excel experts,
Pls tell me how to use vlookup in backward series.
Means data match with last colmn to first colmn.
On Oct 29, 2013 11:32 PM, wrote:
> Today's Topic Summary
>
> Group: http://groups.google.com/group/excel-macros/topics
>
>- data cleansing <#142068f3d9b7fee1_group_thread_
Thanks Anup for your response.
One more thing I want to ask is there any way I can use two column of Pivot
table for any type of calculation (i.e. the calculation also become part of.
Pivot table.)
Suppose, with a data set I have derived with two column in a Pivot table, say
one is sum and othe
What Error are you getting? Can you share your file in which you use your
recorded macro.
On Sun, Oct 27, 2013 at 9:48 AM, ashish koul wrote:
> try this way
> http://mariaevert.dk/vba/?p=6
>
>
>
>
> On Sun, Oct 27, 2013 at 8:26 AM, Howard Rambin wrote:
>
>> I am new to macros in Excel (wiz at l
Sandeep please insert required formula using pivot table formula.
for this go to Options>formula>Calculated Field.
Options Ribbon will populate once you select the pivot field and Calculated
field will enable when you select any column field in pivot.
On Wed, Oct 30, 2013 at 8:07 AM, Sandee
Dear all,
I want to copy from my excel sheet and paste it to other application i
wrote the code but not working please correct it
Sub Button1_Click()
Shell "C:\Program Files\Microsoft Dynamics NAV\60\Classic\finsql.exe",
vbMaximizedFocus
SendKeys "%{TAB}"
Range("B3").Copy
SendKeys "%{TAB}"
Appl
Hi, Excel gurus,
I want to get a column in a pivot table which is comprising of division of two
data-source column.
Thanks & Regards,
Sandeep Kumar Chhajer
Mumbai
India
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
You can use =trim() formula to remove the blanks in end of the word or
starting of the word.
On 30-Oct-2013 4:37 AM, "Pehrson, Dave" wrote:
> I have a situation where I down load data and delineate results leaving
> a name with blanks behind the number making a Vlookup difficult.
>
> ** **
>
I have a situation where I down load data and delineate results leaving a name
with blanks behind the number making a Vlookup difficult.
ASIAN HONDA MOTOR CO.,LTD.
The name above is an example. Is there a formula I can use to remove any
blanks behind the last character?
Your help as always is
place "Return type" in column Labels
.
Enjoy
Team XLS
On Tue, Oct 29, 2013 at 1:38 PM, Pravin Gunjal wrote:
> *Hello,*
> *
> *
> *I have created a pivot table for attached file as per column F, I & M
> from Data Sheet. *
> *
> *
> *I want the total of return types “E
11 matches
Mail list logo
