• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    vlookup with vba

    how to vlookup sheet1 data in sheet2 with vba
  2. S

    password recovery

    is there any process to recover lost password of a excel sheet with out any help of password recovery software.
  3. S

    is it possible with a formula

    I have a database in column A.it's call "chain list" & it's just look like this; > 08382657-SAMARENDRA DUTTA [15] -8-262   - - -- -- - > 08398900 - RUPAK BHOWMIK [ 14 ] -8-262   - - -- - -- - -- - > 08294964 - CHITTA RANJAN DEBBARMA [ 8 ] -8-262   - - -- -- - > 08408726 -...
  4. S

    VBA

    I have data in sheet1 as given bellow; 435 4564 65464 6546 456 6767 767 5677 now i just wanted to know how do i clear those data with a clear button using VBA & how do i create this button in sheet1.
  5. S

    split

    how dose i split the bellow mention text from; A1 hbbj-54564-bhjbj-65666 to; A1 B1 C1 D1 hbbj 54564 bhjbj 65666 with a formula (with out using rext to columns.
  6. S

    date

    A B C D 01/01/2001 01 01 2001 07/02/2011 07 02 2011 28/09/2007 28 09 2007 Is it possiable,plz help me.
  7. S

    text

    ch no- 503610 dt- 14/11/12 ch issued to Rupan debnath mcode- 3246196 for the month of sep-12 Ch no- 503850/ DT- 17-12-12 , Shilpi Begam M-6003990/ Against oct-12 Comm. ch no- 503899 amt paid to bikash das mocde3993781 against advance commission recovery for the month of oct-12 Ch no-...
  8. S

    figure out

    Hi Narayan Sir, Your excel data base looks like this; ID name rank 346814 SURAJ LIMBU 8 507000 HOITHIANDAN VAIPHEI 8 453366 LALCHHUA NAWMI 8 453040 R C LALHMINGHLUA 8 453370 P C LALTHAZAMA 8 259250 BISWANATH WARISA 9 453109 CHONGPI VAIPHEI 9 271831 BISHNU...
  9. S

    figure out

    ID NO NAME RANK 252306 HIMANKA PRAKSH NATH 18 252326 TIMIR KANTI NATH 1 252301 ATUL CHANDRA DAKUA 7 260196 JYOTSNA DAKUA 16 252351 AKTAR HUSSAIN MAZUMDER 11 252361 AMRITA SHEE 10 259250 BISWANATH WARISA 9 257444 SIBU KUMAR CHETRI 15 346814...
  10. S

    help me

    PLAYER NAME IDENTITY CODE POINT A 22 12 B 25 11 C 65 10 D 23 9 E 11 8 F 44 7 G 85 6 H 18 5 I 84 4 J 98 3 K 67 2 L 77 1 as we can see the above shown database contains three headers(PLAYER NAME,IDENTITY CODE,POINT) I just wanted when i enter a IDENTITY CODE...
  11. S

    help

    PLAYER NAME IDENTITY CODE POINT A 22 12 B 25 11 C 65 10 D 23 9 E 11 8 F 44 7 G 85 6 H 18 5 I 84 4 J 98 3 K 67 2 L 77 1 as we can see the above shown database contains three headers(PLAYER NAME,IDENTITY CODE,POINT) I just wanted when i enter a IDENTITY CODE in D1 cell...
  12. S

    plz help me

    I have a database in A1 looking like this 085650777 656464 08356343 08354350854 655557 083453454 544408474 545640875 08433333 343345 08450844 as we can see some numbers contains 08 as first two digits.I just wanted to know is there any formula which eliminate or separate those...
  13. S

    late fine calculation

    i have a policy which monthly installment is rs 15000,if i am unable to deposit it in every month, i have to give 2.5% of interest as a late fine every month.now i just wanted to know if i am unable to deposit my monthly installment near about 6 month, then how do i calculate my 6 month late...
  14. S

    value only formula

    is there any value only formula which copy only the value of a formula. for example, a1 a2 =2*2 4 a1 formula value is 4,where a2 contains the value only of a1. is there any one who can help me.
  15. S

    over write or over paste

    suppose i have some data in a1 & b1.every one of us know that when we over write or paste other data in a1 & b1,the previous or existing data will eliminate.i am looking some formula or tricks that the previous data of a1 & b1 will automatically run down at a2 & b2 when the new data is typed or...
  16. S

    Separate names from text

    Amt. paid to Swapna Das for bb. comp. against a/f. no- A07635737 doc- 30.07.07 676766 Chq. issued in favour of Dulal Debnath for bb. comp. against a/f. no- A07273936 doc- 31.07.07 sir,this time i just wanted to know how to separate names from any sentence or texts using one & only...
  17. S

    vlookup

    CODES NAMES APPLICATION NOS 461627 ANUKUL DAS C084813671 461627 MANIKA DEBNATH C086512235 461627 LAKSHI RANI SHIL C086512248 461627 JHUTAN DEBNATH H112678019 461627 ANAY CHAKRABORTY C084813685 461627 SANTOSH DAS C084813686 Sir,i have a above mentioned...
  18. S

    help: separate dates from text

    hi sir, please help me out. currently i am posted as a computer operator at rose valley group of companies.i just wanted to know how do i separate dates from texts.its look like this... pay to mr arun das rs 1000 on 07/08/0212 against bill no 67775 pay to mr krishan lal rs 1000 against...
Back
Top