Dear Sam,
Thanks for reply
I want to substract from Column c To column B i e B-C,Forget about #N/A
Regards
Shrinivas
On Sun, Dec 1, 2013 at 10:11 PM, Sam Mathai Chacko wrote:
> Srini, are you looking to subtract dates in column C from column B or vice
> versa, ie, B-C or C-B? In addition, som
Oh ya... It is working SAM and ashish... Thanks to you both buddy... :)
On Sun, Dec 1, 2013 at 10:06 PM, Sam Mathai Chacko wrote:
> As Ashish mentioned, you need to correct the dates on the top row.
>
> Regards,
> Sam Mathai Chacko
>
>
> On Sun, Dec 1, 2013 at 8:58 PM, manish mishra wrote:
>
>>
Srini, are you looking to subtract dates in column C from column B or vice
versa, ie, B-C or C-B? In addition, some values are coming as #N/A. What to
do with those?
Regards,
Sam Mathai Chacko
On Sun, Dec 1, 2013 at 3:57 PM, Shrinivas Shevde wrote:
> Dear all
> I want to subtract one date from
By reverse, do you mean to reverse the position of the values, irrespective
of whether larger or smaller, or do you want to sort in the opposite
direction? If sort, why don't you just use Sort method?
If you want to simply reverse the values using formula, use
=INDEX($*A$1*:$A$4,ROWS($*A1*:$A$4))
Will be really thankful if you can attach the sheet as well.., along the
formatting to be done ?/
On Sun, Dec 1, 2013 at 8:50 PM, ashish koul wrote:
>
> =INDEX(Sheet2!$B$1:$CC$80,MATCH(Sheet1!$A2,Sheet2!$A:$A,0),MATCH(Sheet1!B$1,Sheet2!$B$1:$CC$1,0))
>
> change dates in top row
>
> On Sun, Dec
1 4
2 3
3 2
4 1
On Sun, Dec 1, 2013 at 8:34 PM, ashish koul wrote:
> can u share sample file ?
>
> On Sun, Dec 1, 2013 at 7:54 PM, Nishant Sharma > wrote:
>
>> how to do this using formula...
>>
>>
>> On Sat, Nov 30, 2013 at 11:30 PM, ashish koul wrote:
>>
>>> no ...
>>>
>>>
>>> On Sat, Nov 30
=INDEX(Sheet2!$B$1:$CC$80,MATCH(Sheet1!$A2,Sheet2!$A:$A,0),MATCH(Sheet1!B$1,Sheet2!$B$1:$CC$1,0))
change dates in top row
On Sun, Dec 1, 2013 at 8:48 PM, manish mishra wrote:
> When i am dragging it towards right why is it copying all ??
>
>
>
> On Sun, Dec 1, 2013 at 8:46 PM, manish mishra wro
When i am dragging it towards right why is it copying all ??
On Sun, Dec 1, 2013 at 8:46 PM, manish mishra wrote:
> can it be done with index match ??
>
>
>
> On Sun, Dec 1, 2013 at 8:37 PM, ashish koul wrote:
>
>> try this
>> =VLOOKUP($A2,Sheet2!$A$1:$CC$80,MATCH(Sheet1!B$1,Sheet2!$1:$1,0),0
can it be done with index match ??
On Sun, Dec 1, 2013 at 8:37 PM, ashish koul wrote:
> try this
> =VLOOKUP($A2,Sheet2!$A$1:$CC$80,MATCH(Sheet1!B$1,Sheet2!$1:$1,0),0)
>
> On Sun, Dec 1, 2013 at 7:52 PM, manish mishra wrote:
>
>> Whats Wrong with the applied formulae in the sheet attached ??
>>
try this
=VLOOKUP($A2,Sheet2!$A$1:$CC$80,MATCH(Sheet1!B$1,Sheet2!$1:$1,0),0)
On Sun, Dec 1, 2013 at 7:52 PM, manish mishra wrote:
> Whats Wrong with the applied formulae in the sheet attached ??
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,DO:IT,N:O
can u share sample file ?
On Sun, Dec 1, 2013 at 7:54 PM, Nishant Sharma
wrote:
> how to do this using formula...
>
>
> On Sat, Nov 30, 2013 at 11:30 PM, ashish koul wrote:
>
>> no ...
>>
>>
>> On Sat, Nov 30, 2013 at 6:01 PM, Nishant Sharma <
>> sharma.nishan...@gmail.com> wrote:
>>
>>> Hi,
>>>
how to do this using formula...
On Sat, Nov 30, 2013 at 11:30 PM, ashish koul wrote:
> no ...
>
>
> On Sat, Nov 30, 2013 at 6:01 PM, Nishant Sharma <
> sharma.nishan...@gmail.com> wrote:
>
>> Hi,
>>
>> Please help me in reversing numbers in excel.
>>
>> I did thru macro but cant undo it, can w
Dear all
I want to subtract one date from another (file attached )
Can anyone help me
I think for the date format is not same
Regards
Shrini
--
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://ww
13 matches
Mail list logo
