[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Auto Fill problems

Posted on 2013-02-05
7
Medium Priority
?
293 Views
Last Modified: 2013-02-05
I have a sheet with values for every 15 minutes across a 24 hour period I want to break the 15 minute values down into 5 minute blocks across a 24 hour timeline broken down into 5 minute blocks relevant to the matching time period. Auto fill doesnt seem to be working as planned i can do the formulas manually but there is a lot to do. Maybe some sotrt of if statement may work but the autofill problem keeps causing isses
autofill.xlsx
0
Comment
Question by:titanium123
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
7 Comments
 
LVL 35

Expert Comment

by:Norie
ID: 38858106
Do you mean the formula in row 12?

If you do then try this formula, in column A and copy across.

=MATCH(A11,1:1,1)
0
 
LVL 14

Expert Comment

by:Faustulus
ID: 38858133
Try this formula. You should be able to autofill it to the right.
=OFFSET($A$2,0,(-INT(COLUMN()/-3))-1)

Open in new window

0
 

Author Comment

by:titanium123
ID: 38858141
yes thats right the formula in row 12. I tried the match formula it counts in groups of 3 but continues to increase as below not return the value

=MATCH(A11,1:1,1)
1      1      1      2      2      2      3      3      3      4      4      4
0
Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

 

Author Comment

by:titanium123
ID: 38858165
Hi Faustulus tried =OFFSET($A$2,0,(-INT(COLUMN()/-3))-1) just returns a #
0
 
LVL 35

Accepted Solution

by:
Norie earned 2000 total points
ID: 38858192
Sorry, forgot to complete the formula.

=INDEX(2:2,1,MATCH(A11,1:1,1) )
0
 

Author Comment

by:titanium123
ID: 38858204
excellent thanks for your help saved me hours
0
 
LVL 14

Expert Comment

by:Faustulus
ID: 38858207
Yes, I was able to generate the response you got. The reason is the cell formatting. If you increase the column width to accommodate the result you will see the result instead of the pound signs. You can also format the number to Integer, so long as it fits the column width.
0

Featured Post

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article helps those who get the 0xc004d307 error when trying to rearm (reset the license) Office 2013 in a Virtual Desktop Infrastructure (VDI) and/or those trying to prep the master image for Microsoft Key Management (KMS) activation. (i.e.- C…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question