greatly

I am trying to use the MIN formula to return the oldest date from column C if the two IF statements are true. Example of data below. I have tried the following formulas in Excel 2010 but they didn't return the correct information. Any help is greatly appreciated. =MIN(IF(D:D="Yes",AND(E:E="<=...

I need to create a formula to solve this question (put in plain english) so I ask Excel: Look for x in the following cells AI89:AM94 and if you find x put an x otherwise put a 1 if you can only find numbers Any help is greatly appreciated.

to try to keep it simple this is the equation I am working with (A+B)/(A+B+C+D+E)=% I am working this toward a goal % as the answer EX (A+B)(A+B+C+D+E)=15% Goal is 10% How many more "E" will I need to get to Goal any help would be greatly appreciated

Hi, I am using the following formula and would like to only sum everything under 50k, any help greatly appreciated Thanks =SUMPRODUCT(--('04'!$J$2:$J$100=A2),--('04'!$I$2:$I$100))

Hi, I am using the If and then statement. =IF((D6+D7-C8)>=C8,0,(D6+D7-C8)). But when the amounts are less than C8 it should be giving me a zero but it gives me a negative #. When I flip the greater, less than sign it gives me the Zero, but then it doesn't calculate correctly if my D6 and D7 are...

Hi all, Been trying with no luck to write a bit of code to delete all sheet in m workbook that don't end in the word "Trust". I have a report with 50 tabs with 15 of them named xxxx_Trust. These 15 are the only ones I need to keep in my final version. Any help is greatly appreciated.

Hi good people, please help me with a formula that will look at range E2:BV500, and return the column address of the last column in this range which contains a value. So if column AB has a value in ANY cell, and no other columns to the right of column BA has any values in them, I want "AB"...

Hi There I'm having trouble trying to incorporate different formula types in the same cell. Does anyone have any suggestions ? My current data is: Cell A1 = 15 A2 = 0.75 A3 = (either "yes" or "no") In cell A4, I need to: =A1/A2 (to return a % value); as well as If A3 = blank or no, then no...

I'm getting a compile error "Expected: end of statement" with "Pass" being highlighted. Any help getting this code to work would be greatly appreciated. Range("I2").Select ActiveCell.FormulaArray=...

I'm having a problem getting this formula correct.. =IF(AND(B1="SF",B2:B100=N12),B1,IF(AND(C1="LF",C2:C100=N12),C1,)) The result returned is 0, It should return "LF" Any help would be greatly appreciated... Thanks... Michael

Hello, I am using the code below to try to remove rows that contain any value in a certain column (Column AK). Presently, the code is deleting every line. I am probably missing something really obvious, but i have looked on several different sites and I can't seem to sort it out. Any help...

Hi all, I know this is a breeze for some of you, but I'm struggling a little. I have values in G3 and H3. I'm trying to calculate the following If G3 is < H3, make the cell appear blank with "" else If G3 / 2 is < G3 - H3 G3 / 2 else G3 - H3 i.e. G3 H3 14 6 Result of formula would be 7...

Hi, Could anyone take a look into the formula for me please? It seems something went wrong, and all the result Returns to be "0"...

Good Day!! I am a little lost, and hoping someone can at least point me in the right direction. Every month, I need to review 20 hotels on TripAdvisor.com and see what their rankings are. One example here for Hilton Cleveland is #3 of 38 (as of right now, may change at some point). Here is...

Hello all I have a file with about 100 different sheets. I need to be able to print individual pdf's of each sheet automatically. I currently use the following Dim ws As Worksheet For Each ws In Worksheets ws.Select nm = ws.Name ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _...

Hi All, Here is what I am trying to accomplish: I have a project in which I need a quantity of 123 'widgets.' These 'widgets' come in cases of 100. Need a formula that will return the value of 200, when comparing 123 and 100. Any and all help is greatly appreciated. /twg

Hello, i have sheet 1 that is the lookup, sheet 2 is the find and return the total of column3. I keep getting ref# or N/A. I need to sum all instances of A17 from sheet 2. My formula is {=sum(vlookup(A17,'Sheet2'!B1:B30,3,false))} Any help is greatly appreciated

Hi Guys, As the title indicated, I tried the Vlookup formulas in cells which is filled in colour to indicate the Status, but it doesn't look up the value(colour) Could anyone help me to come up with a formula to look up the colour as per items? any help would be greatly appreciated ! Thanks

Hello Forum, Hopefully someone has some pointers on this. Normally I can figure out little problems like this but this one has got me stumped. Obviously my Excel skill are not as good as I thought they were !! Here is my challenge... I have a set of numbers which are grouped, sometimes...

Hi, newbie here! Im trying to complete my cable calculator tool and wanted to add some automation to it. I have added some parts but stuck with others I would like to use G17 to take the value calculated in G15, apply it to the table in whichever column selected in G2. I have got it working to...