Can't find known cell values in excel spreadsheet
Hi,
I have an excel spreadsheet that has a column of simple functions in it, =a1-b1, =a2-b2, etc.
Whenever you try to search the worksheet for values that are known to be in these fields it will not find them, regardless of whether you search by value or formula.
I have tried recreating the values and the formula's, but as it is quite an extensive spreadsheet I haven't recreated the whole spreadsheet (Last resort!)
If anyone has any ideas or anything to check please let me know
Thanks
M@
I have an excel spreadsheet that has a column of simple functions in it, =a1-b1, =a2-b2, etc.
Whenever you try to search the worksheet for values that are known to be in these fields it will not find them, regardless of whether you search by value or formula.
I have tried recreating the values and the formula's, but as it is quite an extensive spreadsheet I haven't recreated the whole spreadsheet (Last resort!)
If anyone has any ideas or anything to check please let me know
Thanks
M@
JP
I have not been able to get excel to search a formula for text if that is what you are trying to do. VBA can do it. If you just want to see where the formulas are you can press Ctrl + ~ to toggle between formulas and values.
mattclarified,
I cannot reporduce the behavior. Can you upload a smallish sample that does exhibit that behavior, along with the work steps you are using?
Patrick
I cannot reporduce the behavior. Can you upload a smallish sample that does exhibit that behavior, along with the work steps you are using?
Patrick
What exactly are you searching for? Can you give some specific examples?
ASKER
I have narrowed it down now, it seems to only happen on the one sheet. The reason it would not find the value when using "look in: Values" was because of the comma separator. It seems on this sheet, whenever you use the "look in: Formulas" option it will not find anything.
The data is pretty basic, I can't upload the spreadsheet as the data is sensitive, but have included some screenshots.
Thanks
M@
The data is pretty basic, I can't upload the spreadsheet as the data is sensitive, but have included some screenshots.
Thanks
M@
I think we need actual data, dummy will do.
ASKER
The problem is, if I copy it, it's fine, but the spreadsheet is too big to sit there copying bits out to another spreadsheet unless it is the final option!
Like Patrick I cannot replicate this unfortunately.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Closing question as no one could help being as the problem was quite bizarre. Ended up rebuilding the sheet in another file