+ Reply to Thread
Results 1 to 3 of 3

find and then count values in a specific column

  1. #1
    Registered User
    Join Date
    04-11-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2010
    Posts
    96

    find and then count values in a specific column

    in column M , it contains values in the range 30000000000 to 399999999999 , count number of values in between 3000000000 to 3090000000 ans assign it to variable "mubashar" and count values in the range 3100000000 to 3100000000 and assign it to "iqbal", thanks
    need command click coding

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: find and then count values in a specific column

    Please Login or Register  to view this content.
    Check / change threshold values as needed.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: find and then count values in a specific column

    Try this...

    Please Login or Register  to view this content.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro to find all specific values in column and replace adjacent cell values
    By dblock02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 06:03 AM
  2. Replies: 1
    Last Post: 04-19-2013, 08:30 PM
  3. Find specific values in a column
    By amivshek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2011, 02:54 PM
  4. Count column w/blanks & values based on specific date
    By nickelcell1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-30-2009, 04:08 PM
  5. Count specific text values contigent on value in next column
    By rgarber1950 in forum Excel General
    Replies: 2
    Last Post: 05-21-2008, 11:23 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