index

hello everybody, I have a problem with excel if command and I need your help I have let's say the below columns distance calendar price 200km 12 months 10€ 400km 24 months 17€ 600km 36 months 29€ 700 km 48months 33€ the distance might be a random number between 200 and 700 I want to create...

Hello, I work for a company that has several employees clocking in and out electronically from home. All this information gets logged into our system which then generates an excel file with fields such as member name, date, task they are working, pay period, and clock in and clock out times...

INDEX.Nth returns (every) nth element(s) (starting at the desired position) from a one-dimensional array and provides output options and full control over data type(s) inclusion/exclusion (The code is modular (as all my other functions) allowing for easy swapping/optimizing over time. See all...

I have the following data in excel. I would like to derive the "Action" column for a "Person ID" based on the Y or N indicators in the "Value" column and what's in the "Month" column ABCD1Person IDValueMonthAction21N1/1/231st action32Y1/1/2341N2/1/232nd action52N2/1/231st...

Hi I need help filling out the highlighted colum. The goal here is to fill out in Sheet 1, Column C "Closest After Dates in B", with the closet date after column B "Date signed up" by vlooking up to sheet 2 column B "Time", with criteria that Type is either "email", "outbound" or "inbound". I am...

I have a output from an accounting product and I need to reformat the table. At the bottom starting at row 23 you can see an example of the new worksheet I am trying to create. Can I get help with a formula to help automate this? The original report has 742 more accounts like this I need to...

Hi All, I am currently working on making a workbook that takes data from a data base and consolidates it down to a easier read. I currently have a system that shows when people call into our system, the problem is that this system creates a row of data for each entry and I would like to take...

Hi! Unfortunately, my xl2bb still refuses to work (blanked out in the excel toolbar) but I'll save that for another post and just attach images here. I also previously posted the same thread but with very unclear and messy parameters so I'm redoing that here, apologies for that. The Sales...

Hi guys! Not sure how to approach this - with lookup and aggregate, an index/match sub or something else. So In the sheet called Empty, when B2 is filled, it populates the Invoice column in D4:D with unique invoice numbers from an external order sheet. The Sales sheet has a list of orders where...

I don't even know if this is possible, it was hard enough figuring out the title for this post. So to give context to my problem, I'm given a sheet from our payroll team of all the leave taken in the previous month for each of our locations within the business, and I need to add up the total...

I have two worksheets. One has the source table: And another has an aggregation table: To get the numbers from the first table to the second I use the following formula: =SUMPRODUCT(INDEX(FS!$A$2:$Z$250,0,MATCH(C$1,FS!$A$1:$Z$1,0)),--(FS!$B$2:$B$250=$A2))/1000 It basically checks the...

=SMALL(INDEX(detail_check_payment!$A$7:$AA$358,MATCH("S&P ",detail_check_payment!$AA$7:$AA$358,0),1),ROWS(AA7:AA7)) When I use the formula above it only returns the first value that matches and I need it to return a list of all that match.

Hi all, I have an open workbook with three sheets called "1", "2", and "3". I want to hide these sheets and make it so that you cannot open or view them without a specific password. Right now, I can protect these sheets. However, protecting them means that you can still click on the sheets...

I have the following. BC33Pos test (dupes)Other field test34113512B34:C35Expression=IF(COUNTIF($B$34:$B$35,B34)>1,IF(COUNTIFS($B$34:$B$35,B34,$C$34:$C$35,"<>")>=2,TRUE,FALSE),FALSE)textNO I would expect each cell to be highlighted, however C35 does not seem to be affected. The theory behind...

Hello, I am pulling my hair out as I cannot see the issue with this formula: =INDEX(CombinedNOI[OBJECTID],MATCH(MIN(SQRT((CombinedNOI[Lat]-U13)^2+(CombinedNOI[Long]-V13)^2)),SQRT((CombinedNOI[Lat]-U13)^2+(CombinedNOI[Long]-V13)^2),0),1) It was working perfectly until I linked it to a...

Hi everyone, I've looked and found several posts about using the greater than match type in index(match formula's but none have any with 2 match references and I'm stuck. I am building an AQL inspection table and want the sample size to be automatically indicated for our team however the value...

Hi, I'm looking for an excel formula that can count the months from the start of positive #s to the end of positive #s. Zero values in between positive #s count. Zero values do not count before the first positive # or after the last positive #. Client 5/31/2022 4/30/2022 3/31/2022 2/28/2022...

Hi all, I am currently doing an overhaul to my Budget/Bills Tracker. I have created a table that reads transactions and gives every transaction a category to be later totaled based on those categories. It used to work because the "table" of categories was not an actual table but was just listed...

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare. How can we solve it in the shortest possible way...

I want to pull the last 5 quarter data of "Symbol and itemcode" from the table. Symbol and item code" must be transpose. Pulling specific columns by transposing two headers I want to reach an image like the first picture so that I can compare.