index

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.

How would I find the last combination of a letter and number in a list? A = Combinations B = Results for A C = Results for D A1 A2 D1 A3 A4 D2 and so on...(not a pattern, just the result of previous selections). So I would need Column B to return the last combination starting with "A", which...

I've just hit a wall here and my brain refuses to bring this information up. I have a cell with a series of room names in it, separated by commas: Master Bedroom, Master Bathroom, Laundry Room, Stairs, etc. Call this A1 In "D1" I'd like to place a formula that will take those room names and...

Let's say I have a dropdown with two options (A2): Category 1 Category 2 I also have a range of cells given with different phrases: (A4:C5) Phrase A Phrase B Phrase C Phrase D Phrase E Phrase F and also a table which looks like this: (A6:B12) Phrase Category Phrase A...

Hello Everyone, I am running into an error when uploading SQL in Excel from database. The message is below. How do I get around this issue with constraint or index? I have done a lot of research but I am stuck. I am not sure what I am missing at this point and I am seeking your help. Error...

Has anyone tried more detail about speed test for value lookup formulas? I tried myself but I doubt my experiment. Please see my screenshot. The lookup formulas to compare: (1) INDEX-MATCH, (2) INDEX-XMATCH, (3) XLOOKUP. Formula setting to compare: (1) whole column vs fixed range reference...