devices

  1. P

    Pull data from cell based on max value against that data

    Hi, Hoping someone can help. This is kinda similar to my previous thread but I think different enough of an issue to warrant a new thread. I have Devices in one column, Memory in another, IMEIs in another and days in stock in another. I want to have a sheet that shows which of each device has...
  2. C

    Finding the correct % value

    I have 20 assets (devices) 9 of the devices have vulnerabilities. Device 1 has 8 x critical vulnerabilities and 20 x High vulnerabilities. How do I correctly determine the true percentage values of Critical vulnerabilities and High vulnerabilities against number of assets with issues...
  3. B

    If/and statement assistance, looking at mulitple cells as reference...

    Alright guys… im struggling with this one, maybe I’ve been looking at it for too long… Background…. Panel A DOES Not have a built in Comm Card, but… Panel B has a built in Comm Card, Both panels can have multiple Comm Cards, the number of Comm Cards is dependent on the number of Com Devices...
  4. S

    How to automatically insert a column under a transposed column array with formula. (Dynamic)

    Hi all, I am designing a staff training records on devices within our organisation. The workbook consists of the following spreadsheet tabs: Devices, staff list & staff requirements. In staff requirements spreadsheet, it has the staff details from staff list spreadsheet on the left of the table...
  5. D

    Please help condense cascade into a single row

    I'm trying to build out a deployment forecast that has two main components: a probability of the deal's timing in a given period, and a % of the deal deployed in a given period. For example, suppose we're forecasting a deal with 100 devices. If there's a 100% probability it closes in...
  6. F

    HELP! - Lookup tab based on cell value

    Hi All, Any help with the following would be greatly appreciated :) This is my current formula: =IFERROR(INDEX('Devices'!$A$1:$V$999,SMALL(IF('Devices'!$D$1:$D$999='IOS Search'!$B$1,ROW('Devices'!$D$1:$D$999)),ROWS($1:1)),1),"") However I want to replace 'Devices' with a cell value i.e. $C$1...
  7. R

    Questions related with MACRO

    What is the best practice in storing the MACRO? Is it in the personal workbook or in the workbook itself ? I have realized that I need to use the macro on different devices. Under such circumstance, I should copy back the macro one by one and save it in the workbook ? Kindly advise.

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