AccessOrange Helpdesk
  • English (US)
  • Chinese (TW)
Go to website
Back
Articles on:Excel
No description

Categories

  • Microsoft 365
  • OneDrive
  • Exchange
  • SharePoint
  • Teams Phone & Calling
  • Excel
  • Scripts
  • Intune
  • Outlook
  • Networking
  • Azure
  • ADPM
  • Active directory
  • Backups
  • Support
  • Signaturely
  • Advanced Threat Protection
  • Word
  • Microsoft 365 Tenant
  • Account/Subscription
  • Microsoft Teams
  • Virtual Machine
  • WebApp
  • Power Automate
  • Subscriptions
  • Security and Compliance
  • Security
  • OMS
  • MSP360 Backup
  • Compare 2 columns in excel
    Articles on: Excel Compare 2 columns in excel Conditional formatting Select both column                 Conditional formatting, highlight duplicate with color                 Conditional formatting, highlight unique with different color =Vlookup(A2, select range and lock,1,0) =iferror(vlooFew readers
  • **Searchable Drop Down List on Separate Sheets**
    Articles on: Excel Searchable Drop Down List on Separate Sheets Min 4 x column are required on source sheet Cell A2                  A1 is empty cell and A2 formula is (Past and Drag to end) =IF(ISNUMBER(SEARCH(INDIRECT(CELL("Address")),B2)),MAX($A$1:A1)+1,0) Original List        Original List is only your teFew readers

Not finding what you are looking for?

Chat with us or send us an email.

  • Chat with us
  • Send us an email
© 2025AccessOrange HelpdeskWe run on Crisp Knowledge.