Forum Discussion
formula to Check if cell value matches with Dynamic Row Number.
Please test the attached version.
Please test the attached version.
- I sincerely apologize, when I reviewed the solution you proposed, I didn't see the countif() statements which makes it dynamic. Your solution is spot on and I appreciate all of your assistance. Please keep doing what you are doing, it is so helpful. Best Regards.
Did you have a specific reason for doing it completely different from what I proposed in my previous reply?
I filtered your raw data for the guest name "Evans, Tony":
It appears that he checked in at two different sites on the same day and, on each occasion, departed that day from a different site. I suspect more precise timing information is required to make sense of that in order to return the information you require.
I don't believe I have yet explained my needs correctly. Attached is the final Report I need to have with the ar_site being dynamic, but as illustrated, the Guest Evans, Tony shows 121 on both occurrence with my current formula. I just need a work around so it gives the ar_site for each occurrence. Thank you.
