ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Every 5th (https://www.excelbanter.com/excel-discussion-misc-queries/266281-every-5th.html)

tekhnogod

Every 5th
 
Hi,

I need some help writing this formula.

Given that every fifth client needs one advisor, how do I write a formula that accounts for this? The information is not provided nor listed so I can not simply use (A1+A6+A11..etc etc.)

Any ideas? Thanks.

~Tom


All times are GMT +1. The time now is 07:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com