system

Hi, Wonder if anyone can help? I'm trying to refine a results system for a type of motorsport event called motorkhana. A timing beam system automatically inserts the competitor's elapsed time over a "test", however officials need to manually add any penalties to the system. A separate...

Hi there - here's the issue I'm having: I measure how long it takes our people to contact a lead that comes into our system. Currently, we track this Monday through Saturday, 9am to 9pm (Sundays are not counted). Here's the formula I'm working with...

<tbody> ID TEAM (WIN) SCORE BET AOS </tbody> Hi, im new here, i really need help about the betting system i create. as you can see at the top. 1. ID 2. TEAM (WIN) 3. SCORE 4. BET 5. AOS i have problem when it comes to the score and the bet, which is i create like this: im using the...

https://drive.google.com/file/d/1fsl-nLcgM2Z8p4anOg_JW8fBndei59qG/view?usp=sharing I have a worksheet that uses VBA to replicate an old game called 2048 (https://gabrielecirulli.github.io/2048/) The game works alright, there are a few issues I need to iron out, but there's one main problem I...

Hello All, I was trying to Log off my colleague system using vba. Can any one suggest me with code or ideas. Thanks, Sasidharan

Hi, Is there any way to have a numeric value in a cell based on a colour in another... For example if cell A1 is green the text in cell A2 would say 100% I cant use macro's or VBA the system I have to use does not allow any macro's/VBA - system is locked down to prevent this

I obtained a spreadsheet that apparently was developed on a 32 bit Windows system and I'm getting an error when I try to use it. I'm not familiar with this type of system conversion and I'd appreciate someone's help. The error seems to be on a function declaration. See the attached error.

Hey! Is it possible to open a file of an other application than Excel, but opening same from within Excel? I was trying to establish by using a link in an Excel cell, but the system does not work, it continues telling that the file cannot be opened, because there is no application to open it. I...

Hello! The data shown below has been sorted ascending by Case Number then by Last Modified Date to create an ordered record set for each case number. I need to get the next closest date/time in Last Modified Date to Row 1 of that same column for each ordered record set and return a “Null” if a...

Hi all, I have a workbook with two sheets and I want to compare between the two where a system name matches. Both sheets look something like this: Column C -------Column L System Fred --- Good System Trev --- Fair System Trev --- Poor System Bob ---- Excellent...

Hello, I am trying to determine two things in relationship to Excel 2016's computational abilities : 1.A benchmark on how to guage the processing power of Excel 2016 on my particular system. 2.Figure out how much computational power is needed to calculate up to 10 Excel sheets. For example...

Some Background We provide a software system to organisation to manage their grant making processes. Our online system removes laborious paper centric practices and moves this all online. When a client signs up with us, we need to import a history (3 years) of their grants so that when...

Good morning, everyone. I have a pivot table that I would like to add some conditional formatting to and I am not sure how to accomplish this. I have monthly sales average for System 1 and System 2. If there is an increase with System 2 compared to System 1, I would like to show cell filled in...

I have multiple cells around 200 having each cell text like below. I need only information starting with 1. up till 1. ends (Example: 1.A mounti... ...in disalignment. ) Following description includes: 1.A mounting system for supporting on a dental endosseous implant having a longitudinal...

Seeking laptop recommendations. I’m currently on an XPS27 AIO which is a 64-bit operating system, Intel(R) Core(TM) i7-4770S CPU @ 3.10 GHz with 16.0 GB installed RAM.

I run reports for ticket analysis in Excel using exports from a case management system (very limited report functionality in an old system). I build up a set of data, each week/month adding the latest resolved/new cases within the period. From that I create a worksheet using CountIFS to...

Hi All I have a very large dataset that is given like this <colgroup><col><col><col span="2"><col><col><col span="4"><col><col><col span="4"><col></colgroup><tbody> Name Manager Trainer Department Start Date System 1 System 2 Score Passed/Failed Score Passed/Failed Score Passed/Failed...

Hi, I've been struggling with a formula all afternoon, and am in desperate need of help for my own sanity. I have a workflow system which automatically generates references. The system will generate a reference which is always prefixed "GOC-" and then will be followed by 6 numbers. The...

Working with the underlying Excel Post System recently, As a copy a given amount of text from outside the site and then I come into the Post New Thread Textbox and either 1) Control+V, right-click-select Paste NOTHING gets pasted in. What's the problem? Anyone experienced this before? Also...

Hello Everyone Im wondering if anyone knows of a faster alternative to this Array formula- {=INDEX('(System) SC Country 1'!$C$5:$C$5000,MATCH(0,IF(('(System) SC Country 1'!$D$5:$D$5000="Incomplete")*('(System) SC Country 1'!$G$5:$G$5000="Routine")*('(System) SC Country...