formula & filter

What formula could i use to to find names in a of information? Would using a index and match make more sense than a Vlookup or something Else? I'm trying to say if the information in column A appears in Column C, Appear in Column B <tbody> Column A Column B Column C <tbody>...

Please can anyone help me to make a formula for this sheet? Thanks in advance!

hello to you all - This (may) be an easy question, but I seem not to be able to find the answer, so all help/pointers will be much appreciated, thanks! Question: Is it possible to cal via a formula the hand-executed right-click: "filter by selected cell's value"? I have one tab with a bunch...

Hello, I have a huge spreadsheet that I am trying to do a summary on. I thought using a SUMIFS formula would work but I just can't seem to get the correct formula, I keep getting ERROR messages. Any help would be greatly appreciated. Please see structure below. <tbody> Current Spreadsheet...

Hi Great Master of Excel, Id like to seek help on how i can make this possible. I need YES or NO to appear on a Cell if the Name is found under opened by using the list on column A I tried conditional formatting but i couldn't seem to get it. Thank you Ralph YES/NO Number Opened by...

Hi there, I have a bunch of data with multiple entries and I need help creating a formula / process to eliminate duplicates based on a certain criteria. I only want to count one of each opportunity if it meets the following: 1) To Stage column (column F) must be "Negotiations/Deal Point...

I have a sheet with thousands of rows of data. I have one column with different 'stations'. For example, column D is where my stations are and the data is 1A, 1B, 1C, 2A, 2B, 2C, etc. Each station has approximately 1500 rows/incidents of data that pertains to it. One of the columns...

I should state that I am trying to copy a formula from column C to column A. I do not want the formula copied, just the values. While in a filter for about 100,000 entries (about 20,000 in the filter itself). I used text to columns to separate names from city/states (they were in the same...

Hello, I'm preparing a sheet for a construction site, the first sheet contains all the construction materials details in Sheet 1 Column A. Sheet 2 contains the list of dealers/shops who sells the products mentioned in the Sheet 1, each coulmn here contains Dealers/ shop name and materials which...

Hi, I have to make some calculations using the last row of the inserted data. Need to be as formulas not macro neither VBA. Any help is more than welcome. In the next day will be more data that have to replace the ones in line 2. <tbody> total potatoes tomato apple this line should copy...

Hello, In column 'AC' i have data that is either ABC 1, ABC 2, ABC 3 or ABC 4. each cell in column AC is a drop down list to choose from ABC1-4 that is linked from another sheet using Data Validation. In Column 'AG' I have a list of dollar amounts. I need a formula that can tell me the total...

Hello, In column 'R' i have data that is either ABC 1, ABC 2, ABC 3 or ABC 4. each cell in column R is a drop down list to choose from ABC1-4 that is linked from another sheet using Data Validation. In Column 'S' I have a list of Assigned, Not Assigned, Less than 1 month, 1-3 months. Each cell...

Good morning my peers, I was wondering if you could advise if there is a formula or VBA code that can be used for my issue. I have a database that once is filtered i would like to select the largest number in the filtered data of column G and populate cell a1. Is that possible by formula or...

Hello! I just signed up and this place looks like heaven to me right now after hours of sweating and crying over this spreadsheet. I have data for thousands of people. The people all have a name, listed in column A. Then in column B is the date at which they logged their weight on an app. In...

I am trying to come up with a formula that will tell me when someone should be written up according to our policy. I have attached a copy of our policy and a copy of our excel spreadsheet that tracks tardies and unexcused absences. I'm struggling to find a formula that would fit. I'd like it to...

Dear Excel Gurus, i am trying to arrange in my excel template a way where the VBA code can select a between range for a date range. eg. PromiseShip Date is the filer option and the range that i would like to select is 06/03/2017 - 12/03/2017. The data set is coming from the SQL Cube...

Fellow Forum Members, Under Conditional Formatting -> New Rules -> Use a Formula to determine which Cells to Format -> Format Values where this Formula is True Field; I inserted the formula shown below: =OR($A$42:$D$151={"1","20","29","40"}) Much to my disappointment I get an error message...

I have a spreadsheet that has the following fields Trip Number; Driver; Date; Classification; Date; 6 Month Limit; Overtime Hours; Regular Hours; Time Owed; Total Hours; Payout Limit. I have 3 dates in the run of the year Dec 30, Jun 26 and Mar 6 that Records of Employment are sent out. What...

I have excel sheet with two columns (Employee Name and Technology).I need formula to filter data on technology column,instead of manually applying filter and sorting the data. Is there any formula which gives me the result to find out the employee name based on technology. (Example:If i want...

Hi, I have two worksheets in the same workbook that I want to be able to transfer data from one to the other. The first worksheet is a ‘quote’ form. Which will have, quantity, type of material and size. I would like the information from a range of cells to filter from the ‘quote’ to a ‘job...