hi,
can anyone provide me help for the below situation:
mzbabar.jpg
and excel file is also attached.
In the attached file in the formula i have used index match function to search for date. match function with wildcard is used to search different texts in a particular cell and then dates which relates/corresponds to that line. what i need is that when there are 2 or 3 dates with the same texts, it should give me max and not the first one.
Thanks
Last edited by mzbabar; 11-20-2019 at 02:17 PM.
G15=IF(MAX(IF(ISNUMBER(SEARCH($E15,$D$3:$D$5)),G$3:G$5))=0,"",MAX(IF(ISNUMBER(SEARCH($E15,$D$3:$D$5)),G$3:G$5)))
control+shift+enter copy across and down
Thanks Caracalla.
Really appreciate your support.
Regards
Guys! Is there any way to avoid array formula in the above case as there are thousands of rows and when i am changing or updating the table it only do calculations for many hours and never complete with array formula.
Kindly provide support.
Amended non-array version of Caracalla's formula. In G15
=MAX(INDEX((ISNUMBER(SEARCH($E15,$D$3:$D$5))*G$3:G$5),0))
Life's a spreadsheet, Excel!
Say thanks, Click *
Thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks