+ Reply to Thread
Results 1 to 11 of 11

How to find "$" in formula

  1. #1
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    How to find "$" in formula

    Hello guys,

    My formula is "=+'Summary YTD'!$F$251"
    Is there any way to find the "$" in the above formula.?

    Please assist...

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2013 (Win 10 - Work) & 365 Subscription (Win 10 - Home)
    Posts
    22,142

    Re: How to find "$" in formula

    I've moved your thread to the appropriate section, as it's not a Windows query.

    I don't understand what you mean by 'find' in this context. Please elaborate.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    STOP PRESS: Forum Rules Updated September 2018! Please read them here.
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

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

    Re: How to find "$" in formula

    Why exactly do you need to find the $? They are used to "absolute" or lock a cell so the reference doesnt change when it is copied.

    If you want to remove them, you could use Find/Replace
    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

  4. #4
    Registered User
    Join Date
    09-26-2018
    Location
    Canada
    MS-Off Ver
    365
    Posts
    1

    Re: How to find "$" in formula

    Do you mean you're trying to summarize only cells with $ present?

    Need more info on what you're trying to do, posting a screenshot would help.

  5. #5
    Forum Contributor
    Join Date
    05-11-2013
    Location
    Mumbai
    MS-Off Ver
    Excel 2007 / 2010
    Posts
    158

    Re: How to find "$" in formula

    Dear therealgates,

    Ye... I need to summarize only cells with $ present.

    There are too many formulas in the sheet. Some contains "$" and some doesn't.
    So when I am copying my data to another place, the output goes for a toss.

    Finding cells which contains "$" is very very time consuming.

    Please assist.

  6. #6
    Forum Guru Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Northern Ireland
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    20,329

    Re: How to find "$" in formula

    Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

    1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential information is removed first!!

    4. Try to avoid using merged cells. They cause lots of problems!

    Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
    Glenn



  7. #7
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,215

    Re: How to find "$" in formula

    Assume that your formula is at A1

    =ISNUMBER(FIND("$",FORMULATEXT(A1))) will return True if A1 has $

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

    Re: How to find "$" in formula

    Bi_Ry, OP's version looks to be 2007/2010. Im not sure Formulatext is available in those (could be wrong)

  9. #9
    Valued Forum Contributor Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    BKK, Thailand
    MS-Off Ver
    Excel2016
    Posts
    1,215

    Re: How to find "$" in formula

    FDibbins,
    Yes Formulatext is available from 2013.

    Just to improvise, Copy formula to other column eg: C1 > Ctrl+H replace "=" with " " to force that cell to text then =ISNUMBER(FIND("$",(C1)))

  10. #10
    Valued Forum Contributor
    Join Date
    10-13-2010
    Location
    UK
    MS-Off Ver
    various
    Posts
    342

    Re: How to find "$" in formula

    You can also investigate use of GET.CELL but tbh if you go that route you may as well use a UDF.

  11. #11
    Registered User
    Join Date
    08-23-2018
    Location
    UAE
    MS-Off Ver
    2013
    Posts
    32

    Re: How to find "$" in formula

    ctrl+~ to view the formula then fine $ sign
    hope this will help you

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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