instances

Hello I have a range of data in O5:O45 with some cells being blank. Is it possible to come up with a formula that ignores and blank cells and looks for instances where there are 2 values under 2, 3 under 3, 4 under 4 and 5 under 5 and return a 2, 3, 4 or 5 as appropriate? Thank you

Hello - Looking for a FORMULA that can find all instances of parentheses and replace with an S. There can be up to 50 parentheses in a cell if that matter. A1 = H2N-(dA)(dVaaaa)(Dava)(dC/CyMal)-OH A2 - H2N-SSSS-OH Possible?

Hello Friends, <tbody> 1 2 3 4 5 6 7 8 9 10 AZ 72 95 77 61 36 60 82 70 76 71 CA 26 90 10 56 61 2 27 53 7 86 NY 41 39 70 60 31 73 93 38 64 1 PA 46 54 62 77 7 28 6 22 54 41 VT 57 35 17 52 51 88 79 61 5 29 </tbody> I am...

I'm using this formula to count the number of instances when a time value falls between 00:00 and 06:00; The range B2:B998 is formatted as Custom hh:mm but the formula result is giving me zero, which is not correct. Can anyone spot where I am going wrong please?

I am sure it's something super simple, and it may be something that can be solved with out VBA. I am looking to highlight the cell of up to the first 3 instances of a unique value in a column. The column might have the unique value twice or maybe 15 times. Thanks <tbody> A highlight A...

Hello everyone! i am trying to determine if there is a way to fade in the first object (on-click), then when the second object loads (on-click) the first object fades out or disappears. Is this possible in the newer instances of PowerPoint? Does anyone have any good suggestions to get help...

Hello How do I do this, please someone please point me in the right direction?? If a row contains a single 'NO' (like Row 1) I'd like to count that as one. If a row contains multiple instances of 'NO' (like Row 2) I'd like that to be counted just as one. I'm not interested in counting the...

I'm using Excel from Office 365 and am having an issue that I don't remember having in previous version. This is the issue: I open Excel from a desktop shortcut or the Start menu and a blank workbook/worksheet opens as normal. I then open a workbook/worksheet that I have saved from the pinned...

Hello this is my first post here. Hopefully I can be clear with my query so you all you excel genii might help. Here is a sequence of numbers in a column 100 20 -78 5 -99 -54 -34 6 0 34 55 89 32 -3 -78 Now I need to COUNT the number of instances of the following data set. The answer is in...

Is it possible to calculate formulas in a workbook from data in another workbook opened in a separate instance? Purpose: I have multiple workbooks which contain weekly data that is compiled in a separate workbook with a tab for each week. My boss wants to have the data books open on one...

Hello, I have this formula to work out the number of instances of "S" appearing within a range. The below formula work brilliantly, however, I cannot get it to incorporate Bank Holidays. I have all the bank holidays listed in a named range called "Holidays". Can any one help with editing the...

Normally I would just call Workbooks("workbookname").activate and everything works fine. However, I am calling someone else's script which opens up a new instance of excel with the data I need. The instance of excel that my macro resides in doesn't have access to workbooks in this new instance...

Hi all, I have a workbook with macros in it. If I make copies of this workbook and open then in different instances of excel i can run the macro in each instance simultaneously (I have tried this). The same thing i want to accomplish using code as each macro takes at least 5 mins to complete...

I apologize from the start if this question gets confusing... Excel 2010 SP1 tested. In Windows XP if you opened an Excel file from Outlook it would open in the last active Excel instance you had selected. This was if you had two or more instances of Excel running. This has changed in...

Hi Everyone, This is what I have in my cells: <table border="0" cellpadding="0" cellspacing="0" height="15" width="517"><col width="111"><col width="406"><tbody><tr height="17"> <td class="xl155" style="height: 12.75pt; width: 83pt;" height="17" width="111"> </td> <td...

Hi Everyone, I am trying to figure out how to return the text between two different instances of the same symbol. For example, I have this in a cell: 100% Cotton / 55.0 in / 3.2 oz/sq yd / 120 x 70 / 40 NE x 40 NE / Yarn Dye I want to be able to to extract all the information between the fifth...

I am using DDE feeds in my Excel workbook in Sheet1 in cell addresses K1, M1 & S1 which gets constantly updated with the latest values. In Sheet2, in column D (starting with cell address D1), I am able to constantly update with the latest value of K1, whenever a change in value takes place in...

I am using DDE feeds in my Excel workbook in Sheet1 in cell addresses K1, M1 & S1 which are constantly being updated with the latest values. In Sheet2, in column D (starting with cell address D1), I am constantly updating with the latest value of K1, whenever a change in value takes place in K1...

I have a column with several thousand phrases in it, each phrase contains a city name. I need to compare that phrase list to a list of city names and replace all instances of the cities in the first list that match the second list with "2222". Any ideas?

Hi, I have created a class module, and it works fine when I call from the VBA project in which I have written the class module. However, I would like to access my class, from other workbooks as well, so I have tried to reference the workbook through Tools -> References. Now I have access to...