officeautomata functions

Apply custom functions to your workbooks with Cortana.

  • Compare Different Lists
    • Say: Compare Different Lists
    • Or Say: Find the difference between two lists
  • Bold the unique items (in a range of cells)
    • Say: Bold the unique items
  • Remove Empty Rows or Columns from a sheet
    • Say: Remove all the empty rows
    • Say: Remove all the empty columns
  • Highlighting
    • Say: Highlight the above average items
    • Say: Highlight the above average items in <range>
    • Say: Highlight the below average items
    • Say: Highlight the below average items in <range>
    • Say: Highlight the cells between <number> and <number>
    • Say: Highlight the bottom <number>
    • Say: Highlight the bottom <number> percent
    • Say: Highlight the cells that contain <any>
    • Say: Highlight the dates occuring <h_dates>
    • Say: Highlight the duplicate items
    • Say: Highlight the cells equal to <number>
    • Say: Highlight the cells greater than <number>
    • Say: Highlight the cells less than <number>
    • Say: Highlight the top <number>
    • Say: Highlight the top <number> percent
    • Say: Highlight cells that contain a value
    • Say: Highlight the unique items
  • Remove highlighting
    • Say: Clear highlighting
  • Count a number of items
    • Say: Count the number of <value>
    • Or Say: Count the number of items that arn't <value>
    • Or Say: Count the number of <value> and <value>
    • Or Say: Count the number of items that arn't <value> and <value>