Formula help
Hi all
How can I express this as a formula: In J3: If any cell in the range C5:H5 contains "a", then J3 contains "a" Cells C5:H5 contain only "a", or are blank. Many thanks George |
George,
In cell J3: =IF(COUNTIF(C5:H5,"a")0,"a","") HTH, Bernie MS Excel MVP "George Gee" wrote in message ... Hi all How can I express this as a formula: In J3: If any cell in the range C5:H5 contains "a", then J3 contains "a" Cells C5:H5 contain only "a", or are blank. Many thanks George |
Bernie
That worked for me! Many thanks George *Bernie Deitrick* has posted this message: George, In cell J3: =IF(COUNTIF(C5:H5,"a")0,"a","") HTH, Bernie MS Excel MVP "George Gee" wrote in message ... Hi all How can I express this as a formula: In J3: If any cell in the range C5:H5 contains "a", then J3 contains "a" Cells C5:H5 contain only "a", or are blank. Many thanks George |
A few strokes shorter.............
=LEFT(C5&D5&E5&F5&G5&H5,1) Vaya con Dios, Chuck, CABGx3 "Bernie Deitrick" <deitbe @ consumer dot org wrote in message ... George, In cell J3: =IF(COUNTIF(C5:H5,"a")0,"a","") HTH, Bernie MS Excel MVP "George Gee" wrote in message ... Hi all How can I express this as a formula: In J3: If any cell in the range C5:H5 contains "a", then J3 contains "a" Cells C5:H5 contain only "a", or are blank. Many thanks George |
All times are GMT +1. The time now is 02:28 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com