I have a table of collected data that I want to be able to sort by Company. The Company is in column A and each row is a separate entry. I want to be able to look at just the rows for one specific company. I would also like to be able to change which company I am looking at. I have attached an example of my database. I would like to do a pivot table that will have a selection for company and then will display all rows (as they are already formatted) that have that company in them. If this is not possible with a pivot table, what other option do I have? I know that google sheets has a function called Query that does what I am looking for and would be useful if not for the fact that I need to be able to hyperlink to documentation stored on an internal server, therefore it has to be excel.
Would index and match be an option? How would I write that formula?
Bookmarks