table analysis

I have a table where each row is a specific Individual ID Number, and each column corresponds to different dates a test was taken for that ID Number. The ID Numbers are in Column B, and the test dates go from Column H to Column AL. Column H is the baseline test, then every test after that is...

I have been fiddling with this for an hour, mostly using SUMIFS but I'm not getting anywhere. Assume I present the following data: A` B C 1 $ 81.00 Expense Personal 2 $ 75.00 Expense Personal 3 $ 25.00 Expense Personal 4 $ 42.00 Expense Business 5 $ 14.00 Expense Personal 6 $...

Hey All, I am trying to sum together values in a column based on a string value in column A. I have something similar to the table below and wish group together the strings in column A and sum the values in column B to give me a combined table. Input: Column A Column B TestA 5 TestA...

Hi all, Looking for some help on extracting data, I have a relatively large table A1 to P272, columns are either names, value (£'s) or %'s What i am looking to do is on another sheet have the top 30 for each category - snippet of example data below Name Stage 1 count Stage 1 Total Value...

Dear All, I have a small apparel business setup from home. I want to automate the workbook so as to cut the time of recounting the products and calculations. I have two sheets the first contains my stocks and second Clients orders. I want to automate in Allocation Column where I want a...

I have a 2D table of timeseries data. I am able to use the following equation in column B: "=BYROW(Value_Array,LAMBDA(x,MIN(x)))" to get the minimum value for each row that results in an array output. In column C the following does not work "=BYROW(Value_Array,LAMBDA(x,MATCH(B6#,x,0)))" to find...

I have attached sample screenshots as a reference. For example (x, b, c, d and e are figures in a cell) Entry 1 - X entry has a percentage of B%, with a total of C and D used, *insert E text (reasoning). This is the structure of the whole report pretty much. Additional notes: The...

Hello, I am currently tracking information for a variety of locations. I have nearly 450 different locations that i need to track identical information, I am counting specific equipment and separating it by a descriptive class. For example - at a specific location i would like to count the...

I'm trying to set up data table to conditionally format a calendar. The calendar I was trying to use is a formula based one that adjusts the dates and shifts weekdays as the year changes. What I want to do is have a data table to enter specific dates and have the calendar be conditionally...

Hi all! This looks like a great forum, first time coming across it and I've got a question. ? I am trying to fill the table on the right with the following information (where there is a red 1, 2 and 3): 1. The ticker of the security here - notice how there are two "ETH" values. I would like...

Hello, I'm trying to figure out how I can extract data from a table that has multiple parent rows and then lists values on a separate row and column. For example, I want to return the value of Total Occupied % that corresponds to 10000-Laurete RE Investors,LP,Houston. I'm sure there is a similar...

Hello, I want to input a lot of data from a production batch into Microsoft Excel with version 2019. I want to search for an effective way to do it and to minimize any mistake from inputting at the wrong column, and to make the process a lot faster, because there's a lot of handwritten notes of...

Hi everyone, I don't think I can explain what I'm looking for, but I will do my best. CRITERIA: If Cell A1 equals 1 of 50 states AND Cell A2 equals 1 of 3 Worker Categories AND Cell A3 equals a 1 of 2 FLSA types AND Cell A4 equals a 1 of 200 jobs THEN A5 equals 1 of 7 Pay Classes Example...

https://www.ons.gov.uk/file?uri=%2fpeoplepopulationandcommunity%2fbirthsdeathsandmarriages%2fconceptionandfertilityrates%2fdatasets%2fconceptionstatisticsenglandandwalesreferencetables%2f2018/conceptions2018workbook.xls I’m working on table 6 in the workbook above. I’m trying to create a pivot...

Hello All, i have a table like a following one (of course, mine is bigger) that is coming from a query: Countries 01/01/2020 01/02/2020 01/03/2020 01/04/2020 01/05/2020 Argentina 0 0 3000 2500 0 Australia 0 1000 0 1500 3000 Austria 1500 0 0 0 3000 Belgium 0 0 0 2000 0 France 1000...

(Based Microsoft 2016/365 ) USD $ : 100050.20 ONE LAKH FIFTY AND CENTS TWENTY ONLY --( This line has been Proper way to convert USD Dollar to word) ( I Was used Powerutility add-ins but every time change Formula , Im scared, totaly time...

Hi all, I am trying to perform an auto-sort of a table using VB, where the table is dynamic using formulae rather than hard-coded data that is static. The table range is J3:R7 with row 3 being the table headers. When data is input, I need the table to update and sort based on the the updated...

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

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

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