excel2016

At my work I have two databases with the same products. The first database contains all the products with all possible combinations (in this istance the database consists of motor exhausts, which are available in different colors and materials). The second database only contains the base...

Hi everyone, I'm trying to connect my Excel workbook to a postgresql database. I've found this link on the internet but it didn't really helped me. https://support.office.com/en-us/article/Connect-to-a-PostgreSQL-database-Power-Query-bf941e52-066f-4911-a41f-2493c39e69e4 In fact, they are...

I have various options in the C2 cell as A,B,C & D (using list command in data validation). I have various options in cell D2 as 4,5,6. So I want to make formula for cell E2 in such a way that when A and 4 is selected in options it gives value 0.1. If A and 5 is selected, it gives 0.2. If B & 1...

The data source has columns 1 to 25. I need to insert several Totals columns each adding the values of 5 columns (Total1 = Col1+Col6+Col11+Col16+Col21; Total2 = Col2+Col7+Col12+Col17+Col22; .........;Total5 = Col5+Col10+Col15+Col20+Col25) Other than manually adding five lines of...

Dear all, As I am a total newbie, I ask for your understanding. I am not even sure if my problem can be solved using excel. I must maintain a list of certain mechanical components that are installed in three types of machines, scattered around different locations in the country. The problem...

Hi All, I just upgraded to Windows 10 and am now on Excel 2016. When i do a pivot table with dates it automatically put's a month header above the dates which I would rather not have, is there a way to remove this? <colgroup><col></colgroup><tbody> Row Labels <5/29/2016 May 29-May...