Hi ,
Please Check. I have attached excel.
On Saturday, 6 October 2018 14:27:11 UTC+5:30, rajeyssh wrote:
>
> Dear Sir
> Formula required as per the attachment in sheet "2".
> Thanks in advance for your help.
>
> Regards
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
--
Are you =EXP(E:RT) or
Give this a shot.
It could be done as a nested if..then..else but for clarity, I recommend
making a custom function in the macro/vba editor.
to use, enter "=Answer(testcell) in you desired answer column, ie: in
Column C, enter"=answer(A1)".
Function Answer(MyCell)
acct = Left(MyCell, 1)
balance
Once again thanks all of you.
--
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, like Pleas
Dear, Please find the attached file.
On Sunday, July 24, 2016 at 4:18:00 PM UTC+5:30, GENIUS wrote:
>
> PLEASE SEE THE QUESTION IN THE FILE
>
--
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:
>
> Hey Guys!
>
I was wondering if you could help me in something
I am completely clueless about Marcros, but I would like to create one to
help me deal with a very redundant task!
I have three excel sheets with invoices : per Month, Year and Total
I usually enter the Monthly values, and th
Post a sample spreadsheet pls
On Monday, April 4, 2016 at 2:27:31 AM UTC-7, Excel ka Keeda wrote:
>
> Dear Experts,
>
> I have some text in a cell like "Date Range: 3/31/16 - 3/31/16"
>
> I want to extract the date in a another cell like date not as text only.
>
> Can any one help me with any dyn
OK I DID IT AND THANK YOU VERY MUCH FOR YOUR KINDNESS
--
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
>
> hey Man,
>
Read what i wrote bro on side *Put these values in column F as values you
will get the desired result** ,which means Copy cells Q2:Q21 go to cell f2
and do pastespecial paste as values check your results then.*
*Regards, *
*Mandeep baluja *
--
Are you =EXP(E:RT) or =NOT(EXP(E
Hi Mandeep
I saw you result but it is not fulfilling my requirements for your
convenience I'm sending the same sheet but with a little different way
please open and check it.
thank you Mandeep for your efforts for me.
secondly Mr Satendra Kumar also sent the sheet but nothing special it is
s
>
> check this formula !! I don't use solver in my work if I can achieve this
> with simple formula
>
Regards,
Mandeep baluja
--
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.faceboo
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
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
average, if i need the averages as per my requirements then how can I get
through solver, please show the steps..
*NOTE:*
ke
PFA !!
Regards,
Mandeep baluja
--
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, like
Hi,
Kindly elaborate your query !!
Regards,
Mandeep Baluja
--
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 titl
Thank you Mr Paul that's really great
On Saturday, 24 October 2015 17:07:35 UTC+5, GENIUS wrote:
>
> Thanks for your reply, but let me clear as you may see if we put more data
> in the rows we may have the sum of all the rows at one place, look at the
> sheet, but i need only row wise sum not th
le you can,
As long as ever you can.” - John Wesley
-
From: GENIUS
To: MS EXCEL AND VBA MACROS
Sent: Saturday, October 24, 2015 8:07 AM
Subject: $$Excel-Macros$$ Re: FORMULA REQUIRED
Thanks for your reply, but let me clear as you may see if w
Thanks for your reply, but let me clear as you may see if we put more data
in the rows we may have the sum of all the rows at one place, look at the
sheet, but i need only row wise sum not the sum of the different rows at
one place i.e. if we sum row three in J3 and K3, the sum must be of row 3
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
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 query in more details.
Regards,
MandeepBaluja
Learningzmypassion.
https://www.facebook.com/groups/825221420889809/
Did not understand your requirement. also, FYI, I can not see anything in
this attachemnt.
On Tuesday, April 21, 2015 at 11:03:22 PM UTC+5:30, rajeyssh wrote:
> Hello Sir
> formula required in both the column matching.
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
--
Are you =EXP(E:RT) o
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
Sorry. now find the attachment.
On Tue, Apr 21, 2015 at 10:53 PM, Rajesh Agarwal wrote:
> Hello Sir
> formula required
>
> --
> *Rajesh Kumar Agarwal*
> *9811063001*
>
--
*Rajesh Kumar Agarwal*
*9811063001*
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME
Hello
Use in O6 cell formula = COUNTIF($D$5:$I$32;O5) and copy to right.
Regards
W dniu piątek, 13 marca 2015 07:28:20 UTC+1 użytkownik Will Sob napisał:
>
>
> Hi,
> Please I need help with the attached file. I want a that calculates how
> many times 10, 13, 17 has appeared within the range D5
How can be the no of months between 1 april and 30 june 19 is 12 ? what
you are saying.
Regards,
Mandeep baluja
*Month* *End Month* *FY 15-16* *FY 16-17* *FY 17-18* *FY 18-19* *FY
19-20* *FY 20-21*
*1-Apr-15* *30-Jun-19* *12* *12* *12* *12* *3* *0*
On Friday, N
Hi ,
you can use MROUND function.
307,077 =MROUND(NUMBER,MULTIPLE) ie (MROUND( 307,077,100) =307100 307,077
For
this also same, this is multiple with 1 = 31
BR
MK
On Tuesday, February 25, 2014 10:15:44 AM UTC+5:30, Rags wrote:
> Hi,
>
> Need formula for rounding up number (i.
Hi Rajan,
Please check here to understand Excel formulas in detail.
http://excelautomate.blogspot.in/2013/11/how-to-work-with-formulas-in-excel.html
On Monday, 11 November 2013 15:42:14 UTC+5:30, Rajan sharma wrote:
>
> Dear experts,
>
> I have wrote formula in the attached file, but throwing e
Not clear what you are trying to do but if your master sheet has different
names and you are trying to sum for your report sheet try the following:
=SUMIF(MASTER!$B$5:$B$35,"Raman Choudary",MASTER!C5:C35)
That goes into B9 of your report sheet. You can then copy across. If B10 is
a different
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.
Thank you De Premor! Works beautifully!
--
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,
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"),(
may be it can help you.
=SUMPRODUCT(--(I9:I17="Black"),--(H9:H17="Cars"),(J9:J17))
Regards
Prince
On Tuesday, June 4, 2013 4:49:56 PM UTC+5:30, Prabhakar S H wrote:
>
> Hi Team,
>
> i want to get formula to find Total value of cars with black color only.
> pls help.
>
> Rgds,
> Prabhakar
>
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))),
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))),"")
in D2 and drag
regards
prince
On Tuesday, 5 March 2013 16:01:30 UTC+5:30, Shaikh Iqbal wrote:
>
> Dear Export,
>
> Please help me attached f
Hi Ganesh,
PFA.
Regards
Prince
On Sunday, February 10, 2013 8:50:17 AM UTC+5:30, GANESH wrote:
>
> Hi I want the J8 show me the total of rim of which I highilighted in
> Green color all the user in Column E
> Column B has user Name Column c has the total of amount
> Please find the at
Hi Dear just use this
=VLOOKUP(A3,MASTER!$A$3:$B$9,2,0)
regards
prince
On Thursday, January 24, 2013 5:30:51 PM UTC+5:30, hilary lomotey wrote:
>
> Hello Experts,
>
> In the file attached, i have a master list with names and codes(master
> sheet), and then another list (list sheet). The codes in
@ 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)
der: * excel-...@googlegroups.com
> *Date: *Sun, 13 Jan 2013 23:02:48 -0800 (PST)
> *To: *>
> *ReplyTo: * excel-...@googlegroups.com
> *Subject: *$$Excel-Macros$$ Re: formula required
>
> Hi Prashant,
>
> I hope it may help you:
>
> =SUM(($D$2:D5=D2)*1*(G2:M2))
o: *
> *ReplyTo: * excel-macros@googlegroups.com
> *Subject: *$$Excel-Macros$$ Re: formula required
>
> Hi Prashant,
>
> I hope it may help you:
>
> =SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2"
>
> Regards
> Prince
>
> On Monday, January 14, 2013 1
Loop Mobile.
-Original Message-
From: Prince
Sender: excel-macros@googlegroups.com
Date: Sun, 13 Jan 2013 23:02:48
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: formula required
Hi Prashant,
I hope it may help you:
=SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in
Hi Prashant,
I hope it may help you:
=SUM(($D$2:D5=D2)*1*(G2:M2)) with CSE in Cell "O2"
Regards
Prince
On Monday, January 14, 2013 12:19:32 PM UTC+5:30, ppawle.excel wrote:
>
> Dear Team,
>
> Need a formula to look up a filed & give sum of figure , sample file
> attached
>
> Regards,
>
> Pras
That worked very well.
Thank-you
Jeff
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 entry for
> equipment maintenance. Column C contains the serial number of the
> equipment. On a separate
> sheet I have a summary,
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
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 entry for
> equipment maintenance. Column C contains the serial number
Hi vinay,
Use this formula it will give you no of weeks between two dates:
let suppose : A1 contain Todays Date and C1 contain futures date then:
in A4:* = trunc((C1-A1)/7)*
*
*
*
*
*Regards*
*Prince*
*
*
On Thursday, December 6, 2012 8:48:34 PM UTC+5:30, t vinay wrote:
>
> Hi Team,
>
> can
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
Dear expert,
Thanks to reply but i have to keep data same as in attached sheet so i need
a formula for amount written in red colour.
-- Forwarded message --
From: अनिल नारायण गवली
Date: Fri, Nov 30, 2012 at 12:26 PM
Subject: Re: $$Excel-Macros$$ Re: Formula need to calculate sum
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
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,
Prince, thank you for the attempt, this does not work as I intended. I'm
interested to learn more about the technique you came back with. If you
have the time can you do a quick explaination of the functions you are
using to arrrive at the result? Thank you again!
On Monday, November 19, 2012
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
Hi Natron,
I hope this will help you.
=MID(A1,FIND("*",SUBSTITUTE(A1," ","*",1),1),LEN(A1))
Regards
Prince
On Monday, November 19, 2012 9:42:53 PM UTC+5:30, Natron wrote:
>
> I have a string such as the following two examples and want a formula to
> grab the last two words.
>
> The followin
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:
>>
>>
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:
>
> Dear All,
>
> I have an excel sheet wherein commission is generated for each
> business placed by our intermedi
Hi Joshnson,
Which version of excel you are using?
Rgds//Vabs
On Friday, September 21, 2012 6:20:20 PM UTC+5:30, johnson wrote:
>
>
> Hellow Guys,
>
> While copying formula in my excel work book, formula is taking fixed
> reference but not the relative reference.
> while saving the file, it g
On Sunday, September 9, 2012 11:50:05 PM UTC+4, prkhan56 wrote:
>
> Hello All,
>
> We have a group of employees having various Grades and Position.
>
> 1) A fixed target of sales to be achieved every month as shown in
> Col D (Target).
>
> 2) Each level has different Target Criteria as
Ok Dear..
PFA Cheerz..
Rgds\\Vabz
On Monday, September 10, 2012 1:58:09 PM UTC+5:30, prkhan56 wrote:
>
> Hello,
> Thanks for the solution.
> But I would prefer it to have in respective applicable columns please.
> Regards
> Rashid
> On Monday, September 10, 2012 8:57:27 AM UTC+4, Vabz wrote:
>
>
Hello,
Thanks for the solution.
But I would prefer it to have in respective applicable columns please.
Regards
Rashid
On Monday, September 10, 2012 8:57:27 AM UTC+4, Vabz wrote:
> Hi
>
> Do you want comm. to be shown in respective applicable col. only or pl
> check soln i have given.
>
> Rgds//V
Hi
Do you want comm. to be shown in respective applicable col. only or pl
check soln i have given.
Rgds//Vabz
On Monday, September 10, 2012 1:20:05 AM UTC+5:30, prkhan56 wrote:
>
> Hello All,
>
> We have a group of employees having various Grades and Position.
>
> 1) A fixed target of sale
I need the result in *hh:mm:ss* format.
On Tuesday, August 28, 2012 1:37:31 PM UTC-4, LJ wrote:
>
> Greetings,
>
> I need a formula that calculates the amount of time between 7pm and 6pm
> between 2 dates. Example:
>
> A1 = End Date and Time 8/1/2012 12:00:00PM
> B1 = Start Date and Time 8/21/201
Hi Pawel,
please see the attachment.
regards
prince
On Wednesday, August 8, 2012 11:15:30 PM UTC+5:30, lupinskip wrote:
>
> Hi All,
>
> I'm looking for formula that will be checking cell base on the condition
> that last 8 digits will be match, with 8 digits from different cell. Pls
> see a
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
hey Lokesh,
Try CTRL+ ~ (button next to 1)
On Thursday, May 31, 2012 3:58:53 PM UTC+3, lokesh wrote:
> Hi Expects,
>
>
>
> Here it is the screen shot for the formula. And please do the needful.
>
>
>
>
>
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, a
Hello Lee,
This should work with just ENTER.
in AC2, then drag down.
=SUMPRODUCT((A$2:A$23=AB2)*(B$2:Z$23<>"")/COUNTIF(B$2:Z$23,B$2:Z$23&""))
Adjust the ranges. See the attached.
Regards,
Haseeb
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread title
@googlegroups.com]
On Behalf Of CoRe
Sent: Apr/Fri/2012 12:58
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: formula required for count or count if
Hello Lee,
PFA!
If you have any queries ,give a shout ...
On Friday, April 27, 2012 7:30:32 AM UTC+3, lee wrote:
hi
i have data as
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
Sent: Apr/Mon/2012 07:42
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Formula to Extract Unique Values :
Hi Rajan,
It gives duplicates as well.
You may try this shorter one.
In E2 and copied down,
=INDEX(Range,MATCH(0,COUNTIF($E$1:E1,Range),0))
Array formula
Behalf Of *Kris
> *Sent:* Apr/Mon/2012 07:42
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Re: Formula to Extract Unique Values :
>
>
>
> Hi Rajan,
>
>
>
> It gives duplicates as well.
>
>
>
> You may try this shorter one.
&
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 Rajan,
It gives duplicates as well.
You may try this shorter one.
In E2 and copied down,
=INDEX(Range,MATCH(0,COUNTIF($E$1:E1,Range),0))
Array formula.
Kris
On Monday, 2 April 2012 19:19:58 UTC+5:30, Rajan_Verma wrote:
>
>
>
> Hi group,
>
> I have just created formula to extract unique
*
*
*
*
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$
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$2:$C$498="Agent",1)),0)),"")
Then copy across & down. if you have huge list, this will slow down the
sheet performance.
___
HTH, Haseeb
--
FORUM
=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
Sent: Thursday, November 10, 2011 12:31 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ Re: formula
>
> Please upload your sample workbook. Without that, it will be difficult
> to understand exactly what you require.
>
> Sam
>
> On Nov 10, 11:11 am, "sm
...@speridian.com
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: Thursday, November 10, 2011 12:31 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: formula
Please upload your sample workbook
Please upload your sample workbook. Without that, it will be difficult
to understand exactly what you require.
Sam
On Nov 10, 11:11 am, "smitha.kumari"
wrote:
> If name in a cell is Simon in a work sheet 2 then the designation already
> allotted for Simon in worksheet 1 should appear there in wo
Hi,
Do you want only 'figures' to be sorted out OR do you want numbers
only to be sorted out ?
Regards,
DILIPandey
--
Thanks & Regards,
DILIP KUMAR PANDEY, mvp
MBA,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Oct 13, 2:46 pm, B
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.
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. Smith" wrote:
> I need the formula to lookup a value in a table and return the table column
> header value. Please see attached spread she
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
Hello Prabhu,
Use SUBSTITUTE. or excel's Find/Replace command
SUBSTITUTE is a case sensitive function, so you need convert the cell to
UPPER or LOWER, so use,
=SUBSTITUTE(UPPER(A1),"ABC","")
Or,
=SUBSTITUTE(LOWER(A1),"abc","")
All the letters in 1st output will be in CAPITAL LETTERS
All the
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
t;
> 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 find and replace***
>
> Hi Friends,
>
> Can yo
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$
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
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 there is no 'ABC"
existing A1 should remain as it is.(Not using ctr+H)
*Example.*
Existing Cell Replace as
12ABC 12#
1
1 - 100 of 150 matches
Mail list logo
