hi everyone,
i try to show who's name staff will Expiry in this month of this year (June,2016) from table =today()
Thank you.
hi everyone,
i try to show who's name staff will Expiry in this month of this year (June,2016) from table =today()
Thank you.
How's the attached?
hello
I want only in yellow table show name staff like this function but I don't know how
=IFERROR(INDEX(B3:B17;SMALL(IF(YEAR(B1)=YEAR(J3:J17)*(MONTH(B1)=MONTH(J3:J17));ROW(B3:B17)-1;"");ROW()-10));"")
Like this?
but it's not like that, can fix this function
=IFERROR(INDEX(B3:B17;SMALL(IF(YEAR(B1)=YEAR(J3:J17)*(MONTH(B1)=MONTH(J3:J17));ROW(B3:B17)-1;"");ROW()-10));"")
function.jpg
I propose the following formula.Formula:
=IF(AND(MONTH(J3)=MONTH(B$1),YEAR(J3)=YEAR(B$1)),B3,"")
Enter N3 in cell and pull down.
thanks for help all i want show formula like how i want it i find it in this sheet but a problem how i used in my sheet! if can put this formula in my sheet, thanks
See more variants.
See more variants in accordance with the post №7.
Thank you so much, Czeslaw & cdubisms, Everything is working perfectly now. Thanks for your time and effort.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks