instances

I need to get a new work computer that it's only use will be to use with excel, no browsing no gaming no nothing. Will be using excel 64bit. I currently have a 7700K running at 4.9GHz with 32 Gigs of RAM and a 8700K at 4.7GHz with 16 Gigs of RAM. Now in the past I have had the luxury of...

I need assistance on a formula to return the KPI scores based on the weighting on the below: The formula should read the number on under detail which in row 1 is 31 and return a kpi score from 0 in line 1 as per the scoring criteria. A <colgroup><col><col><col><col><col...

Hello, I have been at this all morning and cannot get it down. I am trying to search column "d" for "wire" or "roll" and insert a formula in column B of each instances row. The formula is counting all instances from another tab. For some reason, my larger macro (bottom code) makes the...

Hi Please bear with me on this one. I have a large spreadsheet (layout below) which tracks the sale of items (listed down in column A) by customer. Each customer takes a range of items, so therefore there are multiple instances of these items in Column A. In row 1, starting at cell B2 is the...

Hello, EXCEL 2013 is there a way to do a STDEVA with a Match function without an array? I'm looking for a formula in column C. I have a large set of data (9,000 rows, 1200+ different instances of column a) with an unknown amount of instances in column a. I want to match column A to column be...

Hi All, I've got 2 columns of data, and need to add the numbers in column B for all the instances of specific terms in column A. e.g. So I have a list of unique values of the A column in another area, and I need to be able to display the SUM of all the instances of that person - so display...

Hello, i have sheet 1 that is the lookup, sheet 2 is the find and return the total of column3. I keep getting ref# or N/A. I need to sum all instances of A17 from sheet 2. My formula is {=sum(vlookup(A17,'Sheet2'!B1:B30,3,false))} Any help is greatly appreciated

So in a spreadsheet that we have to continuously update that my colleague just handed over to me, I just discovered that the Formulas Calculation Option was changed from Automatic to Manual. I would like to know if there are any instances that such switching can occur on its own without someone...

Hi excel gurus! I'm struggling to find any resources on this but is it at all possible to do the following: I have rows of text which contain semicolons after each phrase, I simply want to count the number of instances of these phrases for example: Hello;Error;T-Shirt Hello Error;T-Shirt...

I have a column range(V:V) of cells containing multiple entries separated by a comma (,). I have another column (AD) containing single entries. I would like to find a formula not VBA that counts all instances of a string (like "Make more money") in range V:V happening for one certain instance...

To all, I am looking for a way to count multiple instances of a particular string in a cell over a range. I have found a way to count if a single string of characters is in a cell in a range but I'm having trouble counting multiple instances of the same string in a single cell in a range. I...

Greetings! I'm trying to create a rolling inventory for a series of products in a table that can be expanded indefinitely. Along the Y-axis are two groupings, products created and products sold. These are the only two ways products come and go. Within each grouping are a few empty cells, each...

Can someone show me a formula please that can count the number of instances that a cell value is a minus number and by that I mean less than zero? The range will be G2:G50.

Hi guys, I'm currently looking for a formula that will allow me to count the last 'X' number of instances a value appears in 2 rows and then find the corresponding value in another row. It's best to show this with an example: For this image I need a formula which will count the first 4...

I have written a code that looks for specific data in a different workbook, but the issue that I am having now is that it won't look through other open instances of excel, which is driving me crazy! If anybody has any insights in how to make excel look into ALL open instances of excel I would...

Hello Folks, I want to check the instances of the cells in C column of sheet1 in sheet2. In the D column i want how many instances it is there in the sheet2. For example if i have 200 value in c column in sheet1 the macro should check sheet2 for 200 and return with how many instances it is there...

Replace all instances of character occurring before another character. Column A jon.doe@email.com jon_doe@email.com jon.a.doe@email.com I would like to replace all instances of "." Results in column B should be: jon_doe@email.com jon_doe@email.com jon_a_doe@email.com Thank you!

I haven't worked with pivot tables since Excel97 (?) so aside from losing my feel for how to solve this issue, I'm also not sure if I had ever done anything like this before. Here's the issue... This is an abbreviated mockup of the data: (sorry, I can't post attachments) <tbody>...

I have been using excel 2016 for over a year. Recently, it started opening in separate instances. Therefore, none of my macros will run as they cannot look against separate instances. How can I force it to go back to opening in the same instance. Just to clarify, I am not speaking of...

Hello, I have table below which consist of some values. <colgroup><col><col><col><col></colgroup><tbody> A B C D 20170731-1004452312 0 67 0 20170412-1004326973 0 4 0 20170712-1004426409 0 3 0 20170724-1004453214 0 11 0 20170731-1004458586 0 2 0 20170801-1004447554 0 1 0...