devices

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...

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...

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...

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...

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...

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...

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.