joe

would this be a situation for countif or something else? Column A I have a column full of unique customer identifiers and column B I have a list of owner names so for example column A has A00000076678 and Column B has Joe Smith I need a formula for how many unique customer identifiers in...

I have a Excel Template, the workbook has sheets named "Data " and "Pivot". The data I pull comes from a CSV file which i open as excel file which i copy and paste to the "DATA" sheet Column N. When i execute the macro it formats it the way i want it and dumps the pivottable to the "Pivot"...

I have 2 reports, I want to use a key field to find the field into the other report and compare all columns after the key field, showing any differences. I'm looking for a formula to show on a different sheet the changes in list from day to day. Searching by the Name to find on the other...

Hi everyone, I am wondering if someone can help me with an issue I've been having recently. I keep track of multiple metrics for people on multiple different reports, and was wondering if there was a way to delete these people and their data across each workbook without having to manually open...

My main problem / lack of knowledge with Excel is getting formulas that look at multiple things to work. I really struggle with it... I've got 2 different formulas, but have no idea how to make it work as one... data is as follows: <tbody> A B C D E (Chris) F (Joe) 1 05/01/17 Joe 1%...