LinkBack URL
About LinkBacks
Hi,
I have 3 dates in column A.
A1= 2/12/2015
A2=2/13/2015
A3=2/16/2015
I have used Small & Large formula to get the earliest and latest Dates in another sheet.
But i am unable to get the date which is in cell A2.
Can anyone help?
Thanks,
Netaji
Hi,
I have 3 dates in column A.
A1= 2/12/2015
A2=2/13/2015
A3=2/16/2015
I have used Small & Large formula to get the earliest and latest Dates in another sheet.
But i am unable to get the date which is in cell A2.
Can anyone help?
Thanks,
Netaji
Try:
=large(a1:a3;2)
Hi Gerry,
I have tried that solution too,
It is not working.
Thanks
Hello Netaji
what do you mean for second latest date?
es. today is 2/16/2015 serial number 42051
than I have a data set
42050
42047
42048
42004
41025
so the the second latest day means the second large day
and in thi exaple the second largest is 42047
maybe you need to somenthings else?
let me know!
Agree this should work. Perhaps change ; to ,...Originally Posted by GerryZucca
=large(a1:a3,2)
If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thanks for reply FDI.
Yes i noticed that typo.
The problem is i have formatted the values to date.
You can just copy and paste the values i have given in the thread.
It is not working.
Thanks,
Hello Ntaji,
The formula: =Large(a1:a3,2) as provided by FDibbins, works for me. Are you sure about your formatting, and that you do not have any leading or trailing spaces, which may occur if you have a cell formatted as "Text".
Alternatively, as FDibbins suggested,
Attach a sample of your Workbook.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Yes I got it.
There was a space.
Thanks for all your support.
I am relieved now.
Thanks again to all those who spent time on the solution.
Netaji
Hi Ntaji,
Thank you for the feedback, glad we could help.
Regards.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks