table analysis

  1. T

    VLOOKUP with multiple criteria

    Hi everyone. imagine you have a database of orders and you use vlookup to fetch the order that has the hightest overdue(comparing from the today’s date) I use the basic formulas to retrieve the answer BUT I can’t get my head around when two orders have the the same value. I want to fetch the...
  2. S

    Is it a table, a lookup, ? range always changing

    I download a .csv daily In the columns the following headers, Meter, serial num, value, uom, day, wk#, timestamp, and a few more rows of usless info. the meter name changes, the serial num, and the value changes. I added the columns for day, and week# in to make it easier I though. I use the...
  3. A

    Resultant value from a Multiple Table

    The File contains 6 tables. First 5 Tables named Apple, Orange, Mango, Grapes & Banana and it contains the data of it varieties and its respective cost. In 6th “Fruit” table, two columns are there. One is ‘Fruit name’ and the second was ‘variety counts’. If I choose any one fruit in a first...
  4. F

    Transform table with Pivot Table, DAX formula

    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...
  5. B

    Excel pivot table /average/look up query

    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...
  6. M

    Compare two tables in VBA

    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...
  7. H

    Dynamic in finding column name in formula

    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...
  8. M

    Calling all Table experts - a tricky issue I need help with!!

    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...
  9. H

    Copy data from Visible cells to visible cells

    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...
  10. M

    Finding which 4 boxes can hold product X's dimensions

    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...
  11. F

    Complex Counting - Count positive values in a table row with a 'Table Criteria'

    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...
  12. A

    Sorting Table of Formulas

    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...
  13. D

    Create Table

    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 ?
  14. A

    Sorting

    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...
  15. W

    Consolidated data in the Summary page

    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...
  16. H

    Get Tables Name from Workbook

    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"...
  17. C

    Need to write a SUM with IF and AND functions. PLEASE HELP!

    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...
  18. S

    IF Function over Two Columns

    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...
  19. K

    Multiple subtotals from multiple sorts of Table

    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...
  20. B

    Input for ways of structuring a data-set - unsure of what tools to use

    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...

Some videos you may like

This Week's Hot Topics

Top