It turns out that Excel assigns values to TRUE and FALSE. and you want to easily count the number of entries that are TRUE or the number that are FALSE? So what can you do if you have a column of 10,000 entries that read TRUE, FALSE, TRUE, TRUE, TRUE, FALSE, etc. And it’s hard to scan down a list like that to count how many FALSE entries you have, if any. I generally use an IF function for that so I have blank spaces or ERROR as my values, but if you use EXACT instead you’ll have TRUE and FALSE values. You may be thinking to yourself, why would I even need this? When is that going to happen? The scenario I was looking at was using the EXACT function to compare two columns of text to identify any entries where those two columns aren’t the same value (like I do when I’m looking at AMS ad performance). So I asked myself, how could I take a column of 10,000 entries and find out how many of those entries were TRUE versus FALSE? I’m working on a new Excel title right now and I was going to put a note in there about counting the number of TRUE or FALSE entries returned by the EXACT function, but then I realized that there actually isn’t a SUMA function that would let you do that.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |