Creating a formula that will determine if a code type occurs within 90 days of anotherspecific type
Hello all
I have a spreadsheet with multiple columns and multiple rows. The idea is to determine if an “E&M” code was paid within 90 days of the “Intraocular” procedure for each MEMNO. The problem with the formula I tried (I tried an If/And formula), is that I cannot incorporate those “E&M” types that come BEFORE the “Intraocular” procedure. I am including a sample to show as an example of how I would like the formula to work. Any assistance would be greatly appreciated.
Thanks
Last edited by wheddingsjr; 10-16-2018 at 12:12 PM.
|