Results 1 to 6 of 6

Putting identifier when number of rows equals 37

Threaded View

  1. #1
    Registered User
    Join Date
    03-13-2020
    Location
    Wroclaw, Poland
    MS-Off Ver
    365
    Posts
    3

    Putting identifier when number of rows equals 37

    Hi Guys,

    Maybe somebody is going to help me with the following problem:
    I was hoping in the worksheet attached:
    Column J or K. can have a formula that can Identify if -> Colum H total is not equal to 37; and if Colum H total is 37 to place an identifier on each of the rows. These are actually small tables within one tablee, with number of rows summed up for each small table. I want to have highlighted those rows that add up to 37 in each small table. I hope you got my point
    Many thanks in advance for your ideas and suggestions!

    screenshots of the worksheet attached

    Attachment 667186Attachment 667188

    Simon
    Attached Files Attached Files
    Last edited by simon86; 03-13-2020 at 09:30 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] sorting rows with unique identifier and then duplicate identifier
    By Roshan.Shakya in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-13-2019, 06:02 AM
  2. Compare rows in Excel and assign unique identifier number to the matches
    By RDMiller1955 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-01-2017, 09:59 AM
  3. Get number of rows where month equals X AND where other criteria match
    By torshen in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-01-2013, 10:48 AM
  4. [SOLVED] if cell above number equals Value, sum all number across all rows and columns
    By Portermt in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-27-2013, 06:20 PM
  5. Putting 1 in row after a specified number of rows.
    By iali in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-20-2012, 09:56 AM
  6. how to add certain rows if column equals certain number
    By cosmicgrooves in forum Excel General
    Replies: 5
    Last Post: 11-27-2007, 04:57 PM
  7. [SOLVED] putting count of the number of rows at the bottom
    By lpdarspe in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-21-2006, 07:55 AM

Tags for this Thread

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