Sorry if this question is confusing. I'm in Microsoft Excel 2010. I have several rows of data. I would like to find the max for each specific row. But here's the catch: My formula should only take the max from visible data (not hidden). How can I do that?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!