How to perform MUS sampling using excel

[chubs]

Hi Guys,

I currently have a large data set and i want to perform sampling using a random start point and an interval, example as below

Sampling interval 123,444
Random start point 39,674


1 39,674
2 163,118
3 286,562
4 410,007
5 533,451

I have an accumulative running balance as below:
A B
398.00 398.00
6,368.00 6,766.00
7,164.00 13,930.00

I want to basically select the rows that hit the sample the sample exceed the interval as above can subsequently move on to select the next sample? anyone help with an excel formula?

[AliGW]

Could you tell us a little more about your expected outcomes?

[MrShorty]

I put "mus sampling" into my favorite internet search engine, and found this page: http://archives.cpajournal.com/2005/...ntials/p36.htm The author discusses "monetary unit sampling" (assuming that you meant the same thing by "mus") as used by auditors in some detail, and includes a downloadable spreadsheet to illustrate the principles he discusses. I did not read through the entire thing in any detail. Assuming it is the same mus, I would suggest you start there.

[chubs]

Hi Guys,

I resolved it after some thinking using a combination of if and offset function.

Thanks anyways