Records | Get Digital Help

Popular categories

Conditional formatting

Drop down lists

Dashboard reporting with excel This e-book teaches you how to create your own Excel dashboard reports, starting from scratch. Learn how to create mini-charts, how to use Excel's Camera tool, how to set up Excel databases, and a lot more.

Excel Worksheet-Formula Add-Ins allows worksheet formulas to change chart settings. For the first time ever, your formulas can create traffic-light charts, highlight chart elements, assign number formats, and much more.

Get Digital Help > Excel > Records

Archive for the ‘Records’ Category

Quickly search a table using many criteria

Unique distinct records sorted by frequency

Compare two tables in excel: Remove common rows

How to sort a table in a custom order in excel

Quickly compare two tables in excel 2007

Excel 2007 pivot table: Count unique distinct records (rows)

Sum unique distinct invoices in excel 2007

Filter unique distinct records with a condition in excel 2007

Excel udf: Filter unique distinct records (case sensitive)

Quickly highlight records containing text strings in excel (AND Logic)

Quickly highlight records in a list in excel (AND logic)

Quickly highlight records in a list using multiple criteria in excel

Find duplicate records in excel 2007

Count unique distinct records in excel 2007

Compare two lists of data: Filter records existing in only one list in excel

Compare two lists of data: Highlight records existing in only one list in excel

Compare two lists of data: Highlight common records in excel

Compare two lists of data: Filter common row records in excel

Filter and highlight duplicate column records in excel 2007

Filter duplicate rows in excel 2007

Highlight duplicate rows in excel 2007

Match two criteria and return multiple rows in excel

Vlookup of three columns to pull a single record

Filter unique distinct row records in excel 2007

« previous entries

Subscribe
Blog updates by email:
Welcome! I am Oscar and here to help you! Feel free to comment and ask excel questions.
Don´t forget to add my RSS feed and subscribe to new blog articles by email.
Recent Comments
- Glenda on Populate a list box with visible unique values from an excel table (vba)
- Anil R. on Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel
- Oscar on Auto refresh a pivot table in excel
- Beth on Sum values in a range where adjacent cell value equals a criterion in excel
- Oscar on Use multiple conditions in Vlookup
- Oscar on Search for a text string in an excel table
- Oscar on Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel
- Oscar on Automate net asset value (NAV) calculation on your stock portfolio (vba) in excel
- Oscar on Use a map in an excel chart
- Jitendra on Use a map in an excel chart
Recent Posts