Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
picking some data from a column
Hi, i'm trying to run some reports on an automatically generate worksheet from our company database. Unfortunately, the data is formatted in columns something like: Column Title 1 8 12 5 15 ... 11 9 1 The data in bold is actually the lifetime average value for the data i the columns. I just need to run simple countif macros on the nonbolde data, is there an easy way to grab just the data I want? I'm kinda ne to vba and excel and havn't been given much time to read up on thing so my apologies if this is obvious -- guente ----------------------------------------------------------------------- guenter's Profile: http://www.excelforum.com/member.php...fo&userid=2556 View this thread: http://www.excelforum.com/showthread.php?threadid=38995 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
picking some data from a column
You might try this
Dim x as Long, cel as Range x = 0 For each cel in Range("A1:A250") ' <<< set to your range (this could be a variable) If cel.Font.Bold = False then x = x+1 End If Next Msgbox "The count is: " & x To avoid blank cells use: If cel.Font.Bold = False And Len(cel) 0 then -- steveB Remove "AYN" from email to respond "guenter" wrote in message ... Hi, i'm trying to run some reports on an automatically generated worksheet from our company database. Unfortunately, the data is formatted in columns something like: Column Title 10 8 12 5 15 .. 11 9 10 The data in bold is actually the lifetime average value for the data in the columns. I just need to run simple countif macros on the nonbolded data, is there an easy way to grab just the data I want? I'm kinda new to vba and excel and havn't been given much time to read up on things so my apologies if this is obvious. -- guenter ------------------------------------------------------------------------ guenter's Profile: http://www.excelforum.com/member.php...o&userid=25562 View this thread: http://www.excelforum.com/showthread...hreadid=389952 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
picking some data from a column
Thank you very much. -- guenter ------------------------------------------------------------------------ guenter's Profile: http://www.excelforum.com/member.php...o&userid=25562 View this thread: http://www.excelforum.com/showthread...hreadid=389952 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Picking a value from a table using Column and Row ranges? | Excel Worksheet Functions | |||
Picking up the latest text value in a column | Excel Worksheet Functions | |||
Picking up last value in column in Excel | Excel Worksheet Functions | |||
Picking one column of info | Excel Worksheet Functions | |||
Picking the latest entries from a column | Excel Programming |