assets

  1. L

    Sumproduct help

    =SUMPRODUCT((Data[Column1]=TRUE)*(Data[Counts of Assets in BU])*(Data[Region]=A17)) I have the above formula but for some reason is returning as #VALUE ! Not sure what i did wrong I just need the formula that if column1 is true in the sheet data and Region in sheet Data matches region in A17...
  2. L

    Sumproduct

    =SUMPRODUCT((Raw Data[Count of Assets in BU)*(Raw Data[Column1]=TRUE)) Something is wrong with the formula, what i need is to place the formula in the calculation tab that if header Column1 is true, sum the header Count of Assets in BU that meet the true criteria
  3. R

    Concatenate column into textbox on input form - VBA

    hello All.... I have an excel input form where the user enters a WORKORDER NUMBER (WONUM) and Asset assigned. Most of the time there will be multiple assets per wonum, each of these assets are a separate entry. What I'm trying to accompish: I want a text box that will list these assets in a...
  4. Y

    Convert weekly data into monthly data in VBA

    Hello, I need some help I have a worksheet called data weekly. C4 to C108 are the date. (C4 = 2017/06/23) D3 to AA3 are the assets. D4:AA108 are the index of those assets. I want to convert those data into monthly data in another worksheet called data monthly VBA. (start from D4) C4=...
  5. R

    eVTOL distro algorithm help

    To whom might be able to help. In the example above location 1 fulfill their 50000 lbs delivery with the first two assets. Would like to modify algorithm so that location 2 is fulfilled with the next available asset (right now starts again with the same assets) and on to the next location so...
  6. B

    Separate numbers into separate cells on another sheet

    Hi, first time poster here...go easy! LOL I have a spreadsheet and in the asset column i have a list of numbers related to that one line of information. All separated by a comma <tbody> Number Title Rev Asset total amount of assets UC02-WPD-UT-REP-N001-000012 Network Design - N1 P01...
  7. M

    Show price evolution over time for a list of assets

    Hello excel community I am new to the forum and a newby to excel. I know stuff but when complicated tasks as this pop up, seeking help is inevitable. Namely I need to show the price changes of assets over a certain period of time. I have been provided with a table where i have all the assets...
  8. P

    Trying to reference my range variable to format the new range... doing something wrong!

    I am trying to insert a row above the cells that have text values that begin with the word "ASSET", and the same thing for "Income". I've got my code below working up to a point It inserts the row above ASSETS and INCOME correctly then I want to select cells (B?:D?") to format those 3 cells in...
  9. dannyok90

    Asset control register (booking assets inward/outward

    All, Could any body help me? im struggling to overcome a problem :) please see the linked spreadsheer (you don't have to activate macros, they're just used for adding new rows - hopefully ill dev this into a userform interface) We have a 'required quantity' column which is the exact amount we...
  10. X

    Return Maximum Gross/Net Proceeds from Auction

    Hi All, I was asked to prepare an excel file that is able to calculate maximum proceeds from an auction of multiple assets. In short, company is liquidating all assets in a court process and we must track bidders for all assets. Some bidders will bid for entire assets while other bidders will...
  11. E

    Why doesnt this formula work?

    Hi All, The following formula returns a 0 value, but the second formula works. The only difference is that the first index column has been changed only to column D, and the same with the second match function. The answer I am looking for is in column D, but i would like to drag the formula...
  12. P

    In Need of array formula help

    Hello Board, I have this formula.... =SUM(COUNTIFS('Assets Open'!$N:$N,">="&U3-6,'Assets Open'!$N:$N,"<="&U3,'Assets Open'!$K:$K,{"john*smith",""})) It counts in the sheet name Assets Open in column N and cell U3 >= -6 and cell U3 <= it counts all the john smith and any blank cells. the...
  13. F

    Speed up VBA code and include worksheet unprotect/protect

    hi all, i have a code snippet which seems to run slow, any way to improve this code and add in worksheet unprotect for each ws in array and then reprotect each ws once columns are hidden? Application.ScreenUpdating = False Dim Assets As Variant Dim Asset As Variant Dim ThisSheet As...
  14. P

    Second search criteria

    Hello board, I have this formula.... =COUNTIFS('Assets Open'!$N:$N,">="&W3 -6,'Assets Open'!$N:$N,"<="&W3 +1,'Assets Open'!$K:$K,"john*smith") It works great. But I want to add another criteria in the same column K:K So it will search for a blank cell in addition to john smith.... count...
  15. C

    chart/query help

    Hi guys So I have made an excel document containing the price of an asset on two different exchanges, i have a query set up so that it gets the information from the server and automatically update the two cells every minute, that all works fine. However I would like to plot the change in the...
  16. R

    Updating changes in a table from another table.

    Hi All, I have a number of assets at a number of locations. Assets are sometimes added, moved, or removed. We have a master tracking list with the location of each asset. I have a maintenance tracking list that I would like to have update automatically from the master list. All the data is in...

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