Search results

Thank you for the information. But It would take me the same amount of time to just count the objects as it would to minpulate the report each month. I was hoping there was a way to count them without having to split the column.

Good Afternoon, Is there a way to count how many unique records I have in the same cell. One of the reports that is exported from my core system puts employees names in the same cell separated by a semi colon. There are several different companies on this report and I need to count the...

I am using 2010.

Thank you Shailyog, however this does not count unique records in column A. Luke I have looked at the other posts and when I try to use them, excel is giving me an error. Here is what my report looks like: A B C D E F G H Account number Amount 1 … … … … … … $0.00 2 … … … … … …...

Thank you for the suggestion. I have tried both of those and they are not working.

Good Morning, I am trying to count unique records in column A based on whether Column H is a positive number. If column H = $0.00 I do not want to count the corresponding record number in Column A. I have used the following formula to count the unique records but I cannot figure out how to...