attempting

I am using excel in this office 365, not sure if it is technically excel 2016 or what. I have a long string of numbers and when I highlight and scroll with the objective of getting the numerical count it is deleting my data in the first selected cell and attempting to add it to the last selected...

I'm attempting to link worksheets using ='worksheetname'$A$1. I'm getting that reference in the cell I'm linking and not the actual value in the cell I'm attempting to link. Thoughts please.

Hi everyone, I have been rying to save this problem foir weks,but am still nableto achieve what I want. I have a column in which a value formatted to a monetary amount. However, if this is not available I want to limit the entry to "Not Known". I hav tried to nter data vlaidain to the...

I am attempting to copy data from another sheet and paste into local sheet. My formula works, but it does not advance to the next set of cells. ="$"&'[Copy of Unproteted - 51-100 UHC 2018 2019 MAHP Portfolio Grid Doug.xlsx]VA Doug Option 4'!$B4&"/$"&'[Copy of Unproteted - 51-100 UHC 2018 2019...

Can anyone help? I am attempting to capture a percentage of a count in a column in a pivot chart. Example: In January 3000 customer service calls were made. Of which 300 were unresolvable. I am attempting to capture what percentage of January's calls could not be resolved and display it on a...

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

I'm attempting to enter data by hand into a worksheet. I have selected cells and formatted it to text only. When entering -7.82 dB it adds = and some other nonsense ahead of what I have typed. And I can't remove it. Attempting to has highlighted a Cell blue and Hung me on something as R-click...

Macros have been working fine routinely, but I must have key stroked something by error when accessing tools/macros since I now get "Invalid Outside Procedure" when attempting to run any of them. I can manually create a new macro but it also gives the same error message when attempting to run...

Greetings All: I came up with a formula attempting to confirm (true or false) if 3 logic conditions are met. I'm attempting to determine if any person being tracked on my spreadsheet entered the facility and was physically here between say 11:00 and 11:10 on a specific date. I have a...

Query criteria attempting to be used: IIf(Day(Date())<=7,Between Date()-Day(Date())+1 And Date(),Between Date()-Day(Date())+1 And Date()-Weekday(Date(),2)) I have used both Between statements individually. This one has been what I have been using by itself to pull from the 1st day of the...

Hi Everyone, Using Excel 2010: On Sheet 1 I have a product name (column C - populated) and product provider (column D - unpopulated). I need to get the corresponding product provider for the product name. The thing is that this information is somewhere in column C of either sheet 2 OR...

Hello, thank you in advance for any replies. I am trying to piggyback off an older thread here to develop a spreadsheet formula tool to identify timecard overlaps. https://www.mrexcel.com/forum/excel-questions/709968-calculate-amount-overlapping-time.html#post4932454 I can provide a google...

I'm attempting to identify the last populated COLUMN. The following snippet of code returns the number 37, how do I translate 37 into column "AK"? LC = Cells(9, Columns.Count).End(xlToLeft).Column Or maybe you have a better way of achieving my requirement. Thanks

I am trying to write a formula that will reference a column and give me a count of all cells that have the specified year in them. Example column H will various years worth of data in this format 1/01/2017 and I am attempting to get counts of each years total, so month and day are pretty much...