Dear all,
Once again I turn to the excellent forum for help with a simple excel problem.
I have a worksheet in excel 2007. The sheet has several hundred rows, and about 100 columns.
For each row there are many blank entries.
i need to know for each row, how many consecutive columns contain data.
I'm sure this is easy, but I can't think of how to do it simply.
I've attached a dummy, simplified worksheet to illustrate the problem.
Thanks,
A
Bookmarks