LinkBack URL
About LinkBacks
Hello guys,
My formula is "=+'Summary YTD'!$F$251"
Is there any way to find the "$" in the above formula.?
Please assist...
Hello guys,
My formula is "=+'Summary YTD'!$F$251"
Is there any way to find the "$" in the above formula.?
Please assist...
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!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
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
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.
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.
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
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Assume that your formula is at A1
=ISNUMBER(FIND("$",FORMULATEXT(A1))) will return True if A1 has $
Bi_Ry, OP's version looks to be 2007/2010. Im not sure Formulatext is available in those (could be wrong)
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)))
You can also investigate use of GET.CELL but tbh if you go that route you may as well use a UDF.
ctrl+~ to view the formula then fine $ sign
hope this will help you
Yes Formulatext is available from 2013.
Welcome to the forum, Xfinitycable. Do you have a question for us? If so, please start a new thread.
thank you AliGW
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks