p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

vba_excel thread: Sorting with Bold


Message #1 by "Stephen Carpenter" <stvc.69@v...> on Tue, 3 Sep 2002 21:22:36
Nice one - thanks

> Just put a formula in the cell next to them like

=IF(A2=A1,1,0)

|-----Original Message-----
|From: Stephen Carpenter [mailto:stvc.69@v...]
|Sent: Tuesday, September 03, 2002 9:23 PM
|To: VBA_Excel
|Subject: [vba_excel] Sorting with Bold
|
|
|Hello all........  I've got a list of over a thousand names, some in 
bold 
|and some not. The ones in bold are duplicates of the cell either above 
or 
|below e.g
|
|Mr S Martin
|Mr S Martin (Bold)
|Mrs J Mccarthy
|Mr f Jones
|Mr S johnson (Bold)
|Mr S johnson
|
|Im looking to count the cells with bold type only and put a 1 in the 
cell 
|next to them so I can do a sum() total of bold names.  All names are in 
|one column - I am totally new to VB and any help would be massivly 
|appreciated - thanks.  
|---
|Change your mail options at http://p2p.wrox.com/manager.asp or 
|to unsubscribe send a blank email to 
|

  Return to Index