formula & filter

The original creator of a spreadsheet has left the company and I have inherited the Excel spreadsheet. The spreadsheet 1st tab INPUTDATA purpose is to input/enter all data. Another tab, is for reporting purposes. Click a button and displays the relevant data. Another tab Formulas that...

Hi, we want to transpose some data from multiple column, is there any option to do it Query Table CodeAmountQty123456789101234567891012345678910807808824793812109113165266101112118081131SD-DE-16853808125901132428661651 Result Table...

I have one sheet called "data dump" and one sheet called "pulls" in the "data dump" sheet i have three columns. One has a name, one has quantity, and one has price. I am trying to find a way to take the rows from data dump to pulls based on a keyword. AKA: If column A has word Corrupted in...

Hi, I was wondering if anyone can help. I want a filter sort out table on one sheet to a breakdown on another sheet. To explain, I have two sheets. Sheet1 is Archived Reports. Sheet2 is a "Dynamic" Calendar. I need both of them to somehow connect in a very specific way. On Sheet2, I need to...

Hi all, i am trying to use filter formula to filter out the result, it works, but if every row use this formula, it will cause #spill! error as sometimes return more than one result May i know is there have any method to update the formula for auto insert the row to avoid #spill? error in using...

Hi, we have posted this question on the following url but in this there are some change in requirement, we have around 100-200 entry and taking the result in new sheet only for example we have used the same sheet...

HI, we have the following sheet where we want to check the steps where are work is pending, kindly provide any excel formula we have the excel 2007, 2010 sheet ABCDEFGHIJKLMNOPQRS1WorkStep 1Step 2Step 3Step 4Step 5Step...

HI, we want to filter data from two column to one, here are two column, column A and B, there are other data also but we want all the data from Column A and B to in one column with removing all the blank rows, you can check the result sheet query sheet BarcSecondfdfftest...

Hi, i am still in learning process with Excel i am trying to make head to tail of a thing so here is my question and please if you can give me some guidance on how to sort this out for me, so i created this excel form that i am trying to introduce to work and i managed to get most of the thing...

Good afternoon all, I have tricky request here and hoping someone can help with it. As you can see the first column depicts the Individual in charge of each account - John DOE. Then the account number, account name, unit type and finally product code. I need a formula that can combine all...

Hi, in column A I have different values formatted as text. In column B, I want to get values from column A, but without specific texts. Column D contains the texts I will be looking for. I've tried different formulas, but I can't leave out more specific texts. ABCD1Text1656OIuzdesired results in...

Hello, I would like to know if it's possible to have some formula to get the specific characters from two or three different cells based on same character in it. I am using this formula at the moment =LEFT(A2,FIND("_",A2)-1) to get the characters I want. for example below table: 1_aaaa_x 1...

@ How to show selected menu in slicer to other cell ??? (Like a Reference Indication) in pivot table ???? I have Try selection in slicer information reference to other cell , Above image like this yellow Highlight cell this reference

Hello, I need help formulating. I'm working on an employee attendance sheet. I need to formulate the total hours/minutes missed. If they were Absent it would equal 8 hours; if they Arrived Late the total amount of hours/minutes they missed; if they Left Early the total amount of hours/minutes...

Hi, I'm having a lot of trouble trying to get some values in some documents I have What I need to do is, get the amount of duplicate values that are in a column, for example In this table I need to do this calculation All the repeated values in the Column "L" are basically a single Item, but...

So I use the same database, the same cell, same formula. But somehow I get different behavior of formula when I evaluate it. Here I use SEARCH as a single formula {=SEARCH(List,E521)} And I get only first item from the List (table). But here I use SEARCH in combination of formula...

I have a batch of data in the following format. This is my input: <tbody> GROUP EMPLOYEE someEmail1@here.com Jane Doe someOtherEmail@there.com Johnny Lee someOtherEmail@there.com Jane Doe someEmail1@here.com Jacob Smith </tbody> My Expected Output would be: <tbody> Jane Doe...

Greetings, Thanks, in advance to those who might be able to help. I'll make it as concise as I can while providing context when needed. Scenario: I work for a Distribution Centre with about 10,000 unique location in the warehouse (4 different sizes and storage capacity [full, half, quarter...

Hey all. I have a program that outputs the data in a fashion that makes it hard to use without the graphics, this in turn makes it hard to convert to a usable CSV. The fun thing is the headers for the data also does not always line up. I was wondering if you guys could help think of a way...