table analysis

Hiya All, I need to set up a sheet to sort out a lot of rows of data into 4 separate sheets based on some of the values. The data is arranged as seen in the table below. I have sorted the sheets for each area but need help filtering the data I paste in. I have a sheet called Paste Data, this...

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