Hi, I group my data in excel sheet. Like I have main assy number and then all 5 or 10 sub components belong to that. when I sort by that then all sub component come under the main assy.
But any way, If I have a date in cell from A2:A10, then I want to put formula in cell A1. that which one is the higher value in from cell range A2:A10. What ever is the higer date, then plug that in Cell A1.
Any macro or formula will be great.
Thanks in advace.
But any way, If I have a date in cell from A2:A10, then I want to put formula in cell A1. that which one is the higher value in from cell range A2:A10. What ever is the higer date, then plug that in Cell A1.
Any macro or formula will be great.
Thanks in advace.