+ Reply to Thread
Results 1 to 3 of 3

Need function to find when number in row doubles

  1. #1
    Registered User
    Join Date
    03-27-2020
    Location
    Wisconsin
    MS-Off Ver
    Office 2016
    Posts
    2

    Need function to find when number in row doubles

    I have a row of numbers that steadily increases I am interested having a formula or function to tell me how many days it has taken for the number to double.

    Day 1 2 3 4 5 6 7 8 9 10 11 12 13
    Data 100 111 125 138 163 175 189 200 225 255 275 325 400

    Function 7 7 7 7 6 5


    I tried a formula with the IFS statement but it gives me the #NAME? error

    =IFS(BT6/BS6>2,"1",BT6/BR6>2,"2",BT6/BQ6>2,"3",BT6/BP6>2,"4",BT6/BO6>2,"5",BT6/BN6>2,"6",BT6/BM6>2,"7",BT6/BL6>2,"8",BT6/BK6>2,"9",BT6/BJ6>2,"10"BT6/BI6>2,"11",BT6/BH6>2,"12")

    Attached a spreadsheet example
    Attached Files Attached Files
    Last edited by JackBox; 03-27-2020 at 12:35 PM.

  2. #2
    Registered User
    Join Date
    03-27-2020
    Location
    Wisconsin
    MS-Off Ver
    Office 2016
    Posts
    2

    Re: Need function to find when number in row doubles

    I apologize for the spacing I assumed it would be wysiwyg but the spacing for my example came out all wrong. The first 7 in the function row would be under the data 200.

  3. #3
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,316

    Re: Need function to find when number in row doubles

    Hi JackBox,

    You may want to follow the guidance in the "yellow" banner above and post a sample workbook with a clear picture of before and after.
    HTH
    Regards, Jeff

+ 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. Find doubles or more of number in one Column and mark them
    By MartinV10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-18-2020, 07:52 AM
  2. [SOLVED] Find doubles in a column and copy them to a seperate place
    By NewExcelNewbie in forum Excel General
    Replies: 11
    Last Post: 12-19-2018, 05:49 AM
  3. [SOLVED] Excel 2007 : How to count number of cells doubles?
    By alpha45 in forum Excel General
    Replies: 4
    Last Post: 07-06-2012, 07:34 AM
  4. [SOLVED] find doubles in number group!
    By stewart08 in forum Excel General
    Replies: 4
    Last Post: 02-19-2009, 09:44 AM
  5. function or sub to dedect doubles
    By matrixknow in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-21-2007, 04:43 AM
  6. function to find if a number is whole
    By ::Cory:: in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 08-15-2006, 03:30 PM
  7. [SOLVED] Complex Formula to Find Doubles
    By Spike9458 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-30-2006, 09:00 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