View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trainee Trainee is offline
external usenet poster
 
Posts: 12
Default A column will depend in B column

My B1 to B100 are dates coming from an array formula (=MIN...)
11-Jan, 28-Jan are examples of outcome in B column.
This is the formula needed please:
If B1 (then I will copy down) IS EQUAL "0-Jan", then A1="blank"
If B1= IS NOT EQUAL "0-Jan", then A1= 1
THANK YOU!