sheilakhull
Board Regular
- Joined
- Jan 5, 2005
- Messages
- 95
I have 2 reports that work together. I need to be able to use formulas not vba.
One report is claim numbers in 1 column & action dates in another column. I need to locate & highlight duplicate claim numbers on this report only if the date for that claim number is the same as the other. (Same claim number can have 2 different action dates.)
On the 2nd report I need to locate & highlight duplicate claim numbers that are on the 1st report only if the action date is the same as on the 1st reports.
Thank you.
Sheila
One report is claim numbers in 1 column & action dates in another column. I need to locate & highlight duplicate claim numbers on this report only if the date for that claim number is the same as the other. (Same claim number can have 2 different action dates.)
On the 2nd report I need to locate & highlight duplicate claim numbers that are on the 1st report only if the action date is the same as on the 1st reports.
Thank you.
Sheila
