Ok Rajan,
Thanks a lot,
I am already using the calculated field currently. Just after posting this
question.
Thanks again for your quick reply and help.
Thanks & Regards,
*BS*
On Wed, Jun 7, 2017 at 10:51 AM, Rajan Verma
wrote:
> no, you need to add a calculated field to do so.
>
> Rajan
>
>
no, you need to add a calculated field to do so.
Rajan
On Wed, 7 Jun 2017 at 10:40 AM, B Sharma wrote:
> Dear Friends,
> I have a database in which the transactions (both buy & sales) of shares
> trading has been entered.
>
> I have another sheet in which I need results using Pivot table.
>
> B
Dear Friends,
I have a database in which the transactions (both buy & sales) of shares
trading has been entered.
I have another sheet in which I need results using Pivot table.
But it calculates the sum of both buy & sales, but I need the subtract of
Buy with sales and show the balance results.
OH THAT'S REALLY GREAT, WHAT A ANSWER THANK YOU VERY MUCH SIR
regarding solver I have another one could you please look at it.
--
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
There are several ways to name a range.Using a version similar to Excel 2010:
First: When you select a single Cell, there is a box in the menu/icon area
that shows the cell address:(to the left of the box that shows the cell
contents)Like: A2
highlight the range (say: A2 through A101)then, in t
Sorry, I already found the solution (source:
https://msdn.microsoft.com/en-us/library/office/ff823060.aspx):
*Create a WorkSHEET Specific named range*
1.
Select the range you want to name.
2.
Click on the "Formulas" tab on the Excel Ribbon at the top of the window.
3.
Thank you for your solution.
How can I name the range: "...in a column and name the range "Input""?
Op dinsdag 6 juni 2017 18:25:43 UTC+2 schreef Paul Schreiner:
>
> You're saying that F77 is a calculation that uses the value of F5.
> You want to change F5 from 1 to 100
> and do WHAT with the res
You're saying that F77 is a calculation that uses the value of F5.You want to
change F5 from 1 to 100 and do WHAT with the resulting value in F77?
Are you saying that you want to simply put 1-100 in one column and then show in
an adjacent column the result when this number is put into F5?
Is the
I need a macro for a simple question:
In my Excel sheet I have a value in cell F5 which gives a result in cell
F77.
Now I want to calculate each value in F5 (from 1 to 100) to the associated
value in cell F77 in two new columns: value F5=1->value F77=..., value
F5=2->value F77=... (etc.)
Is th
Dear all friends
I Required break chart in excel.between data if there are blank cell then
chart show break.
Actually in blank cell there are formula(yellow cell) which show blank cell
(If +is error+blank formula).
Finally I need prepare Break chart on yellow cell data range ,Can We do
this?
R
Hi Guys,
I'd like to know if there is any possibility with functions to fill my
Summary sheet from montly report sheet in the attached sample. or I need to
create a macro?
By selecting Customer and month (Blue cells) filling the indicator .
If I have to code a macro, can somone help me ?
Than
11 matches
Mail list logo
