LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 81
Default How to check for blank cells with formula

I have a number of cells in a row that have formulas that return either text
or "". For example:

=IF(FIND(H$1,$A3)0,H$1,"")

will return the text in H1 if cell A3 contains H1. The above formulas are
in columns E through R for each row of data. Some return text, and some
return "". I want to identify which rows return "" for all cells in that
row in column E through R by putting a formula in column S. Trouble is, I
can't figureout the formula!!! I tried CountA, but it counts cells with ""
as a cell with an entry. Any suggestions?

Bob


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Vlookup and IF statements to check for blank cells Koomba Excel Worksheet Functions 4 September 27th 08 03:54 PM
check a row ignore blank cells print only those with text Rollo Tomasi Excel Discussion (Misc queries) 4 May 18th 07 08:32 AM
check for two blank cells before populating a 3rd. slinger Excel Worksheet Functions 6 October 25th 06 08:14 PM
Need formula to check values of data in several cells as criteria VCTECH Excel Worksheet Functions 0 November 19th 04 09:54 PM
A formula to check differrent cells Carlsbad Excel Worksheet Functions 0 October 28th 04 01:19 AM


All times are GMT +1. The time now is 06:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"