If the Column I have input Texts (Cell N4:N12, i.e., A, T and S) then in Column K Date 1 is filled and Column L Date 2 is not filled then need to extract the Column H numbers excluding duplicates by formula in light yellow cells P7:P25.
If the Column I have input Texts (Cell N4:N12, i.e., A, T and S) then in Column K Date 1 is filled and Column L Date 2 is not filled then need to extract the Column H numbers excluding duplicates by formula in light yellow cells P7:P25.
Sekar
Try this in P7:
=IFERROR(INDEX(H$4:H$256,MATCH(0,IF((COUNTIF(N$7:N$12,I$4:I$256))*(K$4:K$256<>"")*(L$4:L$256=""),COUNTIF(P$6:P6,H$4:H$256),""),0)),"") Ctrl Shift Enter
Hello 63falcondude
Amazing, Thanks for your formula, it working fine.
This will help me to eliminate the manual work.
Thanks again.
You're welcome. Thanks for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks