Hi Matthew, To post the files to this news group, just reply to this email and attach the file. In my previous email, I have already marked the group (excel-macros@googlegroups.com).
-- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On 6/26/10, Matthew Kay <matthew....@optusnet.com.au> wrote: > Dilip, > > Thanks for checking. I was going crazy :) > Also if you select a cell and hit delete it clears the cell so it doesn't > count. > Is there a way to post the file to the news group? > > Mat > > -----Original Message----- > From: Dilip Pandey [mailto:dilipan...@gmail.com] > Sent: Saturday, 26 June 2010 8:05 PM > To: Matthew Kay > Cc: excel-macros@googlegroups.com > Subject: Re: $$Excel-Macros$$ Inbuilt count is counting an empty cell > > Yes Matthew, You are right. In Excel, these highlighted cells are actually > blanks and I have kind of checked this as well. Check the attach file. > Thanks. > > -- > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India > > > On 6/26/10, Matthew Kay <matthew....@optusnet.com.au> wrote: >> Dilip, >> >> >> >> Attached is the spreadsheet. I have highlighted four cells where it >> is occurring. >> >> >> >> Thanks, >> >> >> >> Mat >> >> >> >> >> >> From: Dilip Pandey [mailto:dilipan...@gmail.com] >> Sent: Friday, 25 June 2010 6:50 PM >> To: excel-macros@googlegroups.com >> Cc: matthew....@optusnet.com.au >> Subject: Re: $$Excel-Macros$$ Inbuilt count is counting an empty cell >> >> >> >> Hi Mat, >> >> >> >> Would it be possible for you to share that spreadsheet where you have >> copied cross tab query. >> >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> >> >> On Fri, Jun 25, 2010 at 12:08 PM, Mat <matthew....@optusnet.com.au> wrote: >> >> Hi all, >> >> I copied an access cross tab query into a worksheet and when I high >> lighted a couple of rows the inbuilt count function was counting the >> empty rows!?! (!?! for effect :) >> >> I used count(cell) and len(cell) and code(cell) and nothing is there. >> count(cell) returned 0. >> >> It is clear that the crosstab's empty cells have 'something in there'. >> >> Thanks, >> >> Mat >> >> -- >> ---------------------------------------------------------------------- >> ------ >> ------ >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ >> http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> <http://www.excel-macros.blogspot.com/> >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> <http://www.quickvba.blogspot.com/> >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> <http://exceldailytip.blogspot.com/> >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 7000 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and >> co-workers know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> >> >> >> >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
