solutions

Hi, I have a table that contains visit data for a number of clients. I want to be able to count the number of unique clients by month and year. i have searched online and have not yet been able to find a solution. an example of my data is below: Client ID Date Call Type Area 1 01/08/2022...

I have this datepicker that I have placed on a frame in order to hide it and show it in various instances. Now I am using the "mouseMove " event from a parent frame to hide or show the datepicker. It responded fine. The only issue here is that when the datepicker is opened, after hiding the...

I have a running inventory table with a formula that either adds or subtracts and calculates a current balance. When I add a new row either manually or by the use of a form, a row will generate but the formula won't function and I get a #REF . Any thoughts? I've looked for many solutions but...

Hi, I'm looking to create a searchable dropdown list in each cell of a calendar, for 10 classes, roughly 2000 dropdowns. At the moment I have non-searchable dropdowns in each cell, which means scrolling a long list of lessons to find the correct one - it would be much easier if I could type...

I am pulling down some data and then delimiting it into different columns. Everything looks fine and I then save the document, however, when I re-open the excel document the data appears scrambled....data is not in the correct column and I am not sure why this is happening. Has anyone else...

Hi guys, first time poster, long time lurker. First of all I want to thank you all for your awesome contributions. Thanks to you guys my vba skills have improved and I was able to find solutions to many questions I had in the past. Having said that, I've searched and searched for the...

Hello Mr. Excel Gurus, {=COUNTA(IF(CELL("format",B2:B18)="D4",C2:C18))} Above is my simple formula that counts the values in column C if the values in column B is in Date Format. Isn't working, any solutions please? Thanks

I have a value in a5 (82700000) Needing it to display in a6 as text 82.7 Million. Could also be 827000000, needs to be displayed as text 8.27 Billion I know it has to do with Len Just cant get there, Any tips or solutions are greatly appreciated. Jack

I have a table with formulas where I have inserted a filter at the top. But everytime I make a filter on oneof the columns, it start recalculating. I cannot just set the calculationsto ‘Manual’, since I’m supposed to change some of the cells where it afterwards should becalculating. Is there...

Hi all, I was wondering if it was possible to make my workbook change form any current sheet to Sheet1 if it is left untouched for more then 5 minutes. I've looked around for solutions, but couldn't find anything to suit my needs. Thanks in advance, Chuckarou

Dear readers, I know this is a common question as I have read other threads related to this issue. But it seems I can't apply the solutions from the other treads - probably due to my lack of experience with VBA. So I hope someone is able te guide me in the right direction I use to keep track...

Hi everyone, I'm running the Solver add in, trying to find combinations of cells that sum up to a certain value. It's been running for over 20 minutes, maybe even longer. Right now it's on "Subproblem 4700" or so. And the "Trial Solutions" are going by very quickly. Does anybody know what...

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function. <tbody> Functions Revenue 1A $24.00 2A $54.00 3A $36.00 5A $23.00 8A $25.00 9A $42.00 11A $35.00 13A $75.00 1B $79.00 2B $6.00 3B $80.00 5B $7.00 6B $46.00...

There are 30 functions and each one is tied to revenue. So I know how much revenue is tied to each function. <tbody> Functions Revenue 1A $24.00 2A $54.00 3A $36.00 5A $23.00 8A $25.00 9A $42.00 11A $35.00 13A $75.00 1B $79.00 2B $6.00 3B $80.00 5B $7.00 6B $46.00...

Hi, I am currently working on a sheet where I would need to prevent Columns A to G from being deleted. However, I should still be able to edit cell content in Columns A to G. Anyone has any solutions, perhaps using VBA, on how to tackle this? Many thanks in advance!

Hi all, Hoping you can please help, I have reviewed many of the proposed solutions to a progressive calculation I am trying to solve but am not winning (or looking hard enough). The solutions I have found as far deal mainly with percentages which is not working completely. I have a progressive...

I want to find the values of a,b,c,d and e if a*5+b*4+c*3+d*2+e*1 = 70 (or any other input value) and a+b+c+d+e = 20 (fixed). any solutions preferably a worksheet function or else a macro is also OK ravi

I have data in cells A2:A12 that I want to ensure they have the same data. I was using some of the solutions here but when a blank cell was introduced it returned a false value which I am trying to avoid http://www.mrexcel.com/forum/excel-questions/89780-verify-multiple-cells-have-same-value.html

I was wondering if anyone had any subroutines or subroutine examples in "multithreading VBA" I know VBA is by nature single threaded but I know there are ways of trying to emulate this type of processing and was curious what type of solutions existed on Mrexcel. My other question is have you...

G H J <tbody> - 8x - 8y = 12 -8 -8 12 x= #NUM! - 6x - 6y = -102 -6 -6 -102 y= #NUM! </tbody> I am working on simultaneous equations using {=mmult(minverse(g2:h3),J2:23)}. When there is a solution it works and gives me the correct answer. When there...