Re: $$Excel-Macros$$ Want a shortcut to browse tabs, alas, classic code found is not working.

2011-08-09 Thread Viswanathan M
p://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><&g

Re: $$Excel-Macros$$ How to Find Last Present Date From Month in One column

2011-07-31 Thread Viswanathan M
ird ranges should be of mixed referencing. regards viswanathan m On Sun, Jul 31, 2011 at 5:50 PM, Daniel wrote: > Hi, > > ** ** > > In AF2 (array formula, validate with Ctrl+Shift+Enter) : > > ** ** > > =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2="P",CO

Re: $$Excel-Macros$$ Simple Code

2011-07-17 Thread Viswanathan M
om > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><

Re: $$Excel-Macros$$ Pivot Table Help

2011-03-26 Thread Viswanathan M
Dear Mr. John, =SUM(NOT(B2=""),NOT(D2=""),NOT(F2="")) The above formula will help you for finding out the Total Deliveries *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 *Vande* *Mataram* On Sat, Mar 26, 2011 at 9:57 PM, John A. Smith wrot