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
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

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
 

Forum statistics

Threads
1,144,517
Messages
5,724,817
Members
422,580
Latest member
ScotIain76

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top