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

-- *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 mviswanat...@bsnl.co.in 94861 00423 *Vande* *Mataram* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks

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

be of mixed referencing. regards viswanathan m On Sun, Jul 31, 2011 at 5:50 PM, Daniel dcolarde...@free.fr wrote: Hi, ** ** In AF2 (array formula, validate with Ctrl+Shift+Enter) : ** ** =INDEX($A$1:$AE$1,1,MAX(IF($B$2:$AE$2=P,COLUMN($B$2:$AE$2 ** ** Copy down

Re: $$Excel-Macros$$ Simple Code

To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 mviswanat...@bsnl.co.in 94861 00423 *Vande* *Mataram

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

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 johnasmit...@gmail.comwrote: I have