LinkBack URL
About LinkBacks
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
This one works perfect too, thanks hemesh, all of you are great experts.Originally Posted by hemesh
Hope one day I could have the 1% of your excel knowledge
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks