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...
Backstory:
I have two companys that I am trying to merge into shift tracking system. We have over 200-300 clients and 500-600 projects per year. The file only shows 2 clients
I made this work one way where I had two master lists of projects based on company names and the cell values for...
Hello,
Column A is filled with string values. Column B is sometimes filled with the value "x".
I would like to write VBA code that returns all the string values from column A into an array if they match the "x" value from column B.
Anyone knows how to do this?
Thanks
I am working on putting a template together for my company and ran into a problem with having two dropdown lists. The goal is to have that ever is selected in list 1 to populate only a set list of items for list 2. The spreadsheet attached i am working in column 'H' & 'I'. the code form column...
Hi All
I am writing a code in VBA to index and match against a date which runs in each column, and returns down each row. I can do this for each row if i write it for each as attached, is there a easier way so that it loops rather than me having to write multiple macros?
'''
Sub test2()
Dim...
0000378G
FCP1 or FCP4
€ 39.44
0
€ -
0
€ -
0000447G
0
€ -
0
€ -
0
€ -
0000450G
0
€ -
0
€ -
0
€ -
0000458G
2.01.03
€ 70.47
2.01.07.01.02
€ 375.75
2.01.07.01.02
€ 228.13
So this is example of my data.
Now i want the addition of the amount for each value (2.01.07.01.02) for each ID.
I...
Hi,
I have a problem that I could use some help solving.
I have an Excel workbook that calculate prices. The workbook has about 250 different products. All products are priced based on measurements, both width and height.
The user enters the product number, number of products, width and...
Hi,
I am looking to fill in the matrix on Table 1, referencing criteria in Table 2. I have only included a sample of total data.
I want to INDEX column 4 in Table 2 so that the matrix in Table 1 specifies which stage (1, 2, or 3) is happening and when it is scheduled.
To do this, I want to...
I have been using an awkward method to store and call my UDT arrays by key.
That is by making an array and corresponding collection for storing the array index and calling the content by key, please see my code below.
Is there better practice for this in VBA? That maybe can call array member by...
Hi Community,
is there a way to get INDEX to work with multi-column select dynamically.
This Works: INDEX(Table,,{3,5,9})
This Throws an Error: INDEX(TABLE,,{COL_A,COL_D,COL_C})
EDIT:
Just an FYI; this also works: INDEX(TABLE,,COL_D)
Using google sheets, is there a way to look up a value on the vertical & horizontal axes between two numbers?
If years of service is 2.8 and company growth is 18.8, how can a lookup formula return 10%?
We are rounding down on both years of service & company growth.
Company growth: greater...
Hi,
I have 2 Sheets(workbooks in reality but I made the test sample in 2 sheets).
DATA sheet: All text/numbers. No formulas in this sheet.
RESULT sheet:
CFGMNOP1IDItemBalanceMatch Failed (Accessorials)Invoice Rejected (Accessorials)Approval Failed (Accessorials)Amount Due233283896Stop-off...
I have a list of suppliers that goes on a rolling basis. I'd like to be able to know which suppliers are next in line based on when they last accepted as it should go the longest waiting and if they are available.
Supplier
Status
Date of Last Accepted
Test 1
Available
31/8/22
Test 2...
Hello,
May I ask for some help resolving this query please? I seem to be making an error when I am trying to exclude one field if there is data entered. I will explain further below.
I am looking at some data with a series of dates. The dates are used to determine if the submission should...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.