Quarter Summary

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.

excel-table.png
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,224,609
Messages
6,179,882
Members
452,948
Latest member
Dupuhini

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top