needed

Greetings all - I'm stumped on how to perform a weighted average using three criteria. I'd appreciate it if you folks could help me out. The formula if it were a simple weighted average is below, as well as the 3 criteria needed. Criteria: IF Sheet1!A:A="North" IF Sheet1!B:B="Apple" IF...

Hey everyone. I have a conversion table and a formula working to give me a conversion rate based on dropdown lists. This formula was always intended to work on a userform but i wanted to test my formula before trying it in the userform...

I have a large workbook with 50+ worksheets of physician names that I want to put in alphabetical order to make it easier to find each tab as needed. Is there a way to do that beyond manually dragging the tabs? Thank you!

Good day to all, Hoping for help with the following issue, Column A contains the original data; Column B determines the number of needed repetitions for each value in column A, Column C needs to shows the results. What formula can be used for this operation to work. Thank you <colgroup><col...

hi Friends , i am just trying to write the VBA Code for multiple if statement even i have recorded the MACRO however i am not getting the results what i needed , below is the formula in excel IF(AD2<=0,"Negative",IF(AD2<67,"$1 - $67",IF(AD2<100,"$67 - $100",IF(AD2<200,"$100 -...

I wanna count with these criteria: Col A Col B Col C Type Sex X M X F Y F So I want to count how many F are there for X How many F for Y. How many M for X etc. Thanks in advance. Kelly

Ok, I've done it before and now I can remember how I did it. I need to only return a value in row 24 if there is a number in row 18. If there is a number in row 18 the value in row 24 is Row 17-Row 18. Heres a quick example of the table. <tbody> A B C 17 Needed 120 120 18 Active 100 19...

I'm having a problem with getting arrays populated with functions that are called from a dll. A quick example is: Private Declare Function MHL200_GetDLLVersion Lib "dll path" (ByRef pulDllVersion() As Long) As MHL200_ErrorEnum Then, I call it as such: Dim ulaVersion(2) As Long...

macro needed in cell P2 I want to count the positive numbers in col AK (starting row 19) If col D reads "cap" thanks ironsides

I have a workbook that I use to create labels. It is pretty simple. There is one tab that the user would type in the last name of the person in column A and the number of labels needed in Column B. Table Name: <mark>Teacher Names and Numbers</mark> Name Qty Smith 2 Doe 3 On the...

I need to find the number of months between 2 dates, I have tried "DATEDIF" but this does not give what I require, below is what is needed <tbody> A1 B1 Months 01/01/2017 29/01/2017 1 01/01/2017 01/02/2017 2 01/01/2017 28/02/2017 2 01/01/2017 01/03/2017 3 </tbody>

Good Afternoon All, First time poster, long time lurker! Great forums helped me out many times! Hopefully someone can help with this quesitons? I have created an action tracker in Excel and I've used a formula to indicate if actions have past their target completion date. The formula i have...

I'd like to highlight a row in conditional formatting -- only if the row contains the value of column D, and the Sum of Column L is equal to the value in column F. I've tried a few formulas but to no avail, please let me know if clarification is needed as this may only be making sense in my...

I need to calculate multiple means depending on the qualification codes. I have an example where I did it manually, but it is a lot of data that needs to be processed and there must be and easier way. Currently I'm using the following to calculate the mean: =+MODE($B$3:$B$12), but I need to do...

Hello, I have created the following formula: =IF((AND(AC2="N/A";AQ2<=TODAY()));"Error";"OK") This is working but I need to add another condition; if AC2 is blank then it should be 'Error', if it is filled then it is OK. Basically need to combine the following: =IF(AC2="";"Error";"OK")...

<tbody> Reg No Class PG Nur KG 20 PG required answer is 3 instead of 4 Same Same 25 PG 27 Nur 29 KG 30 PG PG Nur 35 Nur </tbody>

Hello all, Here at work, I need to figure out how many more PTs are needed to reach the target goal of 15%. What formula can I use in order to get the amount without figuring it out myself. Any help is greatly appreciated. Thanks! <tbody> PTs WELDS PTd % GOAL % PTs NEEDED TO REACH...

Hello friends, I'm an high-school manager for youth at risk in Ramla City at Israel, and asking to have a print report from excel sheet of my pupils books lending from school. I want to press a "print" button at D8 cell, and then to receive a print report of the information at row 8. A...

I have sheet1 as laid out below. I need a transpose code I think so that there is only 1 number from column A but all the numbers from C going horizontal on sheet 2 I am happy to make a donation to charity for a quick solution on this one. Excel 2010 <tbody> A B C 15 ECAU1131TA BOSAL...

I need to create a field that extracts the first initial from the last name so I can sort members alphabetically by last name. I'm using the Left function which does the trick but I ran into a situation where someone has a maiden name in front of the last name so all the is being returned are...