DATA LIMITS IN EXCEL ROW
VENDORS PAYMENT DETAILS
1 2 3 4
SL.NO IN FAVOUR AMOUNT THROUGH
1 ABC LTD 30,000.00 DD
2 XYZ PVT LTD 25,000.00 CHQ
3 ZYX LTD 15,000.00 DD
4 CBA SOLUTIONS 2,000.00 CHQ
5 SOMU 8,000.00
6 RANI 6,000.00
7 RANGA 5,400.00
8 RAMANA 56,000.00
Sir
in above table i need to fill in 4th row only DD or CHQ not other characters of any like RTGS, Netbanking etc., how it is possible (details given in attached xls file)
| Attachment | Size |
|---|---|
| REQUIREMENT.xls | 19 KB |
»
- vinod's blog
- Add new comment
- 281 reads

Use Data Validation
Use Data Validation