Search:

Type: Posts; User: PRADEEPSWALSE; Keyword(s):

Search: Search took 0.00 seconds.

  1. Replies
    3
    Views
    107

    Re: Calculation after using IFERROR

    Hi,

    Thanks for the reply.
    It is working fine at my end.....

    Thanks for the solution.

    Regards,
    Pradeep
  2. Replies
    3
    Views
    107

    Calculation after using IFERROR

    Hi,
    I have used IFERROR function which returns cell (B5) to blank cell e.g. Cell ‘B5’ shows blank cell. I want to display cell B5 as numeric (which comes from VLOOKUP) or blank cell (if value is not...
  3. Re: Locking and formatting cell based on variable values of other cells

    Hi,

    Thanks for the solution.

    It works good.

    Sorry for late reply and once again thanks.
  4. Re: Locking and formatting cell based on variable values of other cells

    Hi,

    In my case A1, A2, A3....
  5. Re: Locking and formatting cell based on variable values of other cells

    Hi,

    If I run macro 'LockCells' manually then it works.

    Is it possible to run macro after entering value in certain cells?
  6. Re: Locking and formatting cell based on variable values of other cells

    Hi,
    I tried by clearing A1, A2 but not working at my end.

    I am using MS office 2013. I am not aware VBA.
    I have downloaded file (Sample Excel File_123_1.xlsm) sent by you and saved in Desktop...
  7. Re: I need help in excel for locking and formatting cell based on variable values of other cells

    Can you please send excel file with empty cell of A1 & A2?
    So that I can enter 'CL' in A1 cell and will observe the result at my end i.e. B1 is locked with red color filled.
  8. Re: I need help in excel for locking and formatting cell based on variable values of other cells

    Hi,

    Please download sample file from this link https://we.tl/t-dPMqmsd63M.

    Something is missing from my end. What I have done is mentioned in my earlier post.

    My requirement is :

    If A1...
  9. Re: I need help in excel for locking and formatting cell based on variable values of other cells

    Hi,

    Thanks for the solution but it is not working at my end. May be I missed something. I am new to VBA.

    Refer attached ‘Sample Excel File_123.xlsx’ for your ready reference.
    I have unlocked...
  10. Locking and formatting cell based on variable values of other cells

    Hi,
    I need help in excel for locking and formatting cell based on variable values of other cells

    If A1 cell is having value of “CL3” or “GP1” or “GP2“ or “GP3“ or “GP4“ or “SB1“ or “SB2“ or...
  11. Re: Search text and display required information

    Hello,

    Okay.

    Now I am facing another problem.



    <tbody>
    MOC
  12. Re: Search text and display required information

    Thanks for the solution. It is working fine and I getting desired results.

    Can you please explain that how this formulae is working?

    This will help me in future, if required.
  13. Re: Search text and display required information

    Hello Sir,

    This is short word fixed by me for some material. I want use this short word (i.e. C01, L01 etc.) to other place.
    If cell contains text "ASTM A106 GR.B" then in next cell shows "C01"...
  14. Search text and display required information

    Hello,

    I am attempting to use a formula that will search for key words in text fields of cells and return the appropriate category.
    =LOOKUP(9.99999999999999E+307,SEARCH(" "&MOC&" "," "&$C2),CODE)...
Results 1 to 14 of 14