Thread: Find max number of character and return cell address
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John James
 
Posts: n/a
Default Find max number of character and return cell address

A simple way to see how many "?" are in each cell, enter this formula in
F18 & copy down:
=LEN(E18)-LEN(SUBSTITUTE(E18,"?",""))

This will let you sort them and see the duplicates


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=533076

Reply With QuoteReply With Quote