Hi,
find the attachment with solution.
thanks
satendra kumar
On Tue, Jan 19, 2016 at 12:29 PM, GENIUS wrote:
> THANK YOU VERY MUCH FOR YOUR HELP
>
> I'VE ONE MORE QUESTION, CAN YOU PLEASE SEE IT AND SOLVE IT
>
> in the attachment, there is no figure in column F, in column N there is an
> avera
I think I see your issue.Your example has (4) products (Product A, B, C, D)Your
formula "manually" adds the Unit volumes for eachand the costs for each.
But if you have more Products, this calculation becomes harder to manage.
You want a sum of the Unit volume of ALL products, not EACH product.
In
Need help
i have an excel sheet with lot of data which needs regular updation, in
common folder having access to everybody.
Is there any function by which i can track the changes in excel sheet with
the name of the person and time of change.
kindly help.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)
Send me your query.
On Sunday, May 31, 2015 at 11:06:23 PM UTC+5:30, ali abbas wrote:
>
> My how do Add 100 in query. Plz do attach sample file
> On May 31, 2015 10:15 PM, "Mandeep Baluja" > wrote:
>
>> Hey Ali,
>>
>> In answer to your query you can simply do this by adding 100 in the
>> Valu
My how do Add 100 in query. Plz do attach sample file
On May 31, 2015 10:15 PM, "Mandeep Baluja" wrote:
> Hey Ali,
>
> In answer to your query you can simply do this by adding 100 in the Value,
> But it doesn't seems to me your query is that much simpler . Please correct
> me or explain your quer
Hi
i think your are looking for this..file also attached
=IFERROR(SMALL($B$2:$B$375,COUNTIF($B$2:$B$375,"<=0")+ROW(A1)),"")
Thankx & Rgds,
Chandra Singh Bisht
On Wed, Apr 22, 2015 at 10:11 AM, Rajesh Agarwal wrote:
> Sorry. now find the attachment.
>
> On Tue, Apr 21, 2015 at 10:53 PM, Raj
Elaborate more!!
Regards
Ashish
--
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 thread titles, l
Thanks Mr Vijay,
Using -- operator, I am able to convert Numeric Characters to Numeric
value. (Example : entered =--a1 in cell A2 to convert the
character contents from cell a1).
Similerly, is there any similler operator is available to convert it back
to character except single / double Quote.
Thanks Mr Vijaykumar.
Regards
Eugene
On Thu, Jun 6, 2013 at 12:34 PM, P.VIJAYKUMAR wrote:
> Respected Eugene Bernard,
>
> The double negative is used to "coerce," as we say, a non-number type into
> a
> number type. Since only a number (not text, boolean, error value, etc.)
> can
> follow a mi
Respected Eugene Bernard,
The double negative is used to "coerce," as we say, a non-number type into
a
number type. Since only a number (not text, boolean, error value, etc.) can
follow a minus sign, one minus sign forces the coercion to a number. The
other just reverses the sign change caused by
Hi Prince,
What is the use of -- in the formula mentioned by you.
The result is OK, but I do not find this of syntax in Excel Help.
Please elaborate.
Regards
Eugene
On Tue, Jun 4, 2013 at 5:16 PM, Prince wrote:
> may be it can help you.
>
> =SUMPRODUCT(--(I9:I17="Black"),--(H9:H17="Cars"),(
Prince,
But my column C Prod (On+Off Rte) wrote:
> =IF(IF(ISERROR(C2/A2),"",(C2/A2))>=1,"100%","")
>
> Regards
> Prince
>
> On Tuesday, 5 March 2013 16:31:37 UTC+5:30, Shaikh Iqbal wrote:
>
>> Prince
>>
>> If Column *C* Prod (On+Off Rte) > CallPlan then output in column D only
>> 100% not goes to
=IF(IF(ISERROR(C2/A2),"",(C2/A2))>=1,"100%","")
Regards
Prince
On Tuesday, 5 March 2013 16:31:37 UTC+5:30, Shaikh Iqbal wrote:
>
> Prince
>
> If Column *C* Prod (On+Off Rte) > CallPlan then output in column D only
> 100% not goes to 126%
>
>
>
>
> On 5 March 2013 16:15, Prince > wrote:
>
>> if
Prince
If Column *C* Prod (On+Off Rte) > CallPlan then output in column D only
100% not goes to 126%
On 5 March 2013 16:15, Prince wrote:
> if i m right you may be expecting this :
>
> =IF(IF(ISERROR(ROUND(C2/A2%,2)),0,(ROUND(C2/A2%,2)))=100%,IF(ISERROR(ROUND(C2/A2%,2)),0,(ROUND(C2/A2%,2))),
@ Prince,
Do you think is it a quality answer? and Dont you think you are
re-directing the OP in wrong approach?
=SUM(($D$2:D5=D2)**1**(G2:M2))*with CSE*in Cell "O2"
Could you please explain what is the need of **1* *and what is the need
ofCSE here* *why not then one (Non Array Approach)
Hi Vikas,
Here is the macro than can combine data from multiple filse in to a single
file
Public Sub CombineDataFromFiles()
Dim varArrFile As Variant
Dim intCtr As Integer
Dim strFilesAs String
Dim wbk As Workbook
Dim wbkFinalAs Workbook
Dim rngDa
pl share a worksheet with us
On Tue, Jan 15, 2013 at 1:45 PM, wrote:
> **
> Hi prince
>
>
> Will you please help me.
> I have three different excel file and each excel file have three different
> wrk sheet. I need to link or copy all data in one excel file from these
> different wrk sheet. How d
Hi prince
Will you please help me.
I have three different excel file and each excel file have three different wrk
sheet. I need to link or copy all data in one excel file from these different
wrk sheet. How do I do this.
In advance thnks for help.
Sent from my BlackBerry® Smartphone on
Hi,
PFA
On Fri, Dec 7, 2012 at 12:30 AM, JMac wrote:
> When I opened the file, the formulas don't work on my PC. WIll they not
> work in Excel 2003 ?
>
> Thanks
>
> On Thursday, December 6, 2012 1:10:14 PM UTC-5, JMac wrote:
>
>> I've got a tracking sheet with 6 columns, each row being an en
ed colour.
>
>
> -- Forwarded message --
> From: अनिल नारायण गवली
> Date: Fri, Nov 30, 2012 at 12:26 PM
> Subject: Re: $$Excel-Macros$$ Re: Formula need to calculate sum on
> conditional base
> To: excel-macros@googlegroups.com, Ashish Bhalara <
> ashishbhalar...@gmail.co
Pls find attched sheet for you reference.
Regards,
Gawli Anil
On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara
wrote:
> i need the formula for text enetered in sheet with red color
>
> On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara <
> ashishbhalar...@gmail.com> wrote:
>
>> Dear expert,
>>
>>
Hi,
PFA...
Thanks and Regards,
Somnath C Pardeshi
From: Ashish Bhalara
To: excel-macros@googlegroups.com
Sent: Friday, 30 November 2012 12:16 PM
Subject: $$Excel-Macros$$ Re: Formula need to calculate sum on conditional base
i need the formula for text e
pls share the workbook with us
On Fri, Nov 30, 2012 at 12:16 PM, Ashish Bhalara
wrote:
> i need the formula for text enetered in sheet with red color
>
> On Fri, Nov 30, 2012 at 12:13 PM, Ashish Bhalara <
> ashishbhalar...@gmail.com> wrote:
>
>> Dear expert,
>>
>> I have a data in attached sheet,
Is it Extracting 2 words??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prince
Sent: 19 November 2012 9:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Formula to grab last two w
Dear Sir,
If possible can you please send me the example of the formula.
On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote:
> Hi Ashish,
>
> Please use sumifs formula for getting total GROSS and TDS amount for each
> vendor.
>
> Regards
> Prince
>
> On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30,
Dear Sir,
Thanks will try and get back to you.
On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote:
> Hi Ashish,
>
> Please use sumifs formula for getting total GROSS and TDS amount for each
> vendor.
>
> Regards
> Prince
>
> On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30, ashish damor wrote:
>>
>>
Ya i am trying its not working could you please send me the solved excel
sheet. it would help us to me.
On Thu, May 31, 2012 at 6:43 PM, CoRe wrote:
> hey Lokesh,
>
> Try CTRL+ ~ (button next to 1)
>
>
> On Thursday, May 31, 2012 3:58:53 PM UTC+3, lokesh wrote:
>
>> Hi Expects,
>>
>>
>>
>> Here
Hi
Please find attached Sheet
=SUM(1/COUNTIF(OFFSET(INDEX(Range,MATCH(A2,Range,0),1),,1,COUNTIF(Range,A2),
COUNTA(D1:AC1)-1),OFFSET(INDEX(Range,MATCH(A2,Range,0),1),,1,COUNTIF(Range,A
2),COUNTA(D1:AC1)-1)))-1
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.
Ok Got it.. thanks
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Apr/Mon/2012 08:16
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Formula to Extract Unique Values :
Insert a row before Row 1.
On Monday, 2 April
cros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kris
> *Sent:* Apr/Mon/2012 07:59
> *To:* excel-macros@googlegroups.com
> *Subject:* Re: $$Excel-Macros$$ Re: Formula to Extract Unique Values :
>
>
>
>
>
> PFA.
>
>
>
> Kris
&g
Hi krish
Please see attached sheet..I am unable to understand y its giving duplicate
to you only
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Apr/Mon/2012 07:59
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros
PFA.
Kris
On Monday, 2 April 2012 19:51:01 UTC+5:30, Rajan_Verma wrote:
>
> Hi Krishna,
>
> Can you share a scenario where its giving duplicates?
>
>
>
> Rajan.
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Kris
> *Sent:* Apr/Mon/2012
Hi Krishna,
Can you share a scenario where its giving duplicates?
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Apr/Mon/2012 07:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Formula to Extract Unique Values :
*
*
*
*
Hi Noorain/Haseeb,
Perfect answers.
This is what I was looking for...
Thanks...
Kiran
On Thu, Mar 29, 2012 at 9:06 AM, Haseeb A wrote:
> Hello Kiran,
>
> In G4 with CTRL+SHIFT+ENTER, rather than just ENTER
>
>
> =IFERROR(INDEX(D$2:D$498,MATCH(1,IF(ISNA(MATCH(D$2:D$498,G$3:G3,0)),IF($C$
=VLOOKUP(A1,Sheet3!A:B,*2,0)*
>
> ** **
>
> Regards
>
> Smitha
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *ashish koul
> *Sent:* Thursday, November 10, 2011 1:03 PM
> *To:* excel-mac
: $$Excel-Macros$$ Re: formula
use vlookup
On Thu, Nov 10, 2011 at 12:41 PM, smitha.kumari
wrote:
PFA the sheet with name and designations.
Required is, if I type the name in another worksheet, the designation column
for the name should show as in the attachement
Regards
Smitha/ Senior Finance
use vlookup
On Thu, Nov 10, 2011 at 12:41 PM, smitha.kumari wrote:
> PFA the sheet with name and designations.
> Required is, if I type the name in another worksheet, the designation
> column
> for the name should show as in the attachement
>
> Regards
> Smitha/ Senior Finance Executive
>
> Worl
PFA the sheet with name and designations.
Required is, if I type the name in another worksheet, the designation column
for the name should show as in the attachement
Regards
Smitha/ Senior Finance Executive
World Class Solutions to Power Global Businesses
Office: 0471-2527525/2700526
smitha.kum.
GoldenLance,
I attached the example. It was detailed in the attachment.
John
On Fri, Oct 7, 2011 at 8:53 AM, GoldenLance wrote:
> You might want to clarify 'I need the formula for the GREEN cells to
> lookup the value in the appropriate table', with an example.
>
> On Oct 7, 5:44 pm, "John A.
Haseeb Sir,
I am becoming a FAN of you... You seem to have super knowledge of
Formulas... tooo good...
On Thu, Jul 21, 2011 at 9:58 PM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hello Prabhu,
>
> Use SUBSTITUTE. or excel's Find/Replace command
>
> SUBSTITUTE is a case sensitive fun
Hi All,
Great!!! Thanks..
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.li
@Anish, that's cool dude, just trying to help.
Sam Mathai Chacko
On Jul 21, 9:41 pm, Anish Shrivastava wrote:
> Prabhu,
>
> Use the solution given by GoldenLance below.
>
> =SUBSTITUTE(A1,"ABC","#")
> *GoldenLance,*
> Thanks Man, This formula didnt hit my mind at that time.
>
>
>
>
>
>
>
> On Th
Prabhu,
Use the solution given by GoldenLance below.
=SUBSTITUTE(A1,"ABC","#")
*GoldenLance,*
Thanks Man, This formula didnt hit my mind at that time.
On Thu, Jul 21, 2011 at 10:02 PM, GoldenLance wrote:
> Wouldn't this be much more easier, and apt?
>
> =SUBSTITUTE(A1,"ABC","#")
>
> On Jul 21,
Wouldn't this be much more easier, and apt?
=SUBSTITUTE(A1,"ABC","#")
On Jul 21, 9:27 pm, Prabhu wrote:
> Hi Anish,
>
> If it is "ABC12" and i need to replace the ABC form the cell then the
> formula will be ?
>
> Regards,
>
> Prabhu
--
-
Hi Anish,
If it is "ABC12" and i need to replace the ABC form the cell then the
formula will be ?
Regards,
Prabhu
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
ht
If you are looking for an Excel formula, just use
=SUBSTITUTE(A1,"ABC","")
On Jul 21, 8:37 pm, "Daniel" wrote:
> HI,
>
> Sub ABCReplace()
>
> [A1].Replace "ABC", "#"
>
> End Sub
>
> Regards.
>
> Daniel
>
> De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
> la part
HI,
Sub ABCReplace()
[A1].Replace "ABC", "#"
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Prabhu
Envoyé : jeudi 21 juillet 2011 17:26
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Re: ***Formula for f
Giving the formula as per your example.
*=IF(RIGHT(A1,3)="ABC",LEFT(A1,2)&"#",A1)*
Copy it down.
On Thu, Jul 21, 2011 at 8:55 PM, Prabhu wrote:
> Hi Friends,
>
> Can you help me to know the formula for find and replace.Example i need to
> find "ABC in the A1 cell and replace with "#". If th
On 1/14/11, OpenExcel.com <26may.1...@gmail.com> wrote:
> I agree with Dave & MS-EXL_LEARNER. It's not about favourite function but
> the best formula, which means combination of existing functions, functions
> with arrays, nested functions. i.e. THE BEST PURPOSEFUL FORMULA - we ever
> came across.
thanks again. Very helpful tips!
On Jan 12, 10:19 pm, Manoj kumar
wrote:
> Hello Guys,
>
> Fill Handle(the small black square on the bottom-right corner of a selected
> range of cells) is one of the best option to fill dates, in fact you can
> fill Days, Weekdays, Months and Years as well.
>
> *
Hello Guys,
Fill Handle(the small black square on the bottom-right corner of a selected
range of cells) is one of the best option to fill dates, in fact you can
fill Days, Weekdays, Months and Years as well.
*Here is the option :- *
Instead of dragging the Fill Handle while holding down the
DEAR FRIEND,
PLEASE TYPE
1/1/11
2/1/11
THEN TAKE BOTH COLUMN IN RANGE AND DRAG
On Thu, Jan 13, 2011 at 7:34 AM, J D wrote:
> I am no whiz kid with Excel but use it all the time. I usually just
> put a date in a cell drop to the next one and add 1. A1 would be the
> date formated how I want, A2
ame color.
Thoughts would be appreciated.
Susan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Dave Bonallack
Sent: Wednesday, January 12, 2011 8:44 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: Formula to add date
Hi,
Not sure if I'm missing the point here, but what about just typing the date
into your first cell, then press enter. From there, select your first cell and
drag the copy-down handle down as far as you want. XL defaults to incrementing
the date one day at a time.
Regards - Dave.
> Date: Wed
54 matches
Mail list logo
