View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jeffrey[_2_] Jeffrey[_2_] is offline
external usenet poster
 
Posts: 14
Default Countif or please advice

good day,

I have two sentence, see below: and I would like to reflect respective
dollar value for these statements. If the sentence has "supply & fit"
then it will reflect a supply and price in cell A1 for example. of if
the sentece has "supply only" then it will reflect the supply only
price in cell A1. Noticed that ***** varies (it could be low, medium,
low and medium, high, very high).

Sentence 1
We have pleasure in submitting our quotation for a Supply & Fit in a
***** Wind Zone as per NZS 3604 as below:

Sentence 2
We have pleasure in submitting our quotation for a Supply Only in a
***** Wind Zone as per NZS 3604 as below:

thanks in advance.

Jeff