instance

Good morning. I have a spreadsheet where I want to find a formula that I can put in a cell that looks at all cells to the right and for each instance where it finds an "x", concatenates the column headers into that cell. For instance in the example below: <tbody> Name Sites Site 1 Site 2 Site...

I want to extract the formula in a cell of another worksheet and then increment that extracted formula by 1. For instance if the formula in another cell is "=B3" then I want the formula in my current cell to be "=B4".

I am sure that this is easy, but I just cant get it. I have a data set that I need to create different arrays based on values in the data set. Value 1 is our starting point of our array. Value 1 is a variable that I have created a helper column in Column H which will have "Start" in the cell...

I have 2 numbers, both 18.19 in value, but the rank function treats them differently. Usually the rank function will assign the same rank to numbers of the same value, but here it assigns a different value, which is wrecking my otherwise nicely working VBA script. Out of thousands of trials I've...

Hello, I have a vlookup that will return values such as the following: 1. "123.123.123.xxx" 2. "123.32.32.89 (VPN)" 3. "123.32.32.89 RT" 4. "123.32.32.89 VPN" 5. "D 123.32.32.xxx S 123.32.123.xxx" I currently have the following formula which only works in the first instance...

Hello. To keep it simple, if column A contains the letters A-C and column B contains strings, how do I return the correct letter (B) in the cell ??? (D1) when I type dog into C1 please? I believe I need to use an array formula containing SEARCH, INDEX and MATCH. I have to use a formula in this...

I have a list if ID's in column A where some ID's are repeated and column B I have a list of dates. I want to be able to find the latest date for a specific ID and wondered if the best way to do this is to use VBA code to use the 'Find & Replace' option to find each instance of the ID and...

Hi, I'm trying to code some data migration between 2 spreadsheets. My stumbling block is knowing how to tell the code where to paste the data. The destination workbook has a list of unique IDs in columnQ but the data needs to be pasted into the relevant ColumnD. I can get the cell reference...

Hello, Does anyone know if it is possible to return the date of a specific day (in my case, Fridays) based on a provided date? For instance, if my cell contains the value 2018-04-17 (today's date), I would need it to return the date (2018-04-20) of the next Friday. Any ideas?

Hi, I have the code below that opens up a new instance of google.com and maximises the screen. How could this be adapted to; (a) go to an instance of google.com that is already open and (b) zoom the web page to 150%? Any help much appreciated. Private Declare PtrSafe Function ShowWindow Lib...

Hi guys, is there a way that Excel automatically opens a certain excel file (example file B) when I open for instance excel file A?

Hi everyone, I was hoping someone may be able to assist me with an unusual request that I have not been able to find a formula for that I have been able to modify successfully. I have a worksheet that contains the many instances of the word "Subnet" within column "D". For each instance of...

Hello everyone, this is my first post, I have tried searching the forum but wasn't exactly sure what to search for and couldn't find an answer I have managed to get this formula from searching on the internet, which is working...

The below formula part of another thread find 1st Instance. Can someone explain 1 Plus. D2 =1+SUMPRODUCT(($A$2:$A$10=$A2)*($B$2:$B$10<$B2))

Hello, I need to get the character instance of the 1st character of a sub-string in a string I can get the character instance of the entire string but not the 1st character of a sub-string in a string Ex ref_value.value = sjdhfss jj sd (ppo nns) GGG sub-string = sd (ppo nns) the first...

I view 1000's of numbers each day on 3 monitors each of which is a custom database tied into a custom database. The key field for each is a product # like '12094'. It would save so much time daily if I entered '12094' in one cell of the 1st instance of the database and it appeared in the other...

I have used the command: Application.IgnoreRemoteRequests = True successfully to force Excel to open a new instance of Excel if another file is opened. The above was tested on Excel 2013 but it seems this does not work in Excel 2016, ie subsequent Excel files still open in the same...

Name Date Reason Amount A 8/6/17 Rent/Bond $2,180.00 B 27/7/17 Gift $1,000.00 A 8/2/18 Rent $2,560.00 C D C F A 6/1/18 Gift $696.00 For instance, lookup all the values of A for a sum total. Is that possible with a VLOOKUP formular.? Thanks snmark

Here's my challenge. When the EU (End User) is adding a new Client, they do so via a UserForm (frm_AddNew). When they click the cmd_Submit button, the UserForm data is entered onto various sheets, and a new sheet is created to hold their Service information. This new sheet is named after...

Hi guys, I'm looking to cleanup data that we are importing from Sharepoint, that comes out like this: S, Alicia;#39;#A, Elizabeth;#121;#C, Luis;#13 As you can see, there is a pattern between the # symbols, so in this case, the desired output would be: S, Alicia;A, Elizabeth;C, Luis; This...