 |
|
| Browse | Ask | Answer | Search | Join/Login |
|
|
||||
|
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
|
||||
|
||||
|
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. |
||||
| Question Tools | Search this Question |
Add your answer here.
Check out some similar questions!
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
Three-fourths of a number increased by 1 is 7. what is the number.
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?
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
|
