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 G's blog
- Login or register to post comments
- 3234 reads
Use Data Validation
Use Data Validation