Excel এ Data Validation সটে করে ভুলরে থকেে বাঁচুন

Excel G Data Validation †mU K‡i wbb Avi fz‡ji nvZ †_‡K evuPzb

ai“b, GKwU we`¨vj‡qi wk¶v_©x‡`i 1g †_‡K 5g †kªwYi wk¶v_©x‡`i GKwU Z_¨ kxU ˆZwi Kie| †mLv‡b bvg, Rb¥ ZvwiL, evevi gvwmK Avq, me©‡kl cix¶vq cÖvß †gvU b¤^i BZ¨vw` Kjvg i‡q‡Q|

Avwg Pvw”Q, Rb¥ ZvwiL Gi N‡i †hb Ggb ZvwiL nq †hb GKRb wk¶v_©xi eqm me©wbæ 5 Ges m‡e©v”P 14 nq| Avevi evevi gvwmK Av‡qi N‡i †hb, 2000 †_‡K ïi“ K‡i 15000 nvRvi ch©š— nq| me©‡kl cix¶vq cÖvß †gvU b¤^i †hb 600 Gi †ewk bv nq| GUv Kxfv‡e Ki‡Z cvwi|

1 cÖ_‡g QK ˆZwi K‡i †nwWs¸‡jv wj‡L †dwj|

2 Gevi bvg¸‡jv wj‡L †dje|

Rb¥ ZvwiL

* Gevi Rb¥ Zvwi‡Li †mj¸‡jv wm‡j± K‡i Validation ev Data Validation G wK¬K Kwi|

* Validation criteria Gi Aax‡b Allow G Date wm‡j± Kwi|

* Data †Z wK¬K K‡i  Between wm‡j± Kwi

* Start Date-G †h Zvwi‡L Rb¥MÖnY Ki‡j †h‡Kvb wk¶v_©xi eqm 5 n‡e †m ZvwiL wjwL

* End Date Gi †h Zvwi‡L Rb¥MÖnY Ki‡j eqm 14 n‡e  †m ZvwiL wjwL|

* Gevi Avwg PvB‡j Input Message G Ggb wKQz wj‡L ivL‡Z cvwi †hb H Cell wU wm‡j± Kivi mv‡_ mv‡_ †mB †g‡mRwU †`Lvq| †hgb: '1/1/1998 †_‡K 1/1/2012 Gi g‡a¨ ZvwiL wjLyb|

* Gevi Av‡iKwU KvR Ki‡Z cvwi †mUv n‡”Q, Avwg hw` fzj ZvwiL BbcyU Kwi A_©vr Avgvi

ïi“ I †kl Zvwi‡Li evB‡ii †Kvb ZvwiL wjwL †mUv mv‡_ mv‡_ GKUv †g‡m‡Ri gva¨‡g e‡j †`‡e Ges Gw›Uª †b‡e| †hgb: 'Avcwb fzj Z_¨ cÖ‡ek Kwi‡q‡Qb, `qv K‡i mwVK Z_¨ Gw›Uª Ki“b'| Avi GUv Ki‡j PvB‡j Error Alert G wK¬K K‡i wj‡L w`‡Z n‡e|

evsjvq †g‡mR wjL‡Z PvB‡j BDwb‡KvW e¨envi K‡i wjL‡Z n‡e|

†kªwY:

GKUv KvR Ki‡Z cvwi †mUv n‡”Q: †kªwY †h Cell ¸‡jv‡Z wjLe †m Cell ¸‡jv‡Z Kvm©i ivL‡jB GKUv WªcWvDb wj÷ †`Lv‡e †hLv‡b 1g †_‡K 5g †kªwY  ch©š— †jLv _vK‡e| Avi H wj‡ó wK¬K Ki‡jB Gw›Uª n‡q hv‡e A_ev ûeû †h‡Kvb †kªwY UvBc Ki‡Z n‡e| Ab¨_vq Error Message †`Lv‡e| G KvRUv Ki‡Z PvB‡j cÖ_‡gB Ab¨ GB dvB‡ji Ab¨ †Kv_vI wb‡P wb‡P 1g 2q 3q 4_© 5g wj‡L ivL‡Z n‡e|

* †kªwY †jLvi †mj¸‡jv wm‡j± K‡i Validation ev Data Validation G wK¬K Kwi|

* Validation criteria Gi Aax‡b Allow G List wm‡j± Kwi|

* Source Gi Wvbcv‡k †h jvj wPnœwU i‡q‡Q †mUv‡Z wK¬K Kwi|

* Gevi †hLv‡b 1g 2q 3q 4_© 5g wj‡L †i‡LwQjvg †mB Cell ¸‡jv wm‡j± K‡i G›Uvi w`B|

* c~‡e©i b¨vq Input Message Ges Error Alert wj‡L w`‡q (hw` cÖ‡qvRb g‡b Kwi) Ok Kwi|

Gevi †`Lyb †kªwb Cell ¸‡jv‡Z Kvm©i ivL‡jB WªcWvDb wj÷ †`Lvq|

evevi gvwmK Avq

evevi gvwmK Avq 2000 †_‡K ïi“ 15000 Gi g‡a¨ ivL‡Z PvB‡j

* Gevi Rb¥ Zvwi‡Li †mj¸‡jv wm‡j± K‡i Validation ev Data Validation G wK¬K Kwi|

* Validation criteria Gi Aax‡b Allow G Whole Number wm‡j± Kwi|

* Data †Z wK¬K K‡i  Between wm‡j± Kwi

* Maximum-G 15000 Ges Minimum G 2000 wjwL

* c~‡e©i b¨vq Input Message Ges Error Alert wj‡L w`‡q (hw` cÖ‡qvRb g‡b Kwi) Ok Kwi|

GLv‡b Data †Z wK¬K K‡i Between, Equal to, Grater than, Less than, Not between, Not equal to, Greater than equal to, Less than or equal to wm‡j± K‡i A‡bKfv‡eB Avgiv fzj WvUv Gw›Uªi nvZ †_‡K evuP‡Z cvwi|

*** Excel 2007 G Ki‡Z PvB‡j Awdm 2003 Gi g‡Zv Menu Bar BÝUj K‡i wbb GLvb †_‡K| Zvici me GKB iKg|

Tags: G‡·j, Excel, WvUv †fwj‡Wkb, Data Validation, Data validation in Excel