| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Check if table contains text
I have a table with some functions that returns a text; "Buy" or "".
I would like to check rows in a column to check if any (one or more) of the functions has returned "Buy". Any suggestions on what kind of function I should use? -- Peter B Norway |
|
#2
|
|||
|
|||
|
One way:
=IF(COUNTIF(A:A,"Buy")0, "one or more Buys","no Buys") In article , "Peter B" wrote: I have a table with some functions that returns a text; "Buy" or "". I would like to check rows in a column to check if any (one or more) of the functions has returned "Buy". Any suggestions on what kind of function I should use? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| table | Excel Discussion (Misc queries) | |||
| table | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| Data Table - does it work with DDE links and Stock Tickers? | Excel Worksheet Functions | |||
| Pivot Table "Show All" Check Box missing in Excel 2000 | Excel Worksheet Functions | |||
Linear Mode
