site

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

In Memoriam of Chip Pearson, and all the wonderful contributions he has made to the Excel Community, we are posting a link to his web site, that has too numerous excellent Excel solutions to identify individually. Here is a link to the Index on his site, where one can easily search the hundreds...

Good Evening Excel vba extraordinaires, :biggrin: I have some experience with writing excel vba code, but this problem has me stumped. Basically, I have a workbook with 5 worksheets that are automatically generated from a template worksheet in the same workbook using the following code...

I have a data set of different sites and different events that occur on them, broken down by month <tbody> Entity KPI Jun-16 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18...

Hi, I’m seeking guidance on working backwards from a vba code that was built into a tool by a remote coworker that I can adjust myself. The vba code calls on other scripts from within the same document to get “store address” and other pertinent information to run the Main script - the one...

If you have ever done any serious VBA programming in Excel, then it's almost a lock that at some point you found yourself at an impasse, did a search and found yourself visiting www.cpearson.com where you found a well-documented and well-explained solution to the problem that had been vexing...

I was sad to see on another forum the reports of the death of Chip Pearson. Although I never had any personal dealings with Chip, I (as I would expect many others) used his site for many years for reference and learning. Just wish to post my condolences to his family and friends and although a...

Hello everybody. I'm navigating IE with vba. Now, I need to answer "yes" to the following alert, as I do in manual navigation, to enter the intranet: https://imgur.com/a/J9SSbyI Consider: 1) the alert is exactly what you see in the image, but Current site and Intranet site are different (I...

Hi everyone, Just wanted to introduce myself, and say thanks for the help I've received from searching this site over the last couple of weeks. My name is Tyson. I work for an Aerospace Manufacturer (supplier) and do a lot of data analysis. Our ERP system handles the majority of our data...

I've been working on a formula that counts how many sites fall within the radius of another site. This is the formula I've used. =COUNTIFS('0301 Master'!H:H,"<"&$D2,'0301 Master'!H:H,">"&$F2,'0301 Master'!I:I,">"&$E2,'0301 Master'!I:I,"<"&$G2) Is there a way to list the names of the sites that...

I would like to count the number of times a number string (numbers in bold in Column A) occur in a cell (# in Column B) throughout my file of XXX # of rows. The number string varies in length but the format is always constant (i.e. #.##.##.#). Thanks, in advance, to all for your help! <tbody>...

Hi all, I am trying to make a cell highlight in red if there are more than 1 condition present. The table below represents a work rota and also a holiday planner underneath. The initials of each employee are entered into the rota for each day they are at work. If they are on a rest day (RD)...

Whats the easiest way to copy and paste cells on this site so that someone seeing them can copy and paste them to his excel? Btw are attachments allowed?