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

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

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,141,932
Messages
5,709,408
Members
421,635
Latest member
mehdi hannechi

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