View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
9274211 9274211 is offline
external usenet poster
 
Posts: 2
Default How do I compare two columns and return a number count

I've got a list with two columns with number values that I need to compare.

Eg. compare column A with column B for each single row. Count the number of
rows if Column A is less than Column B (for each individual row, not total
value).

Is it possible to do that?