good

If 2 Criteria is meet then Cell = that percentage Increase. Example1 IF Cell A3= Hammer IF Cell B3= Poor Then Cell C3= 5.00% Example2 IF Cell A4= Socket IF Cell B4= Good Then Cell C4= 10.00% My Chart B5 = Socket E6 = Damaged F6 = 3.00% E7 = Poor F7 = 4.00% E8 = Fair F8 = 6.00% E9 = Good F9 =...

Hello, Good Day! Is it possible to create a transparent listbox?

I need a formula that will return the contents of a cell if two other cells contain one of the numbers in two different specified arrays. I laid out the argument in another question on this board but may not have done a very good job of if. It can be found here...

Hi I formatted a group of cells to Number-->Fraction. The entered 1/2, 1/3, 10/12 and I got these number 1/2,1/3, and 5/6 in the right hand side of these cells (so far so good) but when i typed 10/11 or 11/12 , I got 1 in the middle of the cell? Why is that? Thank you.

Good morning gang. Hope you're all well. My question is around a worksheet I have like this: <tbody> Division Business Unit ID Owner Value Steam Tier Status Championship Delivery 1 14 John Smith Stream 4 Tier B Good Championship Delivery 1 14 John Smith Stream 2 Tier A Good Premier...

Hi, there are so many smart people here, and I was wondering where all of this education comes from? what is the most important basics someone would need to understand programming? to be a programmer does one have to be really good at math? i personally have no formal training, but have...

I need to build logic for below statement: If 2018 Favorability % is greater than 2017 Favorability %, and if 2018 Favorability % is greater than or equal to 70% and if the difference of Favorability percentages 0f 2018-2017 is greater than or equal to 10%, then “positive”, other than that...

Hello people I'm using a new laptop. It doesn't have an 'Enter' key. I can find no way now of entering an array formula. Is there a way around this that anyone would be good enough to share? Many thanks in advance.

Good Evening to All... Can a workbook be protected from being copied ??? Thank you.

Hi I just downloaded office 365..don't know if it's good or bad. The download was free and the yearly fee will be (as long as I stay in good graces with my brother-in-law) :) Is there a way to go back to my old one (Excel 2010)? Some of the ribbon icons changed and I want to see what they...

Hello, How would I be able to clear the contents of adjacent cells based on the value in another? For instance if VDS column value is bigger than zero like 2, then cells B1 and B2 shall be cleared from their existing content that is currently "Good". If value is 4, then 1st 4 cells shall be...

Good morning, I have a column with about 4000 numbers. I want to see how many cells in this column have a value greater than .17. Thanks,

Good morning, I have a sheet in Excel 2010 with over 24000 rows. Each row has info on my part, whether it's "good" or "bad". I want to delete all rows that have "bad" in column C. What's the fastest way to accomplish this? Thanks!

I have been lookin and haven’t come across what I am wanting to do I have a spreadsheet with all of my shop computers and the dates that software expire. I want the backgrounds to be green while the dates are good. When it gets within 30 days I want it to be yellow or orange and turn red the day...

I am pasting a large amount of formulas. Is there any way to check that I have not stalled excel. I do not yet see a progress bar. The little circle keeps turning, is there any way to see if this has not stalled for good. Usually I will just wait for a period of time and then reboot. Is there a...

I posted the other day for some help with a fitness group spreadsheet and the forum was very helpful. I come again asking for advice / help. The fitness group has daily tasks to complete for points (good tasks) and ways to gain negative points (bad tasks). There are 5 good tasks and 2 bad...

Hi Got to be a way to do this I filter by column A and it shows if any cells are blank but text in B to G I manually type in Blank I use a simple macro to do this bit it only works in the last cell is there a better way below is what I use. ActiveSheet.Range("$A$1:$G$3000").AutoFilter Field:=1...

Good day all. Hoping there's a good samaritan out there that can help me for a minute. The reason I joined this forum today was to research whether anyone else was having delayed responses when using active x comboboxes in 2013. What I have is very basic, the combobox is linked to a dynamic...

Hi all, I have an AVERAGEIFS statement that I need to take two different criteria on one range. when I try it, I get the good ol' #DIV/0! error. The statement is as follows: =AVERAGEIFS($B:$B;$C:$C;"MRO";$D:$D;"<25";$E:$E;"jakarta";$E:$E;"bali";$R:$R;">=01/01/2018";$R:$R;"<=31/01/2018") It...

I just received a new computer at work and in switching from Excel 2010 to 2016 some of my workbooks haven't fared as well as others. In one workbook that I use daily, I have several stacked area charts. All of the areas are gray with white borders. Even after I change the fill color, it...