accomplish

I have a cell where I am trying to determine a multiplier from 0 to 1 in column A to then be used to scale a value in column B that produces another value in column C. However if column C is greater than zero the multiplier must be reduced until column C is zero (i.e if column C is zero I want...

Hi Everyone! I searched through other forums for VBA code that would accomplish this, but was unable to find anything that worked. Essentially, I have 5 sheets (year 1, year 2... etc). In column A of each sheet, I have account numbers. i would like to extra all unique accounts numbers and...

Hi all, Looking for a solution for what I would have thought is something very basic - two ranges for value filters in a pivot. E.g. if I have data: 1,2,3,4,5,6 I want to have two 'between ranges' of say 1-2 AND 5-6 which should return: 1,2,5,6. I cannot for the life of me find a way to...

Hello all Any of you could assist me this issue please? How can i do advanced filter unique color only? (Format Condition 3 colors scale) Or any other way to accomplish it? Thank you very much

Hello All, What formula would I use to accomplish the below. If A1 is 1.5 to 1.9 bring back 101 If A1 is 2.0 to 2.4 bring back 111 If A1 is 2.5 to 2.9 bring back 121 This goes on for a while. Can you please help!

I am trying to populate fields in excel using data from access. What is the easiest way to accomplish that?

Hi Everyone, I am trying to make an email automatically prefill with text and a desired email address based on a specific cell value. I am thinking I need to use a IF statement to accomplish what i am trying to do, but i am not coming up with any success, any suggestions?

Good Morning, I'm trying to come up with a code to insert a formula in the column next to the active cell for example if active cell is A2 i want to insert the formula in B2 and then another one to cell C2 The formulas themselves have references to the active cell such as LEFT(A2,FIND("...

Good Day Guys. I currently use the following line of code to populate listbox1 when the userform is open ListBox1.List = Sheets("PI").Range("Names2", Sheets("PI").Cells(Rows.Count, "B").End(xlUp)).Value The thing is, this code only displays data in column B. For the purposes of this project...

I need to input data into a column. There are 34 different data sets, but they repeat after 34. All the way to around 3000. What is the best way to do this? I know this is probably simple but I haven't found a way to accomplish this after a lot of searching. I have provided an example below. The...

Hi, I need some help to accomplish the below, two sort dependent two columns. Before: <tbody> Col A Col B b 2 a 2 a 1 b 1 </tbody> After: <tbody> Col A Col B a 1 a 2 b 1 b 2 </tbody>

Hello, I have 3 cells, let's call them A1, B1 and C1. If A1 OR B1 are blank, then I want C1 to be blank too. Otherwise I have the a calculation for C1. What is the best way to accomplish this?

I would like to create an active hyperlink in my report that would allow me to open a form. Is there a way to accomplish this?