Struggling for a solution
Help! I'm trying to find a formula that would work out this problem: Column "A" contains either Y or L and column "B" contains T or any other letter I need the solution to fprmulate if any cell in column A = Y and any cell in column B contains T. Y & T must always be together.:( -- Baz ------------------------------------------------------------------------ Baz's Profile: http://www.excelforum.com/member.php...o&userid=28930 View this thread: http://www.excelforum.com/showthread...hreadid=486732 |
Struggling for a solution
Baz, Try a formula along these lines in a cell to generate a value of 0 (there are no rows with both a Y in column A and a T in column B) or something other than zero (the result giving the count or rows matching the criteria). =SUMPRODUCT(--(A$1:A$13="Y"),--(B$1:B$13="T")) |
All times are GMT +1. The time now is 08:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com