count values

Hi, Can anyone write me a formula that counts cells which have exactly the same value or the same text by each row? The result should be looking something like this: <tbody> A B C Result AlicK* Alick* Alick* 2 B.Mus. B.MUS. B.MUS. 2 Cl. Cl cl. 0 Corel Corel Corel 3 </tbody> Any help...

Hi, I am trying to do a tricky part and I really need help here. I am trying to check how many blanks there are below the current cell, and if there is more than 6, then run some code. If there is not more than 6, I will check for 5, then 4 and so on until 0. I thought I could add this as an IF...

Dear members, I am working as a Logistic consultant and optimizing processes is a big part of my job. I often have this issue that I need to count the number of unique values where I have a lot of data in. For example: I have 80.000 SKU's and 5.2000.000 orderliness a year, I like to find per...

I am a intermediate user of Excel and am in the process of learning more. I have a spreadsheet of sales data. Our sales is very easy. If the sales person works alone the get 100% of the deal, or 1 count. If two people work on a sales deal together they share the deal 50/50, or .5. I have two...

Dear all, I have tried now for several days to solve this problem and would be so thankful for any help. I use Excel Mac 2011 and have the problem that if I want to display the count for values in multiple columns side by side, the count for column 2 repeats the same numbers as for count in...

Hello, I am struggling with figuring out a way to count ALL the cells (blanks included) UNTIL the last valued cell is reached in a row, below an example of my spreadsheet and the count i would like to get. (goal 1 can be ref as cell A1) <tbody> goal 1 goal 2 goal 3 goal 4 goal 5 goal 6 goal...

I want to count a mixed sequence of values contained in a single column and show how many of each value occur, in order. Here's some sample data and desired output: Sample data: A A A B A B B A A B Desired output: A 3 B 1 A 1 B 2 A 2 B 1 How can this be done (preferably not using VBA, but if...

Hi, I've got an excel sheet in which the amount of hours someone worked on a day are administrated (column c) by date (column b in 'dd mmm' format). When someone didn't work, the cell has to be empty. I want to count the days that someone worked, including today. <table border="0"...