Forum Discussion

JackP326's avatar
JackP326
Copper Contributor
Apr 16, 2020

Help and Old Man Out Please

I have attached a worksheet that illustrates the two problems that I am having.  The spreadsheet has comments in cells that shows what I am trying to accomplish.  The spreadsheet is just an example o...
Formulas and Functions
JackP326's avatar
JackP326
Copper Contributor
Apr 16, 2020

SergeiBaklan 

 

Sergi,

 

You are a Rock Star.  Thanks so much for your help

    • JackP326's avatar
      JackP326
      Copper Contributor
      Apr 17, 2020

      SergeiBaklan 

      Sergei,

       

      I have one last issue.  I don't  know the formula to accomplish my example in the E Column Rows 20-63 of the attached worksheet.  I thought I was going to be able adapt the other formula to use here but it is beyond my skills.  Any help would be greatly appreciated.  I have highlighted the area in yellow that contains the issue

       

      Jack

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor
        Apr 17, 2020

        JackP326 

        Jack, sorry, but  I didn't catch the logic.

        - why first number appears in E26, next series starts at E34, etc

        - why it is nothing between E41 and E52

        - why zero is in E30, E36 but not in E41, E63?

         

        Perhaps other similar question, for me general logic is not clear.

Resources