Formula help

Donai

Well-known Member
Joined
Mar 28, 2009
Messages
543
Hi, i need a formula that will look for blanks in Col A6:A, if blank found then return error else ok


Excel Workbook
AB
3JP MorganTest
4JP MorganTest
5JP MorganTest
6JP MorganTest
7JP MorganTest
8JP MorganTest
9JP MorganTest
10JP MorganTest
11JP MorganTest
12JP MorganTest
13JP MorganTest
14JP MorganTest
15JP MorganTest
16Test
17JP MorganTest
18JP MorganTest
19JP MorganTest
20JP MorganTest
21JP MorganTest
22JP MorganTest
23JP MorganTest
24Test
Sheet2
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Glory

Well-known Member
Joined
Mar 16, 2011
Messages
640
set therange = Range("")

for each theCell in theRange
if theCell.Value = "" Then
msgBox "Error" & theCell.address
Next

Pretty crude... but maybe something like this?
 

Donai

Well-known Member
Joined
Mar 28, 2009
Messages
543
set therange = Range("")

for each theCell in theRange
if theCell.Value = "" Then
msgBox "Error" & theCell.address
Next

Pretty crude... but maybe something like this?

I am after a formula not vba code
 

Donai

Well-known Member
Joined
Mar 28, 2009
Messages
543

ADVERTISEMENT

By this comment, are you looking for just one formula in E1 that evaluates everything in one go?

Based on your sample data, what would be the result in E1?

Yes i want one formula that evaluates everything, if blanks found then return error else Ok
 

Watch MrExcel Video

Forum statistics

Threads
1,108,806
Messages
5,524,987
Members
409,614
Latest member
wile2u

This Week's Hot Topics

Top