Consolidating Data Between Worksheets with Duplicates Removed
 

I am interested in tracking lab values that my staff enter into a daily
worksheet. I would like to compile monthly percentages (% low, % in range, %
high) but sometimes it is necessary to have duplicate data on consecutive
worksheets for my staff's workflow. These duplicate values will cause my
percentages (and absolute numbers) to be incorrect if I just sum between the
worksheets. Does anyone have a solution?

Thank you,

Jody

Consolidating Data Between Worksheets with Duplicates Removed
 

Hi,
Probably the best way is to create another set of data which excludes any
duplicates. There are many ways of doing this, depending on the nature of
your data. XL2007 can filter out duplicates in a single coloumn, but there
are other ways as well.
Regards - Dave.

"JodySmithPharmD" wrote:

I am interested in tracking lab values that my staff enter into a daily
worksheet. I would like to compile monthly percentages (% low, % in range, %
high) but sometimes it is necessary to have duplicate data on consecutive
worksheets for my staff's workflow. These duplicate values will cause my
percentages (and absolute numbers) to be incorrect if I just sum between the
worksheets. Does anyone have a solution?

Thank you,

Jody