can a formula check for a certain value in a range?
Hi all,
I am looking for a formula function that checks to see if a named range contains a paticular entry. Similar to the =IF(DATA!Mark='Computer',d16,""), where instead of '=' I need to check if the range 'contains', 'Computer' in any one cell or a number of cells. Range: The range is a number of rows of mixed data defined by the columns. The cells in the first column in the range are merged, to contain the name of the person all the rest of the data refers to. The rest of the columns in the range can contain text, numbers or remain blank. I'm sure there must be something but I can't find it! |
You can use countif if the cells are contiguous
=COUNTIF(Range,"*Computer*)0 will return TRUE for hits also it is never a good idea using merge too many problems involved and you can easily get similar layout without it Regards, Peo Sjoblom "Lee IT" wrote: Hi all, I am looking for a formula function that checks to see if a named range contains a paticular entry. Similar to the =IF(DATA!Mark='Computer',d16,""), where instead of '=' I need to check if the range 'contains', 'Computer' in any one cell or a number of cells. Range: The range is a number of rows of mixed data defined by the columns. The cells in the first column in the range are merged, to contain the name of the person all the rest of the data refers to. The rest of the columns in the range can contain text, numbers or remain blank. I'm sure there must be something but I can't find it! |
All times are GMT +1. The time now is 06:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com