Feb 25 2021 11:54 PM
Hi. Recently moved over to a Mac from Windows OS.
I often search for transactions in One Drive for Excel SS, based on transaction amounts.
Since moving over to a Mac, when I enter a transaction amount in the One Drive search feature, I get zero search results.
However if I enter words (ie payees/payers/description etc) results appear.
So it seems that for some reason, my one drive search for excel transactions is not recognising digits in my search entries.
I have used figures I definitely know are present in the spreadsheets but it does not register in the search function.
(I am able to successfully used the search function within excel however need to be able to search in the One Drive folders)
Hope that all makes sense.
Feb 27 2021 11:28 AM
It does make sense, in the sense that I fully understand what you're saying, what you want to do.
What doesn't make full sense, however, is WHY you'd search that way. Specifically for a certain number, rather than a payee, or budget category, or...
I did try, prompted by your question, to do a search for a number, in my OneDrive ... and I'm also using a Mac--MacBook Air, to be precise. It worked, in that I got results. So many results, however, that I would consider it not all that helpful unless really searching for a needle in a haystack.
It makes me wonder how you've organized your files, how many (possibly redundant) spreadsheets you have that would force you to search the whole of OneDrive for the presence of 123.45 (or whatever). I keep a lot of financial records in spreadsheets, but if I'm searching for a given transaction, I'd do it in the spreadsheet that tracks those transactions. So I don't mean to be impertinent, but your question piques my curiosity. You needn't answer, but if you'd indulge us (I suspect others may wonder as well), what is the context in which this kind of search makes sense?
Feb 28 2021 12:46 PM