Consolidating Data Between Worksheets with Duplicates Removed
in [Functions]
|
Prev: Return Corresponding Value Based on Comparing Two Sheets of Data
Next: Excel file size increased 3 times after saving!!!!
From: JodySmithPharmD on 12 Mar 2010 07:48 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
From: Dave on 12 Mar 2010 20:11
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 > |