put

I'm sure this has been asked before I need to do a countifs > or = one cell then < or = another cell and and third crietera equals "Yes" This is on office 365 excel when I put the expresion into the cell it just shows the equation. =COUNTIFS(Input!A:A,(">="(Output!C1)),Input!E:E,"Yes") I have...

I have 118 years of data all on one line that looks like this: It needs to be put into columns so it looks like this: So far my Excel skills have come up empty on this one. I have Excel 2007

Please help. I need to put a formula within a formula. I have to create a table on y values for the formula y=1/2at^2 +vt when t is seconds and v is ft/s and given that a=32ft/s^2. T, and v are both numbers but a I'd another formula and I dont know how to put it in my formula for my table. Any...

I want to use a date as a criteria in my formula. How I typically do this is =IF(B5>A1,...... Where B5 is a date and A1 is a date. Or If(B5<NOW().... But what I am trying to do here is put an actual date in the formula. I want to see if B5 is > January 01,2019. Do I have to put 1/1/2019...

i have the following table: Table 1 <tbody> A B 1 payment 1 375 2 payment 2 370 3 payment 3 365 </tbody> I want to create summary in another sheet that if I put "2" then i want to sum both the 375 + 370, but if I put 3 then sum all 3 figures. I was trying to do something along the...

Hi, I am doing a assay formula for sum(if statement from one workbook to another workbook so the value stays even though the source workbook is closed. I need to have it =SUM(IF('[Source spreadsheet.xlsx]Current'!$K:$K=E35,IF('[Source spreadsheet.xlsx]Current'!$F:$F="NAME",IF('[Source...

I have a table in my spreadsheet that gets rows added to it as needed. I want to put a 1.1 into cell AB for a given row. This is to occur when the row is selected and a button pressed. Can someone help me please?

Hi I put the following formula into a blank cell. =A5*-1 and it converts from a negative to positive figure. I always thought that if I was to click on the bottom right of the cell I put the formula in it copies the formula all the way down the worksheet but it dont? Any Ideas? Thanks

How to I test the result from either VLOOKUP or INDEX/MATCH and then put it under the relevant column? I have entered 2 examples below of where I would like the values to show because they are within the value range for each ID I can't seem to add the greater than or less than elements to...

I am a bit confused with regard to the Lifetime and Scope of variables. Given this code: Option Explicit Dim a As Integer Sub FromSheet1() Sheet3.Select a = 1 End Sub Sub FromSheet2() Sheet3.Select a = 2 End Sub Sub GoBack() If a...

I have a column that is in text format with entries like 00:01:22, 00:00:38, 00:10:55, 00:00:09, etc. These are times as in hours:minutes:seconds. I need to put a filter on these and filter anything that is greater than 15 seconds, i.e. ' > 00:00:15 ' I tried the recorder, but couldn't make it...

Hello all, I am looking for a way to do this: If a cell in a column is blank, I want to take the value from the cell to the left of that cell, and put that cell's value into another sheet. How can I do this? Thank you for any help!

Hey All, I've looked through google and remembered I've been helped before here, so I figured I'd ask. This is probably simple for most, but for me, nope. I'm looking to use Excel to keep a track of people I play games with, say I've got a game with 4 players maximum, and 12 players, I want...

guys is this possible in macro i have 2 workbook workbook 1= where i put a table workbook 2= where i will put a criteria i want a button on workbook 2 that will filter the table on workbook 1 depending on the criteria that i will put on workbook 2 example. i have a list of names on a...

I need to show certain percentages if certain numbers come up. The formula can be in A1 and the number can be in B1. Example: If B1 is equal to 2.9 or less put in a 0 if B1 is equal to 3 but less than 3.5 put 10% if B1 is equal to 3.5 but less than 4.0 put 15% if B1 is equal to 4 but less than...

Hello everyone, Quick question here - I downloaded one of Microsoft's sample project plan templates. As I started tweaking it, I noticed underlying logic seemed to stop working. The cells have a progress bar, so whatever percentage amount you put in the bar in the cell adjust to show.... so...

My workbook has two worksheets, Sheet1 and Sheet2. If I put this code in a standard module, it's fine: Sub SetRange() Dim rng As Range Set rng = Range(Sheet1.Cells(1, 1), Sheet1.Cells(100, 1)) End Sub but why is it when I put it in Sheet2, it fails: Private Sub...

Hi, I have a formula like this =IF(OR(COUNTIF(A1,"*"&"ABC"&"*"),COUNTIF(A1,"*"&"DEF"&"*"),COUNTIF(A1,"*"&"GHI"&"*"),COUNTIF(A1,"*"&"JKL"&"*"),COUNTIF(A1,"*"&"MNO"&"*"),"IMPORT","LOCAL") Is there a way to just put all wildcards condition in a column to make to formula shorter? I have a total...