View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PJ Murph[_2_] PJ Murph[_2_] is offline
external usenet poster
 
Posts: 19
Default Can LEFT, MID, or RIGHT be used with a COUNTIF or VLOOKUP

There are single digits in Col A (0-9). I want to know how many times the
double digit numbers in Col B end in the number from Col A. (e.g. if Col
A=1then if Col B=11, 21, 31 etc a counter would increment.)