How to count unique values in a column based on 2 conditions (in different columns)

How to count unique values in a column based on 2 conditions

I just want to share a sample worksheet in Excel where you might find helpful in your work. The worksheet does exactly what the title says: "counting unique values" in one column based on the conditions in other columns.

This is especially useful if you are working on raw data especially those exported from your accounting systems or inventory systems and data are just tabulated in columns which of course contains several duplicates. When you are to count such unique data, this worksheet can be helpful.   

(SOLVED) All contacts in Windows Live Mail are gone or not syncing

Windows Live Mail contacts missing
Consider this scenario: You have been using Windows Live Mail for quite a long time. Everything is working fine and you just loved it. After several months or even years of using it, you have accumulated a lot of email addresses or contacts in your Windows Live Mail.
Then suddenly a disaster came. You opened Windows Live Mail one day and all your contacts are gone. You accessed your email account on the web and all contacts are intact there. But not in Windows Live Mail.
Then you start blaming Microsoft. LOL!

How to Watch FREE Live Streaming of Cricket World Cup 2015

How to Watch FREE Live Streaming of Cricket World Cup 2015
This is good news to the lovers of the Cricket sports! Yes, you can watch the Cricket World Cup 2015 streaming for free using free streaming services on the links below.
These services are available in Pakistan, but when you are using Google Chrome, you can install the free plugin called "Hola Better Internet" so that you can bypass the geo-restrictions of the free streaming services.

A closer look at the world's leading project management software: TEAMWORK

A closer look at TEAMWORK, the world's leading project management software
TeamworkPM as the world's leading online Project Management (PM) software is packed with features that every project manager, collaborator and member needs. In today's world that is fast paced with technology, project management is getting more and more complex.

How to extract the unique values or data in a column with duplicate data

How to extract unique data in a column
Suppose you have a spreadsheet at work and one of the columns contain a huge list of account numbers being exported from your company's accounting system that contains a lot of duplicates. And you are tasked to extract the UNIQUE account numbers in this huge list.

[SOLVED] Cannot open any emails in Windows Live Mail 2012. Cannot reply to emails as well

Windows Live Mail problem solved
Millions of Microsoft Windows users are also using its free email client called Windows Live Mail 2012, the new email client after Outlook Express in Windows XP was discontinued. Also, this Windows Live Mail 2012 is only one of the programs in the free software suite called Windows Essentials 2012.

Get Microsoft Windows 10 as a FREE upgrade!

Upgrade for free to Windows 10

The leading Operating System company - Microsoft - announced Wednesday, that it will offer free upgrades to its newest Windoes version, called Windows 10.

How to setup Google DNS in your Windows computer

Use Google DNS to solve connectivity problems

This is a very common issue with internet connections: you are able to access certain websites and other sites are inaccessible; websites that you used to access before became inaccessible even though the said sites are up and running; you are getting frequest "Page cannot be displayed" error and something similar and reloading the page loads the site thereafter; and a lot more.

How to use HostGator Coupons for Maximum Discount

Save with hostgator hosting coupons

One of the widely used and trused hosting company in the world is HostGator. Today, it has powered several millions of websites: corporate sites and portals, blogs and other online stuffs.

Do I need an e-commerce website?

Do you need an e-commerce site?

Most people especially those technologically challenged ones find an e-commerce system a very huge solution for small-time or startup businesses. They are partly correct. 

Think of Amazon, E-bay, NewEgg, and most computer manufacturers like HP and Dell, they are huge companies so they can afford to build and maintain an online marketing portal - an e-commerce system.


Subscribe to Technical Forum RSS