Thread: formula required
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
finton finton is offline
external usenet poster
  
Posts: 1
Default formula required
On Dec 25, 11:22*pm, Max wrote:
Believe it's meant to be: =IF($B2= ...
in Lars' expression: =IF($B2COLUMN()-2,$A2&"-"&RIGHT("000"&COLUMN()-1,3),"")

Or $B2COLUMN()-3

Phil
Reply With QuoteReply With Quote