Thread: Capitalize Text if 2 lists are equal
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
elevdown
 
Posts: n/a
Default Capitalize Text if 2 lists are equal

I want to compare 2 lists on separate worksheets - (A2:A9) on both
sheets. The lists contain text. If the lists are equal I want the text
in cell A1 on the second worksheet to be "PROPER"case. If the lists are
not equal I want the text to be "UPPER" case. Can I use a standard
formula or an array formula to do this? Thanks for any help!


--
elevdown
------------------------------------------------------------------------
elevdown's Profile: http://www.excelforum.com/member.php...o&userid=29668
View this thread: http://www.excelforum.com/showthread...hreadid=493762

Reply With QuoteReply With Quote