index

Hi all, I have this file that was converted from PDF to Excel. I would really like to filter everything in column A by date However, when I do it looks like this: It filters down until row 687 The row looks like this: I have no idea why it stops? It used to stop at points like these...

I feel like I'm going around in circles between index and more. I have multiple sheets, but for this example just set up the two I needed as they would appear in my workbook. I am trying to make it so that if I select a student's name from a drop down in Column A on sheet 'Student Report' (first...

Hello everyone, I'm trying to extract data from sheet1 into sheet2. One of the columns in sheet1 contains a personal identifier along with other text. On sheet2 I use a filter function to extract data from sheet 1 by referencing cells in sheet2 column (i) that lists the personal identifiers...

Hello I'll try and keep this simple. Sheet 1 This is a list of absence. Each separate occasion of absence is recorded against a unique employee ID in Column A and on it's own row. On each occasion, there is an absence start date and an absence end date. Example: an employee with 2 separate...

i am using this formula using lookup =LOOKUP(2,1/(HHPPD[Code]=[@Code])/(HHPPD[SD]<=[@DOS])/(HHPPD[ED]>=[@DOS]),HHPPD[NP]) i want to use index match to rewrite the formula, i am trying following formula but it is resulting in #NA, whereas above mentioned formula is resulting in right value...

Hello, I have a list of numbers in column A listed as Customer numbers, also in columns C,D,E are customer numbers. What I'm trying to do is if Column A info is found in column C,D or E, then Column F is Contacted, if not then not contacted. Thanks in advance I'm using excel 365

Hey people, I'm currently working on a sheet containing thousands of entries where I will need to update information that is repeated throughout many sheets. Rather than manually 'Search & Replace', I was wondering if there was a way without doing (=A2), to have a formula that will associate...

Hello. I've been using this forum for a decade and this is the first time I've needed to ask a question because there has always been an answer to my question. Please help me figure out how to populate blank cells to the midpoint with the previous value i.e. I have semi random sample points...

Greetings All I am out of ideas on how to implement a "FILTER" Func with Multiple Criteria for Office 2019 which does not support the function while Office 365 does. I have following example setup on O365 Excel and works like a charm. I have (2) Workbooks - Workbook A [DCI Invoice.xlsx]...

I'm an Excel 365 user, and a very new one at that. Forgive me for my lack of etiquette within this forum, I hope that this first post may help introduce me to a way to solve this specific problem of mine, as well as to learn more about Excel 365 in general, and how to properly interact with this...

I have a data set with unique IDs in column B and dates in row 2. I am trying to make a formula that looks at a date I've selected, finds that column in the data sheet, looks at at a range that includes the found column and the 11 before it (i.e., a whole year), then counts the number of rows...

Hi all, This may seem super simple and silly to ask, but I have currently made this setup: I have hidden EVERYTHING except for rows and column 1-7. However, I would like to unhide row 8-10 now, but I have no idea how? When I click on "7", which is the closest row I can currently touch, and...

Hi all, I have this formula: It pulls in data from here: However, despite this column being completely empty, it returns the value 0, rather than a blank cell as I have commanded it to. I have checked the cells in column H and there are nothing there, not even a space, so i do not...

Hi all, I have this very complex formula: It returns a date value from a different sheet. However, it is returned in a number format, rather than a date format. Any idea how to fix this? I believe that I can use the TEXT() formula, but I cannot figure out how :( If anybody can help me...

A B C D E F G H 1 week 1 week 1 week 2 week 2 week 3 week 3 2 W R W R W R WB RB 3 25 10 30 8 30 12 30 FIND THIS NUMBER I have a table of data that looks like above. I have used MAX function to find the highest occurring number in cells labelled with "W". In cell H3, I want to find...

Hi all, I currently have this formula: The formula is supposed to look at the values for the company (column B) and the topic (column F) and then based on the value in column F, it will look at the sheet with the same name and find the values here: I likewise have a sheet with the same name...

Hello there - I keep forgetting how to think about the logic of these functions. I tried to look across my other workbooks for formulas. I feel like I've done this before so I apologize but I couldn't find the formula hence why I"m posting. I've searched and using these links and posts as...

Hi guys, I am currently working on a tool to efficiently print the logs of our production process. However, sad to say I am really stucked. Initially, my idea was to be able to select the desired .xlsx file from a directory - which I was able to do using a macro. Then...

Hi, I am trying to make a column to obtain last values that were added in some table. Each month table expands so new values are added... So far, I managed to get the way to obtain last value, last value -1 and last value -2 (so I'm having last 3 values in other words). My problem comes when...

I have a huge list of accounting entry descriptions (all are unique and hand typed) that need to be examined to determine treatment (1 of 3 possibilities). I built a keyword finder using IFERROR(INDEX(MATCH(ISNUMBER)))) that works great. It leverages a 2 column table with keywords and their...