applied

This is my first post and was hoping someone could help with my dilemma. I stumbled upon the Solver function in my search but I am not familiar with it and have no idea how to implement it. I will try to be as clear as possible. My client wants my company to use a particular time sheet. I...

Hi, This is a bit frustrating. I've applied code to filter data using the autoFilter function but when I apply a new line with AdvancedFilter it appears it clears the filtered range and copies over all data With Sheets(1).ListObjects("Table13256").Range.AutoFilter Field:=22, Criteria1:="<>"...

I have some pretty simple code that just isn't working... Basically, I want to create a button at the head of a column to toggle a filter on and off. So, if I click the button when the filter isn't applied, it applies the filter; if I click the button when it is applied, the filter is removed...

Good day everyone. I'm struggling to get my head around a bit of formula where I use a COUNTIF function, but have the result subtotal when a filter is applied. I have a list of values in column V; my code currently just looks in that range and counts the amount of times the values are equal to...

Good Afternoon, I am trying to edit the row subtotals and grand totals in a pivot table to include items that have been hidden by the filter. Here is my data: The data table is top left, pivot top right (with filter applied to remove 0's from B) and bottom left is a snip of the pivot...

Hi guys, I currently have a sheet with a column that has different filterable criteria (eg Education, How to, Gaming, Style, Film) I recorded a macro to filter by the criteria 'Film' - however I dont know how to make it so that if I make another macro for 'Gaming', it will not deselect...

Hi everyone, I have a large data set where on some sheets, a filter has been applied to the top row. However, on some sheets, no filter has been applied to the top row. I would like to have all top rows filtered. Can IF statement be used to check whether the top row has filters already...

HI all I have several large numbers 019332961003232531020025441319041221179549530 19332961003232531020021401319041221179549570 1933296100323253102002236131904122117954954 0193329610032325310200235813190411211795387001 933296100323253102002280131904112117953858...

Currently I have worksheet 1 and worksheet 2, pivottable, rawdata. Worksheets 1 and 2 both want to pull info from the pivot table, specifically a value associated with a date, when slicer filters are applied the correct data is retrieved but when unfiltered or the incorrect filter applies the...

Hello, My name is Byron and I have been given a task and I am having some trouble. I have just joined up today to ask for some help. I have had a go at searching for different posts but cant seem to find what I am looking for, so I hope what I want to achieve is even possible. I have a...

Hey, I have a Conditional Formatting running on my excel sheet which will run slow at times, especially when applied to larger range such as $A$1:$z$1000, however if fewer cells are chosen the same conditional formatting will run perfectly. therefore I was wondering if a Vba could set...

Me being out of touch with Excel has me being lost at the moment. Can someone guide me on what I'm missing here? This is what I'm trying to obtain. If a "Y" is entered in cell "C5", it will use a multiplier for tax placed in the cell "D5". If a "N" is used it will use the default amount in the...

Hi, I currently have 2 spreadsheets, where I am using the "Get Data" function to pull data from one to the other. One of the columns I am pulling through contains "hardcoded" hyperlinks (not using any formula), where the content of each cell is the name of a file, and the hyperlink to said...

I am using conditional formatting on a pivot table. But when I open a dropdown box the conditional formating does not seemed to get applied to drop down. How do I do that? Any help is greatly appreciated.

Hi Peoples - pls - when a large & commonly used file is opened or saved it is observed that there may be several Format &/or Control icons present which (I assume) are residual from not being fully applied or cancelled during the use of the worksheet... I'm convinced that these slow the...

I'm attempting to augment Jeff Weir's Easy way to back up CF formats sub but I'm running into an issue when more than one CF is applied to the same range. The excerpt below loops thru both the various ranges with CF (rngUsed) and each FormatCondition that is active in that range. However, not...

Hi I'd like to write some code which will 1) apply an auto-filter to the first row of data that's been put into a sheet (but only if an auto-filter has not already been applied) 2) Checks if the word "Test" is in cell D1 2) If the above is true, then it would filter by the blanks in column D...

Hi There, I need to do a simple calculation between 2 cells in a table. Column headers are "Weight in" and "Weight out" I simply need to deduct weight out from weight in and only want this calculation to be applied when both cells contain value and weight out is less than weight in . Thanks Dan

good morning my boss has given me the task of fining the price before the discount was applied... so A1 has the discount price, b1 has the discount applied & c1 the full cost . does any one have the formula for cell c1? thank you for your help KR Trevor3007

Hello Guyz, I have applied a formula to get timestamp - ( =IF(B91<>"",IF(A91<>"",A91,NOW()),"") ) So it will give the time stamp when B cell filled, I converted format into date only because I want date only.But Now when i applied formula count ifs on this column but it is taking the date count...