analytics

Hi there, I'm looking at building a tender document that houses multiple vendor responses with drop down boxes. I've been doing this for a while but what I would really like is to have a drop down box in a summary tab, where I can select either, the lowest price across all vendors or individual...

Hi All, I am building a data set from a download of data from our Reporting Tool. To ensure the data reconciles: - For 2023 Plan I need to take All Country Data - For Actual reporting, I need to exclude one of these My Question is - How can I build a Pivot Report based on the whole data, with...

Hey! I'm trying to plot a trivial chart as shown below and can't still get it :/ Help would be appreciated.

Hi I need a formula for: to find all numbers/rows that repeat at least two numbers in the entire row in at least one other row. Maybe highlight each set wit different color? im not sure if this is even possible since if the numbers in different row repeat then it would highlight it in both...

Hello, I was wondering if someone could look at my code and let me know how to modify this so that when Excel cannot find an entry in the SOURCE workbook, it pastes a zero for the corresponding group/item in the destination workbook (DailyBugCount). Currently, it moves to the next item when...

Hello All, I'm a high school finance teacher and my students have been working towards the MOS Excel Specialist and hopefully Expert certification. Next semester our class is starting to get more involved in exploring analytics. We've been approached about doing a meaningful project where we...

Hello, Has anyone found a workable solution to extracting information for Google Analytics into Excel.

Destination cell is G6 on a tab named "Value" My source will come from tab named "Analytics" on this tab, columns H through S have data representing the previous months analytics. For example, cell H6 has data from January, I6 has data from February, J6 from March and so on. In G6 from the...

I'm struggling to do a few things with regards to developing actionable insights and presenting in an easy to use dashboard for a wide user group. The situation is as follows; I want to Create a hierarchy dashboard across a number of kpis. I.,e start at the president's view of the average...

Hi, I have an Excel database with around 1000 rows of data. Data are arranged as below with around 300 names and with multiple skills for each Name. Name skill Shrinivas Excel Shrinivas VBA Veer C++ Veer UID Veer...

I am working with a huge data set and was wondering would a dcountif work if I need a column which has random loan numbers in it give me back the count of how many times it is in the column. Their might be four or two or 1. I have another formula counting if there is a 1 to give me one answer...