Search results

Yeah, what clapham_gull said is a good option (or you can use more old school web queries with Excel which more people would be familiar with), and companies house has an API where I imagine you can pass in the company registration number as a variable (from Excel possible or using JSON I...

Where is the average being calculated from, is it a column in the pivot table? Eg Product,cost Eggs,1 Milk,5 Cheese,2 So on this chart you would want a horizontal line at 2.66? (8/3) as avg cost (if the column is already an average you cant take an average of the average as the...

I would consider (even if its not needed immediately) 2 more columns , Country, Division for lookups, pivots etc

Probably the most efficient way to tackle Q1 is to have a reference table called say, menu, which is just a list of all the teams Then use Hyperlink function to navigate to the worksheet of the same name eg =HYPERLINK("#"&A2&"!",A2) Reason I would use the lookup list in column A us so you can...

In what part of Excel do you require expertise? Would be cool to share it on here, always learn/teach something on an Excel thread. PM me if it's private information