Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data

2013-11-16 Thread xlstime
attachment missing . Enjoy Team XLS On Thu, Nov 14, 2013 at 9:46 AM, Rajan sharma wrote: > Dear experts, > > > I am unable to write the formula for the attached excel file. > Please help me to create formula please..i have tried many a times, but > unable to w

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Rajan sharma
Dear Sirs, I want to find the Closest match from A and D column. i mean if the word contains in A column similar to D column (it may be 1st , 2nd or any middle line or last line) then the closest matches should be lookup. I hope i could able to explain you all experts, Thanks to all for

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Anil Gawli
Dear rajan, Pl elaborate more on this query Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Thu, Nov 14, 2013 at 11:57 AM, Rajan sharma wrote: > Dear all experts, > > Is my query is valid ? can we lookup the closes

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Ashish Kumar
Dear Ranjan, Are You want delete all the rows which contain orange data in column E. in sheet one. Thanks, Ashish On Thursday, 14 November 2013, Rajan sharma wrote: > Dear all experts, > > Is my query is valid ? can we lookup the closest data as like the > attachment earlier. Please h

Re: $$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Rajan sharma
Dear all experts, Is my query is valid ? can we lookup the closest data as like the attachment earlier. Please help on the attachment. Thanks to all. With warm regards, Rajan Sharma On Thu, Nov 14, 2013 at 9:49 AM, Rajan sharma wrote: > Sorry- attachment missed > Dear experts, > > >

$$Excel-Macros$$ Formula require for Conditional and Lookup data-

2013-11-13 Thread Rajan sharma
Sorry- attachment missed Dear experts, I am unable to write the formula for the attached excel file. Please help me to create formula please..i have tried many a times, but unable to write. I have elaborate my query in the file itself. Please please find the attachment. Thanks a ton

$$Excel-Macros$$ Formula require for Conditional and Lookup data

2013-11-13 Thread Rajan sharma
Dear experts, I am unable to write the formula for the attached excel file. Please help me to create formula please..i have tried many a times, but unable to write. I have elaborate my query in the file itself. Please please find the attachment. Thanks a ton in advance. With warm reg

Re: $$Excel-Macros$$ Formula require

2013-07-05 Thread Bé Trần Văn
* Tuesday, 4 June 2013 4:49 PM > *Subject:* $$Excel-Macros$$ Formula require > > Hi Team, > > i want to get formula to find Total value of cars with black color only. > pls help. > > Rgds, > Prabhakar > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Formula require

2013-07-05 Thread Anil Kumar
From: Prabhakar S H To: excel-macros@googlegroups.com Sent: Tuesday, 4 June 2013 4:49 PM Subject: $$Excel-Macros$$ Formula require Hi Team,   i want to get formula to find Total value of cars with black color only. pls help.   Rgds, Prabhakar -- Are

Re: $$Excel-Macros$$ formula require

2013-06-20 Thread Prabhakar S H
Hi Vinay, You are really expert in excel. can you explain me how this formula works. Also share me your mobile no pls. On Tuesday, June 18, 2013 4:55:08 PM UTC+5:30, Vinay Saraf wrote: > Revised File > > On Tue, Jun 18, 2013 at 4:47 PM, priti verma > > > wrote: > >> pfa >> You can use this

Re: $$Excel-Macros$$ formula require

2013-06-18 Thread priti verma
Great trik On Tue, Jun 18, 2013 at 6:05 PM, De Premor wrote: > Little tricky :D > > > On 18/06/2013 19:13, priti verma wrote: > > Hi Prabhakar, > previous solution was not dynamic , please see another approach > > > On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H wrote: > >> Hi Team, >> >> I

Re: $$Excel-Macros$$ formula require

2013-06-18 Thread Vinay Saraf
Revised File On Tue, Jun 18, 2013 at 4:47 PM, priti verma wrote: > pfa > You can use this one also, > > > > On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H wrote: > >> Hi Team, >> >> I want to split data into name, bank account no & ifsc code separetely in >> attached file. Please help me to get f

Re: $$Excel-Macros$$ formula require

2013-06-18 Thread priti verma
pfa You can use this one also, On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H wrote: > Hi Team, > > I want to split data into name, bank account no & ifsc code separetely in > attached file. Please help me to get formula. > > Rgds, > Prabhakar > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ formula require

2013-06-18 Thread Vinay Saraf
please find the correct solution On Tue, Jun 18, 2013 at 3:48 PM, xlstime wrote: > Hi Prabhakar, > > *Please find attached solution...hope its fulfill your requirement * > > . > > Enjoy > Team XLS > > > > On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H wrote: > >> Hi Team,

Re: $$Excel-Macros$$ formula require

2013-06-18 Thread xlstime
Hi Prabhakar, *Please find attached solution...hope its fulfill your requirement * . Enjoy Team XLS On Tue, Jun 18, 2013 at 3:12 PM, Prabhakar S H wrote: > Hi Team, > > I want to split data into name, bank account no & ifsc code separetely in > attached file. Please h

$$Excel-Macros$$ formula require

2013-06-18 Thread Prabhakar S H
Hi Team, I want to split data into name, bank account no & ifsc code separetely in attached file. Please help me to get formula. 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 @ ht

Re: $$Excel-Macros$$ Formula require

2013-06-04 Thread Prabhu Pinky
Hi Prabhakar, Please find the attached file with solution. Thanks & Regards, Prabhu R On 4 June 2013 16:49, 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 > > -- > Are you =EXP(E:RT) or =NOT(EXP(

Re: $$Excel-Macros$$ Formula require

2013-06-04 Thread अनिल नारायण गवली
Dear Prabhakar, See the attached workbook. Warm Regards, Gawli Anil On Tue, Jun 4, 2013 at 4:49 PM, 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 > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in E

Re: $$Excel-Macros$$ Formula require

2013-06-04 Thread priti verma
try this =SUMIFS($J$9:$J$17,$H$9:$H$17,"Cars",$I$9:$I$17,"black") On Tue, Jun 4, 2013 at 4:49 PM, 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 > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel

$$Excel-Macros$$ Formula require

2013-06-04 Thread Prabhakar S H
Hi Team, i want to get formula to find Total value of cars with black color only. pls help. 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

$$Excel-Macros$$ Formula Require to calculate Medical Reimbursement on Date of Joining.

2013-01-23 Thread Prabhakar S H
Hi Team, Pls help me to get Formula based on attached file. yearly we have to pay rs. 3500/- if some one joined mid of the year then on pro-rata basis we have to pay Medical OTC. Pls help. Rgds, Prabhakar -- Join official Facebook page of this forum @ https://www.facebook.com/discusse