Oct 05 2020 02:34 PM - edited Oct 05 2020 02:38 PM
I want to check if an entire column not just one cell= 415 (the number)
How to do?
Example:
IF(K3:K18=”415”,-1,1)
Data:
J K L M N O P
-1 | A | B | C | D | E | y |
1 | 415 | 25 | 5 | 40 | 1.28 | 63 |
2 | 550 | 25 | 5 | 40 | 4.05 | 21 |
3 | 415 | 95 | 5 | 40 | 4.05 | 36 |
4 | 550 | 95 | 5 | 40 | 1.28 | 99 |
5 | 415 | 25 | 15 | 40 | 4.05 | 24 |
6 | 550 | 25 | 15 | 40 | 1.28 | 66 |
7 | 415 | 95 | 15 | 40 | 1.28 | 71 |
8 | 550 | 95 | 15 | 40 | 4.05 | 54 |
9 | 415 | 25 | 5 | 60 | 4.05 | 23 |
10 | 550 | 25 | 5 | 60 | 1.28 | 74 |
11 | 415 | 95 | 5 | 60 | 1.28 | 80 |
12 | 550 | 95 | 5 | 60 | 4.05 | 33 |
13 | 415 | 25 | 15 | 60 | 1.28 | 63 |
14 | 550 | 25 | 15 | 60 | 4.05 | 21 |
15 | 415 | 95 | 15 | 60 | 4.05 | 44 |
16 | 550 | 95 | 15 | 60 | 1.28 | 96 |
Thanks. MM
Oct 06 2020 06:55 AM
The COUNTIF function in Excel counts the number of cells that meet criteria you specify.
I finally just did an overall search and replace column by column.
It would be nice to automate that.
I am not sure what is supposed to be before ' .@Hans Vogelaar' in this reply. I hope this post is readable.
MM
Oct 06 2020 07:23 AM
The forum automatically starts a reply with @username where username is the one you're replying to. There isn't supposed to be anything before it.