How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask WesPCDr Your Own Question

WesPCDr
WesPCDr, Information Systems Manager
Category: Microsoft Office
Satisfied Customers: 1503
Experience:  Microsoft Office Specialist
21171802
Type Your Microsoft Office Question Here...
WesPCDr is online now
A new question is answered every 9 seconds

I work in a hospital and have to review a daily spreadsheet

Customer Question

I work in a hospital and have to review a daily spreadsheet that represents daily medications ordered (white rows) and the administration of those medication orders (blue rows). There are times when there will be, for example, 3 orders for tylenol but only two administrations, which means on the following day the oppisite should occur.
Is there anyway to remove orders and admin duplicates and only leave non matching rows in the spreadsheet?
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  WesPCDr replied 1 year ago.

Hi, I can help answer your question.

Expert:  WesPCDr replied 1 year ago.

There are a couple of ways to filter or remove duplicate rows, it does involve using the filtering feature in Excel.

Follow the steps in this link to remove / filter the duplicate rows: https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2

Customer: replied 1 year ago.
does not remove both entries. I am trying to leave only non matching items. Formatting is not working for me either. I'll just buy a book - move on to someone else
Expert:  WesPCDr replied 1 year ago.

Sorry to hear that the filtering did not work.

Expert:  WesPCDr replied 1 year ago.

Unfortunately, The filtering does not resolve formatting.

Expert:  WesPCDr replied 1 year ago.

Please let me know if you need additional help and rate my answer based on your satisfaction. Thank you.

Related Microsoft Office Questions