Re: FW: $$Excel-Macros$$ Count help

2014-03-19 Thread Ravi Kumar
From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *AK >> *Sent:* Wednesday, March 19, 2014 8:15 AM >> *To:* excel-macros@googlegroups.com >> *Subject:* $$Excel-Macros$$ Count help >> >> >> >> Hi All, >> &

Re: FW: $$Excel-Macros$$ Count help

2014-03-19 Thread AK
com > *Subject:* $$Excel-Macros$$ Count help > > > > Hi All, > > > > I need to count the non-blank cell from the latest month (Cell M1 -- Feb > 2014) to last blank cell and ignoring rest of the previous values. > > countblank or CountA formula is not working as

FW: $$Excel-Macros$$ Count help

2014-03-19 Thread Raviinder Nei
pfa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of AK Sent: Wednesday, March 19, 2014 8:15 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Count help Hi All, I need to count the non-blank cell from the latest month (Cell M1 -- Feb

$$Excel-Macros$$ Count help

2014-03-19 Thread AK
Hi All, I need to count the non-blank cell from the latest month (Cell M1 -- Feb 2014) to last blank cell and ignoring rest of the previous values. countblank or CountA formula is not working as they are counting all the cells in the range. For example 1: If I need to update cell N2 the value