additional

Hello, I have the following formula which functions correctly, however i wanted to add an additional criteria which is causing an issue. Cells(i, 20) = WorksheetFunction.CountIfs(ThisWorkbook.Sheets("Adviser data").Range("A:A"), Cells(i, 1), ThisWorkbook.Sheets("Adviser data").Range("d:d")...

I need help with combining Index and Match. Can someone tell me why this isn't working? Below is an example of my worksheet. What I'm trying to do is create a dynamic Index/Worksheet combo that will help me identify the additional cost for the type of filling and size of cake. So, for example...

As the title states, I have a datepicker and monthview control question. Since I didn't have these controls originally under the Additional Controls selection. I found out how to install the .ocx file that will allow these controls to be added to the Additional Controls selection. So my question...

Our company time sheet database is created each week, with each job performed entered each day. Everyone's time is entered as regular(REG) by default. Currently we have to go in and look and see if an employee reached overtime and if so, change REG to OT. One example that takes an additional...

I'm thinking that this may not be possible having scoured the related threads I can find on here... I have a set of data which I want to show as 100% stacked and an additional one I want to overlay on a second y-axis as a line (scatter... whatever). Is there a way to do this? I am plotting...

Hi, I've been looking on this for a while and can't seem to figure it out. I've fried looking for a solution on the internet, but it won't help. So, in column E I want to sum up all amounts in C until a blank cell is reached. So for cell E3 I want to sum up 195,97 and for cell E8 I want to sum...

Hi All, I have been trying to figure out a formula that has 3 criteria, A1 = FRIDAY A2 = MONDAY A3 > 500 A4 result would be an additional $250.00 I can do it multiple formulas, but I am trying to combine into one formula. Thank you

Hi Guys, I have recorded a macro to create a table which works fine but i'm wondering if there is a way to change the range so it looks to the last row in column P rather than the selected range. Hope this makes sense. Thanks Sub CREATE() Sheets("Bethan").Select Range(Selection...

This is what I have ( it is just the SQL part of the VBA). I woud l like to be able to Look up all my values in Column A in Access database and return additional information how would I do that? Set db = OpenDatabase(Dbloc) SQL = SQL & "SELECT Date" & " " SQL = SQL & "FROM " & " Deduction" & " "...

This is what I have ( it is just the SQL part of the VBA). I woud l like to be able to Look up all my values in Column A in Access database and return additional information how would I do that? Set db = OpenDatabase(Dbloc) SQL = SQL & "SELECT Date" & " " SQL = SQL & "FROM " & " Deduction" & "...

The formula below works correctly =SUMIF(Consolidated!D:D,Table!A2,Consolidated!P:P) Basically it is saying that if the value in cell A2 of the "Table" worksheet is found in column D of the "Consolidated" worksheet, then sum the values in column P of the "Consolidated" worksheet. I would like...

Is it possible to add additional range value in the same graph points? For example in the second plot (1, 107.6) (8, 107.6) (7,105.6).. so on instead of the first figures 1,8,7, I need to plot data from a different range: 300, 250,250... so on So the result should be (300, 107.6) (250...

Hi my formula "=IF(D3<C3,D3+1,D3)-C3" works fine. I want to add an additional cell after the calculation.<c3,d3+1,d3)-c3" works="" fine="" i="" want="" to="" add="" an="" additional="" cell="" after="" this="" calculation.<c3,d3+1,d3)-c3"="" which="" tells="" me="" hours="" worked="" for="" a=""...

Hi my formula =IF(D3 < C3,D3+1,D3)-C3 works which tells me hours worked for a person, but I want to add 1 more cell for time worked into the existing formula. I'm getting errors. Please help. Thanks...

So I've slowly worked my way up to experimenting with VBA. I understand a few basic functions but not enough to help me solve this problem, and so here I am. I would like to figure out what code I need to make the selections from two dependent combo boxes display a cell range after the command...

Hi, MrExcel virgin here.... I have two formulas that find the data for a 1st hit, (either =VLOOKUP(A107,'Yr6 Wk1'!C5:D250,COLUMN(D:D)-COLUMN('Yr6 Wk1'!C5:D250)+1,0) OR =IF(ISNA(MATCH(A107,'Yr6 Wk1'!$C$5:$C$251,0)),"",VLOOKUP(A107,'Yr6 Wk1'!$C$5:$D$251,2,FALSE)). These both work fine, what I...

Hi Im trying to make a formula that can take keywords i specify and change them to the name of where they are located in an adjacent cell. This is how far i have got =IF(OR(ISNUMBER(SEARCH("Cap",A2)),ISNUMBER(SEARCH("Hat",A2)),ISNUMBER(SEARCH("Snapback",A2))),"Cap Room") but i don't know how...

This is a Great site, Thank you! To start with I am working with Microsoft Excel 2010 Pro I am new at this, however I have used a few VBA scripts in excel 2010 We have multiple door entry systems that I have been graced with setting up by May. The data is required needs to be in a different...

Hi, I am an absolute excel newbie and desperately need your help. I have a dataset with 2 sheets. Sheet A contains information on 2000 subjects, but Sheet B provides additional info on 500 of those 2000. In both sheets, column A provides the identification number for each subject. Now, I want...

Is this plot realizable in Excel without any additional software?