— CAN YOU SOLVE THIS - EXCEL CHALLENGE 152 —
(Solutions in any language are also welcome for Excel Challenges)
Remove the Words from column A as per index in column B.
Hence if column B contains 1, 3 then 1st and 3rd words will be removed.
If a given index doesn’t appear, then there is no removal. For example. from “a, b, c, d”, we need to remove “3, 5”, then there is no 5th word here, hence only 3rd word will be removed. Hence, answer would “a, b, d”.
0 is not a valid index to be removed as index start is 1 not 0.
Post answers in Comment.
(Your formula need not be a single formula. You can write multiple formulas to arrive at a solution. Also your formula need not be different from others as long as you have worked out your formula independently)
Download Practice File - https://lnkd.in/dUtnPbuM
#excel, #excelchallenge, #powerquerychallenge, #daxchallenge, #m, #dax, #powerbi, #powerquery, #powerpivot, #sheets, #googlesheets, #data, #analytics, #businessintelligence, #finance, #office365, #python, #r
Excel BI’s LinkedIn Post