advanced

Hello Everyone, Seeking for assistance to help solve scenario below... I am looking for a formula which would return a non-blank value in a row and cover some additional logic: 1) if the row has one value (i.e. ROW 2 / B2) return that value 2) if the row has two or more values (i.e. ROW3 /...

If you have a table of data, say: <tbody> Name Age Gender John Smith 45 Male Jane Smith 44 Female </tbody> To which you apply an advanced filter which returns cells with ‘Male’ in the Gender field, is it then possible to assign a name to that filter i.e. return a separate column which...

Hi, I have a list of players & their positions: <colgroup><col><col></colgroup><tbody> Alcock, Craig Full Back (Right) Alcock, Craig Central Defender Alcock, Craig Defensive Centre Back Alcock, Craig Full Back (Left) Anderson, Tom Central Defender Anderson, Tom Defensive Centre Back...

Hi, I have a list of players & there rating & there all ranked highest to lowest. But, when there are 2 players that have the same rating it only shows the top one, how do i get it to show the next one? Example: <colgroup><col style="mso-width-source:userset;mso-width-alt:4534;width:93pt"...

Hi, I've got a list of players but i'll just narrow it down to 1 for the reason. At the side of 62.06 i want it to say "Taken" as there is already a player in that position, i just cant figure out the formula. I think it's a VLOOKUP but that just returns the players name & i dont want that. Any...

Hi, At the top of my page i have this: <colgroup><col width="220"><col width="152"><col width="157"><col width="118"></colgroup><tbody> Highest Rated Player (Available): Beestin, Alfie Attacking Midfielder 500 </tbody> <colgroup><col width="220"><col width="152"><col...

hi, right now im using a named range for my advanced filter criteria, but then i tried making the range a TABLE and re-naming the table to the same same (i want to use a table so that it's dynamic if I add more criteria). however, when I run the macro, the advanced filter doesn't work. does...

Hey guys! Is it possible to run an Advanced Filter that accounts for multiple values under the same criteria? Here's what I'd like to achieve: BEFORE: <tbody> ID Name Phone 1 John 99999999 2 Paul 22222222 3 Sara 99999999 4 Vanessa 11111111 5 Andrew 99999999 </tbody> ADVANCED...

Hi folks, Is there a way to use the Advanced Filter tool (under Sort & Filter in Excel 2013) so that my filtered values change as my criteria range changes? For example, I currently setup my criteria range by highlighting my subset (of items I want filtered) and then my master list (aka list...

Hi, I would like to sort data in based on a rank criteria: <tbody> <tbody> responds to questions </tbody> 2 <tbody> uses pronouns correctly </tbody> 1 <tbody> uses advanced propositions </tbody> 0 </tbody> 2 = usually 1 = sometimes 0 = never I would like to produce an...

In my General Settings, I have Enhanced Interface - Full WYSIWYG Editing selected. When I create a new post, it looks like the enhanced editor is active. But when I reply to a post, it looks like it is not until I click on Go Advanced. Is there a way to make it always use the Enhanced Editor?

I am envisioning a way that will allow me to choose an input option from a drop down box (preferred) or a list. Once clicked, it will run a macro in the background and will go find every component that goes into the selected input option. Then it will go to a different tab and copy and paste...

Hi everyone! What I am looking to do is create a dropdown that will autosuggest/autocomplete from a list of products in Column A when starting to type in the dropdown. When confirming the product (by pressing enter), I would like if it could automatically reset, but also add an increment of +1...

Hi guys, Im trying to pull out unique values from a column of a table and trying to paste it in a table of a different sheet. before I just copied the whole column and used remove duplicates, but that was taking a long time since there are a couple hundred thousand lines. then I tried the...

Hi, Good Day Everyone, We need to Download 80 to 90 video & photo. We paste link in excel & from there we want to use Macro store Link:-D:\LocalData\z013304\Kapa If any help or suggestion kindly let me know. Thanks For your suggestion in advanced.

Hi All: I've never used Advanced Filter and I'm having trouble getting the results I want. Here's my problem - I have a list of about 12,000 SKUs along with their price and description in columns D,E,F. I need to remove about 2,000 of those SKUs from the original list and I have those SKUs...

Hi, Excel Experts. I'm trying to create a template that would allow for new data to be pasted in one sheet, then automatically filtered with advanced filtering and copied to a new sheet. In the linked example below I've shown that in Sheet2 I retrieved the selected data from using an advanced...

I have the following data below I want to extract the data on sheet1 containing <14%, >=15% and excluding % using advanced Filter but cannot get it to work Book1AB1VALUEVat %216.810.00%325.250.00%435.3714.00%527.3913.00%627.3915.00%791.0112.00%8309.250.00%9169.2514.00%1011Sheet1 See Sheet...

I have data on sheet 3. I have Sales GP percentages in Col G on sheet 3 I have set up criteria on Sheet 4 to extract the data in Col's A:G where the % > 14% and those less than 14%. However when using advanced Filter all the percentages are being extracted I only want to extract the data on...

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...