If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|