Thanks Ashish, Its nice, please explain how this formula is working
On Thu, Feb 17, 2011 at 5:29 AM, ashish koul wrote:
>
>
> IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Doubt
IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C:C,A:A,A4,B:B,"Substandard"))=SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),"Doubtful",IF(MAX(SUMIFS(C:C,A:A,A4,B:B,"Doubtful"),SUMIFS(C:C,A:A,A4,B:B,"Regular"),SUMIFS(C:C,A:A,A4,B:B,"Loss"),SUMIFS(C
Maximum 4 classifications
1) Regular
2) Substandard
3) Doubtful
4) Loss
On Tue, Feb 15, 2011 at 8:34 PM, ashish koul wrote:
> will it be these three classifications only
>
>
> On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad
> wrote:
>
>> Thanks *Ashish *for reply but can you please provide formu
will it be these three classifications only
On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad wrote:
> Thanks *Ashish *for reply but can you please provide formula without
> pivot. Condition you have understand that if sum of any classification is
> grater then others,it shows that value.
>
>
>
> On
Thanks *Ashish *for reply but can you please provide formula without pivot.
Condition you have understand that if sum of any classification is grater
then others,it shows that value.
On Tue, Feb 15, 2011 at 8:14 AM, ashish koul wrote:
>
>
> On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad
> wr
On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad wrote:
>
> Hi all experts,
>
> Please resolve my query by formula. sheet attached.
>
> Regards,
>
> Aamir Shahzad
>
> --
>
> --
> Some important links for excel users:
>
Hi Thamu,
I don't know what is the need for the comparison of 2003 & 2007 excel column
versions since the query is not very much related to the 2003 column issue.
I agree that the column will be the issue in Excel 2003 when the repetition
of UNIQUE IDNO goes beyond 127 times then we could not abl
hi tamu
thnks for quick reply
i need only bill no. and amount in single row.
for every unique id new row is needed.
max 50 bill no. are their in respect to a single unique id. i hope now
i m clear .
On Thu, Jan 27, 2011 at 4:59 PM, TG T wrote:
> Dear Ankur Pandey
>
> You cannot able to keep
Dear Ankur Pandey
You cannot able to keep it in a single row If you have large amount of data.
Because Excel 2003 has only 256 columns and excel 2007 has only 16384
columns.
Thanks & Regards
Thamu
On Thu, Jan 27, 2011 at 2:55 PM, ankur wrote:
> hi excel experts
> i need one help
> i need da
thank you
On Wed, Jan 19, 2011 at 9:55 AM, Dave Bonallack
wrote:
> Hi Aamir,
> Have a look at the attached.
> Regards - Dave.
>
> --
> Date: Tue, 18 Jan 2011 23:28:27 +0500
> Subject: Re: $$Excel-Macros$$ Query
>
> From: aamirshahza...@g
Hi Aamir,
Have a look at the attached.
Regards - Dave.
Date: Tue, 18 Jan 2011 23:28:27 +0500
Subject: Re: $$Excel-Macros$$ Query
From: aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Thanks for reply, now attached sheet is very clear.
Aamir Shahzad
On Tue, Jan 18, 2011 at 10
Thanks for reply, now attached sheet is very clear.
Aamir Shahzad
On Tue, Jan 18, 2011 at 10:10 AM, ashish koul wrote:
> check the attachment see if it helps you
>
>
> On Tue, Jan 18, 2011 at 10:36 AM, Dave Bonallack <
> davebonall...@hotmail.com> wrote:
>
>> Sorry Aamir, Can't understand the
Dear Amir,
Pl provide more clarity wid complete example.
http://www.signaturebar.com/>http://www.signaturebar.com/uploads/images/24667.png border=0>
On Tue, Jan 18, 2011 at 12:01 AM, Aamir Shahzad wrote:
> Dear experts,
>
>
>
> How to resolved attached query, can anybody tell formula not macro
check the attachment see if it helps you
On Tue, Jan 18, 2011 at 10:36 AM, Dave Bonallack
wrote:
> Sorry Aamir, Can't understand the question. If your worksheet had a cell
> with the desired answer in it (entered manually) this may help me understand
> your request.
> Regards - Dave.
>
> ---
Sorry Aamir, Can't understand the question. If your worksheet had a cell with
the desired answer in it (entered manually) this may help me understand your
request.
Regards - Dave.
From: aamirshahza...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query
Date: Mon, 17 J
Dear Nikhil,
Please find the attached file.
There is duplicate name if name is Unique ??
On Thu, Dec 2, 2010 at 5:20 PM, Daniel wrote:
> Is it possible that the names list were sorted ?
>
> Then you may use :
>
> =OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3))
>
> as the
Dear Daniel
Thanks for FormulaYou have solve my problem..
Regards
Nikhil Shah
On Thu, Dec 2, 2010 at 5:20 PM, Daniel wrote:
> Is it possible that the names list were sorted ?
>
> Then you may use :
>
> =OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3))
>
> as the source dat
On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah wrote:
> Dear All Members,
>
> Here I am postin excel sheet..
>
> *I used vlookup formula plz see attchmt
> *
>
> --
>
> --
> Some important links for excel users:
> 1. Fol
Hi Nikhil,
Please find attached solved sheet.
Thanks & Regards
Mukesh
On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah wrote:
> Dear All Members,
>
> Here I am postin excel sheet..
>
> *Problem :
> *
> *when I select the "NAME" I want the "POLICY NOS." of that perticular
> "NAME" only in the Dr
Is it possible that the names list were sorted ?
Then you may use :
=OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3))
as the source data.
Best regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de Nikhil Shah
Envoyé : jeudi
Dear Ansari,
After filtering the data,select the filtered data and then press
Alt+;(Select Visible cells Only) the you can paste only the filtered data
any were you want.
Regards,
Vijaykumar
--
--
Some important l
Hi Noorain,
Use filter then ctrl+ shift + * (*above alphabet U and I)
other alternative is Advance Filter.
Thanks,
Saber
On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI wrote:
> Dear Experts,
>
> Please solve my problem. How can we copy only filtered data in Excel.
>
> --
> Thanks in advance..
Xls 2003
Select Data
Copy Data
Past Data
Past Only Filter Data
On Fri, Oct 15, 2010 at 2:04 PM, NOORAIN ANSARI wrote:
> Dear Experts,
>
> Please solve my problem. How can we copy only filtered data in Excel.
>
> --
> Thanks in advance..
> Noorain Ansari
>
> --
>
> ---
Hi,
Please use Data Validation Select the Date option from Allow dropdown
and mention the start and end date in that.
If you are not satisfied with the above please send a sample data and
the group members will reply..
Thanks
Vinod N
On Sat, Jul 10, 2010 at 2:59 PM, Nikhil Shah wrote:
Hi
You can use the below formulae for calculation as required:
=EDATE("31-mar-2011","-6")
Regards
Rajender Soni
On Jul 7, 5:21 pm, Avinash Daga wrote:
> Assuming your current date is in a1 cell
>
> =date(year(a1),month(a1)-6,day(a1))
>
> Please let me know,if this works
>
>
>
>
>
> On Wed,
Assuming your current date is in a1 cell
=date(year(a1),month(a1)-6,day(a1))
Please let me know,if this works
On Wed, Jul 7, 2010 at 4:06 AM, Nikhil Shah wrote:
> Hi Friends,
>
> Here I am sending One Query, pl Give the formula..
>
> Date : 31/03/2011 ( Format is dd/mm/ )
> Deduct : 6 (
You are welcome Nikhil..!!
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Wed, Jul 7, 2010 at 6:17 PM, Nikhil Shah wrote:
> Hi Dilip
>
> Thanks for sending me formula..I have apply this
Hi,
If original date is in A1:
=EOMONTH(A1,-6)
Regards - Dave.
Date: Wed, 7 Jul 2010 16:36:18 +0530
Subject: $$Excel-Macros$$ Query - How To Find out Month
From: nikhil201...@gmail.com
To: excel-macros@googlegroups.com
Hi Friends,
Here I am sending One Query, pl Give the formula..
Date : 31/0
Hi Nikhil,
Try below formula:-
=DATE(YEAR(C3),MONTH(C3)-6,DAY(C3))
Note:- Day portion of Date may vary as per the exact calculation, please
revert if you need 31 or 30 as the date every time.
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmai
Your question makes absolutely no sense.
On Mon, Nov 16, 2009 at 8:26 AM, big smile wrote:
> Respected Excel Friends,
>
> Attached please find the excel sheet -- in which i have explained my query.
>
> Try to resolve it
>
> Thanks
>
> J C SHAH
>
> --
>
> -
201 - 230 of 230 matches
Mail list logo