then try below
=MAX((D2:D1000<>"")*(ROW(A2:A1000)))-MAX((D2:D1000=E2:E1000)*ROW(E2:E1000)*(E2:E1000<>""))
copy paste above then hold control and shift together and then hit enter to make it array formula
then try below
=MAX((D2:D1000<>"")*(ROW(A2:A1000)))-MAX((D2:D1000=E2:E1000)*ROW(E2:E1000)*(E2:E1000<>""))
copy paste above then hold control and shift together and then hit enter to make it array formula
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks