david_davidovich
New Member
- Joined
- Sep 14, 2021
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
Hello all.
I have a huge excel sheet with several columns. Of those, two columns are important for me. Let’s call them “A” and “B” columns. “A” and “B” contain one of many text or number values (like 1 of 20). First, i need a formula which gives me "1" (true) if
- “A” column contains one of the several sought values --- let’s say we have a column with colors, and i need to filter for “red” OR “blue” OR “yellow”
AND
- “B” column contains one of several sought values --- in this, i have IDs which contain letters as well as digits, let’s say filter for “AAA000” and “AAA111”
If it’s false, I just need a 0 / false.
It is important for me to filter for the whole columns because the actual needed formula because
1. this database is in daily use so it gets new rows every day
2. at the end i need to summarize the number of cases (rows) where both column values proved to be true (1).
It would be best if i just got a final formula which gives me a single number of the summarized cases. But it's also good if you give me something with which i can create a new column either containing "1" or "0" for every row, and then i just summarize that column.
Thank you very much in advance.
I have a huge excel sheet with several columns. Of those, two columns are important for me. Let’s call them “A” and “B” columns. “A” and “B” contain one of many text or number values (like 1 of 20). First, i need a formula which gives me "1" (true) if
- “A” column contains one of the several sought values --- let’s say we have a column with colors, and i need to filter for “red” OR “blue” OR “yellow”
AND
- “B” column contains one of several sought values --- in this, i have IDs which contain letters as well as digits, let’s say filter for “AAA000” and “AAA111”
If it’s false, I just need a 0 / false.
It is important for me to filter for the whole columns because the actual needed formula because
1. this database is in daily use so it gets new rows every day
2. at the end i need to summarize the number of cases (rows) where both column values proved to be true (1).
It would be best if i just got a final formula which gives me a single number of the summarized cases. But it's also good if you give me something with which i can create a new column either containing "1" or "0" for every row, and then i just summarize that column.
Thank you very much in advance.