Excel Array Formula Tutorial: Comparing Lists of Values in Excel

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

Awesome. I had a similar enough problem to say you fixed it for me. =) I'm wondering now if there's a way to produce a list of cells that do not match a given criteria in the comparison. Say you would want to list the users who have not met their pledges.

pappapez
Автор

can you post the completion of the video please? thanks!

kggeq
Автор

rewatch the your formula was asking if left was bigger than right .... and formula was saying - YES :D
The problem is that you SUMed > :D :D :D :D :D :D

StefanStoykov