Ask Experts Questions for FREE Help !
Ask
    SteveG1972's Avatar
    SteveG1972 Posts: 4, Reputation: 1
    New Member
     
    #1

    Dec 1, 2008, 12:52 PM
    Excel formula
    Have a Excel doc with 15 pages, around 120 rows (representing days with 1 row representing either 3 or 4 day so that 2 rows is 1 week) and 60 columns on each page, data appears a either a 1 or 2 and only in 8 columns in each row. What I want to do is create a formula that can tell me how many days pass on average, covering all pages on in the doc, between either a 1 or 2 appearing on that column any help you can give me will help as I am not that good with computers
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #2

    Dec 1, 2008, 04:53 PM

    Your description is impossible to visualize.

    If you will post a sample workbook showing a range of days and then the answers you'd like to see (and where) and how you manually figured out that example answer, I'll look at a way to automate that so you can expand it to your needs.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Which user is locking an excel file [ 2 Answers ]

Hi all, Over a TCP/IP Network or other Microsoft similar networks, Is there any utility or a way to find who is using or locking an excel file? Much appreciated Joe

A formula [ 6 Answers ]

Three-fourths of a number increased by 1 is 7. what is the number.

Excel spreedsheet [ 1 Answers ]

I am attempting to setup a excel document for this problem: You insert 50 dollars a month in a savings account that will draw 6% interest a year for 40 years. What will you have in the end? How will I insert this in Excel to show what was obtained at each year?

How to get words of figures in Excel [ 2 Answers ]

In Excel, I want to put any value of figure in word. e.g. as in cheque there is figure in numeric as well as in word i.e. "Rs 45010/-" where is Rs is currency symbole in India this is in word will be "Rupees fourtyfive thousand ten ". I want convert the numeric figure in word in other cell .[/


View more questions Search