1st

hi, Doe anyone have the solution to my issue? I would like to email the applicable workbook to out look. It will always be ( for the foreseeable future ATM) to the same recipients. 1 x to 2 x CC however, I need the subject line to contain the WC (IE 03/09/18) which will change weekly &...

Have purchased excel again recently. Cannot convert 2 formulas from open office. 1st is =SUMPRODUCTS(S14:S7409=06;T14:T7409=Q6:X14:X7409=R6;Y14:Y7409) Any help please

Hi everyone, I was checking previous posts but I am not able to amend the formula in the way I wished. So I have following table <tbody> 1st week 1000 2nd week 2000 3rd week 5000 </tbody> In C1 I need a formula that multiply B1*0.5 if A1is "1st week", if A1 is 2nd week multiply...

Hi and thanks in advance! If I wanna know the Week Number of a quarter, I can use, the formula: The Dates are in Column D =WEEKNUM(D3;1)-WEEKNUM((LOOKUP(D3;DATE(YEAR(D3);{2;5;8;11};1)));1)+1 But in my company the first quarter stars the 1st of november, the 2nd quarter the 1st of february...

I am trying to set up a formula using maybe the MOD feature in excel to show break downs for pay-out spots (Golf Tournament) for this example 1st thru 7th position. Total amount of money is $4,680 Finishing 1st 2nd...

I have an if statement and I want to add an additional if(Vlookup) to it. The first if statement is handling a specific rule. I want the if(lookup) to handle everything else. The fields for the 1st if statement are blank in 'Company Info'. Can this be done as I am getting an error...

Hi all, I have the following set of data: <colgroup><col><col span="2"></colgroup><tbody> Name Event Place Athlete 1 A 1st Athlete 1 C 1st Athlete 1 D 1st Athlete 1 E 1st Athlete 2 C 2nd Athlete 2 D 2nd Athlete 3 A 2nd Athlete 4 E 2nd Athlete 4 F 1st Athlete 5 B 1st...

I manage a dB that tracks volunteer availability for a local non-profit. I have created a userform with various search criteria such as "who will work on a specific day of the week or who is willing to work evenings, etc. The challenge I am having is many of these volunteers are snowbirds who...

Hi guys, I'm new to macros and I'm enhancing this report of mine for efficiency. I was able to create the 1st two modules (for formatting and some computations). This is for the 3rd module and for the final step. The scenario goes like this: 1. I have a source file (Working file.xlsx). This...

I need to limit the choices in a drop down list (numbers) based on the users selection from another drop down list (numbers). The method I have gotten to work is not optimal in my opinion and I'm hoping someone has a better way to do it. What I'm currently using is the INDIRECT function combined...

Hi I am trying to automatically copy the percentage in a cell to a cell on a different worksheet on the 1st day of every month to track the progress of a task. For example I update cell a1 each week and the percentage increases but on the 1st of each month I would like this percentage to...

hello all, i have had help on this before but i have added something new and can't work out the formula <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Win Price Place Price Win Outlay Place Outlay Finished Win Amount Place Amount Won/Lost $4.70 $1.90 $50.00 $50.00 1st...

Hi all, I'm new to MrExcel I'm trying to work out which input to use for this scenario. In cell A2 i have 4 different win prices i can use So what i want to be able to do is when i enter a price in A2 it will automatically put the outlay amount in cell B2 and in cell C2 when i enter 1st i want...

Hello, I would like to create a formula that works from the first date entered into a cell. Scenario: 1st date is entered by the user. In another column, I would like the following month but it should start on the 1st. Example: User Enters the 1st date in the first column. The second and...

This one has got me puzzled and I'm sure there is a simple solution. I have a long list of rankings for various statistical tests, i.e., A 1 B 2 C 3 A 2 B 3 C 1 and so on. I just want to determine how many 1st, 2nd and 3rd place rankings of A, then of B, etc. There is no real range to use a...

Hi, I have a dynamic number of rows, and set number of columns up to column S. I want to automate where the code starts in cell S5, and goes down column S only to the bottom of the table such that; - If the very 1st character of the next cell down is the same the very 1st character of the...

Hi Posting for the 1st time in an excel forum as I cannot locate a solution to my day query in excel. I have a list of dates from 1st April 2015 to 31st March 2016, each date has a numeric value associated with it. I need to build a profile for 2018 from 1st Jan to 31st Dec, the issue is 1st...

Ok, so I am creating an attendance sheet and I have it looking up the employee's # of points and letting it dictate by vlookup what level write up that employee is on. The catch is, if a employee has a no call no show they receive a point (like an absent) but also a right. Excel gives them the...

I know it doesnt make sense but this is the situation I am facing. I have 3 tables, 1st table has column A, B 2nd table has column C, D 3rd table has column E,F I need to make a new query so the output is now a single table having 6 columns A,B,C,D,E,F How to do this ? There is no index in all...

Hello, I need VBA which can transpose each 4th row, 3 by 3 columns, 1st digits before "-" in the columns N:P and last digits after "-" in the columns S:U. Example.... Cells C8, D8, E8 1st digits before "-" transpose in cells N8, N9, N10 Cells F8, G8, H8 1st digits before "-" transpose in...