values

Hello: Is there a formula that can count only the visible and unique values in a column, based on criteria from another column? This array formula I have counts the unique values with criteria, but it ignores filters and counts non-visible cells...

I have a formula that uses a match and index function to display the correct data. I have a dropdown list of values in cell ("B3"). The formula finds the matching value of cell ("B3") on sheet ("Competitor Comparison Data") which allows me display different sets of data, depending on what value...

The below formula is counting values in the P5:P313 range; since I also have values in Q5:Q313, how can I fix this formula to also count what's in Q5:Q313? =SUMIF(D5:D313, "GS11", P5:P313)

Hi Everyone, I am trying to calculate the difference between two values and multiply with payable days and sum up all those values. Like, here is my sample formula for one cell...

Hi I am struggling to find examples on how to sumif between visible cells. Here is the formula I am trying to adapt to visible cells only: If it matters Q4 and R4 are cells with TIME values. =SUMIFS(C:C,G:G,">="&Q4,G:G,"<"&R4) Thanks for any help or direction! SD

Hi all, I wonder if there is a code for doing the following: I have a WB called WB1 with Sheet1 with links to another WB, called WB2, Sheet2. Is there a possibility to delete all the values that came from this external file (WB2)? I mean erase all of them quickly. Thanks in advance!

Hi All, In case my subject line may not be self explanatory, apologies for that, I shall try to explain it better below. I have a data dump of a sheet. I want to create a sheet where I can get a summary of specific criteria/columns based on an input. I believe I would need to have an input...

Hiya I have a table where I have a simple sumif formula to calculate for each week Each week when I run an update, I need to paste the week I’m running as values so the table will have inconsistent table formula my question is that can I do that so the table formula can have cells in between...

Hi there, In a peice of VBA code I am a using Copy-Paste with xlValues as follows: Dim Sourcebook, Targetbook as Workbook Dim Sourcesheet, Targetsheet as Worksheet Dim Sourcerange, Targetrange as Range ........ Sourcebook.Sourcesheet.SourceRange.Copy...

Hi All I am inputting values into row 2 under certain labels. Each label has a value which corresponds with the values in table A5:B9. The total is then shown in cell B12 (product of a multiplication). I am trying to remove the intermediate step which requires table D12:E16. I assume a...

Hello, I'm attempting to do a VLookup in a macro while using the Match function to dynamically determine which column to look in. I did some testing by sending values to a Msgbox to validate I am passing the correct values. Ex: MsgBox "Match Value is : " & Match1 <== the value was 13...

Hi, I've searched through 4 pages of "Subtotal" posts in this forum but didn't see one that covers what I need. I just want to have Subtotal values appear to the right of the column being sub-totalled rather than directly below each group of numbers. The col to the right would be created just...

<tbody> A B C D E F G H I J K L 1 Project Value x x x Title Hours Title Hours Title Hours 2 15 Bob 3 14 Justin Bob 4 15 Bob Justin 5 18 Justin </tbody> Can someone help? I know this should be fairly easy, but I am struggling with it. I am...

Hi, I have a Table with days like this: I need a formula that if x number of days have passed it will do something. For example, if 5 days have passed since last time, "sum these two values" column A= C+D, if 5 days have passed since last time there was a value in the column: <tbody> 1...

Hi, I have a sheet with 15000 rows and in column AV-CK have values which can contain duplicates. I'm trying to get in CL the unique values from AV-CK (merged / concatenated) Everything I've found so far (advanced filter, autofilter, remove duplicates) work on a range of values in one...

I wrote this code for a project. It filters two tabs then appends one set of values to the bottom of the other and then saves the result to a new file. It works fine, but sometimes with 100 or more values for "i" it can take a while. Any suggestions or different code to make it run faster...

Hi, I have an excel sheet given below. The pivot table shows the "Amount" portion correctly but in the "Qty" portion, values which are repeated are shown only once. How to show all values in Rows?? Excel 2007 32 bit ABCDEFGHIJ 1Sum of AmountColumn LabelsComm.L / ULQtyRateAmount 2Row...

I don't think I'm on the right course for converting my text timne values to that time's decimal equivalent. pgm_start = (TimeValue(uf8_post.uf8_d_start.Caption) / 24) pgm_end = (TimeValue(uf8_post.uf8_d_end.Caption) / 24) uf8_d_start and uf8_d_end are text boxes in userf orm uf8_post. They...

Hi All, What would be the best way to see what values obtained by Dischargers were above Pollutant Limit Values? I am dealing with 77 Dischargers and 126 pollutants, meaning, I have 77 spreadsheets and I need to check for each pollutant (126) if they were above the limit. I know how to do...

ok got this far and the masg box shows last row values but having trouble on figuring out how to put those values in Sh5 column O , so it finds the last row in sheets 1 -4 , just want to paste the last row value into 4 cells starting at O1= lastrow hS1, O2=lastrow Sh2,O3= lastrow Sh3 and O4=...