Use the EXACT function to compare cell values, including upper and lower case.

Get the links on my Contextures website:

http://www.contextures.com/podcasts/pc20170518.html

Pivot table sorting, how to split date and time, symbols in drop down lists, and many more tips.

Get the links on my Contextures website:

http://www.contextures.com/podcasts/pc20160306.html

See the pivot table survey results, navigation tricks, dashboard design ideas, and many more tips.

Get the links on my Contextures website:

http://www.contextures.com/podcasts/pc20150831.html

Pivot table survey, chart tricks, Power BI update information, and many more tips.

Get the links on my Contextures website:

http://www.contextures.com/podcasts/pc20150817.html

See the Excel Survey results, create a seating chart for an event, compare Excel and Power BI, and more tips

Get the links on my Contextures website:

http://www.contextures.com/podcasts/pc20150803.html

Copy just the numbers in a column, show the month or day name for a date, let me know if you love or hate Excel

Get the links on my Contextures website:

http://www.contextures.com/podcasts/

Use Rank in Excel pivot table, find free Excel add-ins, and more tips

Get links on my Contextures website:

http://www.contextures.com/podcasts/

In this week's Excel Roundup,

--Watch a video on Taking Dashboards to the Next Level

--See how Excel handles the display and entry of dates

--Learn how to build a nested IF formula

--Move fields in a pivot table

and many more Exce tips

Pivot Table % Running Total, best file format, build Excel add-in

Check formulas, fix Excel tables, save time with shortcuts, Power BI