Flag 1 in 5 entries
Hi
I need to write a formula which will enable my spreadsheet to flag up 1 case
in every 5 for audit (was thinking of counting 1 in 4 cases and having a flag
saying next case to be audited)
As my spreadsheet runs over the year i have implemented a total count of
cases for the year. But what i need to know is the formula to flag every 4th
case and also is there a way of putting the message (next case to be audited)
into a pop up box?
Many thanks for your help
Matt
|