table analysis

Hello to all, I'm new with Pivot Tables, DAX formulas and I want to know if it is possible to get the output desired with PT, Power Pivot, DAX etc. I'm using Excel 2016. This is my input Table: <tbody> DESCRIPTION VALUE STAGE 1 ID 0 NAME JFMSC TYPE MLRR DFRUL P1 ADDR 1001 RRUL...

Hi folks, I’m stumbling through a few excel exercises that I wish I was better at. I wondered if someone can help me with a few pointers. My first ever excel forum help request! If anyone reads on – thank you. My problem is this: I have a spreadsheet of employee sales performance data, one...

Hi, I am stuck on one point. I want to compare directly 2 VBA tables, I even do not know if possible: here code: test1 = sheet(1).range("B2:f2") test2 = sheet(2).range("C10:G10") I want to compare test1 and and test2. Can I do directly : if test1 = test2 then do something endif It seems it...

Hi Team, I need some option or solution to my query. I have dataset which define with table and given table name and total column consists of 10 and this is not fixed tomorrow when I get fresh data the number of columns may get increase to 11 or 12. I created few formulas based on the table...

Hi all. Have a question, Is it possible to "load" an excel table so it expands based on a filter criteria from another dataset via a lookup? So imagine I have source data set up as follows: <tbody> Data Source EMPLOYEE Sales Value A Sales Value B DS_1 123456 100 125 DS_1 123457 150 300...

Hello, I need help in two scenarios. 1) when working on data in normal tabular form. 2) when working on data which is in "TABLE" in both cases, some rows I wanted to keep hidden and copy only visible data and paste it to another sheet only in visible cells where too some rows are hidden. So...

Hey, Friends; So lets say I have 4 box sizes with their dimension in a list. I also have an array of objects to fit in the boxes with their own dimensions. I only want to fit one item in one box so i want the box that fits the item the best. Under my "box that fits" column, I'd like a formula...

Hi, Would like to know if there's a single cell formula that would solve my Excel problem. Would like to count (per row) how many values that is above 0 in table 2 using the criteria table (ex. add to count if Town and Juice = 1 in table 1 and positive value in Table 2) The answer I wanted...

https://drive.google.com/open?id=0B7X5e_N0aRshSUthVkNZdXZLUmc Hi all, Link above to excel file in question. The first sheet is simply a table of data - in this case business done with organisations, and the monetary values. Sheet two is an analysis sheet which totals the number of work...

Hi i was asked to construct a table and calculate error percentage based on the sum values of four different rows and then print that value in percentage to a particular cell any idea how can i do that ?

Hello people, I am currrently watching an audiovisual lecture and the tutors used some data on excel to work. I had to downlaod the same data from worldbank dataweb. The data is pulled from the data is not sorted out as the one the tutor used in the video, how do I sort it... Raw Table Format...

HI All, Nice to meet you all. I am a study currently working as an assistant in an educational institution on a voluntary basis. I am going to consolidated the exam result of students and performing analysis. The system we currently using is able to generate the result of each student as...

Hi I have a work book and i have many tables in it How Can I Get Tables Name in Range To Make Drop Down List Only Tables Name For Example: I have 6 tables in workbook I need To make new sheet (ex.Sheet7) that contain tables name So in "Sheet7" "A1=Table1" "A2=Table2" "A3=Table3" "A4=Table4"...

I need help writing a formula. I am trying to make some budgeting sheets in Excel. I have one sheet with a table called MonthlyExpenses, with columns for Date, Categories (includes a drop down list with specific options), and Actual Cost. On another sheet I have a summary sheet which compares...

Hi Guys, Basically I have two columns which have been used to capture data. <tbody> col 1 col 2 col 3 x x x x x </tbody> I want to use an IF function ( I assume ) to collate my data into the third column to effectively see which rows have a mark against them. Is...

HI, I am trying to get different SUBTOTALS from a table depending on the sort. For example, I want to know how many accounts each of my account managers have. I have a master table with all of our accounts, and if I sort that table by account manager, I can get the total. But I want to take...

Hey you guys! - I need your bright excel minds for some help/inspiration with some data structuring in excel! The specific task at hand is: Create a tool where the team is able to filter by city and select multiple dealers. All the relevant listings should appear in a way that is easy to...

Hello everyone, This is my first post, so please bear with me. I have two tables that I need to compare. The first, table 1, is from a call logging system and has hundreds of thousands of rows. The second, table 2, is from a scheduling program and is significantly smaller. Amongst all of...

Since weeks I am looking for an add in for table valued function but I couldn't find any... Could you recommend me some add ins that can help me to make operation with excel tables?

I am trying to shortlist a table by matching information from a list, and would appreciate your help. The list and the table are variable in size and content, the location in the table where the list members can be found also varies. Below is a simplified example of what I am looking at and what...