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

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 "-"

Excel 2007, but it only allows for one character not three On Friday, November 6, 2015 at 11:23:11 AM UTC-5, Paul Schreiner wrote: > > What version of excel are you using? > > If it is Excel 2007 or later, there is a text-to-columns option in the > "Data" tab. > > If you're looking for a VBA

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

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 -

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

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 Excel Formula or VBA Function to Solve the Query.

Hi, See attached file. The result cells are painted yellow. The formulas are array formulas (you have to validate them with Ctrl+Shift+Enter instead of “Enter”) Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de amrahs k Envoyé : dimanche