Named Ranges shown (or not shown) as blue means what?

W

wdeleo

I am having trouble getting the following formula from cpearson's page to work:

IF(ROW()-ROW(NoBlanksRange)+1>ROWS(BlanksRange)-COUNTBLANK(BlanksRange),""
INDIRECT(ADDRESS(SMALL((IF(BlanksRange<>"",ROW(BlanksRange),ROW()+ROWS(BlanksRange))),
ROW()-ROW(NoBlanksRange)+1),COLUMN(BlanksRange),4)))

It removes blank cells from a list and has worked for me before. This time
I notice that when I type in a named range into the formula, it turns blue (I
assume indicating that Excel recognizes it as a variable name). But, only
one of the two named ranges turns blue, and I am getting a circular
reference error.

Insight into the blue color in relation to named ranges?

Thanks in advance,

Billy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Eliminating blank cells in a list on a ROW 5
Extract data from list -exluding blank cells 8
Removing blank cells 0
remove blank cells from list ? 0
Duplicate & Zero Values in Lists (Excel 2003) 6
Removing blanks / sorting - common methods not applicable 1
removing blanks from range (mr Pearson) 1
test for formula result 1

Top