![]() |
|
#1
|
|||
|
|||
![]()
It doesn't like this command. When I select "OK", it highlights "$C$6". (Please see attached image)
|
#2
|
|||
|
|||
![]() Quote:
Code:
=COUNTIF(Sheet1!$B$2:$C$6,"*"&A2&"*") |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
ubns | Excel Programming | 2 | 04-12-2015 06:31 AM |
![]() |
lily | Excel | 9 | 10-23-2014 06:21 AM |
VLOOKUP looking at another cell for its range | Rich18144 | Excel | 1 | 06-24-2014 07:56 AM |
Change formula cell range based on cell value | Scoth | Excel | 4 | 10-25-2012 07:51 AM |
![]() |
talkinglens | Excel | 6 | 12-31-2010 08:43 PM |