![]() |
#3
|
||||
|
||||
![]()
There are many possible solutions. Please post a sample sheet (no pics please) where the patient's name/ ID have been anonymized, but without changes to the dates, as they might be text looking like dates, not real dates ( formatting is how dates are presented to the outside world, it's the underlying data that is important.
If, after removing eventual manual alignments, your dates are left aligned in the cell, they are text ( although they look OK) requiring some additional treatment
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
Peterson | Excel | 2 | 04-05-2021 09:43 PM |
Merging all data between two sheets into a third one without duplicates or rows or columns | Ricko_uk | Excel | 4 | 08-27-2020 01:16 AM |
Split selected columns, or all columns exept for Column1 | Cendrinne | Word VBA | 2 | 09-20-2019 09:14 PM |
![]() |
cjamps | Excel Programming | 27 | 12-18-2017 06:38 AM |
Duplicates | riothecat | Excel | 1 | 02-28-2017 03:31 PM |