Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidating Data between worksheets that removes dulicates | Excel Discussion (Misc queries) | |||
Consolidating with empty-string ("") cells removed | Excel Worksheet Functions | |||
Remove Duplicates; How can I get a list of items removed? | Excel Discussion (Misc queries) | |||
HOW DO I SORT A COLUMN OF NUMBERS AND HAVE THE DUPLICATES REMOVED | Excel Discussion (Misc queries) | |||
Consolidating a Row of data from many worksheets | Excel Worksheet Functions |