LinkBack URL
About LinkBacks
Hello, I have a huge list of data. In the sheet is the clients name and 6 columns with varying dates. I need to check the earliest date on each row not the sheet, can I do this? Thanks
Hello, I have a huge list of data. In the sheet is the clients name and 6 columns with varying dates. I need to check the earliest date on each row not the sheet, can I do this? Thanks
Hard to say without an uploaded spreadsheet (see yellow banner) but based on the information given: on each row, for example row 2
=MIN(B2:G2) where B2:G2 are where your dates are.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thanks, heres an example (attached)
Okay, to get the earliest date in C2:H2 for example
Formula:
Please Login or Register to view this content.
Does that work for you?
Perfect, thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks