View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wingsdihard2 wingsdihard2 is offline
external usenet poster
 
Posts: 1
Default Case Sensative Subtotaling

I have a situation where I have multiple contracts which are 2 characters and
are case sensative.

Example....

Contract #1 = 'AE' (both uppercase)
Contract #2 = 'aE' (lowercase a, uppercase E)
Contract #3 = 'Ae' (uppercase A, lowercase e)

Each contract has multiple lines of sales dollars and I need to sum
according to each specific contract, maintaining the case sensativity. Is
there a way, without changing the characters, to do this??