advanced

Hi All, I am a VBA newbie and want to find the unique values from a column and store them to an array. I found this thread: https://www.mrexcel.com/forum/excel-questions/67144-filter-list-vba-array.html, and am trying out the post by dk with the following code: Sub CopyToRange() Dim Array1...

<colgroup><col><col></colgroup><tbody> Account Description PUBLIC =*TAN* and *LOAN* </tbody> Sir Can you pls help me Refer above I use Advanced Filter to extract data but not getting any results I need to specify 1 condition for Account and 2 conditions for Description I guess I am not...

Hello Guys, Need some help on this one. This is my formula =TEXT("3rd (E-L) / ","[Grey]#")&IF(MONTH($A$15)=12,10,5)&"th business day by 5 p.m." This is what it displays = 3rd (E-L) / 5th business day by 5 p.m. This is how i want it to display= 3rd (E-L) / 5th business day by 5 p.m. I want...

I am trying to do an advanced filter in VBA and the code structure came from a macro I recorded, with some changes to range references. I am getting the following error: "Run-time error '1004': Application-defined or object-defined error. I would appreciate if someone could help me identify...

I'm starting to use the advanced filters for sorting through my lists of academic journal articles. I like the ability to execute OR searches across different columns. My current issue is trying to apply the advanced filter to find cells that contain, in any order, several strings. For...

Hello everyone, I have a problem with advanced sorting (or at least I hope it needs some more advanced formula). Basically I will try to explain what I would like to achieve on the screenshot. I would like to get to the table in blue using 1 array formula or two separate formulas using (for...

Hello, I'm really getting into Excel VBA programming and I was wondering what are the best books or video series out there to help me learn the language and get past the basics and into the intermediate and advanced functions.

I have data in my spreadsheet in columns A thru P. I use Advance Filter to move some of this data to another worksheet. If I want to run the Advanced Filter numerous times, how do I get it to place the filtered data on the next blank row instead of overwriting the previous filtered data? Can a...

Hello all Any of you could assist me this issue please? How can i do advanced filter unique color only? (Format Condition 3 colors scale) Or any other way to accomplish it? Thank you very much

I have 2 columns of data. I need to count how many Advanced are also Safety and so on and so forth. How many Major are Safety, CD, etc. How many Advanced are Safety, CD, etc. ??? <tbody> Advanced Safety Major CD Standard PD Advanced Safety Advanced PD Major QC Advanced PD...

Hello All, I need to advanced filter a table. I have a list of criteria that varies in length depending on what date I am looking at. This is being driven and calculated by an extended macro which I need to insert this code into. I have struggling to code into a macro how to account for this...

Hello, I'm having a lot of trouble with this one so hoping someone can help. I need a formula to sum a range of cells using the weighting below. I'd really appreciate any help with this. <tbody> 1 Needs Development 2 Basic 3 Intermediate 4 Advanced 5 Expert </tbody> <tbody> Total...

Hi all Please advise for some "Advanced Access Macros Training" I'm working few years with Access + VBA, and i'm very successful, but for MACROS (not VBA) i can't find any advanced training. Thanks in advance.

Hi, I've put together this formula. =IF([@[NOV-17 Finished Goods SO Demand]]>[@[VARIABLE SO Months Average]], ([@[QTY IN STOCK]]+[@[QTY ON ORDER NOV 17]])-[@[NOV-17 Finished Goods SO Demand]], ([@[QTY IN STOCK]]+[@[QTY ON ORDER NOV 17]])-[@[VARIABLE SO Months Average]]) It works, but I need...

hi this is my vlookup =IFERROR(VLOOKUP(C6,'Database BA BB'!A3:C7,3,FALSE),"FAIL") when C6 is empty will result E6 with FAIL text in cell. How do i make it empty. Only when C6 is fill with data. thanks in advanced

Hello, If anyone can help me with this matter I will be very grateful. What I have is a list of columns with checkboxes and I want at the bottom of each column to be a total ! Thank you! here is a picture of the file https://ibb.co/d2Hh7m

Hello, I want to know if theres a marco that can do this and if so, please share. I want rows that contain any value other then 0 to be deleted. Thanks in advanced.

Hi Do you recommend any online pdf book or website dealing with advanced functions/excel subjects? Thank you very much.

I've been tasked with creating a spreadsheet that will extract Records between two dates. I've been trying to use the Advanced Filter. I figured I could record the Macro and the copy that into a button so that the user can change the two dates, hit the button and update the report. In the...

I have a workbook with a number of worksheets very hidden. Is there a way to stop users accessing the info in Advanced Properties?