HI,
May be It Can help You.
=SUMIF(D2:AB2,AC2,D3:AB3)
regards
Prince
On Wednesday, February 27, 2013 5:27:38 PM UTC+5:30, Deepak Rawat wrote:
>
> Hi,
>
> need formula for sum in attach
>
> Regards,
> Deepak
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(
Hi On which column you want sum ?
Regards
Prince
On Wednesday, February 27, 2013 5:27:38 PM UTC+5:30, Deepak Rawat wrote:
>
> Hi,
>
> need formula for sum in attach
>
> Regards,
> Deepak
>
--
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
Hi Midhun,
Environ("username")
used in VBA to find username of the system.
Regards
Prince
On Monday, January 21, 2013 12:13:51 PM UTC+5:30, midhun wrote:
>
> hi friends;
>
> i need a formula that will tell me about which user has logged in the
> particular file
>
>
> --
> Midhun Thampan.
hello suyog,
please try this
:-
=+IF((B2+12)>B4,(B7+B10),IF((B2+12)B4:B5,((B5-B2+12)*(B8/12)
On Friday, January 11, 2013 3:18:13 PM UTC+5:30, Suyog Kulkarni wrote:
>
> Hello All,
>
> Please see attached excel, I'm confused how can I set IF statement based
> on varying 3 condition for one c
Thanks Ton. Its working fine.
Can you also send me materials on macros. i want to learn from the basic.
Rgds,
Prabhakar
On Tuesday, January 15, 2013 3:07:53 PM UTC+5:30, अनिल नारायण गवली wrote:
> pl find attached herewith.
>
>
> Warm Regards,
> Anil Gawli
>
> On Tue, Jan 15, 2013 at 1:07 PM
pl find attached herewith.
Warm Regards,
Anil Gawli
On Tue, Jan 15, 2013 at 1:07 PM, Prince wrote:
> Hi Prabhakar,
>
> paste the following formula.
>
> =SUMIFS(C2:C10,A2:A10,"Fax",B2:B10,"Brown")
>
> Regards
> Prince
>
>
> On Tuesday, January 15, 2013 12:40:13 PM UTC+5:30, Prabhakar S H wrote:
Hi Prabhakar,
paste the following formula.
=SUMIFS(C2:C10,A2:A10,"Fax",B2:B10,"Brown")
Regards
Prince
On Tuesday, January 15, 2013 12:40:13 PM UTC+5:30, Prabhakar S H wrote:
>
> Dear Team,
>
> I need to get formula for attached file. Pls help.
>
> Rgds,
> Prabhakar
>
--
Join official Fac
Sam,
You understood my problem correctly. I think rather using IF, I think we
should try for scenario. I don't know much about this.
My conditions are as follows.
1) PL are applicable after 1yr service.
2) Whoever already completed 1yr he/she will get full PL
3) If somebody finishing his 12month
Suyog,
It seems that multiple conditions can be met based on certain dates. Can
you double check the variables? The conditions must be independent of each
other for a multiple IF statement to be valid.
On Sunday, January 13, 2013 1:17:56 AM UTC-5, Suyog Kulkarni wrote:
>
> Hello All,
>
> Reque
Hi Friend,
Instead of adding all cells just Paste below formula in AE5 and Drag the
same upto AE25 .
Formula Is : =SUMPRODUCT(($C$4:$AD$4),($C5:$AD5))
Regards
Prince
On Monday, December 10, 2012 12:31:47 PM UTC+5:30, excel lerner wrote:
>
> Sir
>
> Please see the sample and help me.In this fi
below formula also can use with C+S+E
=IF(MAX(IF($B$2:$B$17=B2,$A$2:$A$17)) wrote:
> Thanks
>
>
> On Thu, Oct 18, 2012 at 1:05 PM, Vabz wrote:
>
>> Hi
>>
>> PFA..
>> Cheers..
>> Rgds//Vabs
>> On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
>>
>>>
>>>
>>> -- Forwar
Thanks
On Thu, Oct 18, 2012 at 1:05 PM, Vabz wrote:
> Hi
>
> PFA..
> Cheers..
> Rgds//Vabs
> On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
>
>>
>>
>> -- Forwarded message --
>> From: Manoj Kumar
>> Date: Thu, Oct 18, 2012 at 12:29 PM
>> Subject: Need fo
Hi
PFA..
Cheers..
Rgds//Vabs
On Thursday, October 18, 2012 12:32:21 PM UTC+5:30, Manoj Kumar wrote:
>
>
> -- Forwarded message --
> From: Manoj Kumar >
> Date: Thu, Oct 18, 2012 at 12:29 PM
> Subject: Need formula to update status
> To: excelvb...@googlegroups.com
>
>
> Dear Exp
hi
PFA
Cheers..
Rgds//Vabs
On Tuesday, September 25, 2012 3:16:49 PM UTC+5:30, rajeyssh wrote:
>
> Hello everyone
> I need simple average and minimum formula in the column but excluding the
> value if 0.
> thanks
>
--
Join official facebook page of this forum @
https://www.facebook.com/disc
hi Prashant,
Use this
=INDEX(A2:A4,MATCH(TRUE,LEN(A2:A4)<>0,0),1) with Ctrl+shift+enter
regards
prince dubey
On Thursday, 12 July 2012 16:50:22 UTC+5:30, ppawle.excel wrote:
>
> Dear All,
>
> Need a formula for getting first text in the Range, in particular cell ,
> sample file attached
>
> R
One way may be to manually copy the data from the three columns, one
at a time, into a single column. In the column next to the Product #
column, write a formula to isolate the number:
=VALUE(MID(A2,FIND(" ",A2,1)+1,LEN(A2)-9))
where column A contains the list and 9 is the length of the word
"Produ
Hi I don't know your valid criteria, But you can compare values from
below given formula
=IF(AND(B2=B3,A2=A3),"Valid","invalid")
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
1) I have slightly confutationon increment column u need max value
or latest value
2) how to upload Xl file here
On May 26, 6:53 pm, Ahmedhonest wrote:
> Dear Team,
>
> Please help out to frame a Formula for the attach, I need it using the
> Worksheet Functions,
>
> Any help or valua
18 matches
Mail list logo