On Sat, 2/3/18, Rabindra Thapa wrote:
Subject: Re: $$Excel-Macros$$ Need formula for 2 criterias
To: excel-macros@googlegroups.com
Date: Saturday, February 3, 2018, 2:31 PM
Regards,
For quick
responds click here for Message
On
*Regards,*
*For quick responds click here for Message *
On Sat, Feb 3, 2018 at 2:13 PM, Kenil Gala wrote:
> Hi
> Pls Find the file attached.
>
> I have written my Query in the excel sheet.
>
> Please help me find the solution for this query
>
> Thanks
> Kenil
>
> --
> Are you =EXP(E:RT) or =N
Hi
Pls Find the file attached.
I have written my Query in the excel sheet.
Please help me find the solution for this query
Thanks
Kenil
--
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.f
Dear Excel Gurus,
Please find the atttached file
and give your valuable suggestions and fedback.
With Regards
*HARISH P Y*
*P* *THINK BEFORE YOU PRINT:**Before printing this e-mail think whether it
is really necessary. Thanks for your support to protect our environment for
the future generatio
>> Please explain a bit more what exactly do you need.
>>>
>>> On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal
>>> wrote:
>>>
>>>> Hi,
>>>>
>>>> Anybody help me !
>>>>
>>>>
>>>>
>>>>
gt;>
>>>
>>>
>>> -- Forwarded message --
>>> From: Shaikh Iqbal
>>> Date: 23 May 2016 at 19:55
>>> Subject: $$Excel-Macros$$ Need - Formula weekly bonus
>>> To: excel-macros@googlegroups.com
>>>
>>>
; Hi,
>>
>> Anybody help me !
>>
>>
>>
>> -- Forwarded message --
>> From: Shaikh Iqbal
>> Date: 23 May 2016 at 19:55
>> Subject: $$Excel-Macros$$ Need - Formula weekly bonus
>> To: excel-macros@googlegroups.com
>>
>>
>> Dear Exp
Please explain a bit more what exactly do you need.
On Tue, May 24, 2016 at 12:09 PM, Shaikh Iqbal
wrote:
> Hi,
>
> Anybody help me !
>
>
>
> -- Forwarded message --
> From: Shaikh Iqbal
> Date: 23 May 2016 at 19:55
> Subject: $$Excel-Macros$$ Ne
Hi,
Anybody help me !
-- Forwarded message --
From: Shaikh Iqbal
Date: 23 May 2016 at 19:55
Subject: $$Excel-Macros$$ Need - Formula weekly bonus
To: excel-macros@googlegroups.com
Dear Export,
Please find attached daily tracking file. I need the a formula in Column Q
as
Dear Export,
Please find attached daily tracking file. I need the a formula in Column Q
as per criteria.
Iqbal Shaikh
--
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/
[mailto:
> excel-macros@googlegroups.com] *On Behalf Of *SUDHIR VERMA
> *Sent:* Thursday, August 27, 2015 5:19 PM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING
>
>
>
> Dear Friends,
>
> Please help me as per attached
Haroon
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of SUDHIR VERMA
Sent: Thursday, August 27, 2015 5:19 PM
To: excel-macros
Subject: $$Excel-Macros$$ NEED FORMULA FOR TEXT TO NUMBER CONVERTING
Dear Friends,
Please help me as per attached sheet. I
select that column -Text to Column ( in Data Tab) -Click Finish
Regards,
Prafull Jadhav
9920553518
On 27 August 2015 at 18:49, SUDHIR VERMA wrote:
> Dear Friends,
> Please help me as per attached sheet. I have data of 25k row. there are
> some code formatting as text. So you are request to
Dear Friends,
Please help me as per attached sheet. I have data of 25k row. there are
some code formatting as text. So you are request to please share formula
for this.
Here, example is attached.
Thanking You
Regards
Sudhir
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna b
Hi
you can do using combination of Index & Match function.
Thanks
On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote:
> Hi,
>
> is there any solution in someproduct formula to get intersect text value
> in 2D range:
>
> Below is the data;
>
>Bran Model - 1 Model - 2 Model - 3 Model - 4 A
i think you want
=VLOOKUP(B7,$A$1:$E$4,MATCH(C7,$A$1:$E$1,0))
On Tue, Mar 25, 2014 at 5:42 PM, Deepak Rawat wrote:
> Hi,
>
> is there any solution in someproduct formula to get intersect text value
> in 2D range:
>
> Below is the data;
>
>Bran Model - 1 Model - 2 Model - 3 Model - 4 Audi
Hi,
is there any solution in someproduct formula to get intersect text value in
2D range:
Below is the data;
Bran Model - 1 Model - 2 Model - 3 Model - 4 Audi A4 A6 A8 A10 BMW Series
3 Series 5 Series 7 X6 Mercedes A Class C Class E Class S Class Brand
Model Answer BMW Model - 2 Ser
Thanks J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kartik Dale
Sent: Tuesday, December 24, 2013 12:56 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ NEED FORMULA HELP
Hi Dhaval,
Please find attachment
Regards
YES
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Shaikh Iqbal
Sent: Friday, December 13, 2013 4:38 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need - formula help
Ravinder,
is it correct
=IF(B2="Platinum&qu
quot;Gold",INT(C2/12000),IF(B2="Silver",INT(C2/6000
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shaikh Iqbal
> *Sent:* Friday, December 13, 2013 4:07 PM
> *To:* excel-macros@googlegroups.com
> *Subje
C2/6000
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Shaikh Iqbal
> *Sent:* Friday, December 13, 2013 4:07 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Need - formula help
>
>
>
> D
2013 4:07 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need - formula help
Dear Exports,
Need your help for if condition. Pls find attached file.
Rgds,
Iqbal
--
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
Dear Exports,
Need your help for if condition. Pls find attached file.
Rgds,
Iqbal
--
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/discussexcel
FORUM RULES
1) Use
Thanks a lot Ravinder J
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ravinder
Sent: Thursday, November 28, 2013 5:48 PM
To: excel-macros@googlegroups.com
Cc: Soum
Subject: RE: $$Excel-Macros$$ Need formula help
=DAY(B2)
From: excel-macros
=DAY(B2)
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dhaval Shah ( Ahd )
Sent: Thursday, November 28, 2013 5:44 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need formula help
Want to choss Day only from date pls refer
Want to choss Day only from date pls refer attachment
Thanks
Dhaval Shah
--
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/discussexcel
FORUM RULES
1) Use
try
d3 = =LEFT(B3,3)
e3 = =LEFT(RIGHT(B3,LEN(B3)-FIND(",",B3)-1),3)
see if it helps
On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky wrote:
> Hi Experts,
>
> Please find the attached file, please revert with appropriate formula for
> my requirement
>
> Thanks & Regards,
> Prabhu R
>
> --
>
Dear Prabhu,
Pl see the attached sheet.
Warm Regards,
Gawli Anil
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
On Tue, Sep 17, 2013 at 10:22 AM, Prabhu Pinky wrote:
> Hi Experts,
>
> Please find the attached file, please revert with appropriate form
Hi Experts,
Please find the attached file, please revert with appropriate formula for
my requirement
Thanks & Regards,
Prabhu R
--
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.c
Hi
pfa
From: raghunandan rallapalli
To: excel-macros@googlegroups.com
Sent: Tuesday, 11 December 2012 5:59 PM
Subject: $$Excel-Macros$$ need formula please
sir,
I need a formula for total sum of each account no wise as given in excel sheet.
Thanks in
Hi Prabhakar
find the solution as per your requirement
On Fri, Jul 5, 2013 at 12:32 PM, Prafull Jadhav wrote:
> Dear Prabhakar,
>
> find the same ...It is alternate use...
> Our expert can give you better solution on it.
>
> Regards,
> Prafull Jadhav.
> MIS-executive.
>
>
>
> On Fri, Jul 5, 2013
Dear Prabhakar,
find the same ...It is alternate use...
Our expert can give you better solution on it.
Regards,
Prafull Jadhav.
MIS-executive.
On Fri, Jul 5, 2013 at 11:27 AM, Prabhakar S H wrote:
> Hi Team,
>
> I need your help to get details with formula in attached file.
>
> Rgds,
> Prabha
Hi Team,
I need your help to get details with formula in attached file.
Rgds,
Prabhakar
--
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/discussexcel
FORUM RULES
1) Use c
Use this formula with Ctrl+Shift+enter
=SUM(IF($D$2:$AB$2=AC$2,$D$3:$AB$3))
On Thu, Feb 28, 2013 at 10:25 AM, Anoop K Sharma wrote:
> Use attached one. This'll take care of text values also.
>
>
> On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote:
>
>> But if some in some place text exists t
Use attached one. This'll take care of text values also.
On Thu, Feb 28, 2013 at 10:41 AM, Deepak Rawat wrote:
> But if some in some place text exists then what to do
>
> Regards,
> Deepak
>
>
> On Wed, Feb 27, 2013 at 8:47 PM, Maries wrote:
>
>> Hi,
>>
>> Try it,
>>
>> =SUMIF($D$2:$AB$2,AC2,D$
Hi,
Try it,
=SUMIF($D$2:$AB$2,AC2,D$3:AB$3)
On Wed, Feb 27, 2013 at 6:26 PM, Deepak Rawat wrote:
> Sorry attached wrong one
> now attached the correct one.
>
> Regards,
> Deepak
>
>
> On Wed, Feb 27, 2013 at 5:41 PM, David Grugeon wrote:
>
>> We need more information. What do you want the sum
We need more information. What do you want the sum of? There does not
seem to be anything in the worksheet provided that you could possibly want
to add up.
On Wednesday, 27 February 2013, Deepak Rawat wrote:
> Hi,
>
> need formula for sum in attach
>
> Regards,
> Deepak
>
> --
> Are you =EXP(E:
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 official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor th
This might help -
http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
On Tue, Feb 19, 2013 at 1:16 PM, Rakesh Kumar Sharma wrote:
> Dear Abhishek,
>
> Working fine
>
> Will yo please explain this how it works?
>
>
>
>
> On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain wrote:
>
>> Check at
Dear Abhishek,
Working fine
Will yo please explain this how it works?
On Tue, Feb 19, 2013 at 12:55 PM, Abhishek Jain wrote:
> Check attached. Let us know if there is any further query.
>
> HTH
> Abhi
>
>
> On Tue, Feb 19, 2013 at 12:31 PM, Rakesh Kumar Sharma <
> rakeshks@gmail.com> wrot
Check attached. Let us know if there is any further query.
HTH
Abhi
On Tue, Feb 19, 2013 at 12:31 PM, Rakesh Kumar Sharma <
rakeshks@gmail.com> wrote:
> Dear Experts,
>
> I need a formula/function which can give required value. Sample file
> attached.
>
> Thanks in Advance
>
> --
> Regar
Dear Experts,
I need a formula/function which can give required value. Sample file
attached.
Thanks in Advance
--
Regards,
Rakesh Kumar Sharma
Contact: +91-9971024741
--
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 Faceboo
Thanks Dear
On Tue, Feb 12, 2013 at 10:04 PM, >>Excel Beginner<< <
excelbegin...@gmail.com> wrote:
> Hi Dhaval,
>
> Find the attachment.
>
>
>
>
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
> On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah wrote:
>
>> Dear Friends
>>
>> pls refer my
Hi Dhaval,
Find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
On Tue, Feb 12, 2013 at 1:42 PM, Dhaval Shah wrote:
> Dear Friends
>
> pls refer my sheet i want a formula solution
>
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(
dear frnd.
Use Pivot get the solution.
On 2/12/13, Dhaval Shah wrote:
> Dear Friends
>
> pls refer my sheet i want a formula solution
>
> --
> 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://
Dear Friends
pls refer my sheet i want a formula solution
--
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/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. P
>
> ** **
>
> Regards
>
> ** **
>
> Kailash
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *>>Excel Beginner<<
> *Sent:* Friday, January 18, 2013 12:00 AM
> *To:* excel-macros@google
Hi
Please remove my id from the group ..
Regards
Kailash
From: excel-macros@googlegroups.com
[mailto:excel-macros@googlegroups.com] On Behalf Of >>Excel Beginner<<
Sent: Friday, January 18, 2013 12:00 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-M
Dear Deepak
Pl see the attached sheet.
Warm Regards,
Gawli Anil
On Mon, Jan 28, 2013 at 9:15 PM, ashish koul wrote:
> HI
>
> try this =SUMPRODUCT((1/COUNTIF(C3:C20,C3:C20&"")))
>
>
> visit
>
> http://www.exceltip.com/st/Counting_number_of_unique_entries_in_a_specified_range./785.html
> or
>
>
HI
try this =SUMPRODUCT((1/COUNTIF(C3:C20,C3:C20&"")))
visit
http://www.exceltip.com/st/Counting_number_of_unique_entries_in_a_specified_range./785.html
or
http://office.microsoft.com/en-in/excel-help/count-occurrences-of-values-or-unique-values-in-a-data-range-HP003056118.aspx
or
http://www.yo
=SUM(IF($C$3:$C$10=G3,IF($D$3:$D$10<>"",1,0)))
Press *CTRL+SHIFT+ENTER*
*
*
*Regards*
*Ashish*
On Mon, Jan 28, 2013 at 6:27 PM, Deepak Rawat wrote:
> Dear All,
>
> Pls provide proper formula for attached problem.
>
> Regards,
> Deepak
>
> --
> Join official Facebook page of this forum @
> https:
@googlegroups.com
Cc: Manjunath Narayanappa; Prince
Subject: Re: FW: $$Excel-Macros$$ need formula Highlight
Hi Manjunath,
See below pdf. I hope it will help you.
http://ide20.com/upload/ModuleAE/Lesson01.pdf
http://ide20.com/upload/ModuleAE/Lesson02.pdf
http://ide20.com/upload/ModuleAE/Lesson03.pdf
e, Jan 22, 2013 at 3:02 PM, Manjunath Narayanappa <
>> manjunath@aon.co.**uk> wrote:
>>
>> Dear Prince,
>>
>>
>>
>> I'm keen to learn this. please teach me.
>>
>>
>>
>> Thanks
>>
>> Manjunath
>>
>>
&
; *To:* excel-...@googlegroups.com
> *Subject:* Re: FW: $$Excel-Macros$$ need formula Highlight
>
>
>
>
>
> 1st Conditional Formatting:
>
>
>
> [image: Inline image 1]
>
> 2nd Conditional Formatting Rules Manager:
>
>
>
> [im
rayanappa
Subject: Re: FW: $$Excel-Macros$$ need formula Highlight
Hi Manjunath,
PFA,
Regards
Prince
On Thursday, January 17, 2013 6:41:46 PM UTC+5:30, Manjunath Narayanappa wrote:
Dear all,
Please can I get macro for below requests
Regards
Manjunath
From: excel-...@googlegroups.com [mailto:excel
hi friends;
i need a formula that will tell me about which user has logged in the
particular file
--
Midhun Thampan.
Administrator(Business Process Management)
Maersk Global Services.
Powai, Hiranandani.
Mumbai:400076
--
Join official Facebook page of this forum @
https://www.facebook.com/di
Manjunath Narayanappa
Sent: 17 January 2013 08:47
To: 'excel-...@googlegroups.com'
Subject: $$Excel-Macros$$ need formula Highlight
Dear Expert,
Good afternoon have a nice day :)
I have a data in the attached spreadsheet, automatically data in B column
should get highlighted when
Manjunath Narayanappa
Sent: 17 January 2013 08:47
To: 'excel-...@googlegroups.com'
Subject: $$Excel-Macros$$ need formula Highlight
Dear Expert,
Good afternoon have a nice day :)
I have a data in the attached spreadsheet, automatically data in B column
should get highlighted when
Hi Deepak,
Below mentioned formula used of worksheet cell "B2" or find
the attachment.
=ROUNDUP(SUM(IF(Data!
B2:B12=Summary!A2,1/COUNTIF(Data!E2:E12,Data!E2:E12),0)),0)
--
*Regards,*
*
*
*Excel Beginner*
On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote:
> HI,
>
> Could u s
Deepak
Watch this video you will be able to solve your problem on your *OWN*
http://www.youtube.com/watch?v=27qh1i_kgCY
Regards
Ashish Koul
On Thu, Jan 17, 2013 at 5:18 PM, Deepak Rawat wrote:
> Hi,
> thax for reply
> but still unsolved in panchayat it should come 2 rather than 5
>
> Regards,
; *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Manjunath
> Narayanappa
> *Sent:* 17 January 2013 08:47
> *To:* 'excel-...@googlegroups.com '
> *Subject:* $$Excel-Macros$$ need formula Highlight
>
>
>
> Dear Expert,
>
you can use conditional formatting for this
--- On Thu, 1/17/13, Manjunath Narayanappa
wrote:
From: Manjunath Narayanappa
Subject: FW: $$Excel-Macros$$ need formula Highlight
To: "'excel-macros@googlegroups.com'"
Date: Thursday, January 17, 2013, 6:41 PM
Dear
Dear all,
Please can I get macro for below requests
Regards
Manjunath
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Manjunath Narayanappa
Sent: 17 January 2013 08:47
To: 'excel-macros@googlegroups.com'
Subject: $$Excel-Macros$$ need formula
Hi,
thax for reply
but still unsolved in panchayat it should come 2 rather than 5
Regards,
Deepak Rawat
On Thu, Jan 17, 2013 at 12:27 PM, Amresh Maurya wrote:
> On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat
> wrote:
> > Dear Anoop,
> >
> > I need as i given table.
> >
> > regards,
> > Deepak
Dear Manjunath,
Pl find attached herewith. Is it OK?
Warm Regards,
Gawli Anil
On Thu, Jan 17, 2013 at 2:17 PM, Manjunath Narayanappa <
manjunath.narayana...@aon.co.uk> wrote:
> Dear Expert,
>
>
>
> Good afternoon have a nice day :)
>
>
>
> I have a data in the attached spreadsheet, automatic
Dear Expert,
Good afternoon have a nice day :)
I have a data in the attached spreadsheet, automatically data in B column
should get highlighted when there is a duplicate or repeated entry.
Please help me on this.
Thanks
Manjunath
PLEASE CONSIDER THE ENVIRONM
On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat wrote:
> Dear Anoop,
>
> I need as i given table.
>
> regards,
> Deepak rawat
>
>
> On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma
> wrote:
>>
>> Hi Deepak,
>>
>> PFA. You need to refresh the pivot on first sheet.
>>
>> Regards,
>> Anoop
>> Sr. Dev
Use the updated file. You can move pivot anywhere in the workbook. There is
no change in your table formatting.
On Thu, Jan 17, 2013 at 12:21 PM, Deepak Rawat wrote:
> Dear Anoop,
>
> I need as i given table.
>
> regards,
> Deepak rawat
>
>
> On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma
>
Dear Anoop,
I need as i given table.
regards,
Deepak rawat
On Thu, Jan 17, 2013 at 11:43 AM, Anoop K Sharma wrote:
> Hi Deepak,
>
> PFA. You need to refresh the pivot on first sheet.
>
> Regards,
> Anoop
> Sr. Developer
>
>
> On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote:
>
>> HI,
>>
>>
Hi Deepak,
PFA. You need to refresh the pivot on first sheet.
Regards,
Anoop
Sr. Developer
On Thu, Jan 17, 2013 at 11:16 AM, Deepak Rawat wrote:
> HI,
>
> Could u suggest any formula to get summary from the data attached in
> summary sheet.
>
> --
> Join official Facebook page of this forum @
HI,
Could u suggest any formula to get summary from the data attached in
summary sheet.
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Pr
plz revert me how to use filter in column.
On Wednesday, January 16, 2013 9:46:56 AM UTC+5:30, अनिल नारायण गवली wrote:
>
> Pl Find attached herewith with two formulae 1) Sumifs and 2) sumproduct.
>
>
> Warm Regards,
> Gawli Anil
>
> On Tue, Jan 15, 2013 at 8:39 PM, ashish koul
> > wrote:
>
>
try this
=SUMIFS(C:C,A:A,"Fax",B:B,"Brown")
On Tue, Jan 15, 2013 at 12:40 PM, Prabhakar S H wrote:
> Dear Team,
>
> I need to get formula for attached file. Pls help.
>
> Rgds,
> Prabhakar
>
> --
> Join official Facebook page of this forum @
> https://www.facebook.com/discussexcel
>
> FORUM RU
Dear Team,
I need to get formula for attached file. Pls help.
Rgds,
Prabhakar
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem,
Hello All,
Requesting to help again. I.ve tried IF condition to solve this problem but
failed. I don.t know how to create conditions with multiple If.
With Regards,
Suyog
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accur
Hello All,
Please see attached excel, I'm confused how can I set IF statement based on
varying 3 condition for one cell.
Please review & advice.
With Regards,
*Suyog*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate th
In A2 cell
*=INDIRECT("'"&$D$1&"'!"&ADDRESS(ROW(),COLUMN()+1))*
Drag it down and right...
On 10-01-2013 1:14 PM, Rajesh Agarwal wrote:
Dear Sir
If I change the sheet name in column D1 all the rows of column A & B
change accordingly
need formula not macro
--
*Rajesh Kumar Agarwal*
*981106300
Hi Raghu,
please find the attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli <
raghunandan.rallapa...@gmail.com> wrote:
> sir,
> I need a formula for total sum of each account no wise as given in excel
> sheet.
>
> Thanks
ecember 11, 2012 12:29 PM
Subject: $$Excel-Macros$$ need formula please
sir,
I need a formula for total sum of each account no wise as given in excel sheet.
Thanks in advance please.
Raghu Nandan R--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULE
Hi,
find below & use this =SUMIF($A$2:$A$23,A2,$C$2:$C$23)
thankx
satendra
On Tue, Dec 11, 2012 at 5:59 PM, raghunandan rallapalli <
raghunandan.rallapa...@gmail.com> wrote:
> sir,
> I need a formula for total sum of each account no wise as given in excel
> sheet.
>
> Thanks in advance please
Dear Excel lerner,
use SUMPRODUCT formula to get desired result
see the attached file
--
*Kalyan Chattopadhyay*
*Executive Sales Coordinator*
*R. S. H. Pvt. Ltd.*
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thre
Dear excellerner,
Use $ sign to make constant row or column .
for eg
if u select A1 A10 then write $A$1 $A$10.
first $ is for column and second $ is for row.
you can use only one $ for only one column like $A1 or you can use only one
row like a$1 .
Regards,
Gawli
On Mon, Dec 10, 2012 at 12:31 PM,
Sir
Please see the sample and help me.In this file Row C4 to AD 4 has
amount to be paid for each unit.If emp-1 done 2 units in c5 then
c5*c4 , emp-2 done 3 units in c6 then c6*c4. as same up to AD to all
employes. I already set formula in AE for all employes.Please verify
and suggest me for simp
Hi Rajesh,
Try this one.
For Max: =MAX(IF(ISERROR(A2:A40),0,A2:A40))
For Min: =MIN(IF(ISERROR(A2:A40),40,A2:A40))
With Ctrl+Shift+Enter.
Regards,
Kuldeep Singh
On Fri, Oct 19, 2012 at 1:05 PM, NOORAIN ANSARI wrote:
> Dear Rajesh,
>
> Please try it..
> =MAX(IF(ISERROR(A2:A40),0,A2:A40))
>
> =M
Dear Rajesh,
Please try it..
=MAX(IF(ISERROR(A2:A40),0,A2:A40))
=MIN(IF(ISERROR(A2:A40),0,A2:A40))
On Fri, Oct 19, 2012 at 12:54 PM, Rajesh Agarwal wrote:
> Dear Sir
> I need formula in b2 and c2 max and minimum value of a2:a40 excluding
> other than numbers.
> rgds
>
> --
> *Rajesh Kumar Aga
Following formulas for Max & Min with C+S+E
=MAX(IF(ISNUMBER(A2:A40),A2:A40))
=MIN(IF(ISNUMBER(A2:A40),A2:A40))
Regards,
Aamir Shahzad
On Fri, Oct 19, 2012 at 12:24 PM, Rajesh Agarwal wrote:
> Dear Sir
> I need formula in b2 and c2 max and minimum value of a2:a40 excluding
> other than numbe
Dear Sir
I need formula in b2 and c2 max and minimum value of a2:a40 excluding other
than numbers.
rgds
--
*Rajesh Kumar Agarwal*
*9811063001*
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use
ps.com
Subject: $$Excel-Macros$$ need formula
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/discussexcel
FORUM RULES (1120+ members already BANNED for violatio
-
From: rajeyssh
To: excel-macros@googlegroups.com
Sent: Tue, September 25, 2012 5:47:00 AM
Subject: $$Excel-Macros$$ need formula
Hello everyone
I need simple average and minimum formula in the column but excluding the value
if 0.
thanks--
Join
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/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poo
2012 12:47 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need formula to take out total number of
> boy and girl
>
> Dear all
> Can you please help me to find out Boys & girls Rank (Regarding Marks) If
> they failed then can not count their rank.
Your file did NOT show any pass/fail or grades so how can we help?
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: amar takale
Sent: Thursday, July 19, 2012 12:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need formula to take out
product formulas in attached.
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Software
> dguille...@gmail.com
>
> *From:* group birle
> *Sent:* Wednesday, July 18, 2012 7:47 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Need formula
See sumproduct formulas in attached.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: group birle
Sent: Wednesday, July 18, 2012 7:47 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need formula to take out total number of boy and
girl
check this
On Thu, Jul 12, 2012 at 2:54 PM, सुनिता पौडेल wrote:
> Dear all,
>
> Can you please help me to find out the total number of boy and girl ? I
> used countif for their grade and it worked. However, for girl and boy
> seggregation it isnot working.
>
> Thank you very much for the suppo
Hi Noorain,
Its working perfectly. I have tried this formulae for other sheets too.
Thanx alot...I need it for my report...
Have a wonderful weekend.
Sunita
On Fri, Jul 13, 2012 at 3:02 PM, NOORAIN ANSARI wrote:
> Hi Sunita,
>
> Please confirm..
>
> Is it not working..
>
> paste in Cell *E2*
Hi Sunita,
Please confirm..
Is it not working..
paste in Cell *E2*
*=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
On Fri, Jul 13, 2012 at 1:22 PM, सुनिता पौडेल wrote:
> Hi,
>
> Still not working :(
> its 2010
>
> On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI > wrote:
>
>> Incase of
Thank you so muck Krishnaraddi ji. Still wondering where it went wrong.
Anyway thanks heaps.
Sunita
On Fri, Jul 13, 2012 at 1:53 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
> and may al
Hi,
Still not working :(
its 2010
On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI
wrote:
> Incase of 2003
>
> You can also use..
>
> *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
>
>
> On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI > wrote:
>
>> Hi Sunita,
>>
>> Please Try it..
>> =CO
Incase of 2003
You can also use..
*=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI
wrote:
> Hi Sunita,
>
> Please Try it..
> =COUNTIFS($E$10:$E$46,$E$1,$D$10:$D$46,C2)
>
>
>
>
> On Fri, Jul 13, 2012 at 11:31 AM, सुनिता पौडेल wrote:
>
>> Dear
1 - 100 of 200 matches
Mail list logo
