I have a data table and i want to find approximate match against that table,
I am trying to create a savings log which would enable us to detail down the savings we generate as a business.
Essentially the main issue I am facing is that I can dedicate fields to detail the saving total along with a date that can be used to identify a realisation month for the saving...
This is a challenge, at least for me. What I'm trying to achieve is the following: I've a big list of items with several specs. I want to project the matching items (with the same specs) in columns after the item to match.
Simplified example of the data:
I am an avid VLookup user and have recently learned of all the benefits of Index Match and Index Match Match.... I just cant seem to get it to work on my workbook!
I would be extremely grateful if someone would be able to help me.
On tab named 'Database' I have a table of data in cells A4:EV7...
I have an index match that gives me results for prices with a string of text I want to remove. Example: USD 41.99
In a separate cell I have the RIGHT function to remove the "USD ", but I would like to have a single formula in one cell...
'm looking for some guidance on creating this lookup in excel.
i have a table similar to below:
I have a large data table that was not very well put together. I need to find the last test date a student took a specific test in a range that contains also contains dates for the other tests they've taken. My table is as such:
ID | LName | Test Date | Math Test | Score | Eng Test | Score |...
Hello, Excel friends. I am trying to wrap my head around how to match by alpha and by number. I have below an example of what I'm going for.
Example: Meeting group discussions with one group leader for every room number. People assigned to room one with the last name between a-ch will have...
I am struggling with writing a formula to achieve the following:
We want to count how many times there are two or more consecutive blanks.
Below is a snapshot of what the data looks like.
In addition, while we are here -
We have the following formula...
I need to change my formulas and/or lookup table structure to calculate a new fee structure bring implemented in July by eBay.
I need to determine multi-level value fees from a table of fees for a given value.
Reader background info
If you look at the Research Tab
This is used...
I'm not entirely sure how to explain this issue, so apologies if the title is confusing or misleading.
I have a spreadsheet with a fairly large number of array formulas. Maybe there is a more efficient way of doing it but this is where I'm at for the moment. The formulas were working. However...
hi all, i am looking to analyze a large set of data and to do so have developed a sort of basic dashboard.
in said dashboard, there is a dropdown (data validation list) with a month name that corresponds to the data set i am analyzing and in which the months are listed horizontally across the...
I apologise in advance. This issue can seem complicated. However, I'll try to simplify this as much as possible, without leaving out important criteria.
I work in the quality engineering business, and I'll use the relevant terms here:
Supplier number — This is a number that identifies a...
Hi everyone - I am trying to avoid creating hundreds of named range formulas. I have set up an image box to display one of three different images in A2 of Sheet1 if B2 of Sheet1 contains one of three specific values, no image shows if B2 contains the value "0". The formula I use for this named...
I'm sure there is an easy solution, but my brain (nor google it seems) can find it...
I'm trying to match two string criteria in an index match formula and I dont want to use an array.
I get the above results using the following formulas in U51:U56 And it removes the duplicate but how can I...
New Lamp and/or Luminaire
Initial Light Output of new End-User Equipment (lm)
New Lamp Circuit Power _Watts
E1.1 A LED Lamp only_ELV
≤5 W=.0.49, ≤10W=0.41...
Using INDEX MATCH I can check if a key word is in a cell and return the name of the group it belongs to. Fine. But what if I want additionally check to see that it does not contain a word/phrase that would mean it is in another group, or there is a second keyword which must be there for a...