- This is a spread sheet that records numbers chosen for a lottery bonus ball. The spread sheet is a very simplified version of the one I am working with however I have extracted the problem I am encountering.
- The master spread sheet will allow me to return many different coding values to build a webpage based on the data within. I am however; stuck on a solution to this issue. I would prefer to use a formula solution as VBA is not good for Mac Excel.
- Column C checks the chosen number in Column B against a range of numbers recorded as drawn on the Draws sheet. If it finds them it marks Column 'C' with a Y.
Q: My conundrum is, I would like the Y to be marked only if the number matching was drawn after the registration date in the draws column.
You can download my spread sheet here ozgrid.com/forum/core/index.php?attachment/69161/
Any help appreciated.