User Profile
MrKevinYork
Copper Contributor
Joined Sep 11, 2023
User Widgets
Recent Discussions
Re: How to compare two large spreadsheets in Excel - 365 small Bus?
Patrick2788 This does not work in my version of office 365. I have a small business account. There is no option as listed: and it is not in the ribbon. I cannot find any other information about making it available to excel. since, as I mentioned above, my version of offices does not include this: "Inquire is only available in the Office Professional Plus and Microsoft 365 Apps for enterprise editions." I read the article several times. Problem is I do not trust free aps, and do not wish to pay more than a days pay for something that I could do in a day.Re: How to compare two large spreadsheets in Excel - 365 small Bus?
Thanks, Perhaps I will try it, but there are already conditional formatting in place. It is a shame because I have used compare functions or perhaps it was a duplicate file finder... that compared long excel sheets and was smart enough to know when the entries were the same even though they were on different lines. Perhaps there is a way to combine both sheets, sort, then highlight duplicate rows or first cells...
