Named Ranges shown (or not shown) as blue means what?
I am having trouble getting the following formula from cpearson's page to work:
IF(ROW()-ROW(NoBlanksRange)+1ROWS(BlanksRange)-COUNTBLANK(BlanksRange),"", INDIRECT(ADDRESS(SMALL((IF(BlanksRange<"",ROW(Bla nksRange),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 |
All times are GMT +1. The time now is 01:48 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com