austin350s10
Active Member
- Joined
- Jul 30, 2010
- Messages
- 321
So I have a table contains a series of data organized by 26 payroll dates within a year. This table contains a set of numbers with quarterly information on it as well, so 4 values instead of 26 values like the rest of the table. I am trying to find a way to extract just the 4 quarterly values so I can create a table with just the 4 quarterly labels instead of 26 payroll date labels.
I think what I need is a formula that will look at an entire column of data and pull out the 1st, 2nd, 3rd and 4th value. I was thinking 4 separate formulas one to pull the 1st value, one for the 2nd value, one for the 3rd value and the 4th. Can this be done?
Below is an example of the table I am working with.
I think what I need is a formula that will look at an entire column of data and pull out the 1st, 2nd, 3rd and 4th value. I was thinking 4 separate formulas one to pull the 1st value, one for the 2nd value, one for the 3rd value and the 4th. Can this be done?
Below is an example of the table I am working with.