+ Reply to Thread
Results 1 to 17 of 17

Suitable formula function to make solution

  1. #1
    Registered User
    Join Date
    07-01-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    20

    Suitable formula function to make solution

    Dear Experts.

    Please find attached file here and solve my Excel problem. The problem when I changing the description the amount not update related the particular description. Please change the formula to clear the problem.


    Thanks,

    Mohamed Iqubal M.
    Attached Files Attached Files
    Last edited by iqubalemco; 09-27-2014 at 03:56 AM.

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,841

    Re: Need suitable excel formula

    Hi,

    Check the updated sheet with sumproduct function.
    This can be done by more other methods if not satisfied i will show you other methods also
    Punnam
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    07-01-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need suitable excel formula

    Dear Punnam,

    Where the sum product formula in that sheet, I cant find the formula please help.


    Thanks,
    Mohamed Iqubal M.

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,841

    Re: Need suitable excel formula

    The cell colored in yellow

    Punnam
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    07-01-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need suitable excel formula

    Dear Punnam,

    This is really great but there is one question I need to change description but the amount not update related as per the description. please help.


    Thanks,

    Mohamed Iqubal M.

  6. #6
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,185

    Re: Need suitable excel formula

    Hi, iqubalemco,

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  7. #7
    Registered User
    Join Date
    07-01-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Need suitable excel formula

    Dear Ciao Holger,

    I have changed my post please help to make suitable formula for my relevant question.

    Thanks,
    Mohamed Iqubal M.

  8. #8
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,841

    Re: Suitable formula function to make solution

    hi iqubalemco ,

    The data is updated based on the five digest number in your description.

    Punnam

  9. #9
    Registered User
    Join Date
    07-01-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Suitable formula function to make solution

    Dear Punnam,

    Yes I agreed but the amount not update the related description (TRANSPORT,MACHINERY,SCAFFOLDING) when I replace the description like

    1. SCAFFOLDING 650.00
    2. MACHINERY 2250.00
    3. TRANSPORT 1995.00

    Please help with formula.

    Thanks,
    Iqubal M.

  10. #10
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,841

    Re: Suitable formula function to make solution

    hi iqubalemco ,

    1) Please change the title to , Like "Loookup / Index / Surmproduct extract data from sheet to another".
    2) Transport , Scaffolding , Machinery in Abstract Sheet are merged , can i un merge & change the alignment to "center along the section" , because the merged cell will mess the formula .
    Punnam

  11. #11
    Registered User
    Join Date
    07-01-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Suitable formula function to make solution

    Dear Punnam,

    No problem you can go with your possible way to make solution.

    Thanks,
    Iqubal M.

  12. #12
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,841

    Re: Suitable formula function to make solution

    hi iqubalemc,

    Check the updated file .Version 2

    Punnam
    Attached Files Attached Files

  13. #13
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,841

    Re: Suitable formula function to make solution

    HI iqubal,

    Change the thread title as i suggested you , in post 10 . this will help you to get support even from other forum members.

    Punnam

  14. #14
    Registered User
    Join Date
    07-01-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    20

    Re: Suitable formula function to make solution

    Dear Punnam,

    This is really grate thanks a lot.


    Regards,
    Iqubal M.

  15. #15
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16/365
    Posts
    52,239

    Re: Suitable formula function to make solution

    iqubalemco, " Suitable formula function to make solution" is hardly any more descriptive of your question than "Need suitable excel formula"

    It seems your question was answered, but for future reference, please consider better thread titles. If it has not been answered, please change your title to something that actually describes your problem.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  16. #16
    Forum Expert Vikas_Gautam's Avatar
    Join Date
    06-04-2013
    Location
    Ludhiana,Punjab, India
    MS-Off Ver
    Excel 2013
    Posts
    1,850

    Re: Suitable formula function to make solution

    This is much simpler.. using wild cards.
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Check the attached file.. sheet 00001
    Attached Files Attached Files
    Regards,
    Vikas Gautam
    Excel-buzz.blogspot.com

    Excel is not a matter of Experience, its a matter of Application.

    Say Thanks, Click * Add Reputation

  17. #17
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,841

    Re: Suitable formula function to make solution

    Quote Originally Posted by iqubalemco View Post
    Dear Punnam,

    This is really grate thanks a lot.


    Regards,
    Iqubal M.
    Hi Iqubal,
    If your questioned in answered and satisfied, mark the thread as solved,
    you can also thank one who helped by clicking "Add Reputation" that is "Star" symbol .

    Punnam

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. last 6 games form in soccer matches,suitable formula
    By davide2574 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-23-2014, 06:03 AM
  2. HELP Using the =if formula (or a more suitable one for my needs).
    By tomow87 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-18-2014, 11:51 PM
  3. [SOLVED] What is the suitable formula if getting error: #VALUE!
    By umais41 in forum Excel General
    Replies: 4
    Last Post: 12-31-2012, 03:19 PM
  4. Looking for A Suitable Formula for My Spreadsheet To Find Exact Matches of Data
    By Lynda Ritchie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2012, 09:22 AM
  5. Replies: 3
    Last Post: 03-29-2010, 10:07 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1