$$Excel-Macros$$ MS Excel

Dear Team I have a bulky database having details of Dealer, item code and Qty, I want to make a report that which dealer has not sold which item, please help, preferably using pivot table. dealerItemaa1ba2aa3ca4aa5da6 Regards, Rajender Soni -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Ex

$$Excel-Macros$$ MS Excel

Dear Team I have a bulky database having details of Dealer, item code and Qty, I want to make a report that which dealer has not sold which item, please help, preferably using pivot table. dealer Item a a1 b a2 a a3 c a4 a a5 d a6 Regards, Rajender Soni -- Are you =EXP(E:RT) or =NOT(EXP

$$Excel-Macros$$ Unable to pick data in horizontal way.

Dear all, I am unable to create the formula as per the attached file, please have a look on this and help me to create the formula. Please find the attachment. With warm regards, Rajan Sharma -- 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)

$$Excel-Macros$$ Lookups and Tables

http://excelautomate.blogspot.in/2013/12/lookups-and-tables.html -- 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 tit

$$Excel-Macros$$ Introduction to Array Formulas

http://excelautomate.blogspot.in/2013/12/introduction-array-formulas-are.html -- 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, accura

$$Excel-Macros$$ Calling Worksheet Functions From VBA

http://excelautomate.blogspot.in/2013/12/calling-worksheet-functions-from-vba.html -- 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, a

Re: $$Excel-Macros$$ excel question

This also can be used: =COUNTA(D2:D15) Regards Pravin Gunjal. On Sat, Nov 2, 2013 at 7:46 PM, Robert Barnes wrote: > You are a GENIUS!!! > > > On Fri, Nov 1, 2013 at 6:41 PM, Sam Mathai Chacko wrote: > >> Are you looking for this? >> >> =COUNTIF($D$2:$D$15,"S") >> >> Regards, >> Sam Mathai Cha