advance

Dear All Need Urgent Help, I have a worksheet with 15 rows when i enter in row 1 i need it to advance filter data which is stored in master sheet and when i enter data in row 2 the filter data of row 1 should clear and it should filter on the value of row 2 similarly for all 15 rows Criteria...

Hi team! Is it possible to combine two formulas like below ones into one single formula? F1: =+IF($C$1="Jan";$B$27;VLOOKUP($C$1;Months!$E$7:$F$18;2;0)*7+$B$27) F2:=+IF($C$1="Jan";$B$55;VLOOKUP($C$1;Months!$E$7:$F$18;2;0)*7+$B$55) Thank you in advance!!

Hello, I have this formula in my project in cell AC4, "=IF(D4>0;AC3-Y4;0)" . AC3 is a date cell equals year 2014. if in Cell U3 i have date 2015, i want to get 0 in cell AC4. Thanks in advance for any help. Best regards.

Hi All, Is there a way of producing a Multi Level Column Graph using Formulas rather than a Pivot Table? Thank in Advance

Hi I create IIF funtion in MS Access but dont know how to Open a Query if result is false. Thanks in advance for the help. Or is there is a way to make it in vba? IIF( [center_checkqry]![Plant] <> "",MsgBox("No new Center/s"),

I am interested in using Sumifs function on blank criterion. i.e. =SUMIFS(F10:F66,D10:D66,"MANUAL ADJUSTMENT (SET)"+SUMIFS(F10:F66,D10:D66,"BLANK CELL")). Thank you in advance

Hi and thanks in advance! if I put this formula in my activhesheet =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) I will get my activesheet name If I create a name named "MyName" when my Activesheet is "France" like: MyName...

Hi I would like a Sub to run every time the number in a particular cell changes. Could someone help me with the syntax? The follwing does not work: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "M3" Then Call Search End Sub Thanks in advance

<tbody> ID # Name Date 1 Date 2 Date 3 29 John 1/9/2011 5/12/2014 42 Bill 6/18/2014 8/16/2017 11/10/2017 112 Jane 9/15/2018 </tbody> Hi Board! Need your help again. Haven't been able to find an answer that works. I need to do a vlookup to find the ID# the find...

Dear All, i have 10 worksheet in a workbook which i update regularly i want a have new sheet where colA and colE are copied from 8 worksheet out of 10. Thanks in advance for your help.

Can we set page break in access if yes kindly guide about it Thanks in advance ?

Hi I want to look up a cell value based on "B" and A7 which contains a number so that the end result should be B23. Im not quite sure how to do this although I believe you use offset. so something like "B&a7" thanks in advance for the help

Enter a formula in cell J4 using the IF function to it whether or not the item Beaded Earrings should go on sale. It will go on sale if its current sales rank (in cell G4) is 8th or lower. (Hint: If the cell value is greater than or equal to 8, it will go on sale.) So far I have =IF(G4>="8"...

Hi guys, I am trying to set up a formula that would automatically subtract 20% (from 100%) for any given value of the given cells: Example: 100 % A X B C X D E In this case, cells B, D and E do not have any value so the percentage should be 60 %. Thanks in advance! :)

Hi Dears, I wanna do this process without column adding and formula. Only macro i need. Could you please help me about it? Thank you in advance. A column data 5555555555 555555 5555555 4444 444 444444444 333333 3333 33333333 B column formula left(A1,3) C column formula lenght(A1) D...

Hello, I am wondering how will my formula below will output me " " (double space) if the resulting value of this formula is equal to 0 Formula: =IFERROR(INDEX(A:A,MATCH(C1,B:B,0)),"") Any help will be appreciated. Thanks in advance.

Hi All, I have the following code in place which work, however if the search finds an empty cell it return "0" but I want it to be blank instead, how can I adjust the following formula? =IFERROR(VLOOKUP(A4,test!$A$1:$L$108,12,FALSE),"") Thanks in advance

Hello, I need help with a formula. i need to show YES if Cells C1, D1 are empty, and NO if they are populated ( C1 & D1 would contain date . Thanks in advance

Hello friends, Hope all is well! Is there a shorter version to make the below formula? it suppose to give a 1, if any result showed up in a certain month, and provided that the amount related is above 4999. 1. Basically, the point is to show the number of months that had any activity or...

Goodmorning from Greece. Is it possible to put the name of every sheet in my workbook in a specific cell (a3) of each sheet? thanks in advance!