Re: $$Excel-Macros$$ Count Names City Wise

2013-05-31 Thread Deepak Rawat
Thanx !! Regards, Deepak On Fri, May 31, 2013 at 1:20 PM, priti verma wrote: > have u enter it with CSE, > PFA for better clarification > > > On Fri, May 31, 2013 at 1:17 PM, Deepak Rawat wrote: > >> its giving 1 for delhi rather than 3 >> >> Kindly check >> >> regards >> >> >> On Fri, May 31,

Re: $$Excel-Macros$$ Count Names City Wise

2013-05-31 Thread priti verma
have u enter it with CSE, PFA for better clarification On Fri, May 31, 2013 at 1:17 PM, Deepak Rawat wrote: > its giving 1 for delhi rather than 3 > > Kindly check > > regards > > > On Fri, May 31, 2013 at 1:08 PM, priti verma wrote: > >> use this >> >> =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:

Re: $$Excel-Macros$$ Count Names City Wise

2013-05-31 Thread Deepak Rawat
its giving 1 for delhi rather than 3 Kindly check regards On Fri, May 31, 2013 at 1:08 PM, priti verma wrote: > use this > > =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""),IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""))>0)) > > > On Fri, May 31, 2013 at

Re: $$Excel-Macros$$ Count Names City Wise

2013-05-31 Thread priti verma
use this =SUM(N(FREQUENCY(IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""),IF($F$4:$F$13=A4,IF($G$4:$G$13<>"",ROW($G$4:$G$13),""),""))>0)) On Fri, May 31, 2013 at 12:59 PM, Deepak Rawat wrote: > Hi, > > I need a formula to count names of managers city wise, attached > > Pls advise > >