container

  1. J

    VBA Help speed up and stop not responding

    HI All I am new to VBA and looking online and recording Macros to help build my code. But I am having a issue when I get to part of my code it is slow up and also making excel go into not responding. Is there anything I can do to my code to speed this up when I run it and also stop it going...
  2. V

    Power Query editor refresh running slowly, Microsoft Mashup Container running even when idle

    All, I have cleaned up a group queries that transform some data for monthly FP&A analysis we do. Without tedious detail we essentially take two exports and combine them into one, and then pull from each previous query (M-Code starts with a source like #"Join Pricing Data") to pull from that...
  3. T

    Stuck for working out which formula i need

    I have multiple columns with alot of data in them. I want to know how many i need of specific items. my table currently looks like this <tbody> Week number Container type Times appeared 1 Grey Tray 10 Black box 5 </tbody> The times appeared column is calculated using countifs but it...
  4. H

    Maximum concurrent event calculation

    Hello, I have a data set with over 60,000 lines of data per year. It contains the date and time an object was placed in a specific container and for how long it was in the container. The more objects that were simultaneously together in the container the greater the weight and loading on the...
  5. L

    vlookup hitting duplicate values?

    I built a spreadsheet for tracking containers at work a while back. it would search column b of sheet2 for the value input into sheet 1 and return the associated value found in column a on sheets 2. Initially we did not have any duplicate container IDs. Having added new containers to our...
  6. J

    Hover over different parts of image

    Hi Everyone, I've signed up on the site as I cant figure out how to do this for the life of me. I'm trying to accomplish some sort of a heat map in excel where the values change depending on where the you hover in the map. For example, using the image below. If i hover over number 1 it will...
  7. K

    Count distinct rows with multiple criteria

    I'm having a hard time with this, and I'd really appreciate some help. I've got 8 compounds distributed across 4 containers. I need to see if there are any compounds for which the container is empty. I can use =SUMPRODUCT(1/COUNTIFS(tbl[COMPOUND],tbl[COMPOUND])) to return number of distinct...
  8. J

    Allocating Amounts into Bucket

    Hi There, Here is the problem: Say I have 5 inventory of products (liquids): Jan Feb Mar Milk 5 10 1 Water 7 8 40 Orange Juice 10 32 3 Now say I have the following containers: Container 1 - capacity 1 Container 2 -...
  9. A

    Formula for Calculating weights

    Hi I'm trying to find a way to calculate the weight of a container based on whether I add 1,2,3,4 or 5 in a cell that references figures from another sheet. For Example In sheet "Weights" I have 5 cells with 40, 200, 480, 760, 1040 these are weights from an irregular shaped container based...
  10. B

    Advanced Character Search Functionality

    Hi Everyone, If I want to search for letters in the cells that are not necessarily in order, how can I do that? <tbody> CEGB DFACE EGBDF FACEG </tbody> Example 1 I want to search for any cells that container the letters D,F,E My results should be cell B1 and Cell C1 because they...
  11. R

    Recursive function...

    Hi all, My UserForm.Initialize() call SetControlEvents. This function purpose is to find all my ComboBox and TextBox controls and attach to them, a class module events. I use recursive because Frame and MultiPage are container. My Initial call to this function is ...

We've detected that you are using an adblocker.

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.
Go back
Back
Top