Perhaps something along these lines ..
Sample construct at:
http://www.savefile.com/files/5870594
Display AutoComposed Sentence_Rao_newusers.xls
Put in E8: =IF(NOT(ISNUMBER(B8)),"",TRIM(SUBSTITUTE(A8,"Form" ,"")))
Copy E8 down to E12
Then put in A6:
=IF(COUNTA(B8:B12)=0,"","List of "&SUBSTITUTE(TRIM(E8&" "&E9&" "&E10&"
"&E11&" "&E12)," ","/")&" Form Received.")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Rao Ratan Singh" wrote in message
...
Sir,
I have have a worksheet which have columns in this manner -
A B C D
Concession Form Received
6 "List of C / D Form Received."
7 Form Form No. Date Amount
8 C Form
9 D Form
10 C Form
11 C Form
12 D Form
I want to do that The sentence "List of C Form Received" or List of D Form
Received" List of Due D form", List of Due C Form", 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 & Regards
Rao Ratan Singh