Results 1 to 23 of 23

How to count values in multiple columns?

Threaded View

yourfriend0 How to count values in... 03-06-2022, 01:19 PM
Richard Buttrey Re: How to count values in... 03-06-2022, 01:46 PM
yourfriend0 Re: How to count values in... 03-06-2022, 02:19 PM
CARACALLA Re: How to count values in... 03-06-2022, 03:09 PM
yourfriend0 Re: How to count values in... 03-06-2022, 03:24 PM
JohnTopley Re: How to count values in... 03-06-2022, 03:46 PM
CARACALLA Re: How to count values in... 03-06-2022, 03:47 PM
Pete_UK Re: How to count values in... 03-06-2022, 04:15 PM
JohnTopley Re: How to count values in... 03-06-2022, 03:22 PM
JeteMc Re: How to count values in... 03-08-2022, 09:38 PM
yourfriend0 Re: How to count values in... 03-13-2022, 07:58 PM
JeteMc Re: How to count values in... 03-15-2022, 05:14 PM
yourfriend0 Re: How to count values in... 03-17-2022, 05:14 PM
JeteMc Re: How to count values in... 03-18-2022, 11:59 AM
yourfriend0 Re: How to count values in... 03-19-2022, 05:33 AM
JeteMc Re: How to count values in... 03-21-2022, 10:58 AM
yourfriend0 Re: How to count values in... 03-22-2022, 05:04 AM
JeteMc Re: How to count values in... 03-22-2022, 10:37 AM
yourfriend0 Re: How to count values in... 03-23-2022, 05:13 AM
JeteMc Re: How to count values in... 03-23-2022, 10:18 AM
  1. #1
    Registered User
    Join Date
    11-03-2019
    Location
    EU
    MS-Off Ver
    2013 pro
    Posts
    28

    How to count values in multiple columns?

    I would like to add a count how many times each value in A column AND B column occurs on the worksheet. It is extremely important that one value is understood as whatever is in the cell of A column AND whatever is within B column of the same line. So that means one value is content of A column PLUS content of B column

    Count to be done from descending order. Count +1 can be done strictly only if there is identical match of both cells in one line with that value in some other line.

    I want to count all values where content of BOTH A and B column (left side of image) is identical to the content in same two columns in different line.

    Please see attached file EXCEL1 to find out what I want to achieve. Starting (input) data is in column A and B. The column C is to be ignored. The wanted result (output) is on the right side of same worksheet of same file: columns J and K and L. In this wanted layout of data the value is separated in two columns. It would be fine if entire value would be in one column too.

    I'm attaching file EXCEL2 which contains UNWANTED approach. It is showing entire value added in one column. Method is based on CountIf function but I cannot use it due to four problems so I'm asking for alternative, easy to follow (for beginners please!) solution. Four problems and the reasons why I cannot use Countif (secondary worksheet) are:

    1. I'm having duplicate values listed. I don't want this. As you see on Excel1 in incomplete output result, each value should be exclusive, so listed only once and then the counter right next to it. I know a way how to delete duplicate values automatically but I'm looking for a way that would count and NOT list duplicate values.

    2. The count should produce the actual value too in order to see to which value does the count belong to. As you can see in B column of List1 worksheet of Excel2 file, there is no value in output results. It's only a count and without ''x''

    3. If you look at By Date worksheet of Excel2 column: When I add new line either above third line or above 330th line, the count won't be auto updated. It has to be.

    4. Every new line I add, other lines below it will go down for one position below. I worry (and obviously don't want to worry) that lines being moved down won't be counted accurately anymore.

    What other alternative to CountIf and how exactly could I use?

    Thank you very much in advance!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to count lines with same values in multiple columns?
    By yourfriend0 in forum Excel General
    Replies: 25
    Last Post: 05-28-2021, 10:28 AM
  2. [SOLVED] Count Multiple Values accross Multiple Columns
    By Bendigus in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 08-24-2017, 01:31 PM
  3. Replies: 6
    Last Post: 08-19-2015, 07:46 PM
  4. Need to count different values in multiple columns
    By jonez19 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2014, 02:47 PM
  5. Replies: 16
    Last Post: 01-11-2012, 10:51 AM
  6. Replies: 5
    Last Post: 04-21-2011, 05:22 PM
  7. How do I count values across multiple columns?
    By elsenorjose@sbcglobal.net in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2006, 07:20 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1