Unique values in google sheets: Difference between revisions

From Cramsession
Jump to navigationJump to search
✍️ Verified Author: MflavellClick to view professional profile & credentials
(Created page with "Use the following formula =UNIQUE(''sheet''!''column'':''column'') foe example =UNIQUE(report!C:C)")
 
No edit summary
 
Line 3: Line 3:
  =UNIQUE(''sheet''!''column'':''column'')
  =UNIQUE(''sheet''!''column'':''column'')


foe example
for example, report tab, column C


  =UNIQUE(report!C:C)
  =UNIQUE(report!C:C)

Latest revision as of 18:10, 28 March 2025

Use the following formula

=UNIQUE(sheet!column:column)

for example, report tab, column C

=UNIQUE(report!C:C)