+ Reply to Thread
Results 1 to 4 of 4

If max formula

  1. #1
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    If max formula

    hi to all ,i need your help on formula

    , which counts the 2222 event,what i need is to add the event of 1111 also and importand is to show zero at any other events for example: 2222 then 1 it must show 0!
    ,you can see more detail in workbook.thanks so much!!
    Last edited by louis128; 01-18-2019 at 02:21 PM.

  2. #2
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: If 1111 formula

    i know is complicated but iam sure you will try!

  3. #3
    Banned User!
    Join Date
    09-04-2018
    Location
    cyprus
    MS-Off Ver
    2007
    Posts
    282

    Re: If 1111 formula

    do we have to use vba on that?

  4. #4
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,742

    Re: If max formula

    I don't understand. Do you want to count how many times 2 was 4 or more times in consecutive rows.
    For ex.
    2
    2
    2
    2
    1
    3
    1
    2
    1
    2
    2
    2
    2
    2
    should give 2 because 1 x 4 times and 1 x 5 times, right?
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

+ 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. How can i do 1111......2222......33333......44444....
    By Ipinho100 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-16-2023, 12:03 AM
  2. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  3. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  4. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  5. Formatting ID numbers to include dashes. Ex. from this 111111111 to this 111-11-1111
    By snowthedirtbub in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-18-2013, 03:00 AM
  6. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM
  7. I need to make 111-11-1111 into 111111111
    By Crawdaddy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-22-2005, 05:05 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