software

Sir,
I have have a worksheet which have columns in this manner ??br />ABCD
Concession Form Received

6quot;List of C / D Form Received.quot;
7FormForm No.DateAmount
8C Form
9D Form
10C Form
11C Form
12D Form

I want to do that The sentence ?ist of C Form Received??or List of D Form
Receivedquot; List of Due D form?? List of Due C Formquot;, automatically display in
A6. only in that case when in b column in front of Form; Form No is Filled,
otherwise it should be returned blank after filtering with specific C or D
Form selection.

I hope you one of MVP will solve my problem.

Thanks amp; Regards

Rao Ratan Singh

Perhaps something along these lines ..

Sample construct at:
www.savefile.com/files/5870594
Display AutoComposed Sentence_Rao_newusers.xls

Put in E8: =IF(NOT(ISNUMBER(B8)),quot;quot;,TRIM(SUBSTITUTE(A8,quot;Formquot; ,quot;quot;)))
Copy E8 down to E12

Then put in A6:
=IF(COUNTA(B8:B12)=0,quot;quot;,quot;List of quot;amp;SUBSTITUTE(TRIM(E8amp;quot; quot;amp;E9amp;quot; quot;amp;E10amp;quot;
quot;amp;E11amp;quot; quot;amp;E12),quot; quot;,quot;/quot;)amp;quot; Form Received.quot;)

--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Rao Ratan Singhquot; gt; wrote in message
...
gt; Sir,
gt; I have have a worksheet which have columns in this manner -
gt;
gt;
gt; A B C D
gt; Concession Form Received
gt;
gt; 6 quot;List of C / D Form Received.quot;
gt; 7 Form Form No. Date Amount
gt; 8 C Form
gt; 9 D Form
gt; 10 C Form
gt; 11 C Form
gt; 12 D Form
gt;
gt; I want to do that The sentence quot;List of C Form Receivedquot; or List of D Form
gt; Receivedquot; List of Due D formquot;, List of Due C Formquot;, automatically display
in
gt; A6. only in that case when in b column in front of Form; Form No is
Filled,
gt; otherwise it should be returned blank after filtering with specific C or D
gt; Form selection.
gt;
gt; I hope you one of MVP will solve my problem.
gt;
gt; Thanks amp; Regards
gt;
gt; Rao Ratan Singh
In the sample construct, A7:B7 contains:

Form Form#
C Form 11
D Form
E Form 13
F Form
G Form 15

[Forms: C Form, D Form, etc are listed in A8:A12. B8:B12 would be where the
inputs for the form numbers are made (I've assumed that only numeric inputs
for the Form# are to be recognised)]

For the sample numeric inputs in B8, B10 and B12,
A6 will return the text: List of C/E/G Form Received.

If the sample input in B8 is cleared (corresponding to quot;C Formquot;),
A6 will then return only: List of E/G Form Received.

And so on.

If the entire input range B8:B12 is cleared, A6 will appear blank.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---