Results 1 to 5 of 5

COUNT and MATCH Column Heading

Threaded View

  1. #1
    Registered User
    Join Date
    04-13-2019
    Location
    Oregon, USA
    MS-Off Ver
    Microsoft Office Home & Student 2019 Version 2301
    Posts
    79

    COUNT and MATCH Column Heading

    I am having a problem with my spreadsheet. i enter numbers from 1 to 36 in cells C3:F22. So when I type 29 in cell C3 it should lookup the corresponding number in cell O31. Then in P31 is the number 4, which matches with the column heading K2 so K3 should have a count of 1 now.

    Then in cell E3 I have the number 30. So that should lookup and match the number 30 in cell O32. In P32 is the number 4, which matches the column heading in K2 which also has a 4 so now the count in K3 should go to 2. Thanks for your help.
    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. [SOLVED] count items in column chosen by column heading
    By ab0ajh in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-26-2023, 01:17 PM
  2. [SOLVED] Paste by Column Heading Date Match
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-10-2021, 11:11 PM
  3. Count specific wording in column heading
    By morerockin in forum Excel General
    Replies: 5
    Last Post: 09-24-2016, 10:40 AM
  4. [SOLVED] VBA Sum Figure Which Match Both Column & Row Heading
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-19-2014, 12:47 PM
  5. [SOLVED] Only count data from column with a particular heading
    By codyryan in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-18-2014, 07:09 PM
  6. [SOLVED] VBA Count Records Which Match Column Heading
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-20-2014, 05:24 AM
  7. Count if column heading is
    By nd2828 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-09-2012, 03:08 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