R
rory_r
I'm trying to compare 2 sheets and highlight any discrapancies from the first
sheet.
Currently sheet 1 (IM) has a column of procedures, a column describing each
procedure and a column showing how many images are acceptable per
procedure(column L).(ie >1<4).
Sheet 2 is copy/pasted from another application to show Patient ID#, name
Procedure code body part description actual image number taken for this
study.
I need to highlight any studies who's image count falls outside that of the
range in the IM sheet coumn L.
This is the formula I'm using to compare the columns and use conditional
formatting to highlight discrepancies in image number, however it only uses
the last number when I use a range. for example 4 when I use >1<4.
=IF(COUNTA(D2:G2),COUNT(MATCH(D2&"*"&G2,IM!A$2:A$1151&"*"&IM!L$2:L$1151,0)),"")
How do I have the cell highlight if the actual number of images fall outside
the range in column L on the worksheet called IM?
Go easy on me I copied and tweaked this formula from another post.
Thank you in advance for your help.
Rory.
sheet.
Currently sheet 1 (IM) has a column of procedures, a column describing each
procedure and a column showing how many images are acceptable per
procedure(column L).(ie >1<4).
Sheet 2 is copy/pasted from another application to show Patient ID#, name
Procedure code body part description actual image number taken for this
study.
I need to highlight any studies who's image count falls outside that of the
range in the IM sheet coumn L.
This is the formula I'm using to compare the columns and use conditional
formatting to highlight discrepancies in image number, however it only uses
the last number when I use a range. for example 4 when I use >1<4.
=IF(COUNTA(D2:G2),COUNT(MATCH(D2&"*"&G2,IM!A$2:A$1151&"*"&IM!L$2:L$1151,0)),"")
How do I have the cell highlight if the actual number of images fall outside
the range in column L on the worksheet called IM?
Go easy on me I copied and tweaked this formula from another post.
Thank you in advance for your help.
Rory.