ขนาดวิดีโอ: 1280 X 720853 X 480640 X 360
แสดงแผงควบคุมโปรแกรมเล่น
เล่นอัตโนมัติ
เล่นใหม่
Of course, we can also use other functions, such as FILTER. =FILTER(D:D, C:C=M3)But, not all versions of Excel have the Filter function, so using the LOOKUPs functions is still a good dynamic solution.
Very powerful and useful technique 👌and a good alternative for those who cannot use the filter function
Absolutely! Not everyone has the most recent versions of Excel, so LOOKUP functions remains an excellent options. 🙏👍
How to with value of amount
Of course, we can also use other functions, such as FILTER. =FILTER(D:D, C:C=M3)
But, not all versions of Excel have the Filter function, so using the LOOKUPs functions is still a good dynamic solution.
Very powerful and useful technique 👌and a good alternative for those who cannot use the filter function
Absolutely! Not everyone has the most recent versions of Excel, so LOOKUP functions remains an excellent options. 🙏👍
How to with value of amount