Re: $$Excel-Macros$$ Need Excel Formula

On Saturday, June 4, 2016 at 9:12:54 AM UTC+5:30, Prabhakar S H wrote: > > it is not happening because i have to get repated dates & names as per the > attached format. > > > On Friday, June 3, 2016 at 8:38:06 PM UTC+5:30, Abhi wrote: >> >> Why not just use pivot ? >> >> On Fri, Jun 3, 2016 at

Re: $$Excel-Macros$$ Need Excel Formula

it is happening because i have to get repated dates & names as per the attached format. On Friday, June 3, 2016 at 8:38:06 PM UTC+5:30, Abhi wrote: > > Why not just use pivot ? > > On Fri, Jun 3, 2016 at 8:35 PM, Prabhakar S H > wrote: > >> Hi Friends, >> >> I have

Re: $$Excel-Macros$$ Need Excel Formula

Why not just use pivot ? On Fri, Jun 3, 2016 at 8:35 PM, Prabhakar S H wrote: > Hi Friends, > > I have Employee database where data is in raw & i need in column. Please > refer attached file & help. > > > Rgds, > Prabhakar > 9844430518 > > -- > Are you =EXP(E:RT) or

$$Excel-Macros$$ Need Excel Formula

Hi Friends, I have Employee database where data is in raw & i need in column. Please refer attached file & help. Rgds, Prabhakar 9844430518 -- 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 @

Re: $$Excel-Macros$$ Need excel formula for text to columns by " - " not "-"

A MACROS <excel-...@googlegroups.com > > *Cc:* schrein...@att.net > *Sent:* Friday, November 6, 2015 2:07 PM > *Subject:* Re: $$Excel-Macros$$ Need excel formula for text to columns by > " - " not "-" > > Excel 2007, but it only allows for one chara

Re: $$Excel-Macros$$ Need excel formula for text to columns by " - " not "-"

all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* "drew...@gmail.com " <drew...@gmail.com > > > *To:* MS EXCEL AND VBA MACROS <

$$Excel-Macros$$ Need excel formula for text to columns by " - " not "-"

Hello, I would be very grateful if someone could provide a formula for dividing text to columns using " - " as a deliminator. Many Thanks, Andrew -- 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 @

Re: $$Excel-Macros$$ Need excel formula for text to columns by " - " not "-"

groups.com> Cc: schreiner_p...@att.net Sent: Friday, November 6, 2015 2:07 PM Subject: Re: $$Excel-Macros$$ Need excel formula for text to columns by " - " not "-" Excel 2007, but it only allows for one character not three On Friday, November 6, 2015 at 11:23:11

Re: $$Excel-Macros$$ need Excel formula

Dear Pankaj Nice explanation thanks, Dear Prafull Thanks for kind help Regards Shrini On Thu, Aug 27, 2015 at 6:16 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear Shrinivas, You will get this after selecting formula and Press F9 For example select 1/(A2:A18=F3) and then Press F9

$$Excel-Macros$$ need Excel formula

HI Expert,, i need a formula to find last collected Amount from client.For example PFA. -- 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

Re: $$Excel-Macros$$ need Excel formula

HTH On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com wrote: HI Expert,, i need a formula to find last collected Amount from client.For example PFA. -- 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

Re: $$Excel-Macros$$ need Excel formula

Great On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain abhishek@gmail.com wrote: HTH On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com wrote: HI Expert,, i need a formula to find last collected Amount from client.For example PFA. -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ need Excel formula

Thank you Abhishek Jain On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain abhishek@gmail.com wrote: HTH On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com wrote: HI Expert,, i need a formula to find last collected Amount from client.For example PFA. --

Re: $$Excel-Macros$$ need Excel formula

Just one thing though...I forgot to freeze the ranges which might result in incorrect values. The correct formula would be - =LOOKUP(2,1/($A$1:$A$17=F2),$B$1:$B$17) Regards, On Thu, Aug 27, 2015 at 3:51 PM, Pankaj Sharma pankaj123...@gmail.com wrote: Thank you Abhishek Jain On Thu,

Re: $$Excel-Macros$$ need Excel formula

yup,, nice trick to get last small value... very useful On Thu, Aug 27, 2015 at 4:13 PM, Abhishek Jain abhishek@gmail.com wrote: Just one thing though...I forgot to freeze the ranges which might result in incorrect values. The correct formula would be -

$$Excel-Macros$$ Need some formula or MACROS

Dear Team, i need to check my updates are correct against the CMS DATA (Container no Size) if it is not matching it has to be give some color indications, I don't know how to ask my question... for more details please go through  the attachment   Best regards Delin.F -- Are you =EXP(E:RT) or

Re: $$Excel-Macros$$ Need some formula or MACROS

Thank you dear  vhaibav now i can save more time...   Best regards Delin.F On Friday, 27 March 2015 7:26 PM, Vaibhav Joshi v...@vabs.in wrote: Your first rule works fine, you can add 2nd rule via conditional formatting mange rule.. check this file i have added rule for your

Re: $$Excel-Macros$$ Need some formula or MACROS

Your first rule works fine, you can add 2nd rule via conditional formatting mange rule.. check this file i have added rule for your reference. Cheers!! On Fri, Mar 27, 2015 at 8:34 PM, 'DELIN FRANCIS' via MS EXCEL AND VBA MACROS excel-macros@googlegroups.com wrote: Dear Team, i need to

Re: $$Excel-Macros$$ Need some formula or MACROS

Hi Vaibhav Bhai, It's perfect .. !! superb :) 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

Re: $$Excel-Macros$$ Need a formula urgently

Hi Rajan, Your file is rally awesome and great. I would like to learn this, do you have any explanatory notes on the functions used in this file so that I will learn to do this. On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma rajansharma9...@gmail.comwrote: Hi Murali, Chek the attachment too.

$$Excel-Macros$$ Need a formula urgently

Dear All, I have a data base like colum A contains State name colum B contains city name against state name, im going to create a report that city name will be displayed in accordance with the change in the state name . Note:Sample data attached along with this mail. Do the needful. Thanks

Re: $$Excel-Macros$$ Need a formula urgently

Dear Murali, Please see in attachment. it might be helpful. Regards, Waseem Saifi On Wed, Sep 4, 2013 at 2:21 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear All, I have a data base like colum A contains State name colum B contains city name against state name, im going to create a

Re: $$Excel-Macros$$ Need a formula urgently

Dear Waseem, Thanks for your great support. On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi waseemsa...@gmail.com wrote: Dear Murali, Please see in attachment. it might be helpful. Regards, Waseem Saifi On Wed, Sep 4, 2013 at 2:21 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear

Re: $$Excel-Macros$$ Need a formula urgently

Your Welcome Murali ! [?] On Wed, Sep 4, 2013 at 2:53 PM, MURALI NAGARAJAN muralin...@gmail.comwrote: Dear Waseem, Thanks for your great support. On Wed, Sep 4, 2013 at 2:33 PM, Waseem Saifi waseemsa...@gmail.comwrote: Dear Murali, Please see in attachment. it might be helpful.

Re: $$Excel-Macros$$ Need a formula urgently

this is too good Rajan ! Regards, Waseem Saifi On Wed, Sep 4, 2013 at 3:01 PM, Rajan sharma rajansharma9...@gmail.comwrote: Hi Murali, Chek the attachment too. Might it will also help you. :-) With warm regards, Rajan Sharma On Wed, Sep 4, 2013 at 2:55 PM, Waseem Saifi

Re: $$Excel-Macros$$ Need a formula urgently

:) All this credit goes to this forum, Atually i have learnt from this forum and just used. Thanks With warm regards, Rajan Sharma On Wed, Sep 4, 2013 at 4:50 PM, Waseem Saifi waseemsa...@gmail.com wrote: this is too good Rajan ! Regards, Waseem Saifi On Wed, Sep 4, 2013 at 3:01

Re: $$Excel-Macros$$ need vlookup formula help

Try to use this in cell B2 *=VLOOKUP($A2,INDIRECT(' B$1 '!$B$2:$R$302),16,FALSE)** * Copy it down Pada 29/07/2013 18:22, Dhaval Shah menulis: here with attach a file for reference On Mon, Jul 29, 2013 at 4:49 PM, Dhaval Shah todhavals...@gmail.com mailto:todhavals...@gmail.com wrote:

$$Excel-Macros$$ Need help/Formula/macro on Transpose command

Hi Team, I have one excel sheet in which i need to arrange the data in such a manner that all the data will come with the help of transpose option under the one by one. i had try this by many methods but in-vain. Hence please kindly suggest formula me or share the Macro for the same. Please find

Re: $$Excel-Macros$$ Need help/Formula/macro on Transpose command

Try this. On Wed, May 29, 2013 at 1:17 PM, vikas khen vikk...@gmail.com wrote: Hi Team, I have one excel sheet in which i need to arrange the data in such a manner that all the data will come with the help of transpose option under the one by one. i had try this by many methods but

Re: $$Excel-Macros$$ Need help/Formula/macro on Transpose command

*Hi Team,* thank you very much for helping me Regards On Wed, May 29, 2013 at 1:46 PM, priti verma pritiverma1...@gmail.comwrote: Solution with formula. PFA On Wed, May 29, 2013 at 1:17 PM, vikas khen vikk...@gmail.com wrote: Hi Team, I have one excel sheet in which i need to arrange

Fwd: $$Excel-Macros$$ Need Excel Formula for Color Count

Dear Brother, What is this xlsm file as this formula is not working in my excel sheet. On Tue, Feb 19, 2013 at 11:57 AM, अनिल नारायण गवली gawlianil8...@gmail.comwrote: Dear ikhan, Pl find attached herewith. Warm Regards, Gawli Anil On Tue, Feb 19, 2013 at 11:47 AM, Imran khan

$$Excel-Macros$$ Need Excel Formula for Color Count

Hi, Can anyone help me count cell by color? I have attached sheet which i need to count all green color. regards, Imran Khan -- 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 @

Re: $$Excel-Macros$$ Need Excel Formula for Color Count

Dear ikhan, Pl find attached herewith. Warm Regards, Gawli Anil On Tue, Feb 19, 2013 at 11:47 AM, Imran khan ikha...@gmail.com wrote: Hi, Can anyone help me count cell by color? I have attached sheet which i need to count all green color. regards, Imran Khan -- Are you =EXP(E:RT) or

$$Excel-Macros$$ Need sumif formula with 2 conditions

Hi experts, Please check the attached file.In it the first table contains daily purchase data, I want to get a summery report of the same in the second table format, How can use a formula with two criteria . Regards Rajesh -- Join official Facebook page of this forum @

Re: $$Excel-Macros$$ Need excel formula

Dear Sriram, Please try it.. =INDEX($H$1:$N$1,0,SMALL(IF($H2:$N2=$C2,COLUMN($H$1:$N$1),),COLUMN(A1))-7) with ctrl+shift+Enter Hope it helps to u. See attached sheet. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com PM, sriram ji

Re: $$Excel-Macros$$ Need rank formula

Hi In G1 on sheet1 and copied across upto I1 =MATCH($A1|B2,Data!$A$2:$A$770|Data!$B$2:$B$770,0) In B3 and copied down and across, =INDEX(Data!$D$1:$BH$1,MATCH(LARGE(INDEX(Data!$D$2:$BH$771,G$1,),ROWS(B$3:B3)),INDEX(Data!$D$2:$BH$771,G$1,),0)) Both are array formulas. Kris -- FORUM

Re: $$Excel-Macros$$ Need rank formula

plz resend file corrupted       From: MURALI NAGARAJAN muralin...@gmail.com To: excel-macros@googlegroups.com Sent: Wednesday, May 2, 2012 11:00 AM Subject: $$Excel-Macros$$ Need rank formula Dear experts. I need rank formula for attached file. Thanks

Re: $$Excel-Macros$$ Need if formula

You didn’t show us your situation but, depending on your need you could use LOOKUP, vLookup Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Ashish Bhalara Sent: Tuesday, March 06, 2012 10:14 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need

Re: $$Excel-Macros$$ Need if formula

:* Ashish Bhalara ashishbhalar...@gmail.com *Sent:* Tuesday, March 06, 2012 10:14 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what

Re: $$Excel-Macros$$ Need if formula

*Subject:* Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara

Re: $$Excel-Macros$$ Need if formula

Subject: Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards

Re: $$Excel-Macros$$ Need if formula

Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Ashish Bhalara ashishbhalar...@gmail.com *Sent:* Tuesday, March 06, 2012 10:14 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need if formula Dear expert, If function used maximum 7 time

$$Excel-Macros$$ Need if formula

hi Experts, please provide if condition formula for attached sheet. Thanks, Rekah -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will

Re: $$Excel-Macros$$ Need if formula

Aren't less then 2 and between 0-2 are the same conditions ? On Tue, Mar 6, 2012 at 2:34 PM, rekha siri rekha.siri2...@gmail.com wrote: hi Experts, please provide if condition formula for attached sheet. Thanks, Rekah -- FORUM RULES (986+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$ Need if formula

0-1 = Okay 2 = Safe 2 = Needs change Use this formula - =IF(A22,Okay,IF(A22,Needs Change,Safe)) On Tue, Mar 6, 2012 at 2:42 PM, Abhishek Jain abhishek@gmail.comwrote: Aren't less then 2 and between 0-2 are the same conditions ? On Tue, Mar 6, 2012 at 2:34 PM, rekha siri

Re: $$Excel-Macros$$ Need if formula

*Try it..* =IF(A22,Okay,IF(A22,Needs Change,Safe)) On Tue, Mar 6, 2012 at 1:14 PM, Abhishek Jain abhishek@gmail.comwrote: 0-1 = Okay 2 = Safe 2 = Needs change Use this formula - =IF(A22,Okay,IF(A22,Needs Change,Safe)) On Tue, Mar 6, 2012 at 2:42 PM, Abhishek Jain

Re: $$Excel-Macros$$ Need if formula

Try this formula... =IF(A12,Check,IF(A10,Okay,Safe)) On Tue, Mar 6, 2012 at 1:17 PM, Maries talk2mar...@gmail.com wrote: *Try it..* =IF(A22,Okay,IF(A22,Needs Change,Safe)) On Tue, Mar 6, 2012 at 1:14 PM, Abhishek Jain abhishek@gmail.comwrote: 0-1 = Okay 2 = Safe 2 = Needs change

Re: $$Excel-Macros$$ Need if formula

On Tue, 06 Mar 2012 14:42:54 +0530 wrote hi Experts, please provide if condition formula for attached sheet. Thanks,Rekah -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Need if formula

Dear expert, If function used maximum 7 time in an function, if the requirement of condition if is more than 7, what is the function used or which type of condition are need to fulfill 10 different condition? Thanks regards Ashish Bhalara On Tue, Mar 6, 2012 at 5:05 PM, Sharad Gupta

Re: $$Excel-Macros$$ Need if formula

Hi, In 200 version u can use only 7 if condition however in 2007 and later version u can use 64 if condition... Thanks seraj On Tue, Mar 6, 2012 at 8:14 PM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear expert, If function used maximum 7 time in an function, if the requirement of

Re: $$Excel-Macros$$ Need a Formula or Macro

, 2011 9:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a Formula or Macro thanks for your assistance. Please take a look. Earlier did not work. Thanks, Smriti On 8/24/11, dguillett1 dguille...@gmail.com wrote: If you didn't solve this, I'll take a look? -Original

Re: $$Excel-Macros$$ Need a Formula or Macro

If you didn't solve this, I'll take a look? -Original Message- From: Baby Patel Sent: Thursday, August 18, 2011 8:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a Formula or Macro Hi All, Please find the attchement. All these data are here in the zipped

Re: $$Excel-Macros$$ Need a Formula or Macro

@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a Formula or Macro Hi All, Please find the attchement. All these data are here in the zipped file. You can use price list to find the details. Thanks and regards, Smriti On 8/18/11, dguillett1 dguille...@gmail.com wrote: It would be very

Re: $$Excel-Macros$$ Need a Formula or Macro

Since you do not give a proper example, It is not yet clear what you want. -Original Message- From: Baby Patel Sent: Thursday, August 18, 2011 8:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a Formula or Macro Hi All, Please find the attchement. All

Re: $$Excel-Macros$$ Need a Formula or Macro

I can have this done in 3 hours. Email me at excelvbasql@gmail if you want me to start. On Wed, Aug 17, 2011 at 8:08 AM, Baby Patel smritipatel2...@gmail.comwrote: Hi Guys, I need an urgent help . Attached is the excel file for your reference. Issue : I want the result in the F coulmn of

Re: $$Excel-Macros$$ Need a Formula or Macro

It would be very helpful if your data could result in an actual case with a real example. You ask to search for data that does NOT exist. -Original Message- From: Baby Patel Sent: Wednesday, August 17, 2011 8:08 AM To: excel-macros Subject: $$Excel-Macros$$ Need a Formula or Macro

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

rajanverma1...@gmail.comwrote: Hi Kabir, See if it help. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) *Sent:* Friday, May 20, 2011 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a formula

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) *Sent:* Friday, May 20, 2011 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO Dear Gurus, I need a formula for calculated

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

*To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO Dear Gurus, I need a formula for calculated two numbers and resulted output should be in a Ratio.i.e., 2:1 or 1.5:3. Thank you in advance, Regards, Saroj

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

...@gmail.comwrote: Hi Kabir, See if it help. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) *Sent:* Friday, May 20, 2011 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need a formula for getting the output of one

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

Dear Noorain, I will be thankful for your effort on my request. Regards, Saroj. On Fri, May 20, 2011 at 10:39 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Pls try it =CONCATENATE(A1,:,B1) On Fri, May 20, 2011 at 5:08 PM, Kabir:-) saroj.32...@gmail.comwrote: Dear Gurus,

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

at 10:00 AM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Kabir, See if it help. *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Kabir:-) *Sent:* Friday, May 20, 2011 5:09 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

:* $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO Dear Gurus, I need a formula for calculated two numbers and resulted output should be in a Ratio.i.e., 2:1 or 1.5:3. Thank you in advance, Regards, Saroj

Re: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

Pls try it =CONCATENATE(A1,:,B1) On Fri, May 20, 2011 at 5:08 PM, Kabir:-) saroj.32...@gmail.com wrote: Dear Gurus, I need a formula for calculated two numbers and resulted output should be in a Ratio.i.e., 2:1 or 1.5:3. Thank you in advance, Regards, Saroj. --

RE: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

Hi Kabir, See if it help. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kabir:-) Sent: Friday, May 20, 2011 5:09 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a formula for getting the output of one calculation as RATIO

RE: $$Excel-Macros$$ Need Excel Formula or VBA Function to Solve the Query.

12 décembre 2010 08:14 À : excel-macros@googlegroups.com Objet : $$Excel-Macros$$ Need Excel Formula or VBA Function to Solve the Query. Dear Experts, I have described my query in the attached workbook. I need excel formula or any appropriate function to solve my query. Please help me

Re: $$Excel-Macros$$ Need a formula help

Thanks a lot for your solution. I got it.. Regards, Vinu. On Apr 24, 9:28 pm, Harsh Gharpure hsgharp...@gmail.com wrote: For the data range you have specified, following is the solution: A           B                     C  (formula) 25         0 -100            2    -        =

Re: $$Excel-Macros$$ Need a formula help

Hello Here is your solution. Chandra Gupta On Sat, Apr 24, 2010 at 3:03 AM, vinu vinu1sm...@gmail.com wrote: Hello Frnds, I have a data like this: columnA -Data column B- range column c- Data in Range(Need formula for this), Please help me a formula to get the answer in column C.

Re: $$Excel-Macros$$ Need a formula help

For the data range you have specified, following is the solution: A B C (formula) 25 0 -1002-= countif(a1:a7,0) - countif(a1:a7,100) 150101 -200 1 --= countif(a1:a7,100) - countif(a1:a7,200) 250

$$Excel-Macros$$ Need a formula help

Hello Frnds, I have a data like this: columnA -Data column B- range column c- Data in Range(Need formula for this), Please help me a formula to get the answer in column C. A B C 25 0 -100 2 ( Need a formula to count the col A data which appears in B Col

$$Excel-Macros$$ Need a formula in picking right status

HI Expert Guru, I need a formula in finding status in column G. For reference the result expected is given in column J. The contion is the status should be picked based on the latest date. condition 2 is if the date is same for expire and active consider active At least i want the first

$$Excel-Macros$$ need array formula

Hi, How to use {=TABLE(,K11)} this type of function. -- Thanks, Gyanesh Jain, BE, MBA (Finance) +91 98868 68488 Please Save a tree...please don't print this e-mail unless you really need to --~--~-~--~~~---~--~~