Search results for query: *

Thank you very much SkipVought!!All great suggestions. I appreciate the input.

Thanks, just looking for a formula.

Thanks Denial. Sumproduct works

My post from 24 Jan 23@21:13 did answer that question. The individual TrackNo will always have the same priority. So if 8710 has a priority of 1, then all instances of 8710 will have a priority of 1 There will never be contradicting priorities. Any help is appreciated.

Like I said data will change every day. Tomorrow may look like trackno priority 8710 1 8710 1 8720 1 8730 0 8740 1 8740 1 8750 0 8750 0 so answer here is 3. Represents 3 unique trackno with priority =1 (8710, 8720, 8740)

The data will refresh every day and the number of rows can and will change, along with the priority. I don't see dynamically specifying a range with priority=1 every time the data refreshes. The individual TrackNo will always have the same priority. So if 8710 has a priority of 1, then all...

Column A (TrackNo) is numberic and I can make sure the values in column A are soreted

I don't see how COUNTIFS will work. If I count the "TrackNo" that has a "Priory" of 1, it will return 3. I need it to return 2. Trackno 8710 is listed twice, I only want to count it once.

In Excel, I need to count the unique values in one column based on the values in a second column. Here is my example using data in columns A and B Column A Column B TrackNo Priority 8710 1 8710 1 8720 1 8730 0 I want the unique count of "TrackNo" that...

Thank you very much. Works for me.

Thanks for the reply. I created filters in the first few columns. When I reopened the file, the filters were there but did not function. I clicked on the filter arrow and there is no drop down.

I’m looking to protect a worksheet, but allow grouped columns to be collapsed or expanded. Also would like to allow the user to set filters and hide columns. I put the below code in the “ThisWorkbook” object. This protected the worksheet but not with a password. The VBA below allowed the grouped...

I did not know that and column A was hidden so I did not see it. Thanks again.

Still not working. Right now cell F1 is blank. I assume the code would place the value of RecDate in cell F1. I placed the code under "ThisWorkbook" as you pictured.

Thanks for your reply. Not sure what I did wrong. The date did not appear. I want the date to appear in cell F1 on the “Report USA” tab. Here is what I entered in two separate modules Module1 Public Function RecDate() RecDate = FileDateTime("F:\folder1\Projections\Rec File.xlsx") End Function...

I created a UDF to return the modify date and time of a file located on a network drive. I entered the function in a cell and UDF returns the correct date. But, how do I get the function to automatically calculate? When I open the file, the last value of the UDF still displays in the cell even...

Sure will. Didn't know to do that.

Works great. Thank you very much or your time.[bigsmile]

One sequence Selection.EntireRow.Insert Selection.EntireRow.Insert Selection.EntireRow.Insert Selection.EntireRow.Insert ActiveCell.Offset(5, 0).Range("A1").Select

I want this to loop possibly hundreds of times. I want it to stop automatically when it reaches a blank cell