Formula Help

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
Here's an extract from my sheet
Abort - Jan.xls
IJKL
1NetworkdaysIntroducerIntroducerID
2NALegalMoveLegalMove
3NALegalMoveFirstActive
4NAFirstActiveYourMove
56FirstActiveNationalWestminsterHomeLoansLtd
6NALegalMoveHalifax
7NALegalMoveTheRoyalBankofScotlandplc
8NALegalMoveBritanniaBuildingSociety
9NALegalMoveIntelligentFinance
10NA#N/AMortgageAdviceBureau
11163YourMoveOneaccount
1213NationalWestminsterHomeLoansLtdTheMayfairOffice
Data


Column I is an IF Formula - When i use find & replace (to replace the NA with blanks) the query i have running from this page, does not recognise the blanks, nor does the replace work as the formula still shows

Any ideas?

TIA

Mark
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
You can't use replace to change the result of a formula. You have to change the formula so that it returns the result you want.
 

MarkAndrews

Well-known Member
Joined
May 2, 2006
Messages
1,963
You can't use replace to change the result of a formula. You have to change the formula so that it returns the result you want.

Andrew, thanks

A Query using MS Query uses this sheet, the query result must show the days (or true result of the formula)

Any idea's how to get around this?

TIA
 

Watch MrExcel Video

Forum statistics

Threads
1,113,953
Messages
5,545,153
Members
410,666
Latest member
forzasec
Top