Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I'm trying to come up with the least amount of code to count every 5th cell that contains text or data in column A starting with row 1. In other words, the following would return a count of 3 records: Column A 1 John Doe 2 Jiffy's 3 101Main 4 Anywhere, MI 79999 5 6 Jim Johnson 2 Jim's Trim 3 1019 Gilmer Rd 4 Jackson, TX 79555 6 7 David Smith 8 Smith MFG 9 109 E Whatley 10 Smithville, Fl 78666 11 12 13 14 15 16 Any help with the code will be greatly appreciated! mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=401529 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Count Text Data | New Users to Excel | |||
Sum / count data from text string with delimiter | Excel Worksheet Functions | |||
how can i count text in a ranges of data | Excel Worksheet Functions | |||
Group and Count Text Data More Efficiently | Excel Worksheet Functions | |||
count G4:G51 for critera only if D4:D51 contains text data | Excel Worksheet Functions |