LinkBack URL
About LinkBacks
In my case Sheet!A2:A10 may contain some data and Sheet!AB2:B10 numerical number which indicate range Sheet!A2:A10 to be repeated accordingly.
Can someone help me making a formula to solve this issue?
In my case Sheet!A2:A10 may contain some data and Sheet!AB2:B10 numerical number which indicate range Sheet!A2:A10 to be repeated accordingly.
Can someone help me making a formula to solve this issue?
Try:
=IFERROR(INDEX($A$2:$A$5,MATCH(0,INDEX(--(COUNTIF($F$1:F1,$A$2:$A$5)=$B$2:$B$5),0),0)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
A spill formulaFormula:
Please Login or Register to view this content.
Really thanks a lot for perfect and quick solution. You are always a great problem solver.
@Glenn Kennedy
Last edited by Ariful Islam; 01-20-2023 at 11:38 AM.
Than you. Your formula gives value error when any value is missing in range B2:B5.
Ok, how aboutFormula:Please Login or Register to view this content.
Sir, this exactly what i was expecting. This solution is more appreciable because this formula needs not be dragged.Originally Posted by Fluff13
Ok, how aboutFormula:Please Login or Register to view this content.
Thank you once again.
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks