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)

AttachmentSize
REQUIREMENT.xls19 KB
Vishesh's picture

Use Data Validation

Use Data Validation